public int Delete(int EmployeeExperienceWithDetailID, int UserIdentity)
{
try
{
using (var db = new HCMEntities())
{
EmployeeExperiencesWithDetails EmployeeExperiencesWithDetailObj = db.EmployeeExperiencesWithDetails.SingleOrDefault(x => x.EmployeeExperienceWithDetailID.Equals(EmployeeExperienceWithDetailID));
db.EmployeeExperiencesWithDetails.Remove(EmployeeExperiencesWithDetailObj);
return(db.SaveChanges(UserIdentity));
}
}
catch
{
throw;
}
}
public int Insert(EmployeeExperiencesWithDetails EmployeeExperiencesWithDetail)
{
try
{
using (var db = new HCMEntities())
{
db.EmployeeExperiencesWithDetails.Add(EmployeeExperiencesWithDetail);
db.SaveChanges();
return(EmployeeExperiencesWithDetail.EmployeeExperienceWithDetailID);
}
}
catch
{
throw;
}
}
public int Update(EmployeeExperiencesWithDetails EmployeeExperiencesWithDetail)
{
try
{
using (var db = new HCMEntities())
{
EmployeeExperiencesWithDetails EmployeeExperiencesWithDetailObj = db.EmployeeExperiencesWithDetails.SingleOrDefault(x => x.EmployeeExperienceWithDetailID.Equals(EmployeeExperiencesWithDetail.EmployeeExperienceWithDetailID));
EmployeeExperiencesWithDetailObj.EmployeeCodeID = EmployeeExperiencesWithDetail.EmployeeCodeID;
EmployeeExperiencesWithDetailObj.FromDate = EmployeeExperiencesWithDetail.FromDate;
EmployeeExperiencesWithDetailObj.ToDate = EmployeeExperiencesWithDetail.ToDate;
EmployeeExperiencesWithDetailObj.JobName = EmployeeExperiencesWithDetail.JobName;
EmployeeExperiencesWithDetailObj.SectorName = EmployeeExperiencesWithDetail.SectorName;
EmployeeExperiencesWithDetailObj.SectorTypeID = EmployeeExperiencesWithDetail.SectorTypeID;
EmployeeExperiencesWithDetailObj.LastUpdatedDate = EmployeeExperiencesWithDetail.LastUpdatedDate;
EmployeeExperiencesWithDetailObj.LastUpdatedBy = EmployeeExperiencesWithDetail.LastUpdatedBy;
return(db.SaveChanges());
}
}
catch
{
throw;
}
}