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;
}
}
