/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CDecree</returns>
internal List <CDecree> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CDecree> list = new List <CDecree>();
while (dataReader.Read())
{
CDecree businessObject = new CDecree();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// insert new row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true of successfully insert</returns>
public bool Insert(CDecree businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_decree_Insert";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_iddecree", businessObject.Iddecree);
sqlCommand.Parameters["p_iddecree"].NpgsqlDbType = NpgsqlDbType.Integer;
sqlCommand.Parameters["p_iddecree"].Direction = ParameterDirection.InputOutput;
sqlCommand.Parameters.AddWithValue("p_cod_decree", businessObject.Cod_decree);
sqlCommand.Parameters["p_cod_decree"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_name_decree", businessObject.Name_decree);
sqlCommand.Parameters["p_name_decree"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_description", businessObject.Description);
sqlCommand.Parameters["p_description"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_cumple", businessObject.Cumple);
sqlCommand.Parameters["p_cumple"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_nocumple", businessObject.Nocumple);
sqlCommand.Parameters["p_nocumple"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_cumple_onlytest", businessObject.Cumple_onlytest);
sqlCommand.Parameters["p_cumple_onlytest"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_status", businessObject.Status);
sqlCommand.Parameters["p_status"].NpgsqlDbType = NpgsqlDbType.Boolean;
sqlCommand.Parameters.AddWithValue("p_conclusion", businessObject.Conclusion);
sqlCommand.Parameters["p_conclusion"].NpgsqlDbType = NpgsqlDbType.Varchar;
MainConnection.Open();
sqlCommand.ExecuteNonQuery();
businessObject.Iddecree = Convert.ToInt32(sqlCommand.Parameters["p_iddecree"].Value);
return(true);
}
catch (Exception ex)
{
throw new Exception("CDecree::Insert::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
protected override bool Grabar_Registro()
{
oDecree = oDecree == null ? new CDecree() : oDecree;
oDecree.Name_decree = tbName.Text;
oDecree.Description = meDescription.Text;
oDecree.Cumple = tbCumple.Text;
oDecree.Nocumple = tbNoCumple.Text;
oDecree.Cumple_onlytest = tbCumpleOnlytest.Text;
oDecree.Conclusion = meConclusion.Text;
oDecree.Status = true;
if (new CDecreeFactory().Update(oDecree))
{
//eliminar todo
foreach (CDecree_detail item in new CDecree_detailFactory().GetAll().Where(x => x.Status == true))
{
item.Status = false;
new CDecree_detailFactory().Update(item);
}
//guardar items
foreach (CDecree_detail item in gcDecree.DataSource as BindingList <CDecree_detail> )
{
item.Iddecree = oDecree.Iddecree;
item.Status = true;
if (!new CDecree_detailFactory().Update(item))
{
new CDecree_detailFactory().Insert(item);
}
}
}
else
{
if (new CDecreeFactory().Insert(oDecree))
{
oDecree.Cod_decree = new ModCorrelatives().GetCorrelative(Comun.Correlative.Decree);
new CDecreeFactory().Update(oDecree);
//guardar items
foreach (CDecree_detail item in gcDecree.DataSource as BindingList <CDecree_detail> )
{
item.Status = true;
item.Iddecree = oDecree.Iddecree;
new CDecree_detailFactory().Insert(item);
}
}
}
return(true);
}
protected override bool Grabar_Registro()
{
oDecree = oDecree == null ? new CDecree() : oDecree;
oDecree.Name_decree = tbName.Text;
oDecree.Description = meDescription.Text;
oDecree.Cumple = tbCumple.Text;
oDecree.Nocumple = tbNoCumple.Text;
oDecree.Cumple_onlytest = tbCumpleOnlytest.Text;
oDecree.Conclusion = meConclusion.Text;
oDecree.Status = true;
if (new CDecreeFactory().Update(oDecree))
{
//eliminar todo
foreach (CDecree_detail item in new CDecree_detailFactory().GetAll().Where(x => x.Status == true))
{
item.Status = false;
new CDecree_detailFactory().Update(item);
}
//guardar items
foreach (CDecree_detail item in gcDecree.DataSource as BindingList<CDecree_detail>)
{
item.Iddecree = oDecree.Iddecree;
item.Status = true;
if (!new CDecree_detailFactory().Update(item))
new CDecree_detailFactory().Insert(item);
}
}
else
{
if (new CDecreeFactory().Insert(oDecree))
{
oDecree.Cod_decree = new ModCorrelatives().GetCorrelative(Comun.Correlative.Decree);
new CDecreeFactory().Update(oDecree);
//guardar items
foreach (CDecree_detail item in gcDecree.DataSource as BindingList<CDecree_detail>)
{
item.Status = true;
item.Iddecree = oDecree.Iddecree;
new CDecree_detailFactory().Insert(item);
}
}
}
return true;
}
/// <summary>
/// Populate business object from data reader
/// </summary>
/// <param name="businessObject">business object</param>
/// <param name="dataReader">data reader</param>
internal void PopulateBusinessObjectFromReader(CDecree businessObject, IDataReader dataReader)
{
businessObject.Iddecree = dataReader.GetInt32(dataReader.GetOrdinal(CDecree.CDecreeFields.Iddecree.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Cod_decree.ToString())))
{
businessObject.Cod_decree = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Cod_decree.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Name_decree.ToString())))
{
businessObject.Name_decree = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Name_decree.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Description.ToString())))
{
businessObject.Description = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Description.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Cumple.ToString())))
{
businessObject.Cumple = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Cumple.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Nocumple.ToString())))
{
businessObject.Nocumple = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Nocumple.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Cumple_onlytest.ToString())))
{
businessObject.Cumple_onlytest = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Cumple_onlytest.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CDecree.CDecreeFields.Status.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CDecree.CDecreeFields.Conclusion.ToString())))
{
businessObject.Conclusion = dataReader.GetString(dataReader.GetOrdinal(CDecree.CDecreeFields.Conclusion.ToString()));
}
}
private void ucToolStrip1_onFind()
{
FormMasterSearch fmBusqueda = new FormMasterSearch();
fmBusqueda.BindGrid(new ModMasterSearch().GetDecrees());
fmBusqueda.ShowDialog();
Dictionary <string, string> keys = fmBusqueda.getKeyValues();
if (keys != null)
{
Limpiar_Campos();
oDecree = new CDecreeFactory().GetAll().Where(x => x.Iddecree == Convert.ToInt32(keys["Iddecree"])).FirstOrDefault();
Recuperar_Registro();
}
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CDecree business object</returns>
public CDecree SelectByPrimaryKey(CDecreeKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_decree_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_iddecree", NpgsqlDbType.Integer, 4, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Iddecree));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CDecree businessObject = new CDecree();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CDecree::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
public FormDecree(CDecree pDecree, LoadData ploadData)
{
InitializeComponent();
Init();
loadData = ploadData;
if (loadData == LoadData.FromDecree_ToDecree)
{
oDecree = new CDecreeFactory().GetAll().Where(x => x.Iddecree == pDecree.Iddecree).FirstOrDefault();
if (oDecree != null)
{
Recuperar_Registro();
tbCode.Text = "";
oDecree.Iddecree = 0;
}
}
}
public FormDecree(CDecree pDecree, LoadData ploadData)
{
InitializeComponent();
Init();
loadData = ploadData;
if (loadData == LoadData.FromDecree_ToDecree)
{
oDecree = new CDecreeFactory().GetAll().Where(x => x.Iddecree == pDecree.Iddecree).FirstOrDefault();
if (oDecree != null)
{
Recuperar_Registro();
tbCode.Text = "";
oDecree.Iddecree = 0;
}
}
}
private void ucToolStrip1_onFind()
{
FormMasterSearch fmBusqueda = new FormMasterSearch();
fmBusqueda.BindGrid(new ModMasterSearch().GetDecrees());
fmBusqueda.ShowDialog();
Dictionary<string, string> keys = fmBusqueda.getKeyValues();
if (keys != null)
{
Limpiar_Campos();
oDecree = new CDecreeFactory().GetAll().Where(x => x.Iddecree == Convert.ToInt32(keys["Iddecree"])).FirstOrDefault();
Recuperar_Registro();
}
}
