string listTimeZone="";
foreach (TimeZoneInfo tzi in TimeZoneInfo.GetSystemTimeZones())
listTimeZone += tzi.Id + " - " + tzi.DisplayName;
protected void Page_Load(object sender, EventArgs e)
{
var inputTime = Convert.ToDateTime("01/15/2019 04:30:00").ToUniversalTime();
TimeZone localZone = TimeZone.CurrentTimeZone;
lblMessage.Text = localZone.StandardName;
DateTime outPutTime = inputTime.ToTimeZoneTime(localZone.StandardName);
lblMessage.Text += "<br>" + inputTime.ToString();
lblMessage.Text += "<br>India = " + outPutTime.ToString();
lblMessage.Text += "<br>US Eastern Standard Time = " + inputTime.ToTimeZoneTime("US Eastern Standard Time").ToString();
}
public static class genericDate
{
public static DateTime ToTimeZoneTime(this DateTime time, string timeZoneId = "Pacific Standard Time")
{
TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById(timeZoneId);
return TimeZoneInfo.ConvertTimeFromUtc(time, tzi);
}
}
namespace JsonToClass
{
class Program
{
static void Main(string[] args)
{
var jsonInput = "{ username:'myName',password:'myPass'}";
var data = JsonConvert.DeserializeObject<demo>(jsonInput);
}
}
class demo
{
public string username { get; set; }
public string password { get; set; }
}
}
Use [dbname]
Find log file name using below query and pass it in DBCC SHRINKFILE query
Select * from sys.database_files
ALTER DATABASE [dbname] SET RECOVERY SIMPLE
DBCC SHRINKFILE ('dbname_Log', 1)
Please follow steps mentioned in below article,
http://anrorathod.blogspot.com/2018/02/how-to-move-or-change-datamdf-file-or.html
| Editor = | C:/Program Files (x86)/GitExtensions/GitExtensions.exe fileeditor |
| Mergetool = | TortoiseMerge |
| Path to mergetool = | C:/Program Files/TortoiseSVN/bin/TortoiseMerge.exe |
| Mergetool
command = |
C:/Program Files/TortoiseSVN/bin/TortoiseMerge.exe /base:"$BASE" /mine:"$LOCAL" /theirs:"$REMOTE" /merged:"$MERGED" |
| Difftool = | tmerge |
| Path to difftool = | C:/Program Files/TortoiseSVN/bin/TortoiseMerge.exe |
| Difftool command = | C:/Program Files/TortoiseSVN/bin/TortoiseMerge.exe "$LOCAL" "$REMOTE" |
CREATE TABLE [dbo].[EventLogData](
[Id] [int] IDENTITY(1,1) NOT NULL,
[EventId] [nvarchar](10) NULL,
[EventType] [nvarchar](50) NULL,
[Site] [nvarchar](200) NULL,
[Source] [nvarchar](500) NULL,
[TimeGenerated] [datetime] NULL,
[Message] [ntext] NULL,
CONSTRAINT [PK__EventLog__3214EC07A20289BA] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
namespace EventLogsDemo
{
class Program
{
static void Main(string[] args)
{
EventLog log = new EventLog("Application");
var entries = log.Entries.Cast<EventLogEntry>()
// .Where(x => x.InstanceId == 4624)
.Select(x => new
{
x.EventID,
x.EntryType,
x.Site,
x.Source,
x.TimeGenerated,
x.Message
})
.ToList();
List<EventLogData> eventLogDatas = new List<EventLogData>();
EventLogData eventLogData;
Console.WriteLine("Total Entries : " + entries.Count.ToString());
foreach (var item in entries)
{
eventLogData = new EventLogData()
{
EventId = Convert.ToString(item.EventID),
EventType = Convert.ToString(item.EntryType),
Site = Convert.ToString(item.Site),
Source = item.Source,
TimeGenerated = item.TimeGenerated,
Message = item.Message
};
eventLogDatas.Add(eventLogData);
}
using (var db = new EventsEntities())
{
db.Database.ExecuteSqlCommand("TRUNCATE TABLE EventLogData");
db.EventLogDatas.AddRange(eventLogDatas);
db.SaveChanges();
}
Console.WriteLine("Process completed. Press any key to continue...");
Console.Read();
}
}
}
namespace UnitTestCaseProject.Case1
{
public class checkEmployee
{
public virtual Boolean checkEmp()
{
throw new NotImplementedException();
//return true;
}
}
}
namespace UnitTestCaseProject.Case1
{
public class processEmployee
{
public bool insertEmployee(checkEmployee objtmp)
{
objtmp.checkEmp();
return true;
}
}
}
namespace UnitTestCaseProject.Case2
{
public interface IGetDataRepository
{
string GetNameById(int id);
}
}
namespace UnitTestCaseProject.Case2
{
public class EmployeeRepository : IGetDataRepository
{
public string GetNameById(int id)
{
string name;
if (id == 1)
{
name = "Excellent";
}
else if (id == 2)
{
name = "Expert";
}
else
{
name = "Not Found";
}
return name;
}
}
}
namespace UnitTestCaseProject.Case2
{
public class Implementation1
{
private readonly IGetDataRepository _data;
public Implementation1(IGetDataRepository data)
{
_data = data;
}
public string GetNameById(int id)
{
return _data.GetNameById(id);
}
}
}
namespace UnitTestCaseProject.Test
{
[TestClass]
public class Case1Test
{
[TestMethod]
public void insertEmployeeTestSuccess()
{
Mock<checkEmployee> chk = new Mock<checkEmployee>();
chk.Setup(x => x.checkEmp()).Returns(true);
processEmployee obje = new processEmployee();
Assert.AreEqual(obje.insertEmployee(chk.Object), true);
}
}
}
namespace UnitTestCaseProject.Test
{
[TestClass]
public class Cast2Test
{
[TestMethod]
public void TestMethod2()
{
var mock = new Mock<IGetDataRepository>();
mock.Setup(p => p.GetNameById(1)).Returns("demo");
Implementation1 home = new Implementation1(mock.Object);
string result = home.GetNameById(1);
Assert.AreEqual("demo", result);
}
}
}
namespace UnitTestCaseProject
{
class Program
{
static void Main(string[] args)
{
processEmployee processEmployee = new processEmployee();
checkEmployee checkEmployee = new checkEmployee();
var result = processEmployee.insertEmployee(checkEmployee);
Console.WriteLine(result);
}
}
}