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 CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim());
foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbAddress.Text = dr["Address"].ToString().Trim();
}
DeleteUnSavedItems();
FillRRGrid(Convert.ToInt16(id));
FillItems(tbPEZAFormNumber.Text.Trim());
}
catch (Exception ex) { }
}
private void CboLOAOwner_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (cboLOAOwner.SelectedIndex != -1)
{
int id = Convert.ToInt32(cboLOAOwner.SelectedValue.ToString().Trim());
foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbCustomerAddress.Text = dr["Address"].ToString().Trim();
}
PopulateLOA();
GroupLOA.IsEnabled = true;
}
}
catch
{
}
}
private void CboCustomer_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cboCustomer.SelectedIndex != -1)
{
int id = Convert.ToInt32(cboCustomer.SelectedValue.ToString().Trim());
if (ClsCantierDB.GetVendorAddress(id).Rows.Count == 0)
{
foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows)
{
tbCustomerAddress.Text = dr1["Address"].ToString().Trim();
}
}
else
{
foreach (DataRow dr in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbCustomerAddress.Text = dr["Address"].ToString().Trim();
}
}
}
}
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 PopulateFields(string _loaNo)
{
ClearFields();
foreach (DataRow dr in ClsPEZAData.GetLOArequestByNumber(_loaNo).Rows)
{
tbLOANo.Text = dr["LOAno"].ToString().Trim();
dateEncoded.SelectedDate = Convert.ToDateTime(dr["LOAdate"]);
cboPurpose.SelectedValue = dr["LOAtype"].ToString().Trim();
if (cboPurpose.SelectedValue.ToString().Trim() == "SC" ||
cboPurpose.SelectedValue.ToString().Trim() == "XX")
{
cboCustomer.ItemsSource = null;
cboCustomer.ItemsSource = ClsPEZAData.GetSubContractorListFromCustomerMaster().DefaultView;
int id = Convert.ToInt32(dr["LOAclient"]);
cboCustomer.SelectedValue = id.ToString();
foreach (DataRow dr2 in ClsCantierDB.GetVendorAddress(id).Rows)
{
tbCustomerAddress.Text = dr2["Address"].ToString().Trim();
}
}
else
{
cboCustomer.ItemsSource = null;
cboCustomer.ItemsSource = ClsCantierDB.GetCustomerList().DefaultView;
cboCustomer.SelectedIndex = 0;
int id = Convert.ToInt32(dr["LOAclient"]);
cboCustomer.SelectedValue = id.ToString();
foreach (DataRow dr1 in ClsCantierDB.GetCustomerAddress(id).Rows)
{
tbCustomerAddress.Text = dr1["Address"].ToString().Trim();
}
}
tbSuretyBondNo.Text = dr["LoaBondNo"].ToString();
tbORNo.Text = dr["LOA_ORno"].ToString().Trim();
if (dr.IsNull("LOAdatePaid"))
{
datePayment.SelectedDate = null;
}
else
{
datePayment.SelectedDate = Convert.ToDateTime(dr["LOAdatePaid"]);
}
tbAmount.Text = dr["LOAamt"].ToString().Trim();
if (dr.IsNull("LOAexp"))
{
dateLOAExpire.SelectedDate = null;
}
else
{
dateLOAExpire.SelectedDate = Convert.ToDateTime(dr["LOAexp"]);
}
if (dr.IsNull("LOAbondExpDate"))
{
dateBondExp.SelectedDate = null;
}
else
{
dateBondExp.SelectedDate = Convert.ToDateTime(dr["LOAbondExpDate"]);
}
if (dr["LOAstatus"].ToString().Trim() == "A")
{
cboStatus.SelectedIndex = 0;
}
else if (dr["LOAstatus"].ToString().Trim() == "C")
{
cboStatus.SelectedIndex = 1;
}
else
{
cboStatus.SelectedIndex = -1;
}
PopulateLOAItemLists(_loaNo.Trim());
}
PopulateCurrency();
ComputeTotalAmount();
}
