private void Fill_Combo()
{
database1 clsdatabase1 = new database1();
INItem_OB clsINItem_OB = new INItem_OB();
DataSet ds = new DataSet();
ds = clsINItem_OB.Fill_Combo(mSys_System.pComp_ID, mSys_System.pUser_ID);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
Set_Combo(lookBranch_ID, ds.Tables[0], "Branch_SName", "Branch_ID", true);
Set_Combo(lookDept_ID_Store, ds.Tables[1], "Dept_DD", "Dept_ID", true);
Set_Combo(lookGrade_ID, ds.Tables[2], "Grade_ID", "Grade_ID", false);
}
private void Fill_Items()
{
database1 clsdatabase1 = new database1();
INItem_OB clsINItem_OB = new INItem_OB();
DataSet ds = new DataSet();
ds = clsINItem_OB.Fill_Items(mSys_System.pComp_ID, mSys_System.pUser_ID, lookGrade_ID.Text);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsdatabase1.sErrorCode + "'", false);
return;
}
DataTable dt = ds.Tables[0];
DataRow row = dt.NewRow();
row["Item_DD"] = string.Empty;
row["Item_ID"] = 0;
dt.Rows.InsertAt(row, 0);
repositoryItemLookUpEdit1.DataSource = dt;
repositoryItemLookUpEdit1.ValueMember = "Item_ID";
repositoryItemLookUpEdit1.DisplayMember = "Item_DD";
gridView1.Columns["Item_DD"].ColumnEdit = repositoryItemLookUpEdit1;
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
INItem_OB clsINItem_OB = new INItem_OB();
object vItem_ID = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Item_ID").ToString();
//strAuth_D = mSys_IN.pcU_M_01_C03_D;
int Ret_Value = clsINItem_OB.Save_Delete(Convert.ToInt32(vItem_ID), lookGrade_ID.Text, mSys_System.pComp_ID, mSys_System.pBranch_ID, Convert.ToInt32(lookDept_ID_Store.EditValue), mSys_System.pUser_ID, 3, strAuth_D);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message("MsgDBError : " + " '" + clsINItem_OB.sErrorCode + "'", false);
return;
}
if (Ret_Value == 1)
{
clsHomeScreen.Display_Message("RECORDS DELETED SUCCESSFULLY....................", false);
Fill_Grid();
}
if (Ret_Value == -4)
{
clsHomeScreen.Display_Message("Please select a valid record to delete....................", false);
Fill_Grid();
}
}
private bool Save_Update()
{
INItem_OB clsINItem_OB = new INItem_OB();
int Ret_Value = 0;
//strAuth_D = mSys_IN.pcU_M_01_C03_S;
//---alert
//if (MessageBox.Show(Msg_BeforeSave, string.Empty, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
//{
// return false;
//}
int Branch_ID = 0;
int Dept_ID = 0;
if (lookBranch_ID.EditValue != null && lookBranch_ID.EditValue.ToString() != "")
{
Branch_ID = Convert.ToInt32(lookBranch_ID.EditValue.ToString());
}
if (lookDept_ID_Store.EditValue != null && lookDept_ID_Store.EditValue.ToString() != "")
{
Dept_ID = Convert.ToInt32(lookDept_ID_Store.EditValue.ToString());
}
DataTable dt = gridControl1.DataSource as DataTable;
foreach (DataRow dRow in dt.Rows)
{
object vItem_ID = dRow["Item_ID"];
if (vItem_ID == null && vItem_ID.ToString() != "")
{
dt.Rows.Remove(dRow);
}
}
List <DataRow> Grid_Data = new List <DataRow>(dt.Select());
Ret_Value = clsINItem_OB.Save_Master(Branch_ID, Dept_ID, Grid_Data, mSys_System.pFYSDate, lookGrade_ID.Text,
mSys_System.pComp_ID, mSys_System.pUserName, mSys_System.pUser_ID, strAuth_D
);
if (clsINItem_OB.sErrorCode != "")
{
clsHomeScreen.Display_Message(clsINItem_OB.sErrorCode + "......", false);
return(false);
}
if (Ret_Value == -1)
{
clsHomeScreen.Display_Message(clsINItem_OB.strErr_Msg + "....................", false);
return(false);
}
if (Ret_Value == 0)
{
clsHomeScreen.Display_Message("ERROR SAVING/UPDATING RECORDS....................", false);
return(false);
}
if (Ret_Value == 1)
{
clsHomeScreen.Display_Message("RECORDS SAVED/UPDATED SUCCESSFULLY....................", false);
Fill_Grid();
}
return(true);
}
