private void FillDataSources()
{
PopulateCustomers();
PopulateMonthAndYear();
PopulateSKPIsignatories();
PopulateTypeAndPurpose();
PopulatePEZAsignatories();
cboCurrency.ItemsSource = ClsPEZAData.GetCurrencyList().DefaultView;
cbo8106ItemDescription.ItemsSource = ClsPEZAData.GetPEZAitemsList().DefaultView;
cboLOAEstimatedUOM.ItemsSource = ClsCantierDB.GetUOM().DefaultView;
PopulateList();
grid8106.SelectedItems.Clear();
tbPEZAPermitNo.Text = string.Empty;
tbORNo.Text = "0";
tb8106ItemNo.Text = "1";
}
private void PopulateFields(string formNo)
{
foreach (DataRow dr in ClsPEZAData.Get8106formByNo(formNo).Rows)
{
_customerid = Convert.ToInt16(dr["8106client"]);
foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(Convert.ToInt32(dr["8106client"])).Rows)
{
tbCustomerName.Text = dr1["Name"].ToString().Trim();
}
if (!dr.IsNull("8106estQty"))
{
tbEstimatedQuantity.Text = Convert.ToDecimal(dr["8106estQty"]).ToString("#,##0");
}
if (!dr.IsNull("8106estAmt"))
{
tbEstimatedAmount.Text = Convert.ToDecimal(dr["8106estAmt"]).ToString("#,##0.00");
}
if (!dr.IsNull("BoatNote"))
{
tbBoatNote.Text = dr["BoatNote"].ToString().Trim();
}
}
}
private void PopulateCustomers()
{
if (cboPurpose.SelectedIndex > -1)
{
cboCustomer.ItemsSource = null;
if (cboPurpose.SelectedValue.ToString().Trim() == "SC" ||
cboPurpose.SelectedValue.ToString().Trim() == "XX")
{
cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
cboCustomer.SelectedIndex = 0;
int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim());
foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbCustomerAddress.Text = dr["Address"].ToString().Trim();
}
}
else
{
cboCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView;
cboCustomer.SelectedIndex = 0;
int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim());
foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows)
{
tbCustomerAddress.Text = dr1["Address"].ToString().Trim();
}
}
}
}
private void TbsearchInvoice_SearchTextChanged(object sender, EventArgs e)
{
if (tbsearchInvoice.SearchText.Length > 0 && cboCustomer.SelectedIndex != -1)
{
gridAvailableInvoices.ItemsSource = ClsPEZAData.GetSalesInvoiceSummaryListFromCantierForPEZA8112byCustomerByInvoice(Convert.ToInt16(cboCustomer.SelectedValue.ToString().Trim())
, tbsearchInvoice.SearchText.ToString().Trim()).DefaultView;
}
}
private void PopulateLOA()
{
if (cboCustomer.SelectedIndex != -1)
{
Int16 client = Convert.ToInt16(cboLOAOwner.SelectedValue.ToString().Trim());
cboPEZALOANo.ItemsSource = ClsPEZAData.GetClientLOAlist(client, _PEZAType).DefaultView;
}
}
private void PopulateLOAType()
{
cboPurpose.ItemsSource = ClsPEZAData.GetLOAtypeList().DefaultView;
cboPurpose.SelectedIndex = 0;
cboCustomer.IsEnabled = true;
PopulateCustomers();
}
private void PopulatePEZAsignatories()
{
cboAuthorizedOfficial1.ItemsSource = ClsPEZAData.GetPEZAsignatories().DefaultView;
cboAuthorizedOfficial1.SelectedValue = _PEZASig1;
cboAuthorizedOfficial2.ItemsSource = ClsPEZAData.GetPEZAsignatories().DefaultView;
cboAuthorizedOfficial2.SelectedValue = _PEZASig1;
}
private void CboSKPIAuthorizedSignatory_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
foreach (DataRow dr in ClsPEZAData.GetSKPIsignatoriesPosition(cboSKPIAuthorizedSignatory.SelectedValue.ToString().Trim()).Rows)
{
tbSKPIPosition.Text = dr["SignatoryPosition"].ToString().Trim();
}
}
catch { }
}
private void CboYear_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
grid8106.ItemsSource = ClsPEZAData.Get8106formListByMonth(Convert.ToInt16(cboMonth.SelectedValue.ToString().Trim())
, Convert.ToInt16(cboYear.SelectedItem.ToString().Trim()), _PEZAType).DefaultView;
}
catch
{
}
}
private void CboType_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (cboType.SelectedIndex != -1)
{
cboPurpose.ItemsSource = ClsPEZAData.GetLOATypePurpose(_PEZAType).DefaultView;
}
}
catch
{
}
}
private void PopulateTypeAndPurpose()
{
cboType.ItemsSource = ClsPEZAData.GetLOAType(_LOAType).DefaultView;
cboType.SelectedValue = _PEZAType;
if (cboType.SelectedIndex != -1)
{
cboPurpose.ItemsSource = ClsPEZAData.GetLOATypePurpose(_PEZAType).DefaultView;
cboPurpose.SelectedValue = _Purposed;
}
}
private void PopulateFields(string _formno)
{
foreach (DataRow dr in ClsPEZAData.Get8105DataByFormNo(_formno).Rows)
{
tbPEZAFormNumber.Text = dr[0].ToString().Trim();
datePEZA.SelectedDate = Convert.ToDateTime(dr[1]);
tbZoneEntName.Text = dr[15].ToString().Trim();
tbZoneEntRegNo.Text = dr[16].ToString().Trim();
tbPEZAcontrolNo.Text = dr[14].ToString().Trim();
tbEcoZoneName.Text = dr[19].ToString();
tbPurpose.Text = dr[2].ToString().Trim();
cboCurrency.Text = dr[3].ToString().Trim();
cboCustomer.SelectedValue = Convert.ToInt16(dr[25]);
tbAddress.Text = dr[5].ToString();
tbInternalRevenueTax.Text = dr[6].ToString();
dateOfDelivery.SelectedDate = Convert.ToDateTime(dr[7]);
tbCarrier.Text = dr[8].ToString();
tbCountryOfOrigin.Text = dr[9].ToString();
dateImported.SelectedDate = Convert.ToDateTime(dr[12]);
tbImportPrice.Text = dr[10].ToString();
tbDutiesNtaxesPaid.Text = dr[11].ToString();
cboSKPIAuthorizedSignatory.SelectedValue = dr[17].ToString();
tbSKPIPosition.Text = dr[18].ToString();
cboAuthorizedOfficial1.SelectedValue = dr[20].ToString();
cboAuthorizedOfficial2.SelectedValue = dr[21].ToString();
}
FillItems(_formno);
FillReturnables(_formno);
}
private void PopulateUsedInvoices()
{
gridUsedInvoices.ItemsSource = ClsPEZAData.GetPEZA8112itemInvoices(tbPEZAFormNumber.Text.Trim()
).DefaultView;
if (gridUsedInvoices.Items.Count > 0)
{
btnRemove8106.IsEnabled = false;
}
else
{
btnRemove8106.IsEnabled = false;
}
}
private void PopulateMonthAndYear()
{
cboMonth.ItemsSource = ClsPEZAData.GenerateMonth().DefaultView;
cboYear.Items.Clear();
for (int i = DateTime.Now.Year; i >= 2000; i--)
{
cboYear.Items.Add(i.ToString());
}
cboMonth.SelectedValue = DateTime.Now.Month;
cboYear.SelectedItem = DateTime.Now.Year.ToString();
}
private void GetLOADetails(string LOANo)
{
foreach (DataRow dr in ClsPEZAData.GetClientLOAlistByLOANo(LOANo).Rows)
{
tbPEZALOANoDateExpired.Text = Convert.ToDateTime(dr["LOAdate"]).ToString("dd/MMM/yyyy");
tbLOABondNo.Text = dr["LOAbondNo"].ToString().Trim();
tbBondExpirationDate.Text = Convert.ToDateTime(dr["LOAbondExpDate"]).ToString("dd/MMM/yyyy");
tbLOAQtyApplied.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAqty"]));
tbLOAQtyUsed.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAqtyDelivered"]));
tbLOAQtyBalance.Text = string.Format("{0:#,###0.#}", Convert.ToDecimal(dr["LOAbalanceQty"]));
}
tb8106ItemNo.Text = "1";
}
private void PopulateFilterCustomer()
{
if (cboFilterPurpose.SelectedIndex > -1)
{
cboFilterCustomer.ItemsSource = null;
if (cboFilterPurpose.SelectedValue.ToString().Trim() == "SC" ||
cboFilterPurpose.SelectedValue.ToString().Trim() == "XX")
{
cboFilterCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
cboFilterCustomer.SelectedIndex = 0;
}
else
{
cboFilterCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView;
cboFilterCustomer.SelectedIndex = 0;
}
}
}
private void Save()
{
SqlCommand cmd = new SqlCommand("Save8105Returnables");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@8105FormNo", _8105formNo.ToString().Trim());
cmd.Parameters.AddWithValue("@PEZAformType", tbFormType.Text.Trim());
cmd.Parameters.AddWithValue("@PEZAformNo", tbFormNo.Text.Trim());
cmd.Parameters.AddWithValue("@ItemDesc", tbDescription.Text.Trim());
cmd.Parameters.AddWithValue("@ItemQty", Convert.ToInt32(tbQuantity.Text.Trim()));
cmd.Parameters.AddWithValue("@ItemUnit", cboUOM.SelectedValue.ToString().Trim());
SqlHelper.ExecuteNonQuery(ClsConfig.PEZAConnectionString, cmd);
PEZA_8105.grid_Returnables.ItemsSource = ClsPEZAData.Get8105Returnables(_8105formNo.ToString().Trim()).DefaultView;
}
private void PopulateUsedInvoices()
{
dtUsedInvoice.Clear();
foreach (var column in dtUsedInvoice.Columns.Cast <DataColumn>().ToArray())
{
if (dtUsedInvoice.AsEnumerable().All(dr => dr.IsNull(column)))
{
dtUsedInvoice.Columns.Remove(column);
}
}
gridUsedSI.ItemsSource = null;
dtUsedInvoice.Columns.Add("invoiceNo", typeof(string));
dtUsedInvoice.Columns.Add("invoiceQty", typeof(string));
dtUsedInvoice.Columns.Add("BalanceQty", typeof(string));
dtUsedInvoice.Columns.Add("invoiceAmt", typeof(string));
dtUsedInvoice.Columns.Add("BalanceAmt", typeof(string));
dtUsedInvoice.Columns.Add("TripNo", typeof(string));
foreach (DataRow dr in ClsPEZAData.GetPEZA8106itemInvoices(_formNo, 1).Rows)
{
DataRow drw = dtUsedInvoice.NewRow();
drw["invoiceNo"] = dr["invoiceNo"].ToString().Trim();
drw["invoiceQty"] = Convert.ToInt32(dr["invoiceQty"]).ToString("#,##0").Trim();
drw["BalanceQty"] = Convert.ToInt32(tbEstimatedQuantity.Text == string.Empty ? 0
: Convert.ToInt32(tbEstimatedQuantity.Text.Replace(",", ""))
- Convert.ToInt32(dr["invoiceQty"])).ToString("#,##0");
drw["invoiceAmt"] = Convert.ToDecimal(Convert.ToDecimal(dr["invoiceAmt"]).ToString("#,##0.00"));
drw["BalanceAmt"] = Convert.ToDecimal((Convert.ToDecimal(tbEstimatedAmount.Text == string.Empty ? 0
: Convert.ToDouble(tbEstimatedAmount.Text.Replace(",", "")))
- Convert.ToDecimal(dr["invoiceAmt"]))).ToString("#,##0.00");
drw["TripNo"] = dr["TripNo"].ToString().Trim();
dtUsedInvoice.Rows.Add(drw);
}
gridUsedSI.ItemsSource = dtUsedInvoice.DefaultView;
}
private void PopulateSKPIsignatories()
{
cboSKPIAuthorizedSignatory.ItemsSource = ClsPEZAData.GetSKPIsignatories().DefaultView;
}
private void PopulateCustomers()
{
cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
cboLOAOwner.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
}
private void PopulateSupplier()
{
cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
cboCustomer.SelectedIndex = 0;
}
private void PopulateAvailableInvoices()
{
gridSI.ItemsSource = ClsPEZAData.GetSalesInvoiceSummaryListFromCantierForPEZA8106byCustomer(_customerid).DefaultView;
}
private void PopulateCommodity()
{
cboCommodity.ItemsSource = ClsPEZAData.GetPEZAcommodityList().DefaultView;
cboCommodity.SelectedIndex = 0;
}
private void FillReturnables(string _form)
{
gridReturnables.ItemsSource = ClsPEZAData.Get8105Returnables(_form).DefaultView;
}
private void FillItems(string _form)
{
gridItems.ItemsSource = ClsPEZAData.GetPEZA8105items(_form).DefaultView;
ComputeTotal();
}
private void PopulateCurrency()
{
cboCurrency.ItemsSource = ClsPEZAData.GetCurrencyList().DefaultView;
cboCurrency.SelectedIndex = 0;
}
private void PopulateFields(string formNo)
{
foreach (DataRow dr in ClsPEZAData.Get8106formByNo(formNo).Rows)
{
tbPEZAFormNumber.Text = dr["8106formNo"].ToString().Trim();
datePEZA.SelectedDate = Convert.ToDateTime(dr["8106date"]);
tbPEZAPermitNo.Text = dr["8106controlNo"].ToString().Trim();
PopulateCustomers();
cboCustomer.SelectedValue = dr["8106client"].ToString().Trim();
int id = Convert.ToInt32(dr["8106client"].ToString().Trim());
foreach (DataRow dr1 in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbCustomerAddress.Text = dr1["Address"].ToString().Trim();
}
PopulateLOA();
GroupLOA.IsEnabled = true;
cboAuthorizedOfficial1.SelectedValue = dr["8106PEZAauthorizedOfficial1"].ToString().Trim();
cboAuthorizedOfficial2.SelectedValue = dr["8106PEZAauthorizedOfficial2"].ToString().Trim();
cboSKPIAuthorizedSignatory.SelectedValue = dr["8106SKPIauthorizedOfficial"].ToString().Trim();
tb8106ItemNo.Text = dr["8106itemNo"].ToString();
tbORNo.Text = dr["8106PEZApermitOR"].ToString().Trim();
dateDelivered.SelectedDate = Convert.ToDateTime(dr["8106deliveryDate"]);
cboCurrency.SelectedValue = dr["8106currency"].ToString().Trim();
cboLOAOwner.SelectedValue = dr["8106LOAowner"].ToString().Trim();
if (!dr.IsNull("8106partCode"))
{
cbo8106ItemDescription.SelectedValue = dr["8106partCode"].ToString();
}
if (!dr.IsNull("8106LOA"))
{
cboPEZALOANo.SelectedValue = dr["8106LOA"].ToString().Trim();
GetLOADetails(dr["8106LOA"].ToString().Trim());
}
if (!dr.IsNull("8106unit"))
{
cboLOAEstimatedUOM.SelectedValue = dr["8106unit"].ToString().Trim();
}
if (!dr.IsNull("8106estQty"))
{
tbLOAEstimatedQty.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8106estQty"]));
}
if (!dr.IsNull("8106estQty"))
{
tbLOATotalEstimatedAmount.Text = string.Format("{0:#,###0.#}", Convert.ToInt32(dr["8106estAmt"]));
}
ComputeActualQtyNamt();
}
}
private void PopulateList()
{
grid8106.ItemsSource = ClsPEZAData.Get8106formListByMonth(Convert.ToInt16(cboMonth.SelectedValue.ToString().Trim())
, Convert.ToInt16(cboYear.SelectedItem.ToString().Trim()), _PEZAType);
}
private void PopulateAvailableInvoices()
{
gridSI.ItemsSource = ClsPEZAData.GetDRSummaryListFromCantierForPEZA8106TripControl_SubCon(
_customerid
).DefaultView;
}
private void FillRRGrid(Int16 _supplier)
{
gridRR.ItemsSource = ClsPEZAData.GetPartsRRlistFor8105(_supplier).DefaultView;
}
