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 + "\", \"\");");
}
}
