/// <summary> /// To Update details of UserPayItemTemplateT in tbl_UserPayItemTemplate_T table /// Created By : NafisaMulla, 14-04-2015 /// Modified By : /// </summary> /// <param name="objUserPayItemTemplateTBO"></param> /// <returns></returns> public ApplicationResult UserPayItemTemplateT_Update(UserPayItemTemplateTBo objUserPayItemTemplateTBO) { try { pSqlParameter = new SqlParameter[9]; pSqlParameter[0] = new SqlParameter("@UserPayItemTemplateID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objUserPayItemTemplateTBO.UserPayItemTemplateID; pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objUserPayItemTemplateTBO.TrustMID; pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objUserPayItemTemplateTBO.SchoolMID; pSqlParameter[3] = new SqlParameter("@UserTemplateID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objUserPayItemTemplateTBO.UserTemplateID; pSqlParameter[4] = new SqlParameter("@PayItem", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objUserPayItemTemplateTBO.PayItem; pSqlParameter[5] = new SqlParameter("@Percentage", SqlDbType.Float); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objUserPayItemTemplateTBO.Percentage; pSqlParameter[6] = new SqlParameter("@Amount", SqlDbType.Float); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objUserPayItemTemplateTBO.Amount; pSqlParameter[7] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objUserPayItemTemplateTBO.LastModifiedUserID; pSqlParameter[8] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objUserPayItemTemplateTBO.LastModifiedDate; sSql = "usp_tbl_UserPayItemTemplate_T_Update"; int iResult = DatabaseTransaction.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter); if (iResult > 0) { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.SUCCESS; return(objResults); } else { ApplicationResult objResults = new ApplicationResult(); objResults.status = ApplicationResult.CommonStatusType.FAILURE; return(objResults); } } catch (Exception ex) { throw ex; } finally { objUserPayItemTemplateTBO = null; } }
protected void gvSelectedPayItem_RowCommand(object sender, GridViewCommandEventArgs e) { try { UserPayItemTemplateTBl objUserPayItemtBL = new UserPayItemTemplateTBl(); UserPayItemTemplateTBo objUserPayItemBO = new UserPayItemTemplateTBo(); TrustPayItemBl objTrustPayItemBl = new TrustPayItemBl(); ApplicationResult objResultsPayItem = new ApplicationResult(); string[] commandArgs = e.CommandArgument.ToString().Split(new char[] { ',' }); ViewState["UserTemplateID"] = commandArgs[0]; ViewState["PayItemMID"] = commandArgs[1]; ViewState["UserPayItemTemplateID"] = commandArgs[2]; if (e.CommandName.ToString() == "Edit1") { PanelVisibility(false, true, true, true); txtPayItemName.Enabled = false; ddlPayItemType.Enabled = false; ddlDependsOn.Enabled = false; btnApplyTemplate.Visible = false; ddlTemplate.Enabled = false; txtAnnual.Enabled = false; txtMonthly.Enabled = false; txtGross.Enabled = false; String[] Depends; // PayItemType = gdSelectedPayItem.SelectedRow.Cells[3].Text; TrustPayItemTemplateTBl objTrustPayItemTemplateBl = new TrustPayItemTemplateTBl(); ApplicationResult objResults = new ApplicationResult(); Controls objControls = new Controls(); objResults = objTrustPayItemTemplateBl.TrustPayItemTemplate_Select_PayItemWise(Convert.ToInt32(ddlTemplate.SelectedValue)); objControls.BindDropDown_ListBox(objResults.resultDT, ddlDependsOn, "Name", "PayItemMID"); ddlDependsOn.Items.Insert(0, new ListItem("-Select-", "-1")); objResultsPayItem = objTrustPayItemBl.PayItemTemplate_SelectAll_BothID(Convert.ToInt32(ViewState["UserTemplateID"].ToString()), Convert.ToInt32(ViewState["PayItemMID"].ToString())); if (objResultsPayItem != null) { if (objResultsPayItem.resultDT.Rows.Count > 0) { txtAmount.Text = Convert.ToString(Math.Round(Convert.ToDouble(objControls.ConvertToCurrancy(objResultsPayItem.resultDT.Rows[0]["Amount"].ToString())), 2)); txtPercentage.Text = objResultsPayItem.resultDT.Rows[0]["Percentage"].ToString(); Depends = objResultsPayItem.resultDT.Rows[0]["DependsOn"].ToString().Split(','); int i = 0; int len = Depends.Length; for (i = 0; i < len; i++) { if (i >= len) { break; } else { if (Depends[i] != "NULL" && Depends[i] != " " && Depends[i] != "" && Depends[i] != "0") { //cbDependsOn.SelectedValue = str[i]; // cbDependsOn.Items.Add(Depends[i]); ddlDependsOn.SelectedValue = Depends[i]; } else { ddlDependsOn.SelectedValue = null; } } } txtPayItemName.Text = objResultsPayItem.resultDT.Rows[0]["Name"].ToString(); // ddlPayItemType.SelectedValue = gvSelectedPayItem.SelectedRow.Cells[3].Text; if (objResultsPayItem.resultDT.Rows[0]["Type"].ToString() == "Dependent") { ddlPayItemType.SelectedValue = "1"; txtPercentage.Enabled = true; txtPercentage.BackColor = System.Drawing.Color.White; txtAmount.BackColor = System.Drawing.Color.Gainsboro; } else if (objResultsPayItem.resultDT.Rows[0]["Type"].ToString() == "Independent") { ddlPayItemType.SelectedValue = "0"; txtAmount.Enabled = true; txtAmount.BackColor = System.Drawing.Color.White; txtPercentage.BackColor = System.Drawing.Color.Gainsboro; txtPercentage.Enabled = false; } else if (objResultsPayItem.resultDT.Rows[0]["Type"].ToString() == "Depends On Gross") { ddlPayItemType.SelectedValue = "2"; txtPercentage.Enabled = true; txtPercentage.BackColor = System.Drawing.Color.White; txtAmount.BackColor = System.Drawing.Color.Gainsboro; txtAmount.Enabled = false; } } } } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { UserPayItemTemplateTBl objUserPayItemtBL = new UserPayItemTemplateTBl(); UserPayItemTemplateTBo objUserPayItemBO = new UserPayItemTemplateTBo(); ApplicationResult objResultsPayItem = new ApplicationResult(); objUserPayItemBO.UserPayItemTemplateID = Convert.ToInt32(ViewState["UserPayItemTemplateID"].ToString()); objUserPayItemBO.PayItem = Convert.ToInt32(ViewState["PayItemMID"].ToString()); objUserPayItemBO.UserTemplateID = Convert.ToInt32(ViewState["UserTemplateID"].ToString()); objUserPayItemBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()); objUserPayItemBO.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString()); objUserPayItemBO.Amount = Convert.ToDouble(txtAmount.Text.Trim()); objUserPayItemBO.Percentage = Convert.ToDouble(txtPercentage.Text.Trim()); objUserPayItemBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUserPayItemBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResultsPayItem = objUserPayItemtBL.UserPayItemTemplateT_Update(objUserPayItemBO); if (objResultsPayItem.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record Successfully Updated');</script>"); objResultsPayItem = objUserPayItemtBL.Employee_Select_ByEmployeeID(Convert.ToInt32(ViewState["EmployeeMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResultsPayItem != null) { gvSelectedPayItem.DataSource = objResultsPayItem.resultDT; gvSelectedPayItem.DataBind(); if (objResultsPayItem.resultDT.Rows.Count > 0) { gvSelectedPayItem.Visible = true; } } GridConvertion(); for (int i = 0; i < gvSelectedPayItem.Rows.Count; ++i) { if (txtPayItemName.Text == gvSelectedPayItem.Rows[i].Cells[5].Text) { str = Convert.ToDouble(gvSelectedPayItem.Rows[i].Cells[6].Text); sum = Math.Round((str * Convert.ToDouble(gvSelectedPayItem.SelectedRow.Cells[7].Text)) / 100);; gvSelectedPayItem.Rows[i].Cells[7].Text = sum.ToString(); objUserPayItemBO.UserTemplateID = Convert.ToInt32(gvSelectedPayItem.Rows[i].Cells[8].Text); objUserPayItemBO.PayItem = Convert.ToInt32(gvSelectedPayItem.Rows[i].Cells[0].Text); objUserPayItemBO.UserTemplateID = Convert.ToInt32(gvSelectedPayItem.Rows[i].Cells[1].Text); objUserPayItemBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()); objUserPayItemBO.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString()); objUserPayItemBO.Amount = Convert.ToDouble(gvSelectedPayItem.Rows[i].Cells[7].Text); objUserPayItemBO.Percentage = Convert.ToDouble(gvSelectedPayItem.Rows[i].Cells[6].Text); objUserPayItemBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUserPayItemBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResultsPayItem = objUserPayItemtBL.UserPayItemTemplateT_Update(objUserPayItemBO); } } PanelVisibility(false, true, true, false); btnApplyTemplate.Visible = false; ddlTemplate.Enabled = false; txtAnnual.Enabled = false; txtMonthly.Enabled = false; txtGross.Enabled = false; } } catch (Exception ex) { logger.Error("Error", ex); ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>"); } }
protected void btnApplyTemplate_Click(object sender, EventArgs e) { if (Page.IsValid == true) { double BasicAmt = 0; double Earnings = 0; double DA = 0; //if (txtGross.Text == "") //{ // lblMsg.Text = "Please Enter the Gross Amount"; // lblMsg.Visible = true; //} UserTemplateTBl objUserTemplateBl = new UserTemplateTBl(); UserTemplateTBo objUTemplateBo = new UserTemplateTBo(); ApplicationResult objResult = new ApplicationResult(); Controls objControls = new Controls(); try { objUTemplateBo.UserID = Convert.ToInt32(Convert.ToInt32(ViewState["EmployeeMID"].ToString())); objUTemplateBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objUTemplateBo.SchoolMID = Convert.ToInt32(Convert.ToInt32(ViewState["SchoolMID"].ToString())); objUTemplateBo.TrustTemplateID = Convert.ToInt32(ddlTemplate.SelectedValue.ToString()); objUTemplateBo.Annual = 0; // Convert.ToDouble(txtAnnual.Text.Trim()); objUTemplateBo.Monthly = 0; // Convert.ToDouble(txtMonthly.Text.Trim()); objUTemplateBo.Gross = Convert.ToDouble(txtGross.Text.ToString()); objUTemplateBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUTemplateBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objUTemplateBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUTemplateBo.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objResult = objUserTemplateBl.UserTemplateT_Insert(objUTemplateBo); int i; ViewState["UserTemplateID"] = objResult.resultDT.Rows[0][0].ToString(); UserPayItemTemplateTBl objUserPayItemTemplateBl = new UserPayItemTemplateTBl(); UserPayItemTemplateTBo objUserPayItemTemplateTBo = new UserPayItemTemplateTBo(); for (i = 0; i < gvPayItem.Rows.Count; ++i) { objUserPayItemTemplateTBo.UserTemplateID = Convert.ToInt32(ViewState["UserTemplateID"].ToString()); objUserPayItemTemplateTBo.PayItem = Convert.ToInt32(gvPayItem.Rows[i].Cells[0].Text); objUserPayItemTemplateTBo.Type = gvPayItem.Rows[i].Cells[2].Text; if (gvPayItem.Rows[i].Cells[5].Text == " ") { objUserPayItemTemplateTBo.Percentage = 0; } else { objUserPayItemTemplateTBo.Percentage = Convert.ToDouble(gvPayItem.Rows[i].Cells[5].Text); } //objUserPayItemTemplateTBo.Percentage = Convert.ToDouble(gvPayItem.Rows[i].Cells[5].Text); objUserPayItemTemplateTBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]); objUserPayItemTemplateTBo.SchoolMID = Convert.ToInt32(Convert.ToInt32(ViewState["SchoolMID"].ToString())); if (gvPayItem.Rows[i].Cells[2].Text == " ") { gvPayItem.Rows[i].Cells[2].Text = ""; objUserPayItemTemplateTBo.DependsOn = gvPayItem.Rows[i].Cells[3].Text.ToString(); } else { objUserPayItemTemplateTBo.DependsOn = gvPayItem.Rows[i].Cells[3].Text.ToString(); } #region Riken changes String str; String[] strPatItem; if (gvPayItem.Rows[i].Cells[2].Text.ToString() == "Independent") { objUserPayItemTemplateTBo.Amount = Convert.ToDouble(gvPayItem.Rows[i].Cells[6].Text); } if (gvPayItem.Rows[i].Cells[2].Text.ToString() == "Depends On Gross") { BasicAmt = Convert.ToDouble(txtGross.Text) * Convert.ToDouble(gvPayItem.Rows[i].Cells[5].Text.ToString()) / 100; BasicAmt = Math.Round(BasicAmt); objUserPayItemTemplateTBo.Amount = BasicAmt; gvPayItem.Rows[i].Cells[6].Text = BasicAmt.ToString(); } if (gvPayItem.Rows[i].Cells[2].Text.ToString() == "Dependent") { Double SumAmount = 0; Double amt = 0; str = gvPayItem.Rows[i].Cells[4].Text.ToString(); strPatItem = str.Split(','); // for (int j = 0; j < strPatItem.Length; j++) for (int j = 0; j < gvPayItem.Rows.Count; j++) { for (int k = 0; k < strPatItem.Length; k++) { if (strPatItem[k] == gvPayItem.Rows[j].Cells[1].Text.ToString()) { SumAmount = SumAmount + Convert.ToDouble(gvPayItem.Rows[j].Cells[6].Text.ToString()); } } } amt = SumAmount * Convert.ToDouble(gvPayItem.Rows[i].Cells[5].Text.ToString()) / 100; amt = Math.Round(amt); objUserPayItemTemplateTBo.Amount = amt; gvPayItem.Rows[i].Cells[6].Text = amt.ToString(); } #endregion objUserPayItemTemplateTBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUserPayItemTemplateTBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); objUserPayItemTemplateTBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString(); objUserPayItemTemplateTBo.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]); //} //objUserPayItemTemplateBO.Amount = Convert.ToDouble(gdPayItem.Rows[i].Cells[6].Text); objResult = objUserPayItemTemplateBl.UserPayItemTemplateT_Insert(objUserPayItemTemplateTBo); // intResult = objUserPayItemTemplateBA.UserPayItemTemplate_Insert(objUserPayItemTemplateBO); } foreach (GridViewRow rowItem in gvPayItem.Rows) { if (rowItem.Cells[1].Text == "SA") { objResult = objUserTemplateBl.EmployeeTemplate_SelectForZero(Convert.ToInt32(ViewState["EmployeeMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); for (int a = 0; a < objResult.resultDT.Rows.Count; a++) { Earnings = Earnings + (Convert.ToDouble(objResult.resultDT.Rows[a]["Amount"].ToString())); } objUserPayItemTemplateTBo.UserTemplateID = Convert.ToInt32(ViewState["UserTemplateID"].ToString()); objUserPayItemTemplateTBo.PayItem = 5; objUserPayItemTemplateTBo.Type = "1"; objUserPayItemTemplateTBo.DependsOn = "0"; objUserPayItemTemplateTBo.Percentage = 0; objUserPayItemTemplateTBo.Amount = Math.Round(Convert.ToDouble(txtGross.Text.ToString()) - Earnings, 2); objResult = objUserPayItemTemplateBl.UserPayItemTemplateT_Insert(objUserPayItemTemplateTBo); break; } } if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS) { ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Record Inserted Successfully');</script>"); objResult = objUserTemplateBl.Employee_Select_ForPayItemTemplate(Convert.ToInt32(ViewState["EmployeeMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); if (objResult != null) { if (objResult.resultDT.Rows.Count > 0) { gvSelectedPayItem.Visible = true; objResult = objUserPayItemTemplateBl.Employee_Select_ByEmployeeID(Convert.ToInt32(ViewState["EmployeeMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(Session[ApplicationSession.SCHOOLID])); gvSelectedPayItem.DataSource = objResult.resultDT; gvSelectedPayItem.DataBind(); for (int j = 0; j < gvSelectedPayItem.Rows.Count; ++j) { sum = sum + Math.Round(Convert.ToDouble(gvSelectedPayItem.Rows[j].Cells[7].Text), 2); } txtMonthly.Text = Convert.ToString(Math.Round(Convert.ToDouble(objControls.ConvertToCurrancy(sum.ToString())), 2)); txtAnnual.Text = Convert.ToString(Math.Round(Convert.ToDouble(objControls.ConvertToCurrancy((12 * sum).ToString())), 2)); GridConvertion(); PanelVisibility(false, true, true, false); btnApplyTemplate.Visible = false; txtMonthly.Enabled = false; txtAnnual.Enabled = false; txtGross.Enabled = false; ddlTemplate.Enabled = false; } else { PanelVisibility(true, false, false, true); objControls.EnableControls(Master.FindControl("ContentPlaceHolder1")); ddlDependsOn.Enabled = false; ddlDependsOn.Items.Clear(); ddlDependsOn.BackColor = System.Drawing.Color.Gainsboro; ddlPayItemType.Enabled = false; ddlPayItemType.BackColor = System.Drawing.Color.Gainsboro; txtAmount.Enabled = false; txtAmount.BackColor = System.Drawing.Color.Gainsboro; //txtPayItemName.Enabled = false; //txtPayItemName.BackColor = System.Drawing.Color.Gainsboro; txtPercentage.Enabled = false; txtPercentage.BackColor = System.Drawing.Color.Gainsboro; // btnApplyOrganisationTemplate.Enabled = true; txtAnnual.Enabled = false; txtAnnual.BackColor = System.Drawing.Color.Gainsboro; txtMonthly.Enabled = false; txtMonthly.BackColor = System.Drawing.Color.Gainsboro; } } } } catch (Exception ex) { } } }