private void frm_Edit_Finish_Product_Load(object sender, EventArgs e)
{
ProjectTools.LoadCbo(cbo_Created_By, DataAccessLayer.GetDataTable("Employee", ""), "Name", "Emp_ID");
string cmd2 =
"select [Sto_ID],[Store].[Name]as st_Name FROM dbo.Store INNER JOIN dbo.Store_Category ON dbo.Store.Sto_Cat_ID = dbo.Store_Category.Sto_Cat_ID where[Store].Sto_Cat_ID=[Store_Category].Sto_Cat_ID and [Store_Category].Name='Finish'";
ProjectTools.LoadCbo(cbo_Stock_Name, DataAccessLayer.GetDataTableComplex(cmd2, ""), "st_Name", "Sto_ID");
ProjectTools.LoadCbo(cbo_Itm_Cat, DataAccessLayer.GetDataTable("Item_Category", ""), "Name", "Itm_Cat_ID");
txt_Add_No.Text = DataAccessLayer.NewRowID("Add_Finish_Process", "Add_Finish_ID");
// EnableHeadDetails(true, false);
FormLoadFlag = true;
try
{
DataRow row_Edit = DataAccessLayer.GetRowByID("Add_Finish_Process", "Add_Finish_ID", IID.ToString());
txt_Add_No.Text = IID.ToString();
cbo_Created_By.SelectedValue = row_Edit[1];
txt_Notes.Text = row_Edit[3].ToString();
cbo_Stock_Name.SelectedValue = row_Edit[4].ToString();
dgv_Itm_Returned.Rows.Clear();
FillTheFormDetails(DataAccessLayer.GetRowsByID("ViewFinishOrder", "Add_Finish_ID", IID.ToString()));
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
throw;
}
}
private void cbo_Itm_Cat_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (FormLoadFlag)
{
ProjectTools.LoadCbo(cbo_Itm_Name, DataAccessLayer.GetDataTable("Item_Subcategory", " where Itm_Cat_ID = " + (cbo_Itm_Cat.SelectedValue).ToString()), "Name", "Itm_Sub_ID");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
private void Frm_SampleForm_Load(object sender, EventArgs e)
{
try
{
ProjectTools.LoadCbo(cbo_Created_By, DataAccessLayer.GetDataTable("Employee", ""), "Name", "Emp_ID");
string cmd2 = "select [Sto_ID],[Store].[Name]as st_Name FROM dbo.Store INNER JOIN dbo.Store_Category ON dbo.Store.Sto_Cat_ID = dbo.Store_Category.Sto_Cat_ID where[Store].Sto_Cat_ID=[Store_Category].Sto_Cat_ID and [Store_Category].Name='Finish'";
ProjectTools.LoadCbo(cbo_Stock_Name, DataAccessLayer.GetDataTableComplex(cmd2, ""), "st_Name", "Sto_ID");
ProjectTools.LoadCbo(cbo_Itm_Cat, DataAccessLayer.GetDataTable("Item_Category", ""), "Name", "Itm_Cat_ID");
txt_Add_No.Text = DataAccessLayer.NewRowID("Add_Finish_Process", "Add_Finish_ID");
EnableHeadDetails(true, false);
FormLoadFlag = true;
//if (edit_or_add == "add")
//{
//}
//else if (edit_or_add == "edit")
//{
// DataRow row_Edit = DataAccessLayer.GetRowByID("Add_Finish_Process", "Add_Finish_ID", IID.ToString());
// txt_Add_No.Text = IID.ToString();
// txt_Notes.Text = row_Edit[3].ToString();
// cbo_Created_By.SelectedValue = row_Edit[1];
// dgv_Itm_Returned_Edit.Rows.Clear();
// dgv_Itm_Returned_Edit.DataSource = DataAccessLayer.GetDataTable("ViewFinishOrder", " where Add_Finish_ID =" + IID.ToString());
//}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
//Display 4
}
private void Finish_Product_Load(object sender, EventArgs e)
{
try
{
ProjectTools.LoadCbo(cbo_Created_By, DataAccessLayer.GetDataTable("Employee", ""), "Name", "Emp_ID");
string cmd = "select [Sto_ID],[Store].[Name]as st_Name FROM dbo.Store INNER JOIN dbo.Store_Category ON dbo.Store.Sto_Cat_ID = dbo.Store_Category.Sto_Cat_ID where[Store].Sto_Cat_ID=[Store_Category].Sto_Cat_ID and [Store_Category].Name='Finish'";
ProjectTools.LoadCbo(cbo_Stock_Name, DataAccessLayer.GetDataTableComplex(cmd, ""), "st_Name", "Sto_ID");
ProjectTools.LoadCbo(cbo_Itm_Cat, DataAccessLayer.GetDataTable("Item_Category", ""), "Name", "Itm_Cat_ID");
FormLoadFlag = true;
// txt_Add_No.Text = DataAccessLayer.NewRowID("Add_Finish_Process", "Add_Finish_ID");
//EnableHeadDetails(true, false);
FormLoadFlag = true;
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
throw;
}
}