protected override bool Grabar_Registro()
{
CSerieFactory faSerie = new CSerieFactory();
List <CSerie> lstCorr_modules = faSerie.GetAll();
foreach (CSerie item in lstCorr_modules)
{
item.Status_serie = false;
faSerie.Update(item);
}
CSerie oSerie = new CSerie();
oSerie.Cod_serie = tbCodSerie.Text;
oSerie.Nom_serie = cbNomSerie.Text;
oSerie.Dateinit = deDateIni.DateTime;
oSerie.Dateend = deDateEnd.DateTime;
oSerie.Status_serie = true;
bool result = false;
if (!(result = faSerie.Update(oSerie)))
{
result = faSerie.Insert(oSerie);
}
return(result);
}
public void EliminarSerie(string CodProducto, string Serie)
{
CSerie S = new CSerie();
if (S.ExisteClavePrimaria(CodProducto))
{
S.Eliminar(CodProducto, Serie);
}
}
public void CargarSeries(string CodProducto)
{
CSerie S = new CSerie();
CboSeries.DataSource = S.ListarPorCodigo(CodProducto);
CboSeries.DisplayMember = "Serie";
CboSeries.ValueMember = "CodProducto";
CboSeries.SelectedIndex = -1;
}
/// <summary>
/// update row in the table
/// </summary>
/// <param name="businessObject">business object</param>
/// <returns>true for successfully updated</returns>
public bool Update(CSerie businessObject)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_serie_Update";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.AddWithValue("p_cod_serie", businessObject.Cod_serie);
sqlCommand.Parameters["p_cod_serie"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_nom_serie", businessObject.Nom_serie);
sqlCommand.Parameters["p_nom_serie"].NpgsqlDbType = NpgsqlDbType.Varchar;
sqlCommand.Parameters.AddWithValue("p_num_digits", businessObject.Num_digits);
sqlCommand.Parameters["p_num_digits"].NpgsqlDbType = NpgsqlDbType.Smallint;
sqlCommand.Parameters.AddWithValue("p_dateinit", businessObject.Dateinit);
sqlCommand.Parameters["p_dateinit"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_dateend", businessObject.Dateend);
sqlCommand.Parameters["p_dateend"].NpgsqlDbType = NpgsqlDbType.Date;
sqlCommand.Parameters.AddWithValue("p_status_serie", businessObject.Status_serie);
sqlCommand.Parameters["p_status_serie"].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();
if (Convert.ToInt32(sqlCommand.ExecuteScalar()) > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
throw new Exception("CSerie::Update::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(CSerie businessObject, IDataReader dataReader)
{
businessObject.Cod_serie = dataReader.GetString(dataReader.GetOrdinal(CSerie.CSerieFields.Cod_serie.ToString()));
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Nom_serie.ToString())))
{
businessObject.Nom_serie = dataReader.GetString(dataReader.GetOrdinal(CSerie.CSerieFields.Nom_serie.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Num_digits.ToString())))
{
businessObject.Num_digits = (short?)dataReader.GetInt16(dataReader.GetOrdinal(CSerie.CSerieFields.Num_digits.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Dateinit.ToString())))
{
businessObject.Dateinit = dataReader.GetDateTime(dataReader.GetOrdinal(CSerie.CSerieFields.Dateinit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Dateend.ToString())))
{
businessObject.Dateend = dataReader.GetDateTime(dataReader.GetOrdinal(CSerie.CSerieFields.Dateend.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Status_serie.ToString())))
{
businessObject.Status_serie = dataReader.GetBoolean(dataReader.GetOrdinal(CSerie.CSerieFields.Status_serie.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Usernew.ToString())))
{
businessObject.Usernew = dataReader.GetString(dataReader.GetOrdinal(CSerie.CSerieFields.Usernew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Datenew.ToString())))
{
businessObject.Datenew = dataReader.GetDateTime(dataReader.GetOrdinal(CSerie.CSerieFields.Datenew.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Useredit.ToString())))
{
businessObject.Useredit = dataReader.GetString(dataReader.GetOrdinal(CSerie.CSerieFields.Useredit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Dateedit.ToString())))
{
businessObject.Dateedit = dataReader.GetDateTime(dataReader.GetOrdinal(CSerie.CSerieFields.Dateedit.ToString()));
}
if (!dataReader.IsDBNull(dataReader.GetOrdinal(CSerie.CSerieFields.Status.ToString())))
{
businessObject.Status = dataReader.GetBoolean(dataReader.GetOrdinal(CSerie.CSerieFields.Status.ToString()));
}
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of CSerie</returns>
internal List <CSerie> PopulateObjectsFromReader(IDataReader dataReader)
{
List <CSerie> list = new List <CSerie>();
while (dataReader.Read())
{
CSerie businessObject = new CSerie();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
/// <summary>
/// Select by primary key
/// </summary>
/// <param name="keys">primary keys</param>
/// <returns>CSerie business object</returns>
public CSerie SelectByPrimaryKey(CSerieKeys keys)
{
NpgsqlCommand sqlCommand = new NpgsqlCommand();
sqlCommand.CommandText = "public.sp_serie_SelectByPrimaryKey";
sqlCommand.CommandType = CommandType.StoredProcedure;
// Use connection object of base class
sqlCommand.Connection = MainConnection;
try
{
sqlCommand.Parameters.Add(new NpgsqlParameter("p_cod_serie", NpgsqlDbType.Varchar, 10, "", ParameterDirection.Input, false, 0, 0, DataRowVersion.Proposed, keys.Cod_serie));
MainConnection.Open();
NpgsqlDataReader dataReader = sqlCommand.ExecuteReader();
if (dataReader.Read())
{
CSerie businessObject = new CSerie();
PopulateBusinessObjectFromReader(businessObject, dataReader);
return(businessObject);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw new Exception("CSerie::SelectByPrimaryKey::Error occured.", ex);
}
finally
{
MainConnection.Close();
sqlCommand.Dispose();
}
}
private void DgvDetalleVenta_CellClick(object sender, DataGridViewCellEventArgs e)
{
//----Determinar las coordenadas de la celda que cambio
int Fila = e.RowIndex;
int Col = e.ColumnIndex;
if (Col == 7)
{
// Como se elimina un producto se aumenta el stock de dicho producto
string CodigoEliminado = DgvDetalleVentas[0, Fila].Value.ToString();
int CantidadAumentada = int.Parse(DgvDetalleVentas[1, Fila].Value.ToString());
ActualizarStock(CodigoEliminado, CantidadAumentada, true);
if (DgvDetalleVentas.Rows[Fila].Cells[5].Value.ToString() != "")
{
CSerie Serie = new CSerie();
Serie.Insertar(new string[] { DgvDetalleVentas.Rows[Fila].Cells[0].Value.ToString(), DgvDetalleVentas.Rows[Fila].Cells[5].Value.ToString() });
}
DgvDetalleVentas.Rows.RemoveAt(Fila);
CalcularTotales();
}
}
private void BtnAgregarSerie_Click(object sender, EventArgs e)
{
if (TxtCodProducto.Text != "P")
{
if (CboSeries.Text != "")
{
CSerie Serie = new CSerie();
Serie.Insertar(new string[] { TxtCodProducto.Text, CboSeries.Text });
if (Serie.ValorAtributo("CodError") == "0" && Serie.ValorAtributo("CodError") == "0")
{
//---Inicializar el formulario
ActualizarStock(TxtCodProducto.Text, 1);
if (aEntidad.ExisteClavePrimaria(TxtCodProducto.Text))
{
TxtStock.Text = aEntidad.ValorAtributo("Stock");
CargarSeries(TxtCodProducto.Text);
}
MessageBox.Show(Serie.ValorAtributo("Mensaje"), "CONFIRMACION");
//Limpiar el formulario
//LimpiarTodo();
}
else
{
MessageBox.Show(Serie.ValorAtributo("Mensaje"), "ERROR");
}
}
else
{
MessageBox.Show("La serie no puede ser vacia");
}
}
else
{
MessageBox.Show("Tiene que ingresar un producto");
}
}
protected override bool Grabar_Registro()
{
CSerieFactory faSerie = new CSerieFactory();
List<CSerie> lstCorr_modules = faSerie.GetAll();
foreach (CSerie item in lstCorr_modules)
{
item.Status_serie = false;
faSerie.Update(item);
}
CSerie oSerie = new CSerie();
oSerie.Cod_serie = tbCodSerie.Text;
oSerie.Nom_serie = cbNomSerie.Text;
oSerie.Dateinit = deDateIni.DateTime;
oSerie.Dateend = deDateEnd.DateTime;
oSerie.Status_serie = true;
bool result = false;
if (!(result = faSerie.Update(oSerie)))
result = faSerie.Insert(oSerie);
return result;
}
