public static bool UpdateData(x_timesheet dataForm, long modifiedBy)
{
x_timesheet dataBefore = GetDatabyId(dataForm.id);
try
{
using (DBSpecEntities db = new DBSpecEntities())
{
dataBefore.modified_by = modifiedBy;
dataBefore.modified_on = System.DateTime.Now;
dataBefore.overtime = dataForm.overtime;
dataBefore.start = dataForm.start;
dataBefore.end = dataForm.end;
dataBefore.start_ot = dataForm.start_ot;
dataBefore.end_ot = dataForm.end_ot;
dataBefore.status = dataForm.status;
dataBefore.timesheet_date = dataForm.timesheet_date;
dataBefore.activity = dataForm.activity;
db.Entry(dataBefore).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public static x_timesheet GetDatabyId(long id)
{
x_timesheet data = new x_timesheet();
using (DBSpecEntities db = new DBSpecEntities())
{
data = db.x_timesheet.Where(a => a.id == id).FirstOrDefault();
}
return(data);
}
public static bool DeleteData(long id)
{
using (DBSpecEntities db = new DBSpecEntities())
{
x_timesheet data = GetDatabyId(id);
data.is_delete = true;
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
}
public static bool SaveData(x_timesheet Sheet, long createdBy)
{
//try
//{
using (DBSpecEntities db = new DBSpecEntities())
{
Sheet.timesheet_date = Sheet.timesheet_date;
Sheet.created_by = createdBy;
Sheet.created_on = System.DateTime.Now;
Sheet.overtime = Sheet.overtime;
Sheet.modified_on = null;
Sheet.deleted_on = null;
Sheet.user_approval = null;
Sheet.ero_status = null;
Sheet.submitted_on = null;
db.x_timesheet.Add(Sheet);
db.SaveChanges();
return(true);
}
//}
//catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
//{
// Exception raise = dbEx;
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
// }
// throw raise;
//}
}
public static bool userApproval(string data)
{
string[] arr = data.Split(',');
using (DBSpecEntities db = new DBSpecEntities())
{
for (int i = 1; i < arr.Length; i++)
{
x_timesheet dtTimesheet = new x_timesheet();
dtTimesheet = GetDatabyId(Convert.ToInt64(arr[i]));
if (arr[0] == "Approved")
{
dtTimesheet.approved_on = System.DateTime.Now;
}
else
{
dtTimesheet.approved_on = null;
}
dtTimesheet.user_approval = arr[0];
db.Entry(dtTimesheet).State = EntityState.Modified;
db.SaveChanges();
}
}
return(true);
}
