public virtual CloudAccountDA.CityMasterDataTable GetDataByStateCityName(int?StateID, int?CountryID, string CityName)
{
this.Adapter.SelectCommand = this.CommandCollection[4];
if (StateID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = StateID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
if (CountryID.HasValue)
{
this.Adapter.SelectCommand.Parameters[2].Value = CountryID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value;
}
if (CityName == null)
{
this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[3].Value = CityName;
}
CloudAccountDA.CityMasterDataTable dataTable = new CloudAccountDA.CityMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual CloudAccountDA.CityMasterDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
CloudAccountDA.CityMasterDataTable dataTable = new CloudAccountDA.CityMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
private void SetRecord(string iD)
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(iD));
if (this.objCityMasterDT.Rows.Count <= 0)
{
return;
}
this.hfCity.Value = this.objCityMasterDT.Rows[0]["CityID"].ToString();
this.txtCode.Text = this.objCityMasterDT.Rows[0]["CityCode"].ToString();
this.txtName.Text = this.objCityMasterDT.Rows[0]["CityName"].ToString();
this.txtDesc.Text = this.objCityMasterDT.Rows[0]["CityDesc"].ToString();
this.chkStatus.Checked = this.objCityMasterDT.Rows[0]["CityStatus"].ToString() == "True";
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCityMasterDT.Rows[0]["CountryID"].ToString()));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCityMasterDT.Rows[0]["StateID"].ToString()));
if (this.objStateMasterDT.Rows.Count <= 0)
{
return;
}
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
public virtual int Fill(CloudAccountDA.CityMasterDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
return(this.Adapter.Fill(dataTable));
}
private void SetRecord(string iD)
{
this.objStaffMasterDT = this.objStaffMasterBll.GetDataByStaffID(int.Parse(iD));
if (this.objStaffMasterDT.Rows.Count <= 0)
{
return;
}
this.hfStaffID.Value = this.objStaffMasterDT.Rows[0]["StaffID"].ToString();
this.hfCompanyID.Value = this.objStaffMasterDT.Rows[0]["CompanyID"].ToString();
this.txtStaffEmail.Text = this.objStaffMasterDT.Rows[0]["Email"].ToString();
this.txtStaffFirstName.Text = this.objStaffMasterDT.Rows[0]["FirstName"].ToString();
this.txtStaffLastName.Text = this.objStaffMasterDT.Rows[0]["LastName"].ToString();
this.txtHomePhone.Text = this.objStaffMasterDT.Rows[0]["HomePhone"].ToString();
this.txtMobile.Text = this.objStaffMasterDT.Rows[0]["Mobile"].ToString();
this.txtUsername.Text = this.objStaffMasterDT.Rows[0]["UserName"].ToString();
this.txtAddress1.Text = this.objStaffMasterDT.Rows[0]["Address1"].ToString();
this.txtAddress2.Text = this.objStaffMasterDT.Rows[0]["Address2"].ToString();
this.txtZipCode.Text = this.objStaffMasterDT.Rows[0]["ZipCode"].ToString();
this.txtBussinessPhone.Text = this.objStaffMasterDT.Rows[0]["BussinessPhone"].ToString();
this.txtFax.Text = this.objStaffMasterDT.Rows[0]["Fax"].ToString();
string s1 = this.objStaffMasterDT.Rows[0]["CountryID"].ToString();
string s2 = this.objStaffMasterDT.Rows[0]["StateID"].ToString();
string s3 = this.objStaffMasterDT.Rows[0]["CityID"].ToString();
if (!string.IsNullOrEmpty(s1))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s1));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
}
if (!string.IsNullOrEmpty(s2))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s2));
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
}
if (!string.IsNullOrEmpty(s3))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s3));
if (this.objCityMasterDT.Rows.Count > 0)
{
this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
}
this.txtUsername.Enabled = false;
this.txtStaffEmail.Enabled = false;
}
private void ViewRecord()
{
this.objAccountantMasterDT = this.objAccountantMasterBll.GetDataByAccountantID(int.Parse(this.hfAccountantID.Value));
if (this.objAccountantMasterDT.Rows.Count <= 0)
{
return;
}
this.hfAccountantID.Value = this.objAccountantMasterDT.Rows[0]["AccountantID"].ToString();
this.txtFirstName.Text = this.objAccountantMasterDT.Rows[0]["AccountantFirstName"].ToString();
this.txtLastName.Text = this.objAccountantMasterDT.Rows[0]["AccountantLastName"].ToString();
this.txtEmail.Text = this.objAccountantMasterDT.Rows[0]["AccountantEmail"].ToString();
this.txtPhone.Text = this.objAccountantMasterDT.Rows[0]["AccountantPhone"].ToString();
this.txtCompanyName.Text = this.objAccountantMasterDT.Rows[0]["CompanyName"].ToString();
this.txtAddress.Text = this.objAccountantMasterDT.Rows[0]["Address1"].ToString();
this.txtProfession.Text = this.objAccountantMasterDT.Rows[0]["AccountantProfession"].ToString();
this.txtDesignation.Text = this.objAccountantMasterDT.Rows[0]["AccountantDesignation"].ToString();
this.txtZipCode.Text = this.objAccountantMasterDT.Rows[0]["ZipCode"].ToString();
string s1 = this.objAccountantMasterDT.Rows[0]["CountryID"].ToString();
string s2 = this.objAccountantMasterDT.Rows[0]["StateID"].ToString();
string s3 = this.objAccountantMasterDT.Rows[0]["CityID"].ToString();
if (!string.IsNullOrEmpty(s1))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s1));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
}
if (!string.IsNullOrEmpty(s2))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s2));
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
}
if (string.IsNullOrEmpty(s3))
{
return;
}
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s3));
if (this.objCityMasterDT.Rows.Count <= 0)
{
return;
}
this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
public virtual CloudAccountDA.CityMasterDataTable GetDataByCityName(string CityName)
{
this.Adapter.SelectCommand = this.CommandCollection[2];
if (CityName == null)
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = CityName;
}
CloudAccountDA.CityMasterDataTable dataTable = new CloudAccountDA.CityMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
public virtual CloudAccountDA.CityMasterDataTable GetDataByCityID(int?CityID)
{
this.Adapter.SelectCommand = this.CommandCollection[1];
if (CityID.HasValue)
{
this.Adapter.SelectCommand.Parameters[1].Value = CityID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value;
}
CloudAccountDA.CityMasterDataTable dataTable = new CloudAccountDA.CityMasterDataTable();
this.Adapter.Fill(dataTable);
return(dataTable);
}
private void ViewRecord(string i)
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(i));
if (this.objCityMasterDT.Rows.Count <= 0)
{
return;
}
this.hfCity.Value = this.objCityMasterDT.Rows[0]["CityID"].ToString();
this.lblCode.Text = this.objCityMasterDT.Rows[0]["CityCode"].ToString();
this.lblName.Text = this.objCityMasterDT.Rows[0]["CityName"].ToString();
this.lblDesc.Text = this.objCityMasterDT.Rows[0]["CityDesc"].ToString();
this.lblStatus.Text = this.objCityMasterDT.Rows[0]["CityStatus"].ToString();
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCityMasterDT.Rows[0]["CountryID"].ToString()));
this.lblCountry.Text = this.objCountryMasterDT.Rows[0]["CountryName"].ToString();
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCityMasterDT.Rows[0]["StateID"].ToString()));
this.lblState.Text = this.objStateMasterDT.Rows[0]["StateName"].ToString();
}
private void SetRecord(string iD)
{
this.objContactMasterDT = this.objContactMasterBll.GetDataByContactID(int.Parse(iD));
if (this.objContactMasterDT.Rows.Count <= 0)
{
return;
}
this.hfContact.Value = this.objContactMasterDT.Rows[0]["ContactID"].ToString();
this.txtCompanyName.Text = this.objContactMasterDT.Rows[0]["CompanyName"].ToString();
this.txtContactPerson.Text = this.objContactMasterDT.Rows[0]["ContactPerson"].ToString();
this.txtAddress1.Text = this.objContactMasterDT.Rows[0]["Address1"].ToString();
this.txtAddress2.Text = this.objContactMasterDT.Rows[0]["Address2"].ToString();
this.txtAddress3.Text = this.objContactMasterDT.Rows[0]["Address3"].ToString();
this.txtAddress4.Text = this.objContactMasterDT.Rows[0]["Address4"].ToString();
this.txtZipCode.Text = this.objContactMasterDT.Rows[0]["ZipCode"].ToString();
this.txtPhone1.Text = this.objContactMasterDT.Rows[0]["Phone1"].ToString();
this.txtPhone2.Text = this.objContactMasterDT.Rows[0]["Phone2"].ToString();
this.txtMobile1.Text = this.objContactMasterDT.Rows[0]["Mobile1"].ToString();
this.txtMobile2.Text = this.objContactMasterDT.Rows[0]["Mobile2"].ToString();
this.txtFax1.Text = this.objContactMasterDT.Rows[0]["Fax1"].ToString();
this.txtFax2.Text = this.objContactMasterDT.Rows[0]["Fax2"].ToString();
this.txtEmail1.Text = this.objContactMasterDT.Rows[0]["Email1"].ToString();
this.txtEmail2.Text = this.objContactMasterDT.Rows[0]["Email2"].ToString();
this.txtWebsite.Text = this.objContactMasterDT.Rows[0]["Website"].ToString();
this.txtGoogleMapCode.Text = this.objContactMasterDT.Rows[0]["GoogleMapCode"].ToString();
this.chkStatus.Checked = this.objContactMasterDT.Rows[0]["Status"].ToString() == "True";
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryName(this.objContactMasterDT.Rows[0]["Country"].ToString());
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateName(this.objContactMasterDT.Rows[0]["State"].ToString());
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityName(this.objContactMasterDT.Rows[0]["City"].ToString());
if (this.objCityMasterDT.Rows.Count <= 0)
{
return;
}
this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
if (!this.Page.IsValid)
{
return;
}
if (this.ddlCountry.SelectedIndex > 0 && this.ddlState.SelectedIndex > 0 && (this.txtCode.Text.Trim().Length > 0 && this.txtName.Text.Trim().Length > 0))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByStateCityName(int.Parse(this.hfCity.Value), int.Parse(this.ddlState.SelectedItem.Value), int.Parse(this.ddlCountry.SelectedItem.Value), this.txtName.Text);
if (this.objCityMasterDT.Rows.Count > 0)
{
this.DisplayAlert("City is Already Exist in State - Country...");
this.checkInDB = true;
}
else
{
this.checkInDB = false;
}
if (this.checkInDB)
{
return;
}
if (this.objCityMasterBll.UpdateCity(int.Parse(this.hfCity.Value), int.Parse(this.ddlCountry.SelectedItem.Value), int.Parse(this.ddlState.SelectedItem.Value), this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtDesc.Text.Trim(), this.chkStatus.Checked))
{
this.DisplayAlert("Update Successfully..");
this.Response.Redirect("~/BillTransact/CityMaster.aspx?cmd=view&ID=" + this.Request.QueryString["ID"]);
}
else
{
this.DisplayAlert("Fail to Update Details.");
}
}
else
{
this.DisplayAlert("Please Fill All Details.");
}
}
catch (Exception ex)
{
this.DisplayAlert(ex.Message);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (!this.Page.IsValid)
{
return;
}
if (this.ddlCountry.SelectedIndex > 0 && this.ddlState.SelectedIndex > 0 && (this.txtCode.Text.Trim().Length > 0 && this.txtName.Text.Trim().Length > 0))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByStateCityName(int.Parse(this.ddlState.SelectedItem.Value), int.Parse(this.ddlCountry.SelectedItem.Value), this.txtName.Text);
if (this.objCityMasterDT.Rows.Count > 0)
{
this.DisplayAlert("City is Already Exist in State - Country...");
this.checkInDB = true;
}
else
{
this.checkInDB = false;
}
if (this.checkInDB)
{
return;
}
int num = this.objCityMasterBll.AddCity(int.Parse(this.ddlCountry.SelectedItem.Value), int.Parse(this.ddlState.SelectedItem.Value), this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtDesc.Text.Trim(), this.chkStatus.Checked);
if (num != 0)
{
this.DisplayAlert("Details Added Successfully.");
this.Response.Redirect("~/BillTransact/CityMaster.aspx?cmd=view&ID=" + (object)num);
}
else
{
this.DisplayAlert("Fail to Add New Details.");
}
}
else
{
this.DisplayAlert("Please Fill All Details...!");
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
this.objCityMasteDT = this.objCityMasterBll.GetDataByStateID(int.Parse(this.hfState.Value));
if (this.objCityMasteDT.Rows.Count > 0)
{
this.DisplayAlert("Child Data Exist..");
}
else if (this.hfState.Value != null)
{
if (this.objStateMasterBll.DeleteState(int.Parse(this.hfState.Value)))
{
this.DisplayAlert("Details has been Deleted");
this.Response.Redirect("~/BillTransact/StateMaster.aspx");
}
else
{
this.DisplayAlert("Error In Deleting Detail");
}
}
else
{
this.DisplayAlert("Error In Deleting Detail");
}
}
protected void lnkClient_OnClick(object sender, EventArgs e)
{
SqlCommand sqlCommand = new SqlCommand("PR_ExportClientTocsv_SelectAll", new SqlConnection(this.conn));
sqlCommand.CommandType = CommandType.StoredProcedure;
SqlCommand selectCommand = sqlCommand;
selectCommand.Parameters.Add(new SqlParameter("@CompanyID", (object)this.hfCompanyID.Value));
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand);
DataSet dataSet = new DataSet();
sqlDataAdapter.Fill(dataSet);
DataTable dataTable = dataSet.Tables[0];
if (dataTable.Rows.Count <= 0)
{
return;
}
string str1 = string.Empty;
foreach (DataColumn dataColumn in (InternalDataCollectionBase)dataTable.Columns)
{
str1 = str1 + (object)dataColumn.ColumnName + (string)(object)',';
}
string str2 = str1 + "\r\n";
foreach (DataRow dataRow in (InternalDataCollectionBase)dataTable.Rows)
{
foreach (DataColumn dataColumn in (InternalDataCollectionBase)dataTable.Columns)
{
if (dataColumn.ColumnName == "City" || dataColumn.ColumnName == "SecCity")
{
string s = dataRow[dataColumn.ColumnName].ToString();
if (!string.IsNullOrEmpty(s))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s));
dataRow[dataColumn.ColumnName] = (object)this.objCityMasterDT.Rows[0]["CityName"].ToString();
}
else
{
dataRow[dataColumn.ColumnName] = (object)"";
}
}
if (dataColumn.ColumnName == "Province" || dataColumn.ColumnName == "SecProvince")
{
string s = dataRow[dataColumn.ColumnName].ToString();
if (!string.IsNullOrEmpty(s))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s));
dataRow[dataColumn.ColumnName] = (object)this.objStateMasterDT.Rows[0]["StateName"].ToString();
}
else
{
dataRow[dataColumn.ColumnName] = (object)"";
}
}
if (dataColumn.ColumnName == "Country" || dataColumn.ColumnName == "SecCountry")
{
string s = dataRow[dataColumn.ColumnName].ToString();
if (!string.IsNullOrEmpty(s))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s));
dataRow[dataColumn.ColumnName] = (object)this.objCountryMasterDT.Rows[0]["CountryName"].ToString();
}
else
{
dataRow[dataColumn.ColumnName] = (object)"";
}
}
str2 = str2 + (object)dataRow[dataColumn.ColumnName].ToString().Replace(",", ";") + (string)(object)',';
}
str2 += "\r\n";
}
this.Response.Clear();
this.Response.Buffer = true;
this.Response.AddHeader("content-disposition", "attachment;filename=" + this.hfCompanyName.Value + "_Clients.csv");
this.Response.Charset = "";
this.Response.ContentType = "application/text";
this.Response.Output.Write(str2);
this.Response.Flush();
this.Response.End();
}
private void ViewRecord(string id)
{
this.objEstimateMasterDT = this.objEstimateMasterBll.GetDataByEstimateID(int.Parse(id));
if (this.objEstimateMasterDT.Rows.Count <= 0)
{
return;
}
this.hfCompanyID.Value = this.objEstimateMasterDT.Rows[0]["CompanyID"].ToString();
this.hfEstimateID.Value = this.objEstimateMasterDT.Rows[0]["EstimateID"].ToString();
this.lblEstimateNum.Text = this.objEstimateMasterDT.Rows[0]["EstimateNumber"].ToString();
this.lblEstimateNumHead.Text = "Estimate: " + this.objEstimateMasterDT.Rows[0]["EstimateNumber"];
this.lblEstimateDate.Text = DateTime.Parse(this.objEstimateMasterDT.Rows[0]["EstimateDate"].ToString()).ToString("MMMM dd, yyyy");
this.lblPONumber.Text = this.objEstimateMasterDT.Rows[0]["PONumber"].ToString();
this.lblTerms.Text = this.objEstimateMasterDT.Rows[0]["Terms"].ToString();
this.lblNotes.Text = this.objEstimateMasterDT.Rows[0]["Notes"].ToString();
string s1 = this.objEstimateMasterDT.Rows[0]["Discount"].ToString();
this.lblDiscout.Text = s1.Length > 0 ? s1 : "0.00";
this.lblEstimateTotalView.Text = Decimal.Round(Decimal.Parse(this.objEstimateMasterDT.Rows[0]["EstimateTotal"].ToString()), 2).ToString();
this.lblPaidToDateView.Text = Decimal.Round(Decimal.Parse(this.objEstimateMasterDT.Rows[0]["PaidToDate"].ToString()), 2).ToString();
Label label1 = this.lblEstimateAmount;
Label label2 = this.lblAmountDue;
Decimal num1 = Decimal.Parse(this.lblEstimateTotalView.Text) - Decimal.Parse(this.lblPaidToDateView.Text);
string str1;
string str2 = str1 = num1.ToString();
label2.Text = str1;
string str3 = str2;
label1.Text = str3;
Label label3 = this.lblEstimateAmount;
Label label4 = this.lblAmountDue;
Decimal num2 = Decimal.Round(Decimal.Parse(this.lblAmountDue.Text), 2);
string str4;
string str5 = str4 = num2.ToString();
label4.Text = str4;
string str6 = str5;
label3.Text = str6;
this.divTaxValueView.Controls.Clear();
this.divTaxView.Controls.Clear();
Hashtable hashtable = new Hashtable();
if (this.gvTaskView.Rows.Count > 0)
{
for (int index = 0; index < this.gvTaskView.Rows.Count; ++index)
{
string text1 = this.gvTaskView.Rows[index].Cells[2].Text;
string text2 = this.gvTaskView.Rows[index].Cells[3].Text;
string text3 = this.gvTaskView.Rows[index].Cells[4].Text;
string text4 = this.gvTaskView.Rows[index].Cells[5].Text;
try
{
if (!string.IsNullOrEmpty(text3) && !text3.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100);
Label label5 = new Label()
{
Text = this.gvTaskView.Rows[index].Cells[4].Text + "(" + s2 + ")"
};
Label label6 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label5.Text))
{
object obj = hashtable[(object)label5.Text];
Decimal num3 = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label5.Text);
hashtable.Add((object)label5.Text, (object)num3.ToString());
}
else
{
hashtable.Add((object)label5.Text, (object)label6.Text);
}
}
}
if (!string.IsNullOrEmpty(text4))
{
if (!text4.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100);
Label label5 = new Label()
{
Text = this.gvTaskView.Rows[index].Cells[5].Text + "(" + s2 + ")"
};
Label label6 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label5.Text))
{
object obj = hashtable[(object)label5.Text];
Decimal num3 = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label5.Text);
hashtable.Add((object)label5.Text, (object)num3.ToString());
}
else
{
hashtable.Add((object)label5.Text, (object)label6.Text);
}
}
}
}
}
catch (Exception ex)
{
this.gvTaskView.Rows[index].Cells[4].Text = "";
this.gvTaskView.Rows[index].Cells[5].Text = "";
}
}
}
if (this.gvItemView.Rows.Count > 0)
{
for (int index = 0; index < this.gvItemView.Rows.Count; ++index)
{
string text1 = this.gvItemView.Rows[index].Cells[2].Text;
string text2 = this.gvItemView.Rows[index].Cells[3].Text;
string text3 = this.gvItemView.Rows[index].Cells[4].Text;
string text4 = this.gvItemView.Rows[index].Cells[5].Text;
try
{
if (!string.IsNullOrEmpty(text3) && !text3.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100);
Label label5 = new Label()
{
Text = this.gvItemView.Rows[index].Cells[4].Text + "(" + s2 + ")"
};
Label label6 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label5.Text))
{
object obj = hashtable[(object)label5.Text];
Decimal num3 = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label5.Text);
hashtable.Add((object)label5.Text, (object)num3.ToString());
}
else
{
hashtable.Add((object)label5.Text, (object)label6.Text);
}
}
}
if (!string.IsNullOrEmpty(text4))
{
if (!text4.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s2 = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s2) / new Decimal(100);
Label label5 = new Label()
{
Text = this.gvItemView.Rows[index].Cells[5].Text + "(" + s2 + ")"
};
Label label6 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label5.Text))
{
object obj = hashtable[(object)label5.Text];
Decimal num3 = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label5.Text);
hashtable.Add((object)label5.Text, (object)num3.ToString());
}
else
{
hashtable.Add((object)label5.Text, (object)label6.Text);
}
}
}
}
}
catch (Exception ex)
{
this.gvItemView.Rows[index].Cells[4].Text = "";
this.gvItemView.Rows[index].Cells[5].Text = "";
}
}
}
if (hashtable.Count > 0)
{
foreach (string str7 in (IEnumerable)hashtable.Keys)
{
this.divTaxView.Controls.Add((Control) new Label()
{
Text = str7
});
this.divTaxView.Controls.Add((Control) new LiteralControl("<br />"));
}
foreach (object obj in (IEnumerable)hashtable.Values)
{
this.divTaxValueView.Controls.Add((Control) new Label()
{
Text = ("+" + (object)Decimal.Round(Decimal.Parse(obj.ToString()), 2))
});
this.divTaxValueView.Controls.Add((Control) new LiteralControl("<br />"));
}
}
Decimal d1 = new Decimal(0);
if (this.gvItemView.Rows.Count > 0)
{
for (int index = 0; index < this.gvItemView.Rows.Count; ++index)
{
string text = this.gvItemView.Rows[index].Cells[6].Text;
d1 += Decimal.Parse(text);
}
}
if (this.gvTaskView.Rows.Count > 0)
{
for (int index = 0; index < this.gvTaskView.Rows.Count; ++index)
{
string text = this.gvTaskView.Rows[index].Cells[6].Text;
d1 += Decimal.Parse(text);
}
}
Label label7 = this.lblSubTotalView;
Decimal num4 = Decimal.Round(d1, 2);
string str8 = num4.ToString();
label7.Text = str8;
Label label8 = this.lblDiscountAmt;
num4 = Decimal.Parse(this.lblSubTotalView.Text) * Decimal.Parse(s1) / new Decimal(100);
string str9 = num4.ToString();
label8.Text = str9;
Label label9 = this.lblDiscountAmt;
num4 = Decimal.Round(Decimal.Parse(this.lblDiscountAmt.Text), 2);
string str10 = num4.ToString();
label9.Text = str10;
this.lblAddedTaxesView.Text = Decimal.Round(Decimal.Parse(this.lblEstimateAmount.Text) - Decimal.Parse(this.lblSubTotalView.Text) + Decimal.Parse(this.lblDiscountAmt.Text), 2).ToString();
this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
this.imgLogo.ImageUrl = "../Handler/CompanyLogoFile.ashx?id=" + this.objCompanyMasterDT.Rows[0]["CompanyID"];
this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString();
string str11 = string.Empty;
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString()))
{
str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString()))
{
str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()));
if (this.objCityMasterDT.Rows.Count > 0)
{
str11 = str11 + this.objCityMasterDT.Rows[0]["CityName"] + " - ";
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString()))
{
str11 = str11 + this.objCompanyMasterDT.Rows[0]["CompanyZipCode"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()));
if (this.objStateMasterDT.Rows.Count > 0)
{
str11 = str11 + this.objStateMasterDT.Rows[0]["StateName"] + ",<br />";
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()));
if (this.objCountryMasterDT.Rows.Count > 0)
{
str11 = str11 + this.objCountryMasterDT.Rows[0]["CountryName"] + ".<br />";
}
}
this.lblCompanyAddress.Text = str11;
Label label10 = this.lblCompanyAddress;
string str12 = label10.Text + (object)"Email: <a href=\"mailto:" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "\">" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "</a><br />";
label10.Text = str12;
Label label11 = this.lblCompanyAddress;
string str13 = label11.Text + (object)"Phone: " + (string)this.objCompanyMasterDT.Rows[0]["CompanyPhone"];
label11.Text = str13;
this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objEstimateMasterDT.Rows[0]["ClientId"].ToString()));
this.lblClientOrganizationName.Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString();
this.lblClientFullName.Text = (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"];
string str14 = string.Empty + this.objCompanyClientMasterDT.Rows[0]["Address1"] + ",<br />" + this.objCompanyClientMasterDT.Rows[0]["Address2"] + ",<br />";
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString()))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString()));
if (this.objCityMasterDT.Rows.Count > 0)
{
str14 = str14 + this.objCityMasterDT.Rows[0]["CityName"] + " ";
}
}
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString()))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString()));
if (this.objStateMasterDT.Rows.Count > 0)
{
str14 = str14 + this.objStateMasterDT.Rows[0]["StateName"] + " ";
}
}
string str15 = string.Concat(new object[4]
{
(object)str14,
(object)" - ",
this.objCompanyClientMasterDT.Rows[0]["ZipCode"],
(object)",<br />"
});
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString()))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString()));
str15 += this.objCountryMasterDT.Rows[0]["CountryName"].ToString();
}
this.lblClientAddress.Text = str15;
switch (this.objEstimateMasterDT.Rows[0]["EstimateStatus"].ToString())
{
case "draft":
this.divStatus.Attributes.Add("class", "status-draft");
break;
case "draft-partial":
this.divStatus.Attributes.Add("class", "status-draft-partial");
break;
case "created":
this.divStatus.Attributes.Add("class", "status-created");
break;
case "sent":
this.divStatus.Attributes.Add("class", "status-received");
break;
case "viewed":
this.divStatus.Attributes.Add("class", "status-received");
break;
case "disputed":
this.divStatus.Attributes.Add("class", "status-disputed");
break;
case "paid":
this.divStatus.Attributes.Add("class", "status-paid");
break;
case "partial":
this.divStatus.Attributes.Add("class", "status-partial");
break;
case "pending":
this.divStatus.Attributes.Add("class", "status-pending");
break;
case "declined":
this.divStatus.Attributes.Add("class", "status-declined");
break;
case "auto-paid":
this.divStatus.Attributes.Add("class", "status-auto-paid");
break;
case "retry":
this.divStatus.Attributes.Add("class", "status-retry");
break;
case "failed":
this.divStatus.Attributes.Add("class", "status-failed");
break;
case "replied":
this.divStatus.Attributes.Add("class", "status-replied");
break;
case "commented":
this.divStatus.Attributes.Add("class", "status-commented");
break;
case "resolved":
this.divStatus.Attributes.Add("class", "status-resolved");
break;
case "invoiced":
this.divStatus.Attributes.Add("class", "status-invoiced");
break;
case "accepted":
this.divStatus.Attributes.Add("class", "status-accepted");
break;
case "Estimated":
this.divStatus.Attributes.Add("class", "status-Estimated");
break;
case "outstanding":
this.divStatus.Attributes.Add("class", "status-outstanding");
break;
case "open":
this.divStatus.Attributes.Add("class", "status-open");
break;
default:
this.divStatus.Attributes.Add("class", "status-created");
break;
}
string s3 = this.objEstimateMasterDT.Rows[0]["CurrencyID"].ToString();
if (string.IsNullOrEmpty(s3))
{
return;
}
this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s3));
if (this.objCurrencyMasterDT.Rows.Count <= 0)
{
return;
}
this.lblCurCodeView1.Text = this.lblCurCodeView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString();
this.lblCurSymbolView1.Text = this.lblCurSymbolView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString();
}
private void ViewRecord(string id)
{
bool flag = false;
this.objCreditMasterDT = this.objCreditMasterBll.GetDataByCreditID(int.Parse(id));
if (this.objCreditMasterDT.Rows.Count > 0)
{
flag = this.objCreditMasterDT.Rows[0]["ClientID"].ToString() == this.hfClientID.Value;
}
if (this.objCreditMasterDT.Rows.Count > 0 && flag)
{
this.hfCompanyID.Value = this.objCreditMasterDT.Rows[0]["CompanyID"].ToString();
this.objTemplateSettingsDT = this.objTemplateSettingsBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
if (this.objTemplateSettingsDT.Rows.Count > 0)
{
this.lblCreditTitle.Text = (string)this.objTemplateSettingsDT.Rows[0]["CreditTitle"] + (object)" #";
this.lblCreditTitleDate.Text = (string)this.objTemplateSettingsDT.Rows[0]["CreditTitle"] + (object)" Date";
}
this.hfCreditID.Value = this.objCreditMasterDT.Rows[0]["CreditID"].ToString();
this.lblCreditNum.Text = this.objCreditMasterDT.Rows[0]["CreditNumber"].ToString();
this.lblTerms.Text = this.objCreditMasterDT.Rows[0]["Terms"].ToString();
this.lblNotes.Text = this.objCreditMasterDT.Rows[0]["Notes"].ToString();
this.lblCreditNumHead.Text = "Credit: " + this.objCreditMasterDT.Rows[0]["CreditNumber"];
this.lblCreditDate.Text = DateTime.Parse(this.objCreditMasterDT.Rows[0]["CreditDate"].ToString()).ToString("MMMM dd, yyyy");
this.lblCreditTotalView.Text = Decimal.Round(Decimal.Parse(this.objCreditMasterDT.Rows[0]["CreditTotal"].ToString()), 2).ToString();
if (this.objCreditMasterDT.Rows[0]["CreditStatus"].ToString().ToLower() == "sent")
{
this.objCreditMasterBll.UpdateCreditStatus(int.Parse(this.hfCreditID.Value), "viewed");
}
this.lblCreditAmount.Text = Decimal.Parse(this.lblCreditTotalView.Text).ToString();
this.lblCreditAmount.Text = Decimal.Round(Decimal.Parse(this.lblCreditAmount.Text), 2).ToString();
this.divTaxValueView.Controls.Clear();
this.divTaxView.Controls.Clear();
Hashtable hashtable = new Hashtable();
if (this.gvTaskView.Rows.Count > 0)
{
for (int index = 0; index < this.gvTaskView.Rows.Count; ++index)
{
string text1 = this.gvTaskView.Rows[index].Cells[2].Text;
string text2 = this.gvTaskView.Rows[index].Cells[3].Text;
string text3 = this.gvTaskView.Rows[index].Cells[4].Text;
string text4 = this.gvTaskView.Rows[index].Cells[5].Text;
try
{
if (!string.IsNullOrEmpty(text3) && !text3.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100);
Label label1 = new Label()
{
Text = this.gvTaskView.Rows[index].Cells[4].Text + "(" + s + ")"
};
Label label2 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label1.Text))
{
object obj = hashtable[(object)label1.Text];
Decimal num = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label1.Text);
hashtable.Add((object)label1.Text, (object)num.ToString());
}
else
{
hashtable.Add((object)label1.Text, (object)label2.Text);
}
}
}
if (!string.IsNullOrEmpty(text4))
{
if (!text4.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100);
Label label1 = new Label()
{
Text = this.gvTaskView.Rows[index].Cells[5].Text + "(" + s + ")"
};
Label label2 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label1.Text))
{
object obj = hashtable[(object)label1.Text];
Decimal num = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label1.Text);
hashtable.Add((object)label1.Text, (object)num.ToString());
}
else
{
hashtable.Add((object)label1.Text, (object)label2.Text);
}
}
}
}
}
catch (Exception ex)
{
this.gvTaskView.Rows[index].Cells[4].Text = "";
this.gvTaskView.Rows[index].Cells[5].Text = "";
}
}
}
if (this.gvItemView.Rows.Count > 0)
{
for (int index = 0; index < this.gvItemView.Rows.Count; ++index)
{
string text1 = this.gvItemView.Rows[index].Cells[2].Text;
string text2 = this.gvItemView.Rows[index].Cells[3].Text;
string text3 = this.gvItemView.Rows[index].Cells[4].Text;
string text4 = this.gvItemView.Rows[index].Cells[5].Text;
try
{
if (!string.IsNullOrEmpty(text3) && !text3.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text3);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100);
Label label1 = new Label()
{
Text = this.gvItemView.Rows[index].Cells[4].Text + "(" + s + ")"
};
Label label2 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label1.Text))
{
object obj = hashtable[(object)label1.Text];
Decimal num = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label1.Text);
hashtable.Add((object)label1.Text, (object)num.ToString());
}
else
{
hashtable.Add((object)label1.Text, (object)label2.Text);
}
}
}
if (!string.IsNullOrEmpty(text4))
{
if (!text4.Contains("&"))
{
this.objTaxMasterDT = this.objTaxMasterBll.GetDataByTaxName(int.Parse(this.hfCompanyID.Value), text4);
if (this.objTaxMasterDT.Rows.Count > 0)
{
string s = this.objTaxMasterDT.Rows[0]["TaxRate"].ToString();
Decimal d = Decimal.Parse(text1) * Decimal.Parse(text2) * Decimal.Parse(s) / new Decimal(100);
Label label1 = new Label()
{
Text = this.gvItemView.Rows[index].Cells[5].Text + "(" + s + ")"
};
Label label2 = new Label()
{
Text = string.Concat((object)Decimal.Round(d, 2))
};
if (hashtable.ContainsKey((object)label1.Text))
{
object obj = hashtable[(object)label1.Text];
Decimal num = d + Decimal.Parse(obj.ToString());
hashtable.Remove((object)label1.Text);
hashtable.Add((object)label1.Text, (object)num.ToString());
}
else
{
hashtable.Add((object)label1.Text, (object)label2.Text);
}
}
}
}
}
catch (Exception ex)
{
this.gvItemView.Rows[index].Cells[4].Text = "";
this.gvItemView.Rows[index].Cells[5].Text = "";
}
}
}
if (hashtable.Count > 0)
{
foreach (string str in (IEnumerable)hashtable.Keys)
{
this.divTaxView.Controls.Add((Control) new Label()
{
Text = str
});
this.divTaxView.Controls.Add((Control) new LiteralControl("<br />"));
}
foreach (object obj in (IEnumerable)hashtable.Values)
{
this.divTaxValueView.Controls.Add((Control) new Label()
{
Text = ("+" + (object)Decimal.Round(Decimal.Parse(obj.ToString()), 2))
});
this.divTaxValueView.Controls.Add((Control) new LiteralControl("<br />"));
}
}
Decimal d1 = new Decimal(0);
if (this.gvItemView.Rows.Count > 0)
{
for (int index = 0; index < this.gvItemView.Rows.Count; ++index)
{
string text = this.gvItemView.Rows[index].Cells[6].Text;
if (!string.IsNullOrEmpty(text))
{
d1 += Decimal.Parse(text);
}
}
}
if (this.gvTaskView.Rows.Count > 0)
{
for (int index = 0; index < this.gvTaskView.Rows.Count; ++index)
{
string text = this.gvTaskView.Rows[index].Cells[6].Text;
if (!string.IsNullOrEmpty(text))
{
d1 += Decimal.Parse(text);
}
}
}
if (this.gvTaskView.Rows.Count <= 0 && this.gvItemView.Rows.Count <= 0)
{
d1 += Decimal.Parse(this.lblCreditAmount.Text);
}
this.lblSubTotalView.Text = Decimal.Round(d1, 2).ToString();
this.lblAddedTaxesView.Text = Decimal.Round(Decimal.Parse(this.lblCreditAmount.Text) - Decimal.Parse(this.lblSubTotalView.Text), 2).ToString();
this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(this.hfCompanyID.Value));
this.imgLogo.ImageUrl = "../Handler/CompanyLogoFile.ashx?id=" + this.objCompanyMasterDT.Rows[0]["CompanyID"];
this.lblCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString();
string str1 = string.Empty;
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString()))
{
str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString()))
{
str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()));
if (this.objCityMasterDT.Rows.Count > 0)
{
str1 = str1 + this.objCityMasterDT.Rows[0]["CityName"] + " - ";
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString()))
{
str1 = str1 + this.objCompanyMasterDT.Rows[0]["CompanyZipCode"] + ",<br />";
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()));
if (this.objStateMasterDT.Rows.Count > 0)
{
str1 = str1 + this.objStateMasterDT.Rows[0]["StateName"] + ",<br />";
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()));
if (this.objCountryMasterDT.Rows.Count > 0)
{
str1 = str1 + this.objCountryMasterDT.Rows[0]["CountryName"] + ".<br />";
}
}
this.lblCompanyAddress.Text = str1;
Label label3 = this.lblCompanyAddress;
string str2 = label3.Text + (object)"Email: <a href=\"mailto:" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "\">" + (string)this.objCompanyMasterDT.Rows[0]["CompanyEmail"] + "</a><br />";
label3.Text = str2;
Label label4 = this.lblCompanyAddress;
string str3 = label4.Text + (object)"Phone: " + (string)this.objCompanyMasterDT.Rows[0]["CompanyPhone"];
label4.Text = str3;
this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(this.objCreditMasterDT.Rows[0]["ClientId"].ToString()));
this.lblClientOrganizationName.Text = this.objCompanyClientMasterDT.Rows[0]["OrganizationName"].ToString();
this.lblClientFullName.Text = (string)this.objCompanyClientMasterDT.Rows[0]["FirstName"] + (object)" " + (string)this.objCompanyClientMasterDT.Rows[0]["LastName"];
string str4 = string.Empty + this.objCompanyClientMasterDT.Rows[0]["Address1"] + ",<br />" + this.objCompanyClientMasterDT.Rows[0]["Address2"] + ",<br />";
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString()))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString()));
if (this.objCityMasterDT.Rows.Count > 0)
{
str4 = str4 + this.objCityMasterDT.Rows[0]["CityName"] + " ";
}
}
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString()))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString()));
if (this.objStateMasterDT.Rows.Count > 0)
{
str4 = str4 + this.objStateMasterDT.Rows[0]["StateName"] + " ";
}
}
string str5 = string.Concat(new object[4]
{
(object)str4,
(object)" - ",
this.objCompanyClientMasterDT.Rows[0]["ZipCode"],
(object)",<br />"
});
if (!string.IsNullOrEmpty(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString()))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString()));
str5 += this.objCountryMasterDT.Rows[0]["CountryName"].ToString();
}
this.lblClientAddress.Text = str5;
switch (this.objCreditMasterDT.Rows[0]["CreditStatus"].ToString())
{
case "draft":
this.divStatus.Attributes.Add("class", "status-draft");
break;
case "draft-partial":
this.divStatus.Attributes.Add("class", "status-draft-partial");
break;
case "created":
this.divStatus.Attributes.Add("class", "status-created");
break;
case "sent":
case "viewed":
this.divStatus.Attributes.Add("class", "status-received");
break;
case "disputed":
this.divStatus.Attributes.Add("class", "status-disputed");
break;
case "paid":
this.divStatus.Attributes.Add("class", "status-paid");
break;
case "partial":
this.divStatus.Attributes.Add("class", "status-partial");
break;
case "pending":
this.divStatus.Attributes.Add("class", "status-pending");
break;
case "declined":
this.divStatus.Attributes.Add("class", "status-declined");
break;
case "auto-paid":
this.divStatus.Attributes.Add("class", "status-auto-paid");
break;
case "retry":
this.divStatus.Attributes.Add("class", "status-retry");
break;
case "failed":
this.divStatus.Attributes.Add("class", "status-failed");
break;
case "replied":
this.divStatus.Attributes.Add("class", "status-replied");
break;
case "commented":
this.divStatus.Attributes.Add("class", "status-commented");
break;
case "resolved":
this.divStatus.Attributes.Add("class", "status-resolved");
break;
case "accepted":
this.divStatus.Attributes.Add("class", "status-accepted");
break;
case "Creditd":
this.divStatus.Attributes.Add("class", "status-Creditd");
break;
case "outstanding":
this.divStatus.Attributes.Add("class", "status-outstanding");
break;
case "open":
this.divStatus.Attributes.Add("class", "status-open");
break;
default:
this.divStatus.Attributes.Add("class", "status-created");
break;
}
string s1 = this.objCreditMasterDT.Rows[0]["CurrencyID"].ToString();
if (string.IsNullOrEmpty(s1))
{
return;
}
this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(s1));
if (this.objCurrencyMasterDT.Rows.Count <= 0)
{
return;
}
this.lblCurCodeView1.Text = this.lblCurCodeView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencyCode"].ToString();
this.lblCurSymbolView1.Text = this.lblCurSymbolView2.Text = this.objCurrencyMasterDT.Rows[0]["CurrencySymbol"].ToString();
}
else
{
this.pnlViewAll.Visible = true;
this.pnlView.Visible = false;
this.BindGrid();
}
}
private void ViewClientDetails(string clientID)
{
this.objCompanyClientMasterDT = this.objCompanyClientMasterBll.GetDataByCompanyClientID(int.Parse(clientID));
if (this.objCompanyClientMasterDT.Rows.Count <= 0)
{
return;
}
this.hfClientID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyClientID"].ToString();
this.hfCompanyID.Value = this.objCompanyClientMasterDT.Rows[0]["CompanyID"].ToString();
this.txtEmail.Text = this.objCompanyClientMasterDT.Rows[0]["Email"].ToString();
this.txtFirstName.Text = this.objCompanyClientMasterDT.Rows[0]["FirstName"].ToString();
this.txtLastName.Text = this.objCompanyClientMasterDT.Rows[0]["LastName"].ToString();
this.txtHomePhone.Text = this.objCompanyClientMasterDT.Rows[0]["HomePhone"].ToString();
this.txtMobile.Text = this.objCompanyClientMasterDT.Rows[0]["Mobile"].ToString();
this.lblUsernameAdd.Text = this.txtUsername.Text = this.objCompanyClientMasterDT.Rows[0]["UserName"].ToString();
this.txtAddress1.Text = this.objCompanyClientMasterDT.Rows[0]["Address1"].ToString();
this.txtAddress2.Text = this.objCompanyClientMasterDT.Rows[0]["Address2"].ToString();
this.txtZipCode.Text = this.objCompanyClientMasterDT.Rows[0]["ZipCode"].ToString();
this.txtAddress1Secondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryAddress1"].ToString();
this.txtAddress2Secondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryAddress2"].ToString();
this.txtZipCodeSecondary.Text = this.objCompanyClientMasterDT.Rows[0]["SecondaryZipCode"].ToString();
this.txtBussinessPhone.Text = this.objCompanyClientMasterDT.Rows[0]["BussinessPhone"].ToString();
this.txtFax.Text = this.objCompanyClientMasterDT.Rows[0]["Fax"].ToString();
MembershipUser user = Membership.GetUser(this.txtUsername.Text);
if (user != null)
{
this.lblPasswordAdd.Text = user.GetPassword();
}
string s1 = this.objCompanyClientMasterDT.Rows[0]["CountryID"].ToString();
string s2 = this.objCompanyClientMasterDT.Rows[0]["StateID"].ToString();
string s3 = this.objCompanyClientMasterDT.Rows[0]["CityID"].ToString();
string s4 = this.objCompanyClientMasterDT.Rows[0]["SecondaryCountryID"].ToString();
string s5 = this.objCompanyClientMasterDT.Rows[0]["SecondaryStateID"].ToString();
string s6 = this.objCompanyClientMasterDT.Rows[0]["SecondaryCityID"].ToString();
if (!string.IsNullOrEmpty(s1))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s1));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
}
if (!string.IsNullOrEmpty(s2))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s2));
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
}
if (!string.IsNullOrEmpty(s3))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s3));
if (this.objCityMasterDT.Rows.Count > 0)
{
this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
}
if (!string.IsNullOrEmpty(s4))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(s4));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountrySecondary.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountrySecondary.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
}
if (!string.IsNullOrEmpty(s5))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(s5));
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlStateSecondary.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlStateSecondary.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
}
if (!string.IsNullOrEmpty(s6))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(s6));
if (this.objCityMasterDT.Rows.Count > 0)
{
this.ddlCitySecondary.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCitySecondary.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
}
this.txtUsername.Enabled = false;
this.txtEmail.Enabled = false;
}
private void SetRecord(string iD)
{
this.objCompanyMasterDT = this.objCompanyMasterBll.GetDataByCompanyID(int.Parse(iD));
if (this.objCompanyMasterDT.Rows.Count <= 0)
{
return;
}
this.hfCompanyID.Value = this.objCompanyMasterDT.Rows[0]["CompanyID"].ToString();
this.txtCompanyName.Text = this.objCompanyMasterDT.Rows[0]["CompanyName"].ToString();
this.txtCompanyUserName.Text = this.objCompanyMasterDT.Rows[0]["CompanyUserName"].ToString();
this.txtPhoneNumber.Text = this.objCompanyMasterDT.Rows[0]["CompanyPhone"].ToString();
this.txtFaxNumber.Text = this.objCompanyMasterDT.Rows[0]["CompanyFax"].ToString();
this.txtEmail.Text = this.objCompanyMasterDT.Rows[0]["CompanyEmail"].ToString();
this.txtAddress1.Text = this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet1"].ToString();
this.txtAddress2.Text = this.objCompanyMasterDT.Rows[0]["CompanyAddressStreet2"].ToString();
this.txtZipCode.Text = this.objCompanyMasterDT.Rows[0]["CompanyZipCode"].ToString();
this.txtNotes.Text = this.objCompanyMasterDT.Rows[0]["CompanyNotes"].ToString();
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()))
{
this.objCountryMasterDT = this.objCountryMasterBll.GetDataByCountryID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCountryID"].ToString()));
if (this.objCountryMasterDT.Rows.Count > 0)
{
this.ddlCountry.Items.Add(this.objCountryMasterDT.Rows[0]["CountryID"].ToString());
this.ddlCountry.SelectedValue = this.objCountryMasterDT.Rows[0]["CountryID"].ToString();
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()))
{
this.objStateMasterDT = this.objStateMasterBll.GetDataByStateID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyStateID"].ToString()));
if (this.objStateMasterDT.Rows.Count > 0)
{
this.ddlState.Items.Add(this.objStateMasterDT.Rows[0]["StateID"].ToString());
this.ddlState.SelectedValue = this.objStateMasterDT.Rows[0]["StateID"].ToString();
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()))
{
this.objCityMasterDT = this.objCityMasterBll.GetDataByCityID(int.Parse(this.objCompanyMasterDT.Rows[0]["CompanyCityID"].ToString()));
if (this.objCityMasterDT.Rows.Count > 0)
{
this.ddlCity.Items.Add(this.objCityMasterDT.Rows[0]["CityID"].ToString());
this.ddlCity.SelectedValue = this.objCityMasterDT.Rows[0]["CityID"].ToString();
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["BussinessID"].ToString()))
{
this.objBussinessMasterDT = this.objBussinessMasterBll.GetDataByBussinessID(int.Parse(this.objCompanyMasterDT.Rows[0]["BussinessID"].ToString()));
if (this.objBussinessMasterDT.Rows.Count > 0)
{
this.ddlBussiness.Items.Add(this.objBussinessMasterDT.Rows[0]["BussinessID"].ToString());
this.ddlBussiness.SelectedValue = this.objBussinessMasterDT.Rows[0]["BussinessID"].ToString();
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["IndustryID"].ToString()))
{
this.objIndustryMasterDT = this.objIndustryMasterBll.GetDataByIndustryID(int.Parse(this.objCompanyMasterDT.Rows[0]["IndustryID"].ToString()));
if (this.objIndustryMasterDT.Rows.Count > 0)
{
this.ddlIndustry.Items.Add(this.objIndustryMasterDT.Rows[0]["IndustryID"].ToString());
this.ddlIndustry.SelectedValue = this.objIndustryMasterDT.Rows[0]["IndustryID"].ToString();
}
}
if (!string.IsNullOrEmpty(this.objCompanyMasterDT.Rows[0]["CurrencyID"].ToString()))
{
this.objCurrencyMasterDT = this.objCurrencyMasterBll.GetDataByCurrencyID(int.Parse(this.objCompanyMasterDT.Rows[0]["CurrencyID"].ToString()));
if (this.objCurrencyMasterDT.Rows.Count > 0)
{
this.ddlCurrency.Items.Add(this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString());
this.ddlCurrency.SelectedValue = this.objCurrencyMasterDT.Rows[0]["CurrencyID"].ToString();
}
}
this.txtCompanyUserName.Enabled = false;
this.txtEmail.Enabled = false;
}
public virtual int Update(CloudAccountDA.CityMasterDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
