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 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.");
}
}
}
public bool Update(itemCustBLL u)
{
bool isSuccess = false;
Module.Tool tool = new Module.Tool();
Module.Text text = new Module.Text();
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
String sql = "UPDATE tbl_item_cust SET forecast_one=@forecast_one, forecast_two=@forecast_two, forecast_three=@forecast_three,forecast_four=@forecast_four, forecast_current_month=@forecast_current_month, forecast_updated_date=@forecast_updated_date, forecast_updated_by=@forecast_updated_by WHERE item_code=@item_code AND cust_id = @cust_id";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@forecast_one", u.forecast_one);
cmd.Parameters.AddWithValue("@forecast_two", u.forecast_two);
cmd.Parameters.AddWithValue("@forecast_three", u.forecast_three);
cmd.Parameters.AddWithValue("@forecast_four", u.forecast_four);
cmd.Parameters.AddWithValue("@forecast_current_month", u.forecast_current_month);
cmd.Parameters.AddWithValue("@forecast_updated_date", u.forecast_updated_date);
cmd.Parameters.AddWithValue("@forecast_updated_by", u.forecast_updated_by);
cmd.Parameters.AddWithValue("@item_code", u.item_code);
cmd.Parameters.AddWithValue("@cust_id", u.cust_id);
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query is executed successfully then the rows' value = 0
if (rows > 0)
{
//query successful
isSuccess = true;
}
else
{
//Query falled
isSuccess = false;
}
}
catch (Exception ex)
{
tool.saveToText(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Insert(itemCustBLL u)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
String sql = "INSERT INTO tbl_item_cust (item_code, cust_id, forecast_one, forecast_two, forecast_three, forecast_four, forecast_current_month, item_cust_added_date, item_cust_added_by) VALUES (@item_code, @cust_id, @forecast_one, @forecast_two, @forecast_three, @forecast_four, @forecast_current_month, @item_cust_added_date, @item_cust_added_by)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@item_code", u.item_code);
cmd.Parameters.AddWithValue("@cust_id", u.cust_id);
cmd.Parameters.AddWithValue("@forecast_one", u.forecast_one);
cmd.Parameters.AddWithValue("@forecast_two", u.forecast_two);
cmd.Parameters.AddWithValue("@forecast_three", u.forecast_three);
cmd.Parameters.AddWithValue("@forecast_four", u.forecast_four);
cmd.Parameters.AddWithValue("@forecast_current_month", u.forecast_current_month);
cmd.Parameters.AddWithValue("@item_cust_added_date", u.item_cust_added_date);
cmd.Parameters.AddWithValue("@item_cust_added_by", u.item_cust_added_by);
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query is executed successfully then the rows' value = 0
if (rows > 0)
{
//query successful
isSuccess = true;
}
else
{
//Query falled
isSuccess = false;
}
}
catch (Exception ex)
{
Module.Tool tool = new Module.Tool(); tool.saveToText(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(itemCustBLL u)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(myconnstrng);
try
{
String sql = "DELETE FROM tbl_item_cust WHERE cust_id=@cust_id AND item_code=@item_code";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@cust_id", u.cust_id);
cmd.Parameters.AddWithValue("@item_code", u.item_code);
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query is executed successfully then the rows' value = 0
if (rows > 0)
{
//query successful
isSuccess = true;
}
else
{
//Query falled
isSuccess = false;
}
}
catch (Exception ex)
{
Module.Tool tool = new Module.Tool(); tool.saveToText(ex);
}
finally
{
conn.Close();
}
return(isSuccess);
}
