コード例 #1
0
ファイル: LendersDAL.cs プロジェクト: hanyweal/HCM
 public int Delete(Lenders Lender, int UserIdentity)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             Lenders LenderObj = db.Lenders.SingleOrDefault(x => x.LenderID.Equals(Lender.LenderID));
             db.Lenders.Remove(LenderObj);
             return(db.SaveChanges(UserIdentity));
         }
     }
     catch
     {
         throw;
     }
 }
コード例 #2
0
ファイル: LendersDAL.cs プロジェクト: hanyweal/HCM
 public int Insert(Lenders Lender)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             db.Lenders.Add(Lender);
             db.SaveChanges();
             return(Lender.LenderID);
         }
     }
     catch
     {
         throw;
     }
 }
コード例 #3
0
ファイル: LendersDAL.cs プロジェクト: hanyweal/HCM
 public int EndLender(Lenders Lender)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             Lenders LenderObj = db.Lenders.SingleOrDefault(x => x.LenderID.Equals(Lender.LenderID));
             LenderObj.LenderStartDate         = Lender.LenderStartDate;
             LenderObj.LenderEndDate           = Lender.LenderEndDate;
             LenderObj.EmployeeCareerHistoryID = Lender.EmployeeCareerHistoryID;
             LenderObj.IsFinished         = Lender.IsFinished;
             LenderObj.LenderOrganization = Lender.LenderOrganization;
             LenderObj.KSACityID          = Lender.KSACityID;
             LenderObj.LenderEndReason    = "" + Lender.LenderEndReason;
             LenderObj.LastUpdatedDate    = Lender.LastUpdatedDate;
             LenderObj.LastUpdatedBy      = Lender.LastUpdatedBy;
             return(db.SaveChanges());
         }
     }
     catch
     {
         throw;
     }
 }