public SavingResult SaveNewRecord(tblEmployeeSalaryIncrement SaveModel) { SavingResult res = new SavingResult(); using (dbVisionEntities db = new dbVisionEntities()) { if (SaveModel.EmployeeSalaryIncrementID == 0) { SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.rcdt = DateTime.Now; SaveModel.CompanyID = Model.CommonProperties.LoginInfo.LoggedInCompany.CompanyID; SaveModel.FinPeriodID = CommonProperties.LoginInfo.LoggedInFinPeriod.FinPeriodID; db.tblEmployeeSalaryIncrements.Add(SaveModel); } else { SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.redt = DateTime.Now; db.tblEmployeeSalaryIncrements.Attach(SaveModel); db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified; } var tblService = db.tblEmployeeServiceDetails.Where(p => p.EmployeeID == SaveModel.EmployeeID).FirstOrDefault(); if (tblService != null) { tblService.BasicSalary = SaveModel.NewBasicSalary; } try { db.SaveChanges(); res.PrimeKeyValue = SaveModel.EmployeeSalaryIncrementID; res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { CommonFunctions.GetFinalError(res, ex); } } return(res); }
public override void FillSelectedRecordInContent(object RecordToFill) { EmployeeSalaryIncrementID = ((EmployeeSalaryIncrementEditListModel)RecordToFill).EmployeeSalaryIncrementID; tblEmployeeSalaryIncrement SaveModel = DALObj.FindSaveModelByPrimeKey(EmployeeSalaryIncrementID); if (SaveModel == null) { return; } txtEmployee.EditValue = SaveModel.EmployeeID; txtTransectionNo.EditValue = SaveModel.EmployeeSalaryIncrementNo; txtCurrentBasicSalary.EditValue = SaveModel.CurrentBasicSalary; cmbIncrementType.SelectedIndex = SaveModel.IncrementType; txtIncrementAmount.EditValue = SaveModel.IncrementAmount; txtIncrementPercentage.EditValue = SaveModel.IncrementPercentage; dtpTransectionDate.EditValue = SaveModel.EmployeeSalaryIncrementDate; dtpEffectiveMonth.EditValue = DateFrom.ToString("MMMM-yyyy"); txtNewBasicSalary.EditValue = SaveModel.NewBasicSalary; txtLastIncAmount.EditValue = SaveModel.LastIncAmount; dtpLastIncDate.Text = SaveModel.LastIncDate == null ? "" : SaveModel.LastIncDate.Value.ToString("dd-MM-yyyy"); txtRemarks.EditValue = SaveModel.Remarks; base.FillSelectedRecordInContent(RecordToFill); }
public SavingResult DeleteRecord(long DeleteID) { SavingResult res = new SavingResult(); using (dbVisionEntities db = new dbVisionEntities()) { if (DeleteID != 0) { tblEmployeeSalaryIncrement RecordToDelete = db.tblEmployeeSalaryIncrements.FirstOrDefault(r => r.EmployeeSalaryIncrementID == DeleteID); if (RecordToDelete == null) { res.ValidationError = "Selected record not found. May be it has been deleted by another user over network."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } else { byte RecordState_Deleted = (byte)eRecordState.Deleted; RecordToDelete.rState = RecordState_Deleted; db.tblEmployeeSalaryIncrements.Attach(RecordToDelete); db.Entry(RecordToDelete).State = System.Data.Entity.EntityState.Modified; } try { db.SaveChanges(); res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { CommonFunctions.GetFinalError(res, ex); } } } return(res); }