public string Put() { DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>(); SchedulingDbContext schDbContext = new SchedulingDbContext(connString); string reqType = this.ReadQueryStringData("reqType"); string str = this.ReadPostData(); try { #region Update Shifts (Manage Shifts) if (reqType == "UpdateShift") { ShiftsMasterModel shiftData = DanpheJSONConvert.DeserializeObject <ShiftsMasterModel>(str); shiftData.ModifiedOn = System.DateTime.Now; schDbContext.ShiftsMaster.Attach(shiftData); schDbContext.Entry(shiftData).State = EntityState.Modified; schDbContext.Entry(shiftData).Property(x => x.CreatedOn).IsModified = false; schDbContext.Entry(shiftData).Property(x => x.CreatedBy).IsModified = false; schDbContext.SaveChanges(); responseData.Status = "OK"; responseData.Results = shiftData; } #endregion } catch (Exception ex) { responseData.Status = "Failed"; responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString(); } return(DanpheJSONConvert.SerializeObject(responseData, true)); }
public static void UpdateEmpShiftMap(SchedulingDbContext schDbContext, EmployeeShiftMap shiftMap) { try { shiftMap.ModifiedOn = System.DateTime.Now; schDbContext.EmpShiftMAP.Attach(shiftMap); schDbContext.Entry(shiftMap).State = EntityState.Modified; schDbContext.Entry(shiftMap).Property(x => x.CreatedOn).IsModified = false; schDbContext.Entry(shiftMap).Property(x => x.CreatedBy).IsModified = false; schDbContext.SaveChanges(); } catch (Exception ex) { throw ex; } }
//here im updating shift master from Manage working hours txn .. as i need following fields(shiftname,starttime,endtime,totalhrs) to get updated, so i have bought only that much content here... #region Update Shift Master public static void UpdateShiftMaster(SchedulingDbContext schDbContext, ShiftsMasterModel shift) { try { shift.ModifiedOn = System.DateTime.Now; schDbContext.ShiftsMaster.Attach(shift); schDbContext.Entry(shift).Property(x => x.ShiftName).IsModified = true; schDbContext.Entry(shift).Property(x => x.StartTime).IsModified = true; schDbContext.Entry(shift).Property(x => x.EndTime).IsModified = true; schDbContext.Entry(shift).Property(x => x.TotalHrs).IsModified = true; schDbContext.SaveChanges(); } catch (Exception ex) { throw ex; } }
public static void UpdateEmpSchedules(SchedulingDbContext schDBContext, EmpSchedules schedules) { try { schDBContext.EmpSchedules.Attach(schedules); schDBContext.Entry(schedules).Property(x => x.IsWorkingDay).IsModified = true; schDBContext.SaveChanges(); } catch (Exception ex) { throw ex; } }