public static int AddData(DeliveryHistoryDTO Data) { using (DBEntities db = new DBEntities()) { //get total day var total = DateTime.Now.Subtract(db.TB_CANDIDATE_SELECTION_HISTORY.FirstOrDefault(d => d.CANDIDATE_ID == Data.CANDIDATE_ID && d.CANDIDATE_STATE == 1).PROCESS_DATE.Value); int TotalDay = Convert.ToInt16(DateTime.Now.Subtract(db.TB_CANDIDATE_SELECTION_HISTORY.FirstOrDefault(d => d.CANDIDATE_ID == Data.CANDIDATE_ID && d.CANDIDATE_STATE == 1).PROCESS_DATE.Value).ToString("dddd")); //get process date var process_Date = db.TB_CANDIDATE_SELECTION_HISTORY.FirstOrDefault(d => d.CANDIDATE_ID == Data.CANDIDATE_ID && d.CANDIDATE_STATE == 1).PROCESS_DATE; //data candidate var DataCandidate = db.TB_CANDIDATE.FirstOrDefault(c => c.ID == Data.CANDIDATE_ID); db.TB_DELIVERY_HISTORY.Add(new TB_DELIVERY_HISTORY { DELIVERY_ID = Data.DELIVERY_ID, CANDIDATE_ID = Data.CANDIDATE_ID, CANDIDATE_POSITION = Data.CANDIDATE_POSITION, SOURCE = DataCandidate.SOURCE, CANDIDATE_STATE = Data.CANDIDATE_STATE, LAST_PIC = Data.LAST_PIC, PROCESS_DATE = process_Date, CLIENT_ID = Data.CLIENT_ID, START_DATE = DateTime.Now, LAST_UPDATE = DateTime.Now, TOTA_DAY = TotalDay, CLIENT_STATE = Data.CLIENT_STATE, NOTE = Data.NOTE }); return(db.SaveChanges()); } }
public static int EditData(DeliveryHistoryDTO Data) { using (DBEntities db = new DBEntities()) { TB_DELIVERY_HISTORY DeliveryHistory = db.TB_DELIVERY_HISTORY.FirstOrDefault(d => d.ID == Data.ID); //data PIC UserDTO DataPic = (UserDTO)HttpContext.Current.Session["UserLogin"]; DeliveryHistory.CANDIDATE_POSITION = Data.CANDIDATE_POSITION; DeliveryHistory.SOURCE = Data.SOURCE; DeliveryHistory.CANDIDATE_STATE = Data.CANDIDATE_STATE; DeliveryHistory.LAST_PIC = DataPic.USER_ID; DeliveryHistory.PROCESS_DATE = db.TB_CANDIDATE_SELECTION_HISTORY.FirstOrDefault(d => d.CANDIDATE_ID == Data.CANDIDATE_ID && d.CANDIDATE_STATE == 1).PROCESS_DATE; DeliveryHistory.CLIENT_ID = Data.CLIENT_ID; DeliveryHistory.LAST_UPDATE = DateTime.Now; DeliveryHistory.CLIENT_STATE = Data.CLIENT_STATE; DeliveryHistory.NOTE = Data.NOTE; return(db.SaveChanges()); } }