//Delete user in the database
public void Delete(int id)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_UserRateSchedule t_userRateSchedule = new T_UserRateSchedule();
t_userRateSchedule = db.T_UserRateSchedule.FirstOrDefault(u => u.Id == id);
db.T_UserRateSchedule.Remove(t_userRateSchedule);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
private void Parse(T_UserRateSchedule t_userRateSchedule, UserRateSchedule userRateSchedule)
{
t_userRateSchedule.Id = userRateSchedule.Id;
t_userRateSchedule.UserId = userRateSchedule.UserId;
t_userRateSchedule.StartTime = userRateSchedule.StartTime;
t_userRateSchedule.EndTime = userRateSchedule.EndTime;
t_userRateSchedule.StartDate = userRateSchedule.StartDate;
t_userRateSchedule.EndDate = userRateSchedule.EndDate;
t_userRateSchedule.MonthlySalary = userRateSchedule.MonthlySalary;
t_userRateSchedule.IsCurrentRate = userRateSchedule.IsCurrentRate;
t_userRateSchedule.OffDay = userRateSchedule.OffDay;
t_userRateSchedule.SpecialOffDay = userRateSchedule.SpecialOffDay;
t_userRateSchedule.NoOTPay = userRateSchedule.NoOTPay;
t_userRateSchedule.MinsBreak = userRateSchedule.MinsBreak;
t_userRateSchedule.IsOfficeWorker = userRateSchedule.IsOfficeWorker;
t_userRateSchedule.OptionalOffDay1 = userRateSchedule.OptionalOffDay1;
t_userRateSchedule.OptionalOffDay2 = userRateSchedule.OptionalOffDay2;
t_userRateSchedule.OptionalOffDay3 = userRateSchedule.OptionalOffDay3;
t_userRateSchedule.OptionalOffDay4 = userRateSchedule.OptionalOffDay4;
t_userRateSchedule.CreatedDate = userRateSchedule.CreatedDate;
t_userRateSchedule.LastUpdatedDate = userRateSchedule.LastUpdatedDate;
t_userRateSchedule.UsePattern = userRateSchedule.UsePattern;
t_userRateSchedule.OffPattern = userRateSchedule.OffPattern;
t_userRateSchedule.PatternStartDate = userRateSchedule.PatternStartDate;
}
public void Insert(UserRateSchedule userRateSchedule)
{
T_UserRateSchedule t_userRateSchedule = new T_UserRateSchedule();
Parse(t_userRateSchedule, userRateSchedule);
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_UserRateSchedule.Add(t_userRateSchedule);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
