private void pairCustomer()
{
itemCustBLL uItemCust = new itemCustBLL();
itemCustDAL dalItemCust = new itemCustDAL();
string cust = cmbCust.Text;
if (cmbCat.Text.Equals("Part") && !string.IsNullOrEmpty(cust))
{
if (!IfExists(txtItemCode.Text, cmbCust.Text))
{
uItemCust.cust_id = Convert.ToInt32(tool.getCustID(cmbCust.Text));
uItemCust.item_code = txtItemCode.Text;
uItemCust.item_cust_added_date = DateTime.Now;
uItemCust.item_cust_added_by = MainDashboard.USER_ID;
uItemCust.forecast_one = 0;
uItemCust.forecast_two = 0;
uItemCust.forecast_three = 0;
uItemCust.forecast_current_month = DateTime.Now.ToString("MMMM");
bool success = dalItemCust.Insert(uItemCust);
if (!success)
{
//Failed to insert data
MessageBox.Show("Failed to add new item_cust record");
}
}
else
{
MessageBox.Show("Data already exist.");
}
}
}
private void pairCustomer(string cust, string itemCode)
{
itemCustBLL uItemCust = new itemCustBLL();
itemCustDAL dalItemCust = new itemCustDAL();
if (!tool.IfExists(itemCode, cust))
{
uItemCust.cust_id = Convert.ToInt32(tool.getCustID(cust));
uItemCust.item_code = itemCode;
uItemCust.item_cust_added_date = DateTime.Now;
uItemCust.item_cust_added_by = MainDashboard.USER_ID;
uItemCust.forecast_one = 0;
uItemCust.forecast_two = 0;
uItemCust.forecast_three = 0;
uItemCust.forecast_current_month = DateTime.Now.ToString("MMMM");
bool success = dalItemCust.Insert(uItemCust);
if (!success)
{
//Failed to insert data
MessageBox.Show("Failed to add new item_cust record");
}
}
else
{
MessageBox.Show("Data already exist.");
}
}
private bool IfExists(string itemCode, string custName)
{
itemCustDAL dalItemCust = new itemCustDAL();
DataTable dt = dalItemCust.existsSearch(itemCode, tool.getCustID(custName).ToString());
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
