/// <summary>
/// To Update details of TrustTemplate in tbl_TrustTemplate_M table
/// Created By : NafisaMulla, 09-04-2015
/// Modified By :
/// </summary>
/// <param name="objTrustTemplateBO"></param>
/// <returns></returns>
public ApplicationResult TrustTemplate_Update(TrustTemplateBo objTrustTemplateBO)
{
try
{
pSqlParameter = new SqlParameter[5];
pSqlParameter[0] = new SqlParameter("@TrustTemplateID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objTrustTemplateBO.TrustTemplateID;
pSqlParameter[1] = new SqlParameter("@TrustTemplateName", SqlDbType.NVarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objTrustTemplateBO.TrustTemplateName;
pSqlParameter[2] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objTrustTemplateBO.TrustMID;
pSqlParameter[3] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objTrustTemplateBO.LastModifiedUserID;
pSqlParameter[4] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objTrustTemplateBO.LastModifiedDate;
sSql = "usp_tbl_TrustTemplate_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
{
objTrustTemplateBO = null;
}
}
protected void btnAddTemplate_OnClick(object sender, EventArgs e)
{
try
{
TrustTemplateBo objTrustTemplateBo = new TrustTemplateBo();
ApplicationResult objResult = new ApplicationResult();
TrustTemplateBl ObjTrustTemplatemBl = new TrustTemplateBl();
if (txtTemplateName.Text != "")
{
objTrustTemplateBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objTrustTemplateBo.TrustTemplateName = txtTemplateName.Text.Trim();
objTrustTemplateBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objTrustTemplateBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
if (ViewState["Mode"].ToString() == "Save")
{
objTrustTemplateBo.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objTrustTemplateBo.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objResult = ObjTrustTemplatemBl.TrustTemplate_Insert(objTrustTemplateBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "divHide();", true);
txtTemplateName.Text = "";
BindTemplateName();
GridTemplateBind();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Template Name Saved Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Template Name already Exists.');</script>");
}
}
else
{
objTrustTemplateBo.TrustTemplateID = Convert.ToInt32(ViewState["TrustTemplateID"].ToString());
objResult = ObjTrustTemplatemBl.TrustTemplate_Update(objTrustTemplateBo);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "divHide();", true);
txtTemplateName.Text = "";
BindTemplateName();
GridTemplateBind();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Template Name Updated Successfully.');</script>");
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Template Name already Exists.');</script>");
}
}
ViewState["Mode"] = "Save";
}
else
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Write template Name.');</script>");
}
}
catch (Exception ex)
{
}
}
