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