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