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); }