예제 #1
0
 public int Insert(Allowances Allowance)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             db.Allowances.Add(Allowance);
             db.SaveChanges();
             return(Allowance.AllowanceID);
         }
     }
     catch (DbEntityValidationException e)
     {
         foreach (var eve in e.EntityValidationErrors)
         {
             Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
             foreach (var ve in eve.ValidationErrors)
             {
                 Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
             }
         }
         throw;
     }
     catch
     {
         throw;
     }
 }
예제 #2
0
 public int Delete(int AllowanceID, int UserIdentity)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             Allowances AllowanceObj = db.Allowances.FirstOrDefault(x => x.AllowanceID.Equals(AllowanceID));
             db.Allowances.Remove(AllowanceObj);
             return(db.SaveChanges(UserIdentity));
         }
     }
     catch
     {
         throw;
     }
 }
예제 #3
0
 public int Update(Allowances Allowance)
 {
     try
     {
         using (var db = new HCMEntities())
         {
             Allowances AllowanceObj = db.Allowances.FirstOrDefault(x => x.AllowanceID.Equals(Allowance.AllowanceID));
             AllowanceObj.AllowanceAmountTypeID      = Allowance.AllowanceAmountTypeID;
             AllowanceObj.AllowanceCalculationTypeID = Allowance.AllowanceCalculationTypeID;
             AllowanceObj.AllowanceName   = Allowance.AllowanceName;
             AllowanceObj.AllowanceAmount = Allowance.AllowanceAmount;
             AllowanceObj.IsActive        = Allowance.IsActive;
             AllowanceObj.LastUpdatedDate = DateTime.Now;
             AllowanceObj.LastUpdatedBy   = Allowance.LastUpdatedBy;
             return(db.SaveChanges());
         }
     }
     catch
     {
         throw;
     }
 }