/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CCells_program businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_cells_program_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_idcell_reported", businessObject.Idcell_reported);
sqlCommand.Parameters["p_idcell_reported"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters["p_idcell_reported"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_idrecep_sample_detail_elem", businessObject.Idrecep_sample_detail_elem);
sqlCommand.Parameters["p_idrecep_sample_detail_elem"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters.AddWithValue("p_idrecep_sample_program", businessObject.Idrecep_sample_program);
sqlCommand.Parameters["p_idrecep_sample_program"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters.AddWithValue("p_idtemplate_method", businessObject.Idtemplate_method);
sqlCommand.Parameters["p_idtemplate_method"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters.AddWithValue("p_idrecep_sample_detail", businessObject.Idrecep_sample_detail);
sqlCommand.Parameters["p_idrecep_sample_detail"].NpgsqlDbType = NpgsqlDbType.Bigint;
sqlCommand.Parameters.AddWithValue("p_flag_confirm_report", businessObject.Flag_confirm_report);
sqlCommand.Parameters["p_flag_confirm_report"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_usernew", businessObject.Usernew);
sqlCommand.Parameters["p_usernew"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_datenew", businessObject.Datenew);
sqlCommand.Parameters["p_datenew"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_useredit", businessObject.Useredit);
sqlCommand.Parameters["p_useredit"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_dateedit", businessObject.Dateedit);
sqlCommand.Parameters["p_dateedit"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status);
sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Idcell_reported = Convert.ToInt64(sqlCommand.Parameters["p_idcell_reported"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CCells_program::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CCells_program businessObject, IDataReader dataReader)
{
businessObject.Idcell_reported = dataReader.GetInt64(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idcell_reported.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_detail_elem.ToString())))
{
businessObject.Idrecep_sample_detail_elem = dataReader.GetInt64(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_detail_elem.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_program.ToString())))
{
businessObject.Idrecep_sample_program = dataReader.GetInt64(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_program.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idtemplate_method.ToString())))
{
businessObject.Idtemplate_method = dataReader.GetInt32(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idtemplate_method.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_detail.ToString())))
{
businessObject.Idrecep_sample_detail = dataReader.GetInt64(dataReader.GetOrdinal(CCells_program.CCells_programFields.Idrecep_sample_detail.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Flag_confirm_report.ToString())))
{
businessObject.Flag_confirm_report = dataReader.GetBoolean(dataReader.GetOrdinal(CCells_program.CCells_programFields.Flag_confirm_report.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Usernew.ToString())))
{
businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CCells_program.CCells_programFields.Usernew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Datenew.ToString())))
{
businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CCells_program.CCells_programFields.Datenew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Useredit.ToString())))
{
businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CCells_program.CCells_programFields.Useredit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Dateedit.ToString())))
{
businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CCells_program.CCells_programFields.Dateedit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CCells_program.CCells_programFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CCells_program.CCells_programFields.Status.ToString()));
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CCells_program</returns>
internal List <CCells_program> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CCells_program> list = new List <CCells_program>();
while (dataReader.Read())
{
CCells_program businessObject = new CCells_program();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CCells_program business object</returns>
public CCells_program SelectByPrimaryKey(CCells_programKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_cells_program_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_idcell_reported", NpgsqlDbType.Bigint, 8, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Idcell_reported));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CCells_program businessObject = new CCells_program();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CCells_program::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
private void repProgramButton_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
// --- save partial or final report
if (e.Button.Index == 0)
{
#region save program
bool result_insert_program = false;
CRecep_sample_program oRecep_sample_program = new CRecep_sample_program();
CRecep_sample_programFactory faRecep_sample_program = new CRecep_sample_programFactory();
Reception oReception = new Reception();
oRecep_sample_program = faRecep_sample_program.GetByPrimaryKey(
new CRecep_sample_programKeys(Convert.ToInt64(gvProgram.GetFocusedRowCellValue(gcRep_idrecep_sample_report))));
short report_status = Convert.ToInt16(gvReport.GetFocusedRowCellValue(gcRep_report_status));
// si es un reporte en creación poner como reservado
if (report_status == Convert.ToInt16(Comun.ReportStatus.EnCreacion)) // --- creacion
{
oRecep_sample_program = new CRecep_sample_program();
gvReport.SetFocusedRowCellValue(gcProg_Program_status, Convert.ToInt16(Comun.ReportStatus.Reportado));
oRecep_sample_program.Idrecep_sample = oRecep_sample.Idrecep_sample;
oRecep_sample_program.Idrecep_sample_program = Convert.ToInt64(gvProgram.GetFocusedRowCellValue(gcProg_Idrecep_sample_program));
oRecep_sample_program.Order_report = Convert.ToInt16(gvProgram.GetFocusedRowCellValue(gcProg_Order_report));
oRecep_sample_program.Program_status = Convert.ToInt16(Comun.ReportStatus.Reportado);
oRecep_sample_program.Cod_recep_sample_program = oReception.GetNewCodProgram();
oRecep_sample_program.Date_report = Convert.ToDateTime(gvProgram.GetFocusedRowCellValue(gcProg_Date_report));
oRecep_sample_program.Time_report = Convert.ToDateTime(gvProgram.GetFocusedRowCellValue(gcProg_Time_report));
result_insert_program = faRecep_sample_program.Insert(oRecep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Program_status, oRecep_sample_program.Program_status);
gvProgram.SetFocusedRowCellValue(gcProg_Idrecep_sample_program, oRecep_sample_program.Idrecep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Cod_recep_sample_program, oRecep_sample_program.Cod_recep_sample_program);
gvProgram.SetFocusedRowCellValue(gcProg_Str_cod_recep_sample_program, oReception.GetFormatProgramCode(oRecep_sample_program.Cod_recep_sample_program));
if (result_insert_program)
{
// --- create the partial report
List<CPositionValueProgram> lstPositionValueProgram = new List<CPositionValueProgram>();
foreach (GridCell[] cells in lstItemsSelProgram)
{
foreach (GridCell cell in cells)
{
CTagInfoMethod tagMethod = (CTagInfoMethod)cell.Column.Tag;
int idtemplate_method = tagMethod.IDTemplate_method;
long idrecep_sample_detail = Convert.ToInt64(gvReception.GetRowCellValue(cell.RowHandle, gcRec_idrecep_sample_detail));
long idrecep_sample_program = oRecep_sample_program.Idrecep_sample_program;
CPositionValueProgram position = GetObjectPositionProgram(idrecep_sample_detail, tagMethod.IDTemplate_method);
CCells_programFactory faCells_reported = new CCells_programFactory();
CCells_program oCell_program = new CCells_program();
oCell_program.Idtemplate_method = idtemplate_method;
oCell_program.Idrecep_sample_detail = idrecep_sample_detail;
oCell_program.Idrecep_sample_program = idrecep_sample_program;
oCell_program.Idrecep_sample_detail_elem = position.idrecep_sample_detail_elem;
bool result_cell_reported = false;
if (!(result_cell_reported = faCells_reported.Update(oCell_program)))
result_cell_reported = faCells_reported.Insert(oCell_program);
if (result_cell_reported)
{
position.idrecep_sample_program = idrecep_sample_program;
position.row = cell.RowHandle;
position.col = cell.Column;
position.idcell_program = oCell_program.Idcell_reported;
position.color = Comun.ColorRojo;
if (!lstPositionValueProgram.Exists(c => c.idrecep_sample_detail_elem == position.idrecep_sample_detail_elem))
lstPositionValueProgram.Add(position);
}
}
}
lstItemsSelProgram.Clear();
DicCellsSaveProgram.Add(Convert.ToInt32(oRecep_sample_program.Order_report), lstPositionValueProgram);
}
}
#endregion
lstItemsSelProgram.Clear();
gvReception.Focus();
}
}
