public async Task <string> AddUpdateSalary(SalaryDomainModel salary) { string status = ""; if (salary.sal_id > 0) { tblSalary salaryToUpdate = await salaryRepository.SingleOrDefault(s => s.sal_id == salary.sal_id); if (salaryToUpdate != null) { salaryToUpdate.date = salary.date; salaryToUpdate.emp_id = salary.emp_id; salaryToUpdate.amount = salary.amount; await salaryRepository.Update(salaryToUpdate); status = "updated"; } } else { tblSalary salaryToAdd = new tblSalary(); salaryToAdd.date = salary.date; salaryToAdd.emp_id = salary.emp_id; salaryToAdd.amount = salary.amount; await salaryRepository.Insert(salaryToAdd); status = "added"; } return(status); }
public void AddEmployee(DAL.Employee e, tblSalary s) { using (OriginatorEntities db = new OriginatorEntities()) { db.Employees.Add(e); db.SaveChanges(); s.EmployeeId = e.ID; db.tblSalaries.Add(s); db.SaveChanges(); } }
public int Save(tblSalary sal) { try { int?SalId = 0; objData.STP_Insert_tblSalary(Convert.ToInt32(sal.EmpId), Convert.ToDateTime(sal.SalDate), Convert.ToInt32(sal.No_of_Days), Convert.ToInt32(sal.LeavesTaken), Convert.ToInt32(sal.Attend_Days), Convert.ToString(sal.Sal_Month), Convert.ToDecimal(sal.NetPayment), Convert.ToBoolean(sal.IsPaymentDone), Convert.ToInt32(sal.OTHours), ref SalId); return(SalId.Value); } catch (Exception ex) { throw ex; } }
public bool Add(tblSalary obj) { try { repository.tblSalaries.Add(obj); repository.SaveChanges(); return(true); } catch (Exception) { return(false); } }
protected void BtnEdit_Click(object sender, EventArgs e) { try { Session["MyFlag"] = "Edit"; ImageButton imgEdit = (ImageButton)sender; GridViewRow row = (GridViewRow)imgEdit.NamingContainer; Session["LedgerId"] = Convert.ToInt32(dgvSalary.DataKeys[row.RowIndex].Value); tblSalary sal = new tblSalary(); EntitySalary lst = mobjSalBLL.GetDetail(Convert.ToInt32(Session["LedgerId"])); if (lst.IsPaymentDone == true) { lblMessage.Text = "Payment is Done.You Cannot Edit Details...."; return; } else { ListItem item = ddlEmployee.Items.FindByText(Convert.ToString(row.Cells[1].Text)); ddlEmployee.SelectedValue = item.Value; ddlEmployee_SelectedIndexChanged(sender, e); txtDos.Text = string.Format("{0:dd/MM/yyyy}", row.Cells[2].Text).ToString(); txtMonth.Text = string.Format("{0:MMM/yyyy}", row.Cells[3].Text).ToString(); txtDays.Text = Convert.ToString(row.Cells[4].Text); txtAttendDays.Text = Convert.ToString(row.Cells[5].Text); txtLeavesTaken.Text = Convert.ToString(row.Cells[6].Text); txtOTHours.Text = Convert.ToString(row.Cells[7].Text); txtNetAmount.Text = Convert.ToString(row.Cells[8].Text); ddlEmployee.Enabled = false; lblbaseSal.Enabled = false; txtDoj.Enabled = false; txtDos.Enabled = false; //calDos.Enabled = false; txtMonth.Enabled = false; txtDays.Enabled = false; txtAttendDays.Enabled = false; txtLeavesTaken.Enabled = true; txtOTHours.Enabled = true; BindSalary(Convert.ToInt32(Session["LedgerId"])); BindSalaryDeduction(Convert.ToInt32(Session["LedgerId"])); BtnSave.Visible = false; btnUpdate.Visible = true; } } catch (Exception ex) { lblMsg.Text = ex.Message; } MultiView1.SetActiveView(View2); }
public ActionResult AddEmployee(VMEmployee Employee) { try { if (ModelState.IsValid) { tblUser user = Session[WebUtil.CURRENT_USER] as tblUser; if (!(user != null)) { return(RedirectToAction("RedirectToLogin", "user")); } Employee e = new Employee(); long uno = DateTime.Now.Ticks; if (Employee.ImageUrl != null) { HttpPostedFileBase file = Employee.ImageUrl; if (!string.IsNullOrWhiteSpace(file.FileName)) { string url = $"~/DataImages/Employee/{uno}{file.FileName.Substring(file.FileName.LastIndexOf("."))}"; string path = Request.MapPath(url); file.SaveAs(path); e.ImageUrl = url; } } e.CompanyId = user.CompanyId; e.FirstName = Employee.FirstName; e.LastName = Employee.LastName; e.Designation = Employee.Designation; e.CreatedBy = user.Id; e.CreatedDate = DateTime.Now; tblSalary s = new tblSalary(); s.Salary = Employee.Salary; s.CreatedBy = user.CreatedBy; s.CreatedDate = DateTime.Now; s.EmployeeId = 0; new EmployeeHandler().AddEmployee(e, s); return(JavaScript("showMessage('success', 'Employee added Successfully','bottom-right','Employee', 'Manage')")); } else { return(JavaScript("showMessage('error', 'All fields are required, Please try again','bottom-right','Employee', 'Manage')")); } } catch (Exception ex) { return(JavaScript("showMessage('error', 'Failed to Add Employee, Please Contact to Administrator','bottom-right','Employee', 'Manage')")); } }
protected void btnUpdate_Click(object sender, EventArgs e) { tblSalary result = get_Data_From_Form(); result.SalaryId = Int32.Parse(Request.QueryString["id"]); Salary repository = new Salary(); if (repository.Update(result)) { Response.Redirect("~/pages/salary.aspx"); } else { this.ShowErrorNotification("Error occured"); } }
private void Get_Salary_Data_By_QueryString() { // Set up environment gridSalary.Visible = false; btnInsert.Visible = false; btnUpdate.Visible = true; linkBack.Visible = true; Salary repository = new Salary(); tblSalary result = repository.Get(Int32.Parse(Request.QueryString["id"])); cbEmployee.SelectedValue = result.EmployeeId.ToString(); txtStartDate.Text = result.StartDate.ToShortDateString(); txtEndDate.Text = result.EndDate.ToShortDateString(); txtTotalHours.Text = result.TotalHours.ToString(); lblTotalSalary.Text = "$" + result.TotalSalary.ToString(); }
public bool Delete(int id) { try { tblSalary result = Get(id); if (result != null) { result.Deleted = true; repository.SaveChanges(); return(true); } return(false); } catch (Exception) { return(false); } }
public bool Update(tblSalary obj) { try { tblSalary result = Get(obj.SalaryId); if (result != null) { repository.Entry(result).CurrentValues.SetValues(obj); repository.SaveChanges(); return(true); } return(false); } catch (Exception) { return(false); } }
public int?Save(tblSalary sal, List <tblSalaryDetail> lst) { int?SalId = 0; try { objData.STP_Insert_tblSalary(Convert.ToInt32(sal.EmpId), Convert.ToDateTime(sal.SalDate), Convert.ToInt32(sal.No_of_Days), Convert.ToInt32(sal.LeavesTaken), Convert.ToInt32(sal.Attend_Days), Convert.ToString(sal.Sal_Month), Convert.ToDecimal(sal.NetPayment), Convert.ToBoolean(sal.IsPaymentDone), Convert.ToInt32(sal.OTHours), ref SalId); foreach (tblSalaryDetail item in lst) { item.SalId = Convert.ToInt32(SalId); objData.tblSalaryDetails.InsertOnSubmit(item); } objData.SubmitChanges(); } catch (Exception ex) { throw ex; } return(SalId); }
public void Update(tblSalary obj, List <tblSalaryDetail> lst) { try { tblSalary objcurrent = (from tbl in objData.tblSalaries where tbl.SalId == obj.SalId select tbl).FirstOrDefault(); if (objcurrent != null) { objcurrent.IsPaymentDone = obj.IsPaymentDone; objcurrent.Attend_Days = obj.Attend_Days; objcurrent.LeavesTaken = obj.LeavesTaken; objcurrent.OTHours = obj.OTHours; objcurrent.NetPayment = obj.NetPayment; } foreach (tblSalaryDetail item in lst) { tblSalaryDetail objsal = (from tbl in objData.tblSalaryDetails where tbl.SalId == item.SalId && tbl.AllowanceDeduction_Id == item.AllowanceDeduction_Id && tbl.IsDelete == false select tbl).FirstOrDefault(); if (objsal != null) { objsal.Amount = item.Amount; objsal.IsDelete = item.IsDelete; } else { objsal = item; objData.tblSalaryDetails.InsertOnSubmit(objsal); } } objData.SubmitChanges(); } catch (Exception ex) { throw ex; } }
public bool ValidateAllocation(tblSalary sal) { try { var res = (from tbl in objData.tblSalaries where tbl.EmpId == sal.EmpId && tbl.Sal_Month == sal.Sal_Month select tbl).FirstOrDefault(); if (res != null) { return(false); } else { return(true); } } catch (Exception ex) { throw ex; } }
public void UpdateEmployee(long EmployeeId, DAL.Employee e, tblSalary s) { using (OriginatorEntities db = new OriginatorEntities()) { DAL.Employee found = db.Employees.Find(EmployeeId); if (!string.IsNullOrWhiteSpace(e.FirstName)) { found.FirstName = e.FirstName; } if (!string.IsNullOrWhiteSpace(e.LastName)) { found.LastName = e.LastName; } if (!string.IsNullOrWhiteSpace(e.Designation)) { found.Designation = e.Designation; } if (!string.IsNullOrWhiteSpace(e.ImageUrl)) { found.ImageUrl = e.ImageUrl; } if (e.ModifiedBy != null && e.ModifiedBy > 0) { found.ModifiedBy = e.ModifiedBy; } if (!string.IsNullOrWhiteSpace(e.ModifiedDate.ToString())) { found.ModifiedDate = e.ModifiedDate; } // Get Latest Salary // If Latest salary is equal to parameter wali salary then then you dont want to change anything // other wise add new entry to salary table db.SaveChanges(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { try { decimal totalAllowances = 0; decimal totalDed = 0; tblEmployee objFac = mobjSalBLL.GetEmployee(Convert.ToInt32(ddlEmployee.SelectedValue)); if (objFac != null) { tblSalary obj = new tblSalary(); if (chkIspayment.Checked == true) { obj.IsPaymentDone = true; } else { obj.IsPaymentDone = false; } if (mobjSalBLL.ValidateAllocation(obj, Convert.ToInt32(Session[" LedgerId"]))) { tblSalary sal = new tblSalary(); List <tblSalaryDetail> lst = new List <tblSalaryDetail>(); foreach (GridViewRow item in DgvAllowance.Rows) { lst.Add(new tblSalaryDetail { SalDetail_Id = Convert.ToInt32(item.Cells[0].Text), SalDate = Convert.ToDateTime(txtDos.Text), SalId = Convert.ToInt32(Session["LedgerId"]), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text) }); totalAllowances += Convert.ToDecimal(item.Cells[3].Text); } foreach (GridViewRow item in dgvDeduction.Rows) { lst.Add(new tblSalaryDetail { SalDetail_Id = Convert.ToInt32(item.Cells[0].Text), SalDate = Convert.ToDateTime(txtDos.Text), SalId = Convert.ToInt32(Session["LedgerId"]), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text) }); totalDed += Convert.ToDecimal(item.Cells[3].Text); } //List<tblSalaryDetail> lstDeletedAllDed = new List<tblSalaryDetail>(); List <EntityAllowanceDeduction> lstDel = (List <EntityAllowanceDeduction>)Session["FromEdit"]; List <EntityAllowanceDeduction> lstDelDed = (List <EntityAllowanceDeduction>)Session["FromEditDeduction"]; foreach (EntityAllowanceDeduction item in lstDel) { if (item.IsDelete) { lst.Add(new tblSalaryDetail() { AllowanceDeduction_Id = item.AllowDedId, SalId = Convert.ToInt32(Session["LedgerId"]), IsDelete = item.IsDelete, Amount = item.Amount }); } } foreach (EntityAllowanceDeduction item in lstDelDed) { if (item.IsDelete) { lst.Add(new tblSalaryDetail() { AllowanceDeduction_Id = item.AllowDedId, SalId = Convert.ToInt32(Session["LedgerId"]), IsDelete = item.IsDelete, Amount = item.Amount }); } } decimal netPay = totalAllowances - totalDed; decimal dayPayment = netPay / Convert.ToInt32(txtDays.Text); decimal hours = dayPayment / 8; decimal Payment = Convert.ToInt32(txtOTHours.Text) * decimal.Round(hours, 2); decimal monthpayment = dayPayment * Convert.ToDecimal(txtAttendDays.Text); decimal NetPayment = monthpayment + Payment; obj.IsPaymentDone = chkIspayment.Checked; obj.SalId = Convert.ToInt32(Session["LedgerId"]); obj.LeavesTaken = Convert.ToInt32(txtLeavesTaken.Text); obj.OTHours = Convert.ToInt32(txtOTHours.Text); obj.Attend_Days = Convert.ToInt32(txtAttendDays.Text); obj.NetPayment = decimal.Round(NetPayment, 0); mobjSalBLL.Update(obj, lst); lblMessage.Text = "Record Updated successfully."; List <EntityAllowanceDeduction> lstallow = new List <EntityAllowanceDeduction>(); List <EntityAllowanceDeduction> lstded = new List <EntityAllowanceDeduction>(); DgvAllowance.DataSource = lstallow; DgvAllowance.DataBind(); dgvDeduction.DataSource = lstded; dgvDeduction.DataBind(); BindSalaryAllocation(); Session["FromEditDeduction"] = null; Session["FromEdit"] = null; } } } catch (Exception ex) { lblMessage.Text = ex.Message; } MultiView1.SetActiveView(View1); }
protected void BtnSave_Click(object sender, EventArgs e) { try { bool flag = false; foreach (GridViewRow item in DgvAllowance.Rows) { bool IsBasic = mobjSalBLL.CheckIsBasic(Convert.ToInt32(item.Cells[1].Text)); if (IsBasic) { flag = true; break; } else { flag = false; } } if (!flag) { lblMsg.Text = "You shuould be add Basic in Salary"; return; } tblSalary sal = new tblSalary(); EntitySalaryDetails obj = new EntitySalaryDetails(); EntitySalary salobj = new EntitySalary(); sal.EmpId = Convert.ToInt32(ddlEmployee.SelectedValue); sal.SalDate = Convert.ToDateTime(txtDos.Text); sal.Sal_Month = string.Format("{0:MMM-yyyy}", txtMonth.Text); sal.No_of_Days = Convert.ToInt32(txtDays.Text); sal.Attend_Days = Convert.ToInt32(txtAttendDays.Text); sal.LeavesTaken = Convert.ToInt32(txtLeavesTaken.Text); sal.OTHours = Convert.ToInt32(txtOTHours.Text); decimal day = Convert.ToDecimal(txtNetAmount.Text) / Convert.ToDecimal(txtDays.Text); decimal month = day * Convert.ToDecimal(txtAttendDays.Text); decimal hour = day / 8; decimal tothour = Convert.ToInt32(txtOTHours.Text) * decimal.Round(hour, 2); decimal payment = Convert.ToDecimal(month + tothour); txtNetAmount.Text = Convert.ToString(payment); sal.NetPayment = decimal.Round(payment, 0); if (chkIspayment.Checked == true) { sal.IsPaymentDone = true; } else { sal.IsPaymentDone = false; } tblEmployee objFac = mobjSalBLL.GetEmployee(Convert.ToInt32(ddlEmployee.SelectedValue)); if (objFac != null) { tblSalary objExist = mobjSalBLL.CheckExistRecord(objFac.PKId, Convert.ToString(txtMonth.Text)); if (objExist == null) { if (mobjSalBLL.ValidateAllocation(sal)) { List <tblSalaryDetail> lst = new List <tblSalaryDetail>(); foreach (GridViewRow item in DgvAllowance.Rows) { lst.Add(new tblSalaryDetail { SalDate = Convert.ToDateTime(txtDos.Text), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text) }); } foreach (GridViewRow item in dgvDeduction.Rows) { lst.Add(new tblSalaryDetail { SalDate = Convert.ToDateTime(txtDos.Text), AllowanceDeduction_Id = Convert.ToInt32(item.Cells[1].Text), IsDelete = false, Amount = Convert.ToDecimal(item.Cells[3].Text) }); } int SalId = Convert.ToInt32(mobjSalBLL.Save(sal, lst)); lblMessage.Text = "Record Saved Successfully....."; Clear(); } } else { Clear(); List <EntityAllowanceDeduction> lst = new List <EntityAllowanceDeduction>(); List <EntityAllowanceDeduction> lstded = new List <EntityAllowanceDeduction>(); DgvAllowance.DataSource = lst; DgvAllowance.DataBind(); dgvDeduction.DataSource = lstded; dgvDeduction.DataBind(); lblMsg.Text = string.Empty; MultiView1.SetActiveView(View1); lblMessage.Text = "Salary Is Already Allocated To Employee!!"; } } else { lblMsg.Text = "Invalid Employee"; } Session["allowance"] = new List <EntityAllowanceDeduction>(); Session["Deduction"] = new List <EntityAllowanceDeduction>(); BindSalaryAllocation(); MultiView1.SetActiveView(View1); } catch (Exception ex) { lblMsg.Text = ex.Message; } }