/// <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)
{
}
}
}