protected void GetUserGroupById(string companyId) { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { DataTable dt = payToFromCompany.GetPayToFromCompanyById(companyId); if (dt.Rows.Count > 0) { payToFromCompanyNameForUpdateHiddenField.Value = companyNameTextBox.Text = dt.Rows[0]["CompanyName"].ToString(); descriptionTextBox.Text = dt.Rows[0]["Description"].ToString(); companyNameTextBox.Text = dt.Rows[0]["CompanyName"].ToString(); companyAddressTextBox.Text = dt.Rows[0]["CompanyAddress"].ToString(); companyContactTextBox.Text = dt.Rows[0]["CompanyContact"].ToString(); companyEmailTextBox.Text = dt.Rows[0]["CompanyEmail"].ToString(); companyWebsiteTextBox.Text = dt.Rows[0]["CompanyWeb"].ToString(); } else { msgbox.Visible = true; msgTitleLabel.Text = "Company Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
protected void LoadPayToFromCompanyList() { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { DataTable dt = payToFromCompany.GetActivePayToFromCompanyList(); payToFromCompanyDropDownList.DataSource = dt; payToFromCompanyDropDownList.DataValueField = "CompanyId"; payToFromCompanyDropDownList.DataTextField = "CompanyName"; payToFromCompanyDropDownList.DataBind(); payToFromCompanyDropDownList.Items.Insert(0, ""); payToFromCompanyDropDownList.Items.Insert(1, "N/A"); payToFromCompanyDropDownList.SelectedIndex = 0; if (dt.Rows.Count < 1) { msgbox.Visible = true; msgTitleLabel.Text = "Pay To/From Company Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
public DataTable SavePayToFromCompany(PayToFromCompanyBLL payToFromCompany, LumexDBPlayer db) { try { db.AddParameters("@CompanyName", payToFromCompany.CompanyName); db.AddParameters("@Description", payToFromCompany.Description); db.AddParameters("@CompanyAddress", payToFromCompany.CompanyAddress); db.AddParameters("@CompanyContact", payToFromCompany.CompanyContact); db.AddParameters("@CompanyEmail", payToFromCompany.CompanyEmail); db.AddParameters("@CompanyWeb", payToFromCompany.CompanyWebsite); db.AddParameters("@CreatedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@CreatedFrom", LumexLibraryManager.GetTerminal()); DataTable dt = db.ExecuteDataTable("INSERT_PAY_TO_FROM_COMPANY", true); return dt; } catch (Exception) { throw; } finally { payToFromCompany = null; } }
protected void GetPayToFromCompanyList() { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { DataTable dt = payToFromCompany.GetPayToFromCompanyList(); payToFromCompanyListGridView.DataSource = dt; payToFromCompanyListGridView.DataBind(); if (payToFromCompanyListGridView.Rows.Count > 0) { payToFromCompanyListGridView.UseAccessibleHeader = true; payToFromCompanyListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Company List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
protected void saveButton_Click(object sender, EventArgs e) { //starting to work here... PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { if (companyNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Company Name field is required."; } else if (descriptionTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required."; } else { payToFromCompany.CompanyName = companyNameTextBox.Text.Trim(); payToFromCompany.Description = descriptionTextBox.Text.Trim(); payToFromCompany.CompanyAddress = companyAddressTextBox.Text.Trim(); payToFromCompany.CompanyContact = companyContactTextBox.Text.Trim(); payToFromCompany.CompanyEmail = companyEmailTextBox.Text.Trim(); payToFromCompany.CompanyWebsite = companyWebsiteTextBox.Text.Trim(); if (!payToFromCompany.CheckDuplicatePayToFromCompany(payToFromCompany.CompanyName.Trim())) { DataTable dt = payToFromCompany.SavePayToFromCompany(); if (dt.Rows.Count > 0) { string message = "Company <span class='actionTopic'>Created</span> Successfully with Company ID: <span class='actionTopic'>" + dt.Rows[0][0].ToString() + "</span>."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/PayToFromCompany/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "<span class='actionTopic'>Failed</span> to Create Company."; MyAlertBox("ErrorAlert(\"" + "Process Failed" + "\", \"" + message + "\");"); } } else { string message = "This Company Name <span class='actionTopic'>already exist</span>, try another one."; MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");"); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
protected void deletedListButton_Click(object sender, EventArgs e) { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { if (fromDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date From field is required."; } else if (toDateTextBox.Text.Trim() == "" || LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()) == "False") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Date To field is required."; } else { string fromDate = LumexLibraryManager.ParseAppDate(fromDateTextBox.Text.Trim()); string toDate = LumexLibraryManager.ParseAppDate(toDateTextBox.Text.Trim()); DataTable dt = payToFromCompany.GetDeletedPayToFromCompanyListByDateRangeAll(fromDate, toDate, ""); deletedListGridView.DataSource = dt; deletedListGridView.DataBind(); if (deletedListGridView.Rows.Count > 0) { deletedListGridView.UseAccessibleHeader = true; deletedListGridView.HeaderRow.TableSection = TableRowSection.TableHeader; } else { msgbox.Visible = true; msgTitleLabel.Text = "Deleted Company List Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-info"); } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; MyAlertBox("MyOverlayStop();"); } }
protected void updateButton_Click(object sender, EventArgs e) { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { if (payToFromCompanyIdForUpdateHiddenField.Value.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Company not found to update."; } else if (companyNameTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Company Name field is required."; } else if (descriptionTextBox.Text.Trim() == "") { msgbox.Visible = true; msgTitleLabel.Text = "Validation!!!"; msgDetailLabel.Text = "Description field is required."; } else { payToFromCompany.CompanyId = payToFromCompanyIdForUpdateHiddenField.Value.Trim(); payToFromCompany.CompanyName = companyNameTextBox.Text.Trim(); payToFromCompany.Description = descriptionTextBox.Text.Trim(); payToFromCompany.CompanyAddress = companyAddressTextBox.Text.Trim(); payToFromCompany.CompanyContact = companyContactTextBox.Text.Trim(); payToFromCompany.CompanyEmail = companyEmailTextBox.Text.Trim(); payToFromCompany.CompanyWebsite = companyWebsiteTextBox.Text.Trim(); if (!payToFromCompany.CheckDuplicatePayToFromCompany(companyNameTextBox.Text.Trim())) { payToFromCompany.UpdatePayToFromCompany(); payToFromCompanyNameForUpdateHiddenField.Value = ""; payToFromCompanyIdForUpdateHiddenField.Value = ""; string message = "Company <span class='actionTopic'>Updated</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/PayToFromCompany/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { if (payToFromCompanyNameForUpdateHiddenField.Value == companyNameTextBox.Text.Trim()) { payToFromCompany.CompanyName = "WithOut"; payToFromCompany.UpdatePayToFromCompany(); payToFromCompanyNameForUpdateHiddenField.Value = ""; payToFromCompanyIdForUpdateHiddenField.Value = ""; string message = "Company <span class='actionTopic'>Updated</span> Successfully."; MyAlertBox("var callbackOk = function () { MyOverlayStart(); window.location = \"/UI/AccUI/PayToFromCompany/List.aspx\"; }; SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", callbackOk);"); } else { string message = "This Company Name <span class='actionTopic'>already exist</span>, try another one."; MyAlertBox("WarningAlert(\"" + "Data Duplicate" + "\", \"" + message + "\");"); } } } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
public void UpdatePayToFromCompany(PayToFromCompanyBLL payToFromCompany, LumexDBPlayer db) { try { db.AddParameters("@CompanyId", payToFromCompany.CompanyId.Trim()); db.AddParameters("@CompanyName", payToFromCompany.CompanyName.Trim()); db.AddParameters("@Description", payToFromCompany.Description.Trim()); db.AddParameters("@CompanyAddress", payToFromCompany.CompanyAddress); db.AddParameters("@CompanyContact", payToFromCompany.CompanyContact); db.AddParameters("@CompanyEmail", payToFromCompany.CompanyEmail); db.AddParameters("@CompanyWeb", payToFromCompany.CompanyWebsite); db.AddParameters("@ModifiedBy", LumexSessionManager.Get("ActiveUserId").ToString()); db.AddParameters("@ModifiedFrom", LumexLibraryManager.GetTerminal()); db.ExecuteNonQuery("UPDATE_PAY_TO_FROM_COMPANY_BY_ID", true); } catch (Exception) { throw; } finally { payToFromCompany = null; } }
protected void LoadPayToFromCompanyList() { PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); try { payToFromCompanyDropDownList.Items.Clear(); DataTable dt = new DataTable(); if (payToFromTypeDropDownList.SelectedValue == "com") { dt = payToFromCompany.GetActivePayToFromCompanyList(); payToFromCompanyDropDownList.DataSource = dt; payToFromCompanyDropDownList.DataValueField = "CompanyId"; payToFromCompanyDropDownList.DataTextField = "CompanyName"; payToFromCompanyDropDownList.DataBind(); lblPaytoFromType.Text = "Company"; } else if (payToFromTypeDropDownList.SelectedValue == "ven") { VendorBLL vendor = new VendorBLL(); dt = vendor.GetActiveVendors(); payToFromCompanyDropDownList.DataSource = dt; payToFromCompanyDropDownList.DataValueField = "VendorId"; payToFromCompanyDropDownList.DataTextField = "VendorName"; payToFromCompanyDropDownList.DataBind(); lblPaytoFromType.Text = "Vendor"; } else if (payToFromTypeDropDownList.SelectedValue == "cus") { CustomerBLL customer = new CustomerBLL(); dt = customer.GetActiveCustomerList(); payToFromCompanyDropDownList.DataSource = dt; payToFromCompanyDropDownList.DataValueField = "CustomerId"; payToFromCompanyDropDownList.DataTextField = "CustomerIdName"; payToFromCompanyDropDownList.DataBind(); lblPaytoFromType.Text = "Customer"; } payToFromCompanyDropDownList.Items.Insert(0, ""); payToFromCompanyDropDownList.Items.Insert(1, "N/A"); payToFromCompanyDropDownList.SelectedIndex = 0; if (dt.Rows.Count < 1) { msgbox.Visible = true; msgTitleLabel.Text = "Pay To/From Company Data Not Found!!!"; msgDetailLabel.Text = ""; msgbox.Attributes.Add("class", "alert alert-warning"); } } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } finally { payToFromCompany = null; } }
protected void activateLinkButton_Click(object sender, EventArgs e) { try { LinkButton lnkBtn = (LinkButton)sender; GridViewRow row = (GridViewRow)lnkBtn.NamingContainer; PayToFromCompanyBLL payToFromCompany = new PayToFromCompanyBLL(); payToFromCompany.UpdatePayToFromCompanyActivation(payToFromCompanyListGridView.Rows[row.RowIndex].Cells[0].Text.ToString(), "True"); payToFromCompanyListGridView.Rows[row.RowIndex].Cells[3].Text = "True"; string message = "Company <span class='actionTopic'>Activated</span> Successfully."; MyAlertBox("SuccessAlert(\"" + "Process Succeed" + "\", \"" + message + "\", \"\");"); } catch (Exception ex) { string message = ex.Message; if (ex.InnerException != null) { message += " --> " + ex.InnerException.Message; } MyAlertBox("ErrorAlert(\"" + ex.GetType() + "\", \"" + message + "\", \"\");"); } }