private void GetProgramByID(string procID) { M_Program program = null; try { using (AdministratorBLL adminBll = new AdministratorBLL()) { program = adminBll.GetProgramByID(procID); } if (program != null) { this.txtPROG_ID.EditValue = program.PROG_ID; this.txtPROG_NAME.EditValue = program.PROG_NAME; this.txtPROG_KEY.EditValue = program.PROG_KEY; this.luePROG_TYPE.EditValue = program.PROG_TYPE; this.txtORDER_BY.EditValue = program.ORDER_BY; this.txtICON.EditValue = program.ICON; this.txtDESCRIPTION.EditValue = program.DESCRIPTION; this.icbREC_STAT.EditValue = program.REC_STAT; } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public List <M_Program> GetProgramList(string procType, string procID) { List <M_Program> lstProgram = null; M_Program mProgram; try { ProcParam param = new ProcParam(3); param.ProcedureName = "ADMINISTRATOR_PACK.GET_PROGRAM_LIST"; param.AddParamRefCursor(0, "io_cursor"); param.AddParamInput(1, "strPROG_TYPE", procType); param.AddParamInput(2, "strPROG_ID", procID); OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param); //////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; if (OraDataReader.Instance.HasRows) { lstProgram = new List <M_Program>(); OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000; while (OraDataReader.Instance.OraReader.Read()) { mProgram = new M_Program(); mProgram.PROG_ID = OraDataReader.Instance.GetString("PROG_ID"); mProgram.PROG_NAME = OraDataReader.Instance.GetString("PROG_NAME"); mProgram.PROG_TYPE = OraDataReader.Instance.GetString("PROG_TYPE"); if (!OraDataReader.Instance.IsDBNull("ORDER_BY")) { mProgram.ORDER_BY = OraDataReader.Instance.GetInteger("ORDER_BY"); } mProgram.ICON = OraDataReader.Instance.GetString("ICON"); mProgram.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y"); mProgram.DESCRIPTION = OraDataReader.Instance.GetString("DESCRIPTION"); mProgram.PROG_KEY = OraDataReader.Instance.GetString("PROG_KEY"); lstProgram.Add(mProgram); } } // always call Close when done reading. OraDataReader.Instance.Close(); } catch (Exception ex) { lstProgram = null; } return(lstProgram); }
public M_Program GetProgramByID(int progId) { M_Program mProgram = null; try { SQLiteParam param = new SQLiteParam(1) { CommandText = StoreProcedure.Instance.GetScript("GetProgramById") }; param.ParamInt32(0, "@PROG_ID", progId); SQLiteReader.Instance.SLReader = GlobalSqliteDB.Instance.DataAc.ExecuteDataReader(param); if (SQLiteReader.Instance.HasRows) { while (SQLiteReader.Instance.SLReader.Read()) { mProgram = new M_Program(); mProgram.PROG_ID = SQLiteReader.Instance.GetInteger("PROG_ID"); mProgram.PROG_NAME = SQLiteReader.Instance.GetString("PROG_NAME"); mProgram.PROG_KEY = SQLiteReader.Instance.GetString("PROG_KEY"); mProgram.PROG_GROUP.PROG_TYPE_ID = SQLiteReader.Instance.GetInteger("PROG_TYPE_ID"); mProgram.PROG_GROUP.PROG_TYPE_NAME = SQLiteReader.Instance.GetString("PROG_TYPE_NAME"); mProgram.PROG_TYPE_ICON = SQLiteReader.Instance.GetString("PROG_TYPE_ICON"); if (!SQLiteReader.Instance.IsDBNull("ORDER_BY")) { mProgram.ORDER_BY = SQLiteReader.Instance.GetInteger("ORDER_BY"); } mProgram.ICON = SQLiteReader.Instance.GetString("ICON"); mProgram.DESCRIPTION = SQLiteReader.Instance.GetString("DESCRIPTION"); mProgram.PROG_RESOURCE = SQLiteReader.Instance.GetString("PROG_RESOURCE"); mProgram.IS_ACTIVE = (SQLiteReader.Instance.GetString("IS_ACTIVE").ToUpper() == "Y"); } } //Always call Close when done reading. SQLiteReader.Instance.Close(); } catch (Exception ex) { mProgram = null; } return(mProgram); }
public string InsertProgram(ref M_Program proc) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(8) { CommandText = StoreProcedure.Instance.GetScript("ProgramInsert") }; param.ParamStringFixedLength(0, "@PROG_NAME", proc.PROG_NAME); param.ParamStringFixedLength(1, "@PROG_KEY", proc.PROG_KEY); param.ParamInt32(2, "@PROG_TYPE_ID", proc.PROG_GROUP.PROG_TYPE_ID); if (proc.ORDER_BY.HasValue) { param.ParamInt32(3, "@ORDER_BY", proc.ORDER_BY.Value); } else { param.ParamNull(3, "@ORDER_BY"); } param.ParamStringFixedLength(4, "@ICON", proc.ICON); param.ParamStringFixedLength(5, "@DESCRIPTION", proc.DESCRIPTION); param.ParamStringFixedLength(6, "@PROG_RESOURCE", proc.PROG_RESOURCE); param.ParamStringFixedLength(7, "@IS_ACTIVE", (proc.IS_ACTIVE ? "Y" : "N")); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); object resultid = GlobalSqliteDB.Instance.DataAc.ExecuteScalar(@"SELECT SEQ FROM sqlite_sequence WHERE NAME = 'M_PROGRAM'"); if (resultid != null) { proc.PROG_ID = Convert.ToInt32(resultid); } result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
public string UpdateProgram(M_Program proc, string userid) { string result = string.Empty; try { ProcParam param = new ProcParam(10); param.ProcedureName = "ADMINISTRATOR_PACK.PROGRAM_UPD"; param.AddParamInput(0, "strPROG_ID", proc.PROG_ID); param.AddParamInput(1, "strPROG_NAME", proc.PROG_NAME); param.AddParamInput(2, "strPROG_TYPE", proc.PROG_TYPE); param.AddParamInput(3, "strORDER_BY", proc.ORDER_BY); param.AddParamInput(4, "strICON", proc.ICON); param.AddParamInput(5, "strREC_STAT", (proc.REC_STAT ? "Y" : "N")); param.AddParamInput(6, "strDESCRIPTION", proc.DESCRIPTION); param.AddParamInput(7, "strPROG_KEY", proc.PROG_KEY); param.AddParamInput(8, "strUSER_ID", userid); param.AddParamOutput(9, "RESULTMSG", OracleDbType.NVarchar2, 255, "OK"); GlobalDB.Instance.DataAc.ExecuteNonQuery(param); ////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime; OracleString resultDB = (OracleString)param.ReturnValue(9); if (!resultDB.IsNull) { result = resultDB.Value; } else { throw GlobalDB.Instance.DataAc.LastException; } } catch (Exception ex) { throw ex; } return(result); }
public string UpdateProgram(M_Program proc) { string result = string.Empty; try { SQLiteParam param = new SQLiteParam(9) { CommandText = StoreProcedure.Instance.GetScript("ProgramUpdate") }; param.ParamStringFixedLength(0, "@PROG_NAME", proc.PROG_NAME); param.ParamStringFixedLength(1, "@PROG_KEY", proc.PROG_KEY); param.ParamInt32(2, "@PROG_TYPE_ID", proc.PROG_GROUP.PROG_TYPE_ID); if (proc.ORDER_BY.HasValue) { param.ParamInt32(3, "@ORDER_BY", proc.ORDER_BY.Value); } else { param.ParamNull(3, "@ORDER_BY"); } param.ParamStringFixedLength(4, "@ICON", proc.ICON); param.ParamStringFixedLength(5, "@DESCRIPTION", proc.DESCRIPTION); param.ParamStringFixedLength(6, "@PROG_RESOURCE", proc.PROG_RESOURCE); param.ParamStringFixedLength(7, "@IS_ACTIVE", (proc.IS_ACTIVE ? "Y" : "N")); param.ParamInt32(8, "@PROG_ID", proc.PROG_ID); int rowAfect = GlobalSqliteDB.Instance.DataAc.ExecuteNonQuery(param); result = "OK"; } catch (Exception ex) { throw ex; } return(result); }
private void UpdateProgram() { string result = string.Empty; try { M_Program program = new M_Program(); program.PROG_ID = (string)this.txtPROG_ID.EditValue; program.PROG_NAME = (string)UiUtility.IsNullValue(this.txtPROG_NAME.EditValue, ""); program.PROG_KEY = (string)UiUtility.IsNullValue(this.txtPROG_KEY.EditValue, ""); program.PROG_TYPE = (string)this.luePROG_TYPE.EditValue; if (this.txtORDER_BY.EditValue != null) { program.ORDER_BY = (int)this.txtORDER_BY.EditValue; } program.ICON = (string)UiUtility.IsNullValue(this.txtICON.EditValue, ""); program.DESCRIPTION = (string)UiUtility.IsNullValue(this.txtDESCRIPTION.EditValue, ""); program.REC_STAT = (bool)this.icbREC_STAT.EditValue; using (AdministratorBLL adminBll = new AdministratorBLL()) { result = adminBll.UpdateProgram(program, ((frmMainMenu)this.ParentForm).UserID); } if (result.Equals("OK")) { GridView view = (GridView)this.grdProgramList.Views[0]; view.BeginDataUpdate(); view.SetFocusedRowCellValue("PROG_ID", program.PROG_ID); view.SetFocusedRowCellValue("PROG_NAME", program.PROG_NAME); view.SetFocusedRowCellValue("PROG_TYPE", program.PROG_TYPE); view.SetFocusedRowCellValue("ORDER_BY", program.ORDER_BY); view.SetFocusedRowCellValue("REC_STAT", program.REC_STAT); view.EndDataUpdate(); NotifierResult.Show("Update Complete", "Result", 50, 1000, 50, NotifyType.Safe); } else { NotifierResult.Show(result, "Error", 100, 1000, 0, NotifyType.Warning); } } catch (Exception ex) { NotifierResult.Show(ex.Message, "Error", 50, 1000, 0, NotifyType.Warning); } finally { this.FormState = eFormState.ReadOnly; //Get all Invoice on Invoice List this.lueProgramType.EditValue = this.luePROG_TYPE.EditValue; this.GetProgramList(this.lueProgramType.EditValue.ToString(), string.Empty); if (result.Equals("OK")) { GridView viewList = (GridView)this.grdProgramList.Views[0]; viewList.ClearSorting(); int position = UiUtility.GetRowHandleByColumnValue(viewList, "PROG_ID", this.txtPROG_ID.Text); if (position != 0) { if (position != GridControl.InvalidRowHandle) { this.dntProgram.Position = position; } } else { viewList.FocusedRowHandle = 0; } //Reload Menu ((frmMainMenu)this.ParentForm).ReloadMenu(); } } }
public List <M_Program> GetProgramList(int?progId) { List <M_Program> lstProgram = null; M_Program mProgram; try { SQLiteParam param = new SQLiteParam(1) { CommandText = StoreProcedure.Instance.GetScript("GetProgramList") }; if (progId.HasValue) { param.ParamInt32(0, "@PROG_TYPE_ID", progId.Value); } else { param.ParamNull(0, "@PROG_TYPE_ID"); } SQLiteReader.Instance.SLReader = GlobalSqliteDB.Instance.DataAc.ExecuteDataReader(param); if (SQLiteReader.Instance.HasRows) { lstProgram = new List <M_Program>(); while (SQLiteReader.Instance.SLReader.Read()) { mProgram = new M_Program(); mProgram.PROG_ID = SQLiteReader.Instance.GetInteger("PROG_ID"); mProgram.PROG_NAME = SQLiteReader.Instance.GetString("PROG_NAME"); mProgram.PROG_KEY = SQLiteReader.Instance.GetString("PROG_KEY"); mProgram.PROG_GROUP.PROG_TYPE_ID = SQLiteReader.Instance.GetInteger("PROG_TYPE_ID"); mProgram.PROG_GROUP.PROG_TYPE_NAME = SQLiteReader.Instance.GetString("PROG_TYPE_NAME"); mProgram.PROG_TYPE_ICON = SQLiteReader.Instance.GetString("PROG_TYPE_ICON"); if (!SQLiteReader.Instance.IsDBNull("ORDER_BY")) { mProgram.ORDER_BY = SQLiteReader.Instance.GetInteger("ORDER_BY"); } mProgram.ICON = SQLiteReader.Instance.GetString("ICON"); mProgram.IS_ACTIVE = (SQLiteReader.Instance.GetString("IS_ACTIVE").ToUpper() == "Y"); mProgram.DESCRIPTION = SQLiteReader.Instance.GetString("DESCRIPTION"); mProgram.PROG_RESOURCE = SQLiteReader.Instance.GetString("PROG_RESOURCE"); lstProgram.Add(mProgram); } } //Always call Close when done reading. SQLiteReader.Instance.Close(); } catch (Exception ex) { string re = ex.Message; lstProgram = null; } return(lstProgram); }