public int Update(Assignings assigning) { try { using (var db = new HCMEntities()) { Assignings assigningObj = db.Assignings.FirstOrDefault(x => x.AssigningID.Equals(assigning.AssigningID)); assigningObj.AssigningTypID = assigning.AssigningTypID; assigningObj.AssigningStartDate = assigning.AssigningStartDate; //assigningObj.AssigningEndDate = assigning.AssigningEndDate; //assigningObj.IsFinished = assigning.IsFinished; //assigningObj.EmployeeCareerHistoryID = assigning.EmployeeCareerHistoryID; assigningObj.ExternalOrganization = assigning.ExternalOrganization; assigningObj.ExternalKSACityID = assigning.ExternalKSACityID; assigningObj.JobID = assigning.JobID; assigningObj.OrganizationID = assigning.OrganizationID; assigningObj.ManagerCodeID = assigning.ManagerCodeID; assigningObj.AssigningReasonID = assigning.AssigningReasonID; assigningObj.AssigningReasonOther = assigning.AssigningReasonOther; assigningObj.LastUpdatedDate = assigning.LastUpdatedDate; assigningObj.LastUpdatedBy = assigning.LastUpdatedBy; return(db.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int Insert(Assignings Assigning) { try { using (var db = new HCMEntities()) { db.Assignings.Add(Assigning); db.SaveChanges(); return(Assigning.AssigningID); } } catch (Exception ex) { throw ex; } }
public int Delete(int AssigningID, int UserIdentity) { try { using (var db = new HCMEntities()) { Assignings AssigningObj = db.Assignings.FirstOrDefault(x => x.AssigningID.Equals(AssigningID)); db.Assignings.Remove(AssigningObj); return(db.SaveChanges(UserIdentity)); } } catch (Exception ex) { throw ex; } }
public int BreakAssigning(Assignings assigning) { try { using (var db = new HCMEntities()) { Assignings assigningObj = db.Assignings.FirstOrDefault(x => x.AssigningID.Equals(assigning.AssigningID)); assigningObj.AssigningEndDate = assigning.AssigningEndDate; assigningObj.IsFinished = assigning.IsFinished; assigningObj.EndAssigningReasonID = assigning.EndAssigningReasonID; assigningObj.Notes = assigning.Notes; assigningObj.LastUpdatedDate = assigning.LastUpdatedDate; assigningObj.LastUpdatedBy = assigning.LastUpdatedBy; return(db.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public int UpdateOrganizationManager(Assignings assigning) { try { using (var db = new HCMEntities()) { List <Assignings> assigningObj = db.Assignings.Where(x => x.OrganizationID == assigning.OrganizationID && x.IsFinished == false).ToList(); assigningObj.ForEach(a => { a.ManagerCodeID = assigning.ManagerCodeID; a.LastUpdatedBy = assigning.LastUpdatedBy; a.LastUpdatedDate = assigning.LastUpdatedDate; } ); return(db.SaveChanges()); } } catch (Exception ex) { throw ex; } }