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