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 AddShiftMaster(SchedulingDbContext schDbContext, ShiftsMasterModel shift) { try { shift.CreatedOn = System.DateTime.Now; schDbContext.ShiftsMaster.Add(shift); 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 string Post() { DanpheHTTPResponse <object> responseData = new DanpheHTTPResponse <object>(); SchedulingDbContext schDbContext = new SchedulingDbContext(connString); string reqType = this.ReadQueryStringData("reqType"); string str = this.ReadPostData(); try { #region Employee Schedule manage : Insert/Update schedules if (reqType == "manageEmpSchedules") { List <EmpSchedules> schedulesData = DanpheJSONConvert.DeserializeObject <List <EmpSchedules> >(str); Boolean Flag = false; Flag = SchedulingBL.ManageEmpSchedules(schedulesData, schDbContext); if (Flag) { responseData.Status = "OK"; responseData.Results = 1; } else { responseData.ErrorMessage = "check console for error details."; responseData.Status = "Failed"; } } #endregion #region Add Shift (Manage Shifts) else if (reqType == "AddShift") { ShiftsMasterModel shiftMaster = DanpheJSONConvert.DeserializeObject <ShiftsMasterModel>(str); shiftMaster.CreatedOn = System.DateTime.Now; schDbContext.ShiftsMaster.Add(shiftMaster); schDbContext.SaveChanges(); responseData.Status = "OK"; responseData.Results = shiftMaster; } #endregion #region Employee Working Hours manage Transaction else if (reqType == "EmpWokringHours") { WorkingHoursTxnVM workHrsTxnData = DanpheJSONConvert.DeserializeObject <WorkingHoursTxnVM>(str); Boolean Flag = false; Flag = SchedulingBL.WorkingHrsTxn(workHrsTxnData, schDbContext); if (Flag) { responseData.Status = "OK"; responseData.Results = 1; } else { responseData.ErrorMessage = "check console for error details."; responseData.Status = "Failed"; } } #endregion } catch (Exception ex) { responseData.Status = "Failed"; responseData.ErrorMessage = ex.Message + " exception details:" + ex.ToString(); } return(DanpheJSONConvert.SerializeObject(responseData, true)); }