public void bindTrust()
{
try
{
#region Bind Trust
TrustBL objTrustBL = new TrustBL();
TrustBO objTrustBO = new TrustBO();
Controls objControls = new Controls();
ApplicationResult objResultTrust = new ApplicationResult();
objResultTrust = objTrustBL.Trust_SelectAll();
if (objResultTrust != null)
{
if (objResultTrust.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResultTrust.resultDT, ddlTrustID, "TrustNameEng", "TrustMID");
}
ddlTrustID.Items.Insert(0, new ListItem("-Select-", "-1"));
}
#endregion
}
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
{
TrustBO objTrustBo = new TrustBO();
TrustBL objTrustBl = new TrustBL();
BankAssociationBL objBankBl = new BankAssociationBL();
BankAssociationBO objBankBo = new BankAssociationBO();
ApplicationResult objResults = new ApplicationResult();
Controls objControls = new Controls();
//objTrustBo.TrustMID = Convert.ToInt32(ViewState["TrustMID"].ToString());
objTrustBo.TrustNameEng = txtTrustName.Text;
objTrustBo.TrustNameGuj = txtTrustNameGuj.Text;
objTrustBo.RegistrationCode = txtRegCode.Text;
objTrustBo.TrustAbbreviation = txtAbbreviation.Text;
if (ViewState["Bytes"] != null)
{
objTrustBo.TrustLogo = (byte[])ViewState["Bytes"];
}
else
{
objTrustBo.TrustLogo = ImageToByteArrayFromFilePath("../Images/NoImage-big.jpg");
}
objTrustBo.ApprovalNo = txtApprovalNo.Text;
objTrustBo.ApprovalDate = txtApprovalDate.Text;
objTrustBo.AccountStartDate = txtAccStartDate.Text;
objTrustBo.ApprovalYear = ddlApprovalYear.SelectedItem.ToString();
objTrustBo.AddressEng = txtTrustAddress.Text;
objTrustBo.AddressGuj = txtTrustAddressGuj.Text;
objTrustBo.CountryEng = txtCountry.Text;
objTrustBo.CountryGuj = txtCountryGuj.Text;
objTrustBo.StateEng = txtState.Text;
objTrustBo.StateGuj = txtStateGuj.Text;
objTrustBo.DistrictEng = txtDistrict.Text;
objTrustBo.DistrictGuj = txtDistrictGuj.Text;
objTrustBo.TownEng = txtCity.Text;
objTrustBo.TownGuj = txtcityGuj.Text;
objTrustBo.Pincode = txtPincode.Text;
objTrustBo.TelephoneNo = txtTelephone.Text;
objTrustBo.MobileNo = txtMobileNo.Text;
objTrustBo.EmailId = txtEmailID.Text;
objTrustBo.AlternateEmailId = txtAlterID.Text;
objTrustBo.FaxNo = txtFax.Text;
objTrustBo.Website = txtWebsite.Text;
objTrustBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objTrustBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objBankBo.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objBankBo.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
if (ValidateName() == true)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert(Trust Name " + txtTrustName.Text + " Already Exists.');</script>");
goto Exit;
}
#region RollBack Transaction Starts
DatabaseTransaction.OpenConnectionTransation();
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objTrustBl.Trust_Insert(objTrustBo);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
ViewState["TrustMID"] = Convert.ToInt32(objResults.resultDT.Rows[0][0].ToString());
InsertBank();
}
ClearAll();
GridDataBind();
PanelGrid_VisibilityMode(1);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust Created Successfully');</script>");
}
}
else
{
objResults = objBankBl.BankAssociation_Delete_TrustMID(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
InsertBank();
objTrustBo.TrustMID = Convert.ToInt32(ViewState["TrustMID"].ToString());
objResults = objTrustBl.Trust_Update(objTrustBo);
if (objResults.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust updated successfully');</script>");
ClearAll();
objControls.ClearForm(Master.FindControl("ContentPlaceHolder1"));
ViewState["Mode"] = "Save";
btnSave.Text = "Save";
txtAccStartDate.Enabled = true;
}
}
DatabaseTransaction.CommitTransation();
GridDataBind();
#endregion
Exit :;
}
catch (Exception ex)
{
DatabaseTransaction.RollbackTransation();
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
/// <summary>
/// To Update details of Trust in tbl_Trust_M table
/// Created By : NafisaMulla, 27/6/2014
/// Modified By :
/// </summary>
/// <param name="objTrustBO"></param>
/// <returns></returns>
public ApplicationResult Trust_Update(TrustBO objTrustBO)
{
try
{
pSqlParameter = new SqlParameter[30];
pSqlParameter[0] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objTrustBO.TrustMID;
pSqlParameter[1] = new SqlParameter("@TrustNameEng", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objTrustBO.TrustNameEng;
pSqlParameter[2] = new SqlParameter("@TrustNameGuj", SqlDbType.NVarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objTrustBO.TrustNameGuj;
pSqlParameter[3] = new SqlParameter("@TrustAbbreviation", SqlDbType.VarChar);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objTrustBO.TrustAbbreviation;
pSqlParameter[4] = new SqlParameter("@TrustLogo", SqlDbType.Image);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objTrustBO.TrustLogo;
pSqlParameter[5] = new SqlParameter("@RegistrationCode", SqlDbType.VarChar);
pSqlParameter[5].Direction = ParameterDirection.Input;
pSqlParameter[5].Value = objTrustBO.RegistrationCode;
pSqlParameter[6] = new SqlParameter("@AddressEng", SqlDbType.VarChar);
pSqlParameter[6].Direction = ParameterDirection.Input;
pSqlParameter[6].Value = objTrustBO.AddressEng;
pSqlParameter[7] = new SqlParameter("@AddressGuj", SqlDbType.NVarChar);
pSqlParameter[7].Direction = ParameterDirection.Input;
pSqlParameter[7].Value = objTrustBO.AddressGuj;
pSqlParameter[8] = new SqlParameter("@TownEng", SqlDbType.VarChar);
pSqlParameter[8].Direction = ParameterDirection.Input;
pSqlParameter[8].Value = objTrustBO.TownEng;
pSqlParameter[9] = new SqlParameter("@TownGuj", SqlDbType.NVarChar);
pSqlParameter[9].Direction = ParameterDirection.Input;
pSqlParameter[9].Value = objTrustBO.TownGuj;
pSqlParameter[10] = new SqlParameter("@DistrictEng", SqlDbType.VarChar);
pSqlParameter[10].Direction = ParameterDirection.Input;
pSqlParameter[10].Value = objTrustBO.DistrictEng;
pSqlParameter[11] = new SqlParameter("@DistrictGuj", SqlDbType.NVarChar);
pSqlParameter[11].Direction = ParameterDirection.Input;
pSqlParameter[11].Value = objTrustBO.DistrictGuj;
pSqlParameter[12] = new SqlParameter("@StateEng", SqlDbType.VarChar);
pSqlParameter[12].Direction = ParameterDirection.Input;
pSqlParameter[12].Value = objTrustBO.StateEng;
pSqlParameter[13] = new SqlParameter("@StateGuj", SqlDbType.NVarChar);
pSqlParameter[13].Direction = ParameterDirection.Input;
pSqlParameter[13].Value = objTrustBO.StateGuj;
pSqlParameter[14] = new SqlParameter("@CountryEng", SqlDbType.VarChar);
pSqlParameter[14].Direction = ParameterDirection.Input;
pSqlParameter[14].Value = objTrustBO.CountryEng;
pSqlParameter[15] = new SqlParameter("@CountryGuj", SqlDbType.NVarChar);
pSqlParameter[15].Direction = ParameterDirection.Input;
pSqlParameter[15].Value = objTrustBO.CountryGuj;
pSqlParameter[16] = new SqlParameter("@Pincode", SqlDbType.VarChar);
pSqlParameter[16].Direction = ParameterDirection.Input;
pSqlParameter[16].Value = objTrustBO.Pincode;
pSqlParameter[17] = new SqlParameter("@TelephoneNo", SqlDbType.VarChar);
pSqlParameter[17].Direction = ParameterDirection.Input;
pSqlParameter[17].Value = objTrustBO.TelephoneNo;
pSqlParameter[18] = new SqlParameter("@MobileNo", SqlDbType.VarChar);
pSqlParameter[18].Direction = ParameterDirection.Input;
pSqlParameter[18].Value = objTrustBO.MobileNo;
pSqlParameter[19] = new SqlParameter("@EmailId", SqlDbType.VarChar);
pSqlParameter[19].Direction = ParameterDirection.Input;
pSqlParameter[19].Value = objTrustBO.EmailId;
pSqlParameter[20] = new SqlParameter("@AlternateEmailId", SqlDbType.VarChar);
pSqlParameter[20].Direction = ParameterDirection.Input;
pSqlParameter[20].Value = objTrustBO.AlternateEmailId;
pSqlParameter[21] = new SqlParameter("@FaxNo", SqlDbType.VarChar);
pSqlParameter[21].Direction = ParameterDirection.Input;
pSqlParameter[21].Value = objTrustBO.FaxNo;
pSqlParameter[22] = new SqlParameter("@Website", SqlDbType.VarChar);
pSqlParameter[22].Direction = ParameterDirection.Input;
pSqlParameter[22].Value = objTrustBO.Website;
pSqlParameter[23] = new SqlParameter("@ApprovalYear", SqlDbType.VarChar);
pSqlParameter[23].Direction = ParameterDirection.Input;
pSqlParameter[23].Value = objTrustBO.ApprovalYear;
pSqlParameter[24] = new SqlParameter("@ApprovalDate", SqlDbType.VarChar);
pSqlParameter[24].Direction = ParameterDirection.Input;
pSqlParameter[24].Value = objTrustBO.ApprovalDate;
pSqlParameter[25] = new SqlParameter("@ApprovalNo", SqlDbType.VarChar);
pSqlParameter[25].Direction = ParameterDirection.Input;
pSqlParameter[25].Value = objTrustBO.ApprovalNo;
pSqlParameter[26] = new SqlParameter("@IsDeleted", SqlDbType.Int);
pSqlParameter[26].Direction = ParameterDirection.Input;
pSqlParameter[26].Value = objTrustBO.IsDeleted;
pSqlParameter[27] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[27].Direction = ParameterDirection.Input;
pSqlParameter[27].Value = objTrustBO.LastModifiedUserID;
pSqlParameter[28] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[28].Direction = ParameterDirection.Input;
pSqlParameter[28].Value = objTrustBO.LastModifiedDate;
pSqlParameter[29] = new SqlParameter("@AccountStartDate", SqlDbType.VarChar);
pSqlParameter[29].Direction = ParameterDirection.Input;
pSqlParameter[29].Value = objTrustBO.AccountStartDate;
sSql = "usp_tbl_Trust_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
{
objTrustBO = null;
}
}
