/// <summary> /// To Update details of UserTemplateT in tbl_UserTemplate_M table /// Created By : NafisaMulla, 14-04-2015 /// Modified By : /// </summary> /// <param name="objUserTemplateTBO"></param> /// <returns></returns> public ApplicationResult UserTemplateT_Update(UserTemplateTBo objUserTemplateTBO) { try { pSqlParameter = new SqlParameter[14]; pSqlParameter[0] = new SqlParameter("@UserTemplateID", SqlDbType.Int); pSqlParameter[0].Direction = ParameterDirection.Input; pSqlParameter[0].Value = objUserTemplateTBO.UserTemplateID; pSqlParameter[1] = new SqlParameter("@UserID", SqlDbType.Int); pSqlParameter[1].Direction = ParameterDirection.Input; pSqlParameter[1].Value = objUserTemplateTBO.UserID; pSqlParameter[2] = new SqlParameter("@TrustMID", SqlDbType.Int); pSqlParameter[2].Direction = ParameterDirection.Input; pSqlParameter[2].Value = objUserTemplateTBO.TrustMID; pSqlParameter[3] = new SqlParameter("@SchoolMID", SqlDbType.Int); pSqlParameter[3].Direction = ParameterDirection.Input; pSqlParameter[3].Value = objUserTemplateTBO.SchoolMID; pSqlParameter[4] = new SqlParameter("@TrustTemplateID", SqlDbType.Int); pSqlParameter[4].Direction = ParameterDirection.Input; pSqlParameter[4].Value = objUserTemplateTBO.TrustTemplateID; pSqlParameter[5] = new SqlParameter("@Annual", SqlDbType.Float); pSqlParameter[5].Direction = ParameterDirection.Input; pSqlParameter[5].Value = objUserTemplateTBO.Annual; pSqlParameter[6] = new SqlParameter("@Monthly", SqlDbType.Float); pSqlParameter[6].Direction = ParameterDirection.Input; pSqlParameter[6].Value = objUserTemplateTBO.Monthly; pSqlParameter[7] = new SqlParameter("@Gross", SqlDbType.Float); pSqlParameter[7].Direction = ParameterDirection.Input; pSqlParameter[7].Value = objUserTemplateTBO.Gross; pSqlParameter[8] = new SqlParameter("@LastPaySlipGenerated", SqlDbType.Int); pSqlParameter[8].Direction = ParameterDirection.Input; pSqlParameter[8].Value = objUserTemplateTBO.LastPaySlipGenerated; pSqlParameter[9] = new SqlParameter("@IsDeleted", SqlDbType.Int); pSqlParameter[9].Direction = ParameterDirection.Input; pSqlParameter[9].Value = objUserTemplateTBO.IsDeleted; pSqlParameter[10] = new SqlParameter("@CreatedUserID", SqlDbType.Int); pSqlParameter[10].Direction = ParameterDirection.Input; pSqlParameter[10].Value = objUserTemplateTBO.CreatedUserID; pSqlParameter[11] = new SqlParameter("@CreatedDate", SqlDbType.VarChar); pSqlParameter[11].Direction = ParameterDirection.Input; pSqlParameter[11].Value = objUserTemplateTBO.CreatedDate; pSqlParameter[12] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int); pSqlParameter[12].Direction = ParameterDirection.Input; pSqlParameter[12].Value = objUserTemplateTBO.LastModifiedUserID; pSqlParameter[13] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar); pSqlParameter[13].Direction = ParameterDirection.Input; pSqlParameter[13].Value = objUserTemplateTBO.LastModifiedDate; sSql = "usp_tbl_UserTemplate_M_Update"; int iResult = Database.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 { objUserTemplateTBO = null; } }
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) { } } }