public void bindYear()
{
string[] strYear;
int intacYear = 0;
#region Get Accounting Start Date
ApplicationResult objResults = new ApplicationResult();
TrustBL objTrustBl = new TrustBL();
objResults = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
string strACStartDate = objResults.resultDT.Rows[0][TrustBO.TRUST_ACCOUNTSTARTDATE].ToString();
strYear = strACStartDate.ToString().Split(new char[] { '/' });
intacYear = Convert.ToInt32(strYear[2]);
}
}
#endregion
for (int i = intacYear; i <= DateTime.Now.Year; i++)
{
ddlYear.Items.Add(i.ToString());
}
ddlYear.Items.Insert(0, new ListItem("-Select-", "-1"));
}
private void GridDataBind()
{
try
{
TrustBL objTrustBl = new TrustBL();
ApplicationResult objResult = new ApplicationResult();
objResult = objTrustBl.Trust_SelectAll();
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
gvTrust.DataSource = objResult.resultDT;
gvTrust.DataBind();
PanelGrid_VisibilityMode(1);
}
else
{
PanelGrid_VisibilityMode(2);
}
}
}
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>");
}
}
public void FetchImage()
{
try
{
#region Declaretion
TrustBL objTrustBl = new TrustBL();
ApplicationResult objResultsEdit = new ApplicationResult();
#endregion
objResultsEdit = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResultsEdit != null)
{
if (objResultsEdit.resultDT.Rows.Count > 0)
{
ViewState["Bytes"] = objResultsEdit.resultDT.Rows[0][TrustBO.TRUST_TRUSTLOGO];
if (ViewState["Bytes"].ToString() != "")
{
imgphoto.ImageUrl = "../Client.UI/GetImage.ashx?TrustMID=" + Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
}
}
}
}
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>");
}
}
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>");
}
}
private void FetchLabel()
{
try
{
#region Declaretion
TrustBL objTrustBl = new TrustBL();
DataTable dtTrust = new DataTable();
#endregion
ApplicationResult objResultsEdit = new ApplicationResult();
objResultsEdit = objTrustBl.Trust_Select(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResultsEdit != null)
{
dtTrust = objResultsEdit.resultDT;
if (dtTrust.Rows.Count > 0)
{
lblTrustName.Text = dtTrust.Rows[0][TrustBO.TRUST_TRUSTNAMEENG].ToString();
}
}
}
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>");
}
}
public void getTrustName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
TrustBL objTrustBl = new TrustBL();
objResult = objTrustBl.Trust_SelectAll_ForDropDown();
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlOrgName, "TrustNameEng", "TrustMID");
}
ddlOrgName.Items.Insert(0, new ListItem("--Select--", ""));
}
}
public void getTrustName()
{
ApplicationResult objResult = new ApplicationResult();
Controls objControls = new Controls();
TrustBL objTrustBL = new TrustBL();
objResult = objTrustBL.Trust_SelectAll_ForDropDown();
if (objResult != null)
{
objControls.BindDropDown_ListBox(objResult.resultDT, ddlTrust, "TrustNameEng", "TrustMID");
if (objResult.resultDT.Rows.Count > 0)
{
}
ddlTrust.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1"));
ddlSchool.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1"));
}
}
public void BindTrust()
{
var objTrustBl = new TrustBL();
var objResult = objTrustBl.Trust_SelectAll();
if (objResult == null)
{
return;
}
if (objResult.resultDT.Rows.Count <= 0)
{
return;
}
_objControl.BindDropDown_ListBox(objResult.resultDT, ddlTrust, "TrustNameEng", "TrustMID");
ddlTrust.Items.Insert(0, new ListItem("--Select--", ""));
}
public bool ValidateName()
{
TrustBL objTrustBl = new TrustBL();
ApplicationResult objResults = new ApplicationResult();
if (ViewState["Mode"].ToString() == "Save")
{
objResults = objTrustBl.Trust_ValidateName(txtTrustName.Text, txtAbbreviation.Text, -1);
}
else
{
objResults = objTrustBl.Trust_ValidateName(txtTrustName.Text, txtAbbreviation.Text, Convert.ToInt32(ViewState["TrustMID"].ToString()));
}
if (objResults.resultDT.Rows.Count > 0)
{
return(true);
}
return(false);
}
protected void btnbackup_Click(object sender, EventArgs e)
{
try
{
TrustBL objTrustBL = new TrustBL();
ApplicationResult objResultBackup = new ApplicationResult();
objResultBackup = objTrustBL.Download_DatabaseBackup();
if (objResultBackup.status == ApplicationResult.CommonStatusType.SUCCESS)
{
bindGrid();
// Response.Redirect(Request.Url.AbsoluteUri);
//String FileName = "Navchetan"+DateTime.Now.ToString("yyyy-MM-dd")+".bak";
//String FilePath = Server.MapPath("~/DBBackups/") + FileName; //Replace this
//System.Web.HttpResponse response = System.Web.HttpContext.Current.Response;
//response.ClearContent();
//response.Clear();
//response.ContentType = "application/octet-stream";
////response.ContentType = "text/plain";
//response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ";");
//response.TransmitFile(FilePath);
//response.Flush();
//response.End();
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "Error, Please Try Again..!!";
}
}
catch (Exception ex)
{
lblMsg.Visible = true;
lblMsg.Text = "" + ex.Message.ToString();
}
}
public void RestrictNewTrust()
{
try
{
TrustBL objTrustBl = new TrustBL();
ApplicationResult objResult = new ApplicationResult();
objResult = objTrustBl.Trust_SelectAll();
if (objResult.resultDT.Rows.Count > 0)
{
//lnkAddNewTrust.Visible = false;
}
else
{
//lnkAddNewTrust.Visible = true;
}
}
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 gvTrust_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
BindYear();
ApplicationResult objResults = new ApplicationResult();
TrustBL objTrustBl = new TrustBL();
BankAssociationBL objBankBl = new BankAssociationBL();
Controls objControls = new Controls();
ViewState["TrustMID"] = Convert.ToInt32(e.CommandArgument.ToString());
objResults = objTrustBl.Abbreviation_Validation(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0, 0);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtAbbreviation.Enabled = false;
}
else
{
txtAbbreviation.Enabled = true;
}
}
if (e.CommandName.ToString() == "Edit1")
{
// txtAccStartDate.Enabled = false;
objResults = objTrustBl.Trust_Select(Convert.ToInt32(ViewState["TrustMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtTrustName.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTNAMEENG].ToString();
txtTrustNameGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTNAMEGUJ].ToString();
txtRegCode.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_REGISTRATIONCODE].ToString();
txtAbbreviation.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTABBREVIATION].ToString();
ViewState["Bytes"] = objResults.resultDT.Rows[0][TrustBO.TRUST_TRUSTLOGO];
if (ViewState["Bytes"].ToString() != "")
{
imgphoto.ImageUrl = "GetImage.ashx?TrustMID=" + ViewState["TrustMID"];
}
else
{
imgphoto.ImageUrl = "~/images/noimage-big.jpg";
//lbtnRemovePhoto.Visible = false;
}
txtApprovalNo.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALNO].ToString();
txtApprovalDate.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALDATE].ToString();
txtAccStartDate.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ACCOUNTSTARTDATE].ToString();
if (objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALYEAR].ToString() != "-Select-")
{
ddlApprovalYear.SelectedValue = objResults.resultDT.Rows[0][TrustBO.TRUST_APPROVALYEAR].ToString();
}
txtTrustAddress.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ADDRESSENG].ToString();
txtTrustAddressGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ADDRESSGUJ].ToString();
txtCountry.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_COUNTRYENG].ToString();
txtCountryGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_COUNTRYGUJ].ToString();
txtState.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_STATEENG].ToString();
txtStateGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_STATEGUJ].ToString();
txtDistrict.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_DISTRICTENG].ToString();
txtDistrictGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_DISTRICTGUJ].ToString();
txtCity.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TOWNENG].ToString();
txtcityGuj.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TOWNGUJ].ToString();
txtPincode.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_PINCODE].ToString();
txtTelephone.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_TELEPHONENO].ToString();
txtMobileNo.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_MOBILENO].ToString();
txtEmailID.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_EMAILID].ToString();
txtAlterID.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_ALTERNATEEMAILID].ToString();
txtFax.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_FAXNO].ToString();
txtWebsite.Text = objResults.resultDT.Rows[0][TrustBO.TRUST_WEBSITE].ToString();
ApplicationResult objResultsEditBank = new ApplicationResult();
DataTable dtBankAssociation = new DataTable();
objResultsEditBank = objBankBl.BankAssociation_Select_TrustMID(Convert.ToInt32(ViewState["TrustMID"].ToString()), 0);
if (objResults != null)
{
dtBankAssociation = objResultsEditBank.resultDT;
if (dtBankAssociation.Rows.Count > 0)
{
gvbankAssociation.Visible = true;
gvbankAssociation.DataSource = dtBankAssociation;
gvbankAssociation.DataBind();
}
ViewState["dtBank"] = dtBankAssociation;
}
ViewState["Mode"] = "Edit1";
PanelGrid_VisibilityMode(2);
}
}
}
else if ((e.CommandName.ToString() == "Delete"))
{
objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
objResults = objTrustBl.Validate_Trust_Delete(Convert.ToInt32(ViewState["TrustMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
if (Convert.ToInt32(objResults.resultDT.Rows[0]["TrustMID"]) == Convert.ToInt32(ViewState["TrustMID"].ToString()))
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('There are School(s) associated with this Trust. To delete this Trust you need to delete School(s) first.');</script>");
goto Exit;
}
}
}
ApplicationResult objResultsDelete = new ApplicationResult();
ApplicationResult objResultsBankDelete = new ApplicationResult();
objResultsDelete = objTrustBl.Trust_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('Trust deleted successfully.');</script>");
GridDataBind();
}
}
Exit :;
}
catch (Exception ex)
{
}
}
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>");
}
}
protected void gvSchool_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
SchoolBO objSchoolBo = new SchoolBO();
SchoolBL objSchoolBl = new SchoolBL();
TrustBL objTrustBl = new TrustBL();
ApplicationResult objResults = new ApplicationResult();
BankAssociationBL objBankBl = new BankAssociationBL();
Controls objControls = new Controls();
ViewState["SchoolMID"] = Convert.ToInt32(e.CommandArgument.ToString());
objResults = objTrustBl.Abbreviation_Validation(0, Convert.ToInt32(ViewState["SchoolMID"].ToString()), 0);
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtAbbreviation.Enabled = false;
}
else
{
txtAbbreviation.Enabled = true;
}
}
objSchoolBo.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
if (e.CommandName.ToString() == "Edit1")
{
// txtAccStartDate.Enabled = false;
objResults = objSchoolBl.School_Select(Convert.ToInt32(ViewState["SchoolMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtSchoolName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLNAMEENG].ToString();
txtSchoolNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLNAMEGUJ].ToString();
txtSchoolTiming.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLTIMING].ToString();
ddlAcademicMonth.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACADEMICMONTH].ToString();
txtSchoolCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLCODE].ToString();
ViewState["Bytes"] = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLLOGO];
if (ViewState["Bytes"].ToString() != "")
{
imgphoto.ImageUrl = "GetImage.ashx?SchoolMID=" + ViewState["SchoolMID"];
}
else
{
imgphoto.ImageUrl = "~/images/noimage-big.jpg";
//lbtnRemovePhoto.Visible = false;
}
txtAbbreviation.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLABBREVIATION].ToString();
txtAccStartDate.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ACCOUNTSTARTDATE].ToString();
txtSchoolAddress.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ADDRESSENG].ToString();
txtSchoolAddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ADDRESSGUJ].ToString();
if (objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREATYPE].ToString() == "")
{
//rblAreaType.SelectedItem.Text = "";
}
else
{
rblAreaType.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREATYPE].ToString();
}
if (objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREASUBTYPE].ToString() == "")
{
//rblAreaSubType.SelectedItem.Text = "";
}
else
{
rblAreaSubType.SelectedValue = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_AREASUBTYPE].ToString();
}
txtTown.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TOWNENG].ToString();
txtTownGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TOWNGUJ].ToString();
txtATPOEng.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ATPONOENG].ToString();
txtATPOGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ATPONOGUJ].ToString();
txtTalukaEng.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TALUKAENG].ToString();
txttalukaGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TALUKAGUJ].ToString();
txtDistrict.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_DISTRICTENG].ToString();
txtDistrictGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_DISTRICTGUJ].ToString();
txtState.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_STATEENG].ToString();
txtStateGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_STATEGUJ].ToString();
txtCountry.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_COUNTRYENG].ToString();
txtCountryGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_COUNTRYGUJ].ToString();
txtPinCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PINCODE].ToString();
txtTelephoneNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_TELEPHONENO].ToString();
txtMobileNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_MOBILENO].ToString();
txtEmailID.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_EMAILID].ToString();
txtAlternateEmail.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ALTERNATEEMAILID].ToString();
txtFax.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_FAXNO].ToString();
txtWebsite.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WEBSITE].ToString();
txtSSCIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SSCINDEXNO].ToString();
txtCommerceIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCCOMMERCEINDEXNO].ToString();
txtScienceIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCSCIENCEINDEXNO].ToString();
txtArtsIndexNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_HSCARTSINDEXNO].ToString();
txtRegistrationCode.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTRATIONCODE].ToString();
txtRegistrationName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTEREDNAMEENG].ToString();
txtRegistrationCodeGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTREREDNAMEGUJ].ToString();
// txtRegisteredAddress.Text = dtSchool.Rows[0][SchoolBO.SCHOOL_REGISTEREDADDRESSENG].ToString();
txtRegisteredddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_REGISTEREDADDRESSGUJ].ToString();
txtSchoolMotto.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLMOTTOENG].ToString();
txtSchoolMottoGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLMOTTOGUJ].ToString();
txtSchoolVision.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLVISIONENG].ToString();
txtSchoolVisionGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_SCHOOLVISIONGUJ].ToString();
if (Convert.ToInt32(objResults.resultDT.Rows[0][SchoolBO.SCHOOL_ISONRENT].ToString()) == 1)
{
chkIsRent.Checked = true;
}
else
{
chkIsRent.Checked = false;
}
txtOwnerName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERNAMEENG].ToString();
txtOwnerNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERNAMEGUJ].ToString();
txtOwnerAddress.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERADDRESSENG].ToString();
txtOwnerAddressGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_OWNERADDRESSGUJ].ToString();
txtWordNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNO].ToString();
txtWordName.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNAMEENG].ToString();
txtWardNameGuj.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_WORDNAMEGUJ].ToString();
txtPlotNo.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PLOTNO].ToString();
txtPlotArea.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_PLOTAREA].ToString();
ddlConstructionYear.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_CONSTRUNCTIONYEAR].ToString();
txtNoOfFloor.Text = objResults.resultDT.Rows[0][SchoolBO.SCHOOL_NOOFFLOORS].ToString();
ApplicationResult objResultsBankEdit = new ApplicationResult();
DataTable dtBankAssociation = new DataTable();
objResultsBankEdit = objBankBl.BankAssociation_Select_TrustMID(0, Convert.ToInt32(ViewState["SchoolMID"].ToString()));
if (objResultsBankEdit != null)
{
dtBankAssociation = objResultsBankEdit.resultDT;
if (dtBankAssociation.Rows.Count > 0)
{
gvbankAssociation.Visible = true;
gvbankAssociation.DataSource = dtBankAssociation;
gvbankAssociation.DataBind();
}
ViewState["dtBank"] = dtBankAssociation;
}
ViewState["Mode"] = "Edit1";
PanelGrid_VisibilityMode(2);
}
}
}
else if ((e.CommandName.ToString() == "Delete1"))
{
objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
objResults = objSchoolBl.Validate_School_Delete(Convert.ToInt32(ViewState["SchoolMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
if (Convert.ToInt32(objResults.resultDT.Rows[1]["SchoolMID"]) == Convert.ToInt32(ViewState["SchoolMID"].ToString()))
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('There are Section(s)/Student(s) associated with this School. To delete this School you need to delete Section(s)/Student(s) first.');</script>");
goto Exit;
}
}
}
ApplicationResult objResultsDelete = new ApplicationResult();
ApplicationResult objResultsBankDelete = new ApplicationResult();
objResultsDelete = objSchoolBl.School_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='JavaScript'>alert('School deleted successfully.');</script>");
GridDataBind();
}
}
Exit :;
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public void ProcessRequest(HttpContext context)
{
DataTable dtResult = new DataTable();
SchoolBL objSchoolBL = new SchoolBL();
StudentBL objStudentBL = new StudentBL();
EmployeeMBL objEmployeeBL = new EmployeeMBL();
TrustBL objTrustBL = new TrustBL();
ApplicationResult objResult = new ApplicationResult();
Controls objControl = new Controls();
byte[] imgByte = { };
if (context.Request.QueryString["StudentMID"] != null)
{
objResult = objStudentBL.Student_Select(Convert.ToInt32(context.Request.QueryString["StudentMID"].ToString()), 0);
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
imgByte = (byte[])objResult.resultDT.Rows[0]["StudentPhoto"];
}
}
}
else if (context.Request.QueryString["SchoolMID"] != null)
{
objResult = objSchoolBL.School_Select(Convert.ToInt32(context.Request.QueryString["SchoolMID"].ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
imgByte = (byte[])objResult.resultDT.Rows[0]["SchoolLogo"];
}
}
}
else if (context.Request.QueryString["EmployeeMID"] != null)
{
objResult = objEmployeeBL.EmployeeM_Select(Convert.ToInt32(context.Request.QueryString["EmployeeMID"].ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
imgByte = (byte[])objResult.resultDT.Rows[0]["Photo"];
}
}
}
else
{
objResult = objTrustBL.Trust_Select(Convert.ToInt32(context.Request.QueryString["TrustMID"].ToString()));
if (objResult != null)
{
if (objResult.resultDT.Rows.Count > 0)
{
imgByte = (byte[])objResult.resultDT.Rows[0]["TrustLogo"];
}
}
}
// objResult = objVisitorBL.Visitor_Select(1);
context.Response.BinaryWrite(imgByte);
context.Response.End();
context.Response.Clear();
context.Response.ClearHeaders();
context.Response.ClearContent();
}
protected void gvSection_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
Controls objControls = new Controls();
ApplicationResult objResults = new ApplicationResult();
TrustBL objTrustBl = new TrustBL();
SectionBL objSectionBL = new SectionBL();
ViewState["SectionMID"] = Convert.ToInt32(e.CommandArgument.ToString());
objResults = objTrustBl.Abbreviation_Validation(0, 0, Convert.ToInt32(ViewState["SectionMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtAbbreviation.Enabled = false;
}
else
{
txtAbbreviation.Enabled = true;
}
}
if (e.CommandName.ToString() == "Edit1")
{
objResults = objSectionBL.Section_Select(Convert.ToInt32(ViewState["SectionMID"].ToString()));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
txtSectionName.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONNAME].ToString();
txtAbbreviation.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_SECTIONAVBBREVIATION].ToString();
txtSectionDesc.Text = objResults.resultDT.Rows[0][SectionBO.SECTION_DESCRIPTION].ToString();
ViewState["Mode"] = "Edit1";
PanelGrid_VisibilityMode(2);
}
}
}
else if ((e.CommandName.ToString() == "Delete1"))
{
objControls.EnableControls(Master.FindControl("ContentPlaceHolder1"));
objResults = objSectionBL.Validate_Section_Delete(Convert.ToInt32(ViewState["SectionMID"].ToString()), Convert.ToInt32(Session[ApplicationSession.SCHOOLID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
if (Convert.ToInt32(objResults.resultDT.Rows[0]["SectionMID"]) == Convert.ToInt32(ViewState["SectionMID"].ToString()))
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('There are Classes(s) associated with this Section. To delete this Section you need to delete Classes(s) first.');</script>");
goto Exit;
}
}
}
ApplicationResult objResultsDelete = new ApplicationResult();
objResultsDelete = objSectionBL.Section_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResultsDelete.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ApplicationResult objResultsDeleteT = new ApplicationResult();
objResultsDeleteT = objSectionBL.SectionT_Delete(Convert.ToInt32(e.CommandArgument.ToString()));
if (objResultsDeleteT.status == ApplicationResult.CommonStatusType.SUCCESS)
{
}
ClearAll();
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script language='javascript'>alert('Section deleted successfully.');</script>");
GridDataBind();
PanelGrid_VisibilityMode(1);
}
}
Exit :;
}
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>");
}
}
