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