private void Page_Load(object sender, System.EventArgs e) { if (Session["UserID"] == null) { Response.Redirect("../../close_win.aspx"); } baseUtil.keepAlive(this); Session["SelectedPage"] = "BranchManagement"; if (!Page.IsPostBack) { if (Convert.ToInt32(Session["CompanyTypeID"]) == 0) { GetCompanyListForBranch(); GetBranchNameCompanyWiseForHubAdmin(14); } else { RecordSet rs = BranchNL.GetBranchList(System.Convert.ToInt32(Session["CompanyID"])); grdBranch.DataSource = rs.ParentTable; grdBranch.DataBind(); } } }
protected void Datagrid_Click(object source, DataGridCommandEventArgs e) { if (e.CommandName == "DELETERECORD") { lblMessage.Visible = true; if (objCompany.DeleteBranchRecord(Convert.ToInt32(e.CommandArgument))) { lblMessage.Text = "Record(s) deleted successfully."; if (Convert.ToInt32(Session["CompanyTypeID"]) == 0) { GetCompanyListForBranch(); GetBranchNameCompanyWiseForHubAdmin(14); } else { RecordSet rs = BranchNL.GetBranchList(System.Convert.ToInt32(Session["CompanyID"])); grdBranch.DataSource = rs.ParentTable; grdBranch.DataBind(); } } else { lblMessage.Text = "Error deleting branch. References exists in invoice."; } } }
private void PopulateData() { branchID = System.Convert.ToInt32(Request.QueryString["BranchID"]); RecordSet rs = BranchNL.GetBranchData(branchID); if (rs["Branch"] != DBNull.Value) { txtName.Text = rs["Branch"].ToString(); } if (rs["BranchCode"] != DBNull.Value) { txtBranchCode.Text = rs["BranchCode"].ToString(); } txtAddress1.Text = rs["Address1"].ToString(); txtAddress2.Text = rs["Address2"].ToString(); txtAddress3.Text = rs["Address3"].ToString(); txtAddress4.Text = rs["Address4"].ToString(); try { if (rs["CountryID"] != DBNull.Value) { cboCountry.SelectedValue = System.Convert.ToString(rs["CountryID"]); } } catch { } try { if (rs["CountyID"] != DBNull.Value) { cboCounty.SelectedValue = System.Convert.ToString(rs["CountyID"]); } } catch { } txtPostCode.Text = rs["PostCode"].ToString(); txtTelephone.Text = rs["Telephone"].ToString(); txtFax.Text = rs["Fax"].ToString(); txtAddress5.Text = rs["Address5"].ToString(); txtPContact.Text = rs["PContact"].ToString(); txtPEmail.Text = rs["PEmail"].ToString(); if (rs["IsInvoiceLocation"] != DBNull.Value) { chkInvoice.Checked = (bool)rs["IsInvoiceLocation"]; } if (rs["IsDeliveryLocation"] != DBNull.Value) { chkDelivery.Checked = (bool)rs["IsDeliveryLocation"]; } txtPurchaseVolume.Text = rs["PurchaseInvoiceVolume"].ToString(); txtSupplierCount.Text = rs["ActiveSupplierCount"].ToString(); txtCustomerCount.Text = rs["ActiveCustomerCount"].ToString(); txtSalesVolume.Text = rs["SalesInvoiceVolume"].ToString(); txtTurnover.Text = rs["ApproxTurnover"].ToString(); txtWebsite.Text = rs["Website"].ToString(); }
private void LoadData() { RecordSet rs = BranchNL.GetCountyList(); while (!rs.EOF()) { ListItem listItem = new ListItem(rs["County"].ToString(), rs["CountyID"].ToString()); cboCounty.Items.Add(listItem); rs.MoveNext(); } rs = BranchNL.GetCountryList(); while (!rs.EOF()) { ListItem listItem = new ListItem(rs["Country"].ToString(), rs["CountryID"].ToString()); cboCountry.Items.Add(listItem); rs.MoveNext(); } cboCountry.Items.Insert(0, new ListItem("Select Country", "0")); cboCounty.Items.Insert(0, new ListItem("Select County", "0")); }
private void btnSubmit_Click(object sender, System.EventArgs e) { BranchNL branch = new BranchNL(); DataAccess da = new DataAccess(CBSAppUtils.PrimaryConnectionString); if (ViewState["BranchID"] == null) { if (objInvoice.CheckDuplicateBranchCode(Convert.ToInt32(ViewState["BranchID"]), txtBranchCode.Text.Trim(), Convert.ToInt32(Session["CompanyID"]))) { lblErrorDuplicateBranchCode.Visible = true; return; } } RecordSet rs = null; if (branchID == 0) { rs = da.CreateInsertBuffer("Branch"); } else { rs = BranchNL.GetBranchData(branchID); } if (ViewState["CID"] != null) { rs["CompanyID"] = ViewState["CID"].ToString().Trim(); } else { rs["CompanyID"] = Session["CompanyID"].ToString(); } rs["Branch"] = txtName.Text; rs["BranchCode"] = txtBranchCode.Text.Trim(); rs["Address1"] = txtAddress1.Text; rs["Address2"] = txtAddress2.Text; rs["Address3"] = txtAddress3.Text; rs["Address4"] = txtAddress4.Text; rs["Address5"] = txtAddress5.Text; rs["PostCode"] = txtPostCode.Text; rs["Telephone"] = txtTelephone.Text; rs["Fax"] = txtFax.Text; if (cboCountry.SelectedIndex != 0) { rs["CountryID"] = cboCountry.SelectedValue; } else { rs["CountryID"] = DBNull.Value; } if (cboCounty.SelectedIndex != 0) { rs["CountyID"] = cboCounty.SelectedValue; } else { rs["CountyID"] = DBNull.Value; } rs["IsInvoiceLocation"] = chkInvoice.Checked; rs["IsDeliveryLocation"] = chkDelivery.Checked; rs["CurrencyTypeID"] = DBNull.Value; rs["PContact"] = txtPContact.Text; rs["PEmail"] = txtPEmail.Text; rs["PurchaseInvoiceVolume"] = txtPurchaseVolume.Text == "" ? 0 : System.Convert.ToDecimal(txtPurchaseVolume.Text); rs["ActiveSupplierCount"] = txtSupplierCount.Text == "" ? 0 : System.Convert.ToInt32(txtSupplierCount.Text); rs["ActiveCustomerCount"] = txtCustomerCount.Text == "" ? 0 : System.Convert.ToInt32(txtCustomerCount.Text); rs["SalesInvoiceVolume"] = txtSalesVolume.Text == "" ? 0 : System.Convert.ToDecimal(txtSalesVolume.Text); rs["ApproxTurnover"] = txtTurnover.Text == "" ? 0 : System.Convert.ToDecimal(txtTurnover.Text); rs["Website"] = txtWebsite.Text; rs["ModUserId"] = Session["UserID"].ToString(); if (branchID == 0) { if (branch.InsertBranchData(rs) == 0) { Response.Write(branch.ErrorMessage); } else { Response.Redirect("BranchBrowseNL.aspx"); } } else { if (!branch.UpdateBranchData(rs)) { Response.Write(branch.ErrorMessage); } else { Response.Redirect("BranchBrowseNL.aspx"); } } }
private void btnSubmit_Click(object sender, System.EventArgs e) { if (Page.IsValid) { if (CheckDuplicateCompanyName(Convert.ToInt32(Request["CompanyID"]), txtCompanyName.Text.Trim()) == -101) { lblMessage.Text = "Sorry, company name already exist."; return; } Company company = new Company(); DataAccess da = new DataAccess(CBSAppUtils.PrimaryConnectionString); RecordSet rs = null; string strPasswordGUID = System.Guid.NewGuid().ToString().Substring(0, 8).Trim(); if (companyID == 0) { string strNetworkGUID = System.Guid.NewGuid().ToString().Substring(0, 11).Trim(); rs = da.CreateInsertBuffer("Company"); rs["CreateDate"] = DateTime.Now; rs["NetworkID"] = strNetworkGUID; } else { rs = Company.GetCompanyData(companyID); } if (cboCompanyType.SelectedValue.Trim().Equals("2")) { rs["CompanyCode"] = DBNull.Value; } else { rs["CompanyCode"] = txtCompanyCode.Text; } rs["CompanyName"] = txtCompanyName.Text; rs["VATRegNo"] = txtVAT.Text.Trim() + "-" + txtVatNo.Text.Trim(); #region New_TaxCountryNo MODIFIED BY TARAKESHWAR DATE 26-JAN-2006 (11:42 AM) if (ddlCountryTaxNo.SelectedValue.Trim().Equals("Select")) { rs["New_TaxCountryNo"] = DBNull.Value; } else { rs["New_TaxCountryNo"] = ddlCountryTaxNo.SelectedValue; } #endregion #region New_TradersReference MODIFIED BY TARAKESHWAR DATE 26-JAN-2006 (2:42 PM) if (txtTradersReference.Text.Trim() != "") { rs["New_TradersReference"] = txtTradersReference.Text.Trim(); } else { rs["New_TradersReference"] = DBNull.Value; } #endregion rs["CompanyTypeID"] = cboCompanyType.SelectedItem.Value; rs["MemberTypeID"] = cboMemberType.SelectedItem.Value; rs["ModUserId"] = Session["UserID"].ToString(); rs["EmailID"] = txtEmail.Text.Trim(); if (Convert.ToInt32(Session["CompanyTypeID"]) == 0) { rs["ParentCompanyID"] = DBNull.Value; } else { rs["ParentCompanyID"] = iParentCompanyID; } if (Session["NewLook"].ToString() == "1") { if (ViewState["Mode"].ToString() == "ADD") { if (tbAddress1.Text.Trim() != "") { rs["Address1"] = tbAddress1.Text.Trim(); } else { rs["Address1"] = DBNull.Value; } if (tbAddress2.Text.Trim() != "") { rs["Address2"] = tbAddress2.Text.Trim(); } else { rs["Address2"] = DBNull.Value; } if (tbAddress3.Text.Trim() != "") { rs["Address3"] = tbAddress3.Text.Trim(); } else { rs["Address3"] = DBNull.Value; } if (ddlCounty.SelectedIndex != 0) { rs["CountyID"] = ddlCounty.SelectedItem.Text.Trim(); } else { rs["CountyID"] = DBNull.Value; } if (ddlCountry.SelectedIndex != 0) { rs["CountryID"] = ddlCountry.SelectedItem.Text.Trim(); } else { rs["CountryID"] = DBNull.Value; } if (tbPostCode.Text.Trim() != "") { rs["PostCode"] = tbPostCode.Text.Trim(); } else { rs["PostCode"] = DBNull.Value; } if (tbPhoneNo.Text.Trim() != "") { rs["PhoneNumber1"] = tbPhoneNo.Text.Trim(); } else { rs["PhoneNumber1"] = DBNull.Value; } rs["ModDate"] = DateTime.Now; } } else { rs["Address1"] = DBNull.Value; rs["Address2"] = DBNull.Value; rs["Address3"] = DBNull.Value; rs["CountyID"] = DBNull.Value; rs["CountryID"] = DBNull.Value; rs["PostCode"] = DBNull.Value; rs["PhoneNumber1"] = DBNull.Value; rs["ModDate"] = DateTime.Now; } if (companyID == 0) { BranchNL branch = new BranchNL(); RecordSet rsBranch = null; if (Session["NewLook"].ToString() != "1") { rsBranch = da.CreateInsertBuffer("Branch"); rsBranch["Branch"] = txtCompanyName.Text; rsBranch["ModUserId"] = Session["UserID"].ToString(); } da.BeginTransaction(); companyPKID = company.InsertCompanyData(rs, da); if (companyPKID > 0) { if (Session["NewLook"].ToString() != "1") { rsBranch["CompanyID"] = companyPKID; branch.InsertBranchData(rsBranch, da); } } if (da.ErrorCode != DataAccessErrors.Successful) { da.RollbackTransaction(); Response.Write(da.ErrorMessage); } else { da.CommitTransaction(); lblMessage.Text = "Record(s) saved successfully."; } } else { if (!company.UpdateCompanyData(rs)) { Response.Write(company.ErrorMessage); } else { companyPKID = companyID; lblMessage.Text = "Record(s) saved successfully."; } } if (Session["NewLook"].ToString() == "1" && ViewState["Mode"].ToString() == "ADD") { if (companyPKID > 0) { bool bBranchInsertFlag = false; if (objCompany.SaveBranchForNewLook(companyPKID, txtCompanyName.Text.Trim(), txtCompanyCode.Text.Trim(), tbAddress1.Text.Trim(), tbAddress2.Text.Trim(), tbAddress3.Text.Trim(), tbPostCode.Text.Trim(), tbPhoneNo.Text.Trim(), Convert.ToInt32(ddlCounty.SelectedValue), Convert.ToInt32(ddlCountry.SelectedValue), txtEmail.Text.Trim(), Convert.ToInt32(Session["UserID"]), "I")) { bBranchInsertFlag = true; } else { bBranchInsertFlag = false; } if (objCompany.SaveBranchForNewLook(companyPKID, txtCompanyName.Text.Trim(), txtCompanyCode.Text.Trim(), tbDeliveryAddress1.Text.Trim(), tbDeliveryAddress2.Text.Trim(), tbDeliveryAddress3.Text.Trim(), tbDeliveryPostCode.Text.Trim(), tbDeliveryPhoneNo.Text.Trim(), Convert.ToInt32(ddlCountyDelivery.SelectedValue), Convert.ToInt32(ddlCountryDelivery.SelectedValue), txtEmail.Text.Trim(), Convert.ToInt32(Session["UserID"]), "D")) { bBranchInsertFlag = true; } else { bBranchInsertFlag = false; } if (bBranchInsertFlag) { lblMessage.Text = "Record(s) saved successfully."; } else { lblMessage.Text = "Error saving record(s)."; } } } else if (Session["NewLook"].ToString() == "1" && ViewState["Mode"].ToString().Equals("EDIT")) { bool bBranchInsertFlag = false; if (objCompany.UpdateDeliveryAddressBranchForNewLook(Convert.ToInt32(ViewState["SubCompanyID"]), txtCompanyName.Text.Trim(), txtCompanyCode.Text.Trim(), tbDeliveryAddress1.Text.Trim(), tbDeliveryAddress2.Text.Trim(), tbDeliveryAddress3.Text.Trim(), tbDeliveryPostCode.Text.Trim(), tbDeliveryPhoneNo.Text.Trim(), Convert.ToInt32(ddlCountyDelivery.SelectedValue), Convert.ToInt32(ddlCountryDelivery.SelectedValue), txtEmail.Text.Trim(), Convert.ToInt32(Session["UserID"]), "D")) { bBranchInsertFlag = true; } else { bBranchInsertFlag = false; } if (objCompany.UpdateDeliveryAddressBranchForNewLook(Convert.ToInt32(ViewState["SubCompanyID"]), txtCompanyName.Text.Trim(), txtCompanyCode.Text.Trim(), tbAddress1.Text.Trim(), tbAddress2.Text.Trim(), tbAddress3.Text.Trim(), tbPostCode.Text.Trim(), tbPhoneNo.Text.Trim(), Convert.ToInt32(ddlCounty.SelectedValue), Convert.ToInt32(ddlCountry.SelectedValue), txtEmail.Text.Trim(), Convert.ToInt32(Session["UserID"]), "I")) { bBranchInsertFlag = true; } else { bBranchInsertFlag = false; } if (bBranchInsertFlag) { lblMessage.Text = "Record(s) saved successfully."; } else { lblMessage.Text = "Error saving record(s)."; } } } }