private void Fill_SCat()
{
database1 clsdatabase1 = new database1();
INSub_Category clsINSub_Category = new INSub_Category();
DataSet ds = new DataSet();
ds = clsINSub_Category.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
Set_Combo(lookSCat_ID, ds.Tables[0], "SCat_DD", "SCat_ID", true);
}
private void cmd1_Delete_Click(object sender, EventArgs e)
{
INSub_Category clsINSub_Category = new INSub_Category();
int Ret_Value = 0;
if (lblSCat_ID.Text.Trim() == "")
{
clsHomeScreen.Display_Message("Please select a record first to delete....................", false);
return;
}
//if (MessageBox.Show(Msg_BeforeDelete_1, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// return;
//}
//if (MessageBox.Show(Msg_BeforeDelete_2, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// return;
//}
//strAuth_D = mSys_IN.pcU_M_01_C01_D;
Ret_Value = clsINSub_Category.Save_Delete(lblSCat_ID.Text,
mSys_System.pComp_ID, mSys_System.pUserName, mSys_System.pUser_ID, strAuth_D);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsINSub_Category.sErrorCode + "......", false);
return;
}
if (Ret_Value == -1)
{
clsHomeScreen.Display_Message(clsINSub_Category.strErr_Msg + "....................", false);
return;
}
if (Ret_Value == 0)
{
clsHomeScreen.Display_Message("ERROR SAVING/UPDATING RECORDS....................", false);
return;
}
if (Ret_Value == 1)
{
clsHomeScreen.Display_Message("SAVED/UPDATED SUCCESSFULLY....................", false);
Set_Refresh_1();
Fill_Grid_1();
Fill_SCat();
return;
}
}
private void Fill_Grid_1()
{
database1 clsdatabase1 = new database1();
INSub_Category clsINSub_Category = new INSub_Category();
DataSet ds = new DataSet();
ds = clsINSub_Category.Fill_Grid(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsdatabase1.sErrorCode, false);
return;
}
DataTable dt = ds.Tables[0];
gridControl_SCat.DataSource = dt;
}
private void Find_Record_1(int ID)
{
database1 clsdatabase1 = new database1();
INSub_Category clsINSub_Category = new INSub_Category();
DataSet ds = new DataSet();
ds = clsINSub_Category.Find_Record(mSys_System.pComp_ID, ID);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsINSub_Category.sErrorCode, false);
return;
}
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
lblSCat_ID.Text = dt.Rows[i]["SCat_ID"].ToString();
txtSCat_D.Text = dt.Rows[i]["SCat_D"].ToString();
txtSCat_DD.Text = dt.Rows[i]["SCat_DD"].ToString();
lookSub_Cat_ID.EditValue = (dt.Rows[i]["Cat_ID"] == null || dt.Rows[i]["Cat_ID"].ToString() == "") ? null : dt.Rows[i]["Cat_ID"];
}
}
private bool Save_Update_1(int IsUpdate)
{
INSub_Category clsINSub_Category = new INSub_Category();
int Ret_Value = 0;
if (IsUpdate == 0)
{
//---alert
//strAuth_D = mSys_IN.pcU_M_01_C01_S;
//if (MessageBox.Show(Msg_BeforeSave, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// return false;
//}
}
else if (IsUpdate == 1) //---update
{
//strAuth_D = mSys_IN.pcU_M_01_C01_U;
////---alert
//if (MessageBox.Show(Msg_BeforeUpdate, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// return false;
//}
}
int Cat_ID = 0;
if (lookSub_Cat_ID.EditValue != null && lookSub_Cat_ID.EditValue.ToString() != "")
{
Cat_ID = Convert.ToInt32(lookSub_Cat_ID.EditValue);
}
Ret_Value = clsINSub_Category.Save_Master(lblSCat_ID.Text, txtSCat_D.Text.Trim(), txtSCat_DD.Text.Trim(), Cat_ID,
mSys_System.pComp_ID, mSys_System.pUserName, mSys_System.pUser_ID, IsUpdate, strAuth_D);
if (clsINSub_Category.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsINSub_Category.sErrorCode + "......", false);
return(false);
}
if (Ret_Value == -1)
{
clsHomeScreen.Display_Message(clsINSub_Category.strErr_Msg + "....................", false);
return(true);
}
if (Ret_Value == 0)
{
clsHomeScreen.Display_Message("ERROR SAVING/UPDATING RECORDS....................", false);
return(true);
}
if (Ret_Value == 1)
{
txtSCat_D.Text = clsINSub_Category.str_Code;
lblSCat_ID.Text = clsINSub_Category.str_ID.ToString();
clsHomeScreen.Display_Message("SAVED/UPDATED SUCCESSFULLY....................", false);
Set_Refresh_1();
Fill_SCat();
return(true);
}
return(true);
}
