private void ucLMMaking_Load(object sender, EventArgs e)
{
lblDate.Text = DateTime.Today.ToString("dd/MM/yyyy");
btnAdd.Text = "Add"; //TEXTBOX DEFAULT TEXT SET AFTER DATAGRIDVIEW ROW DOUBLE CLICK
LoadDataDgv(); //LOAD USER DATA
DataGrdViewDesign(); //DATAGRIDVIEW DESIGN
//LOAD DIVISION DATA TO COMBO BOX
objClassBLL = new LM_MakingClassBLL();
cbxLmType.DataSource = objClassBLL.LoadType();
cbxSearchLmType.DataSource = objClassBLL.LoadType();
//CLEAR ALL COMBOBOX DEFAULT SELECT VALUE
ClearTextBoxces();
}
//UPDATE DATA
private void DataUpadate()
{
try
{
if (//CHECK TEXBOXES NOT NULL OR EMPTY
String.IsNullOrWhiteSpace(txtSupplierName.Text) ||
String.IsNullOrWhiteSpace(cbxLmType.Text.ToString()) ||
String.IsNullOrWhiteSpace(txtNoOfLM.Text)
)
{
MessageBox.Show("You must be filling all field!.", "LM MAKING", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
objClassBLL = new LM_MakingClassBLL()
{
making_id = id,
date = DateTime.Today,
lm_type = cbxLmType.Text.ToString(),
supplier_name = txtSupplierName.Text,
no_of_lm = int.Parse(txtNoOfLM.Text),
username = _username,
division = _division
};
objClassBLL.Update();//UPDATE USER DATA
MessageBox.Show("LM making Update successfully!", "LM MAKING", MessageBoxButtons.OK, MessageBoxIcon.Information);
//CLEAR ALL TEXBOX AND COMBOBOX
ClearTextBoxces();
//LOAD USER DATA
LoadDataDgv();
//SET TO BUTTON TEXT Add
btnAdd.Text = "Add";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LM MAKING", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//SAVE DATA
private void DataSave()
{
try
{
if (//CHECK TEXBOXES NOT NULL OR EMPTY
String.IsNullOrWhiteSpace(txtSupplierName.Text) ||
String.IsNullOrWhiteSpace(cbxLmType.Text.ToString()) ||
String.IsNullOrWhiteSpace(txtNoOfLM.Text)
)
{
MessageBox.Show("You must be filling all field!.", "LM Making Added Successfully!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//PROPERTIES FOR DATA ADD
objClassBLL = new LM_MakingClassBLL()
{
//making_id = txtEmpRegNo.Text,
date = DateTime.Today,
lm_type = cbxLmType.Text.ToString(),
supplier_name = txtSupplierName.Text,
no_of_lm = int.Parse(txtNoOfLM.Text),
username = _username,
division = _division
};
//INSERT DATA TO DATABASE
objClassBLL.AddNew();
MessageBox.Show("Lm making added successfully!", "LM MAKING", MessageBoxButtons.OK, MessageBoxIcon.Information);
//CLEAR ALL TEXBOX AND COMBOBOX
ClearTextBoxces();
//LOAD USER DATA
LoadDataDgv();
//SET TO BUTTON TEXT Add
btnAdd.Text = "Add";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "LM MAKING", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//LOAD DATA
private void LoadDataDgv()
{
objClassBLL = new LM_MakingClassBLL();
dgvLmMaking.DataSource = objClassBLL.Load();
}
