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 void btnAdd_Click(object sender, EventArgs e) { if (Validation()) { DialogResult dialogResult = MessageBox.Show("Are you sure want to insert data to database?", "Message", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { if (!IfExists(cmbItemCode.Text, cmbCust.Text)) { uItemCust.cust_id = Convert.ToInt32(getCustID(cmbCust.Text)); uItemCust.item_code = cmbItemCode.Text; uItemCust.item_cust_added_date = DateTime.Now; uItemCust.item_cust_added_by = 0; 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 == true) { refreshList(); } else { //Failed to insert data MessageBox.Show("Failed to add new item_cust record"); } } else { MessageBox.Show("Data already exist."); } } } }
private void dgvForecast_CellEndEdit(object sender, DataGridViewCellEventArgs e) { try { var datagridview = sender as DataGridView; int rowIndex = e.RowIndex; DateTime updatedTime = DateTime.Now; uItemCust.item_code = dgvForecast.Rows[rowIndex].Cells["item_code"].Value.ToString(); uItemCust.cust_id = tool.getCustID(cmbCust.Text); uItemCust.forecast_one = Convert.ToSingle(dgvForecast.Rows[rowIndex].Cells["forecast_one"].Value.ToString()); uItemCust.forecast_two = Convert.ToSingle(dgvForecast.Rows[rowIndex].Cells["forecast_two"].Value.ToString()); uItemCust.forecast_three = Convert.ToSingle(dgvForecast.Rows[rowIndex].Cells["forecast_three"].Value.ToString()); uItemCust.forecast_four = Convert.ToSingle(dgvForecast.Rows[rowIndex].Cells["forecast_four"].Value); uItemCust.forecast_updated_date = updatedTime; uItemCust.forecast_current_month = cmbForecast1.Text; uItemCust.forecast_updated_by = MainDashboard.USER_ID; if (Convert.ToInt32(forecastNum) == 2) { newForecast = uItemCust.forecast_one.ToString(); } else if (Convert.ToInt32(forecastNum) == 3) { newForecast = uItemCust.forecast_two.ToString(); } else if (Convert.ToInt32(forecastNum) == 4) { newForecast = uItemCust.forecast_three.ToString(); } else { newForecast = uItemCust.forecast_four.ToString(); } if (oldForecast != newForecast) { if (tool.IfExists(uItemCust.item_code, cmbCust.Text)) { bool success = dalItemCust.Update(uItemCust); if (!success) { MessageBox.Show("Failed to updated forecast"); tool.historyRecord(text.System, "Failed to updated forecast(frmForecast) " + uItemCust.item_code, DateTime.Now, MainDashboard.USER_ID); } else { dgvForecast.Rows[rowIndex].Cells["forecast_updtd_date"].Value = updatedTime; dgvForecast.Rows[rowIndex].Cells["forecast_updtd_by"].Value = dalUser.getUsername(MainDashboard.USER_ID); tool.historyRecord(text.ForecastEdit, text.getForecastEditString(cmbCust.Text, forecastNum, uItemCust.item_code, oldForecast, newForecast), DateTime.Now, MainDashboard.USER_ID); } } else { bool success = dalItemCust.Insert(uItemCust); //If the data is successfully inserted then the value of success will be true else false if (!success) { MessageBox.Show("Failed to add new forecast"); tool.historyRecord(text.System, "Failed to add new forecast(frmForecast) " + uItemCust.item_code, DateTime.Now, MainDashboard.USER_ID); } dgvForecast.Rows[rowIndex].Cells["forecast_updtd_date"].Value = updatedTime; dgvForecast.Rows[rowIndex].Cells["forecast_updtd_by"].Value = dalUser.getUsername(MainDashboard.USER_ID); } } } catch (Exception ex) { tool.saveToTextAndMessageToUser(ex); } }