private void btnGrabar_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
if (!ValidarIngreso())
{
TallaBL objBL_Talla = new TallaBL();
TallaBE objTalla = new TallaBE();
objTalla.IdTalla = IdTalla;
objTalla.NameTalla = txtDescripcion.Text;
objTalla.FlagState = true;
objTalla.Login = Parametros.strUsuarioLogin;
objTalla.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objTalla.IdCompany = Parametros.intEmpresaId;
if (pOperacion == Operacion.Nuevo)
objBL_Talla.Inserta(objTalla);
else
objBL_Talla.Actualiza(objTalla);
this.Close();
}
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public async Task <IHttpActionResult> Eliminar(int Id, int IdCliente, string UsrModificador)
{
try
{
TallaBL oTallaBL = new TallaBL(IdCliente);
TallaBE obe = new TallaBE();
obe.Id = Id;
obe.UsrModificador = UsrModificador;
bool rpta = false;
rpta = oTallaBL.Eliminar(obe);
if (rpta)
{
return(Ok(Models.Util.GetBodyResponse(200, "OK")));
}
else
{
return(Ok(Models.Util.GetBodyResponse(300, "Ocurrió un error al actualizar.")));
}
}
catch (Exception ex)
{
//LogSA.GrabarLogError("SOL TR", model.user, "EditarTareas", ex);
return(Ok(Models.Util.GetBodyResponse(400, ex.Message)));
}
}
private void tlbMenu_DeleteClick()
{
try
{
Cursor = Cursors.WaitCursor;
if (XtraMessageBox.Show("Be sure to delete the record?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (!ValidarIngreso())
{
TallaBE objE_Talla = new TallaBE();
objE_Talla.IdTalla = int.Parse(gvTalla.GetFocusedRowCellValue("IdTalla").ToString());
objE_Talla.Login = Parametros.strUsuarioLogin;
objE_Talla.Machine = WindowsIdentity.GetCurrent().Name.ToString();
objE_Talla.IdCompany = Parametros.intEmpresaId;
TallaBL objBL_Talla = new TallaBL();
objBL_Talla.Elimina(objE_Talla);
XtraMessageBox.Show("The record was successfully deleted.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
Cargar();
}
}
Cursor = Cursors.Default;
}
catch (Exception ex)
{
Cursor = Cursors.Default;
XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool Eliminar(SqlConnection cnBD, SqlTransaction trx, TallaBE obe)
{
bool rpta = false;
string msjError = "";
using (SqlCommand cmd = new SqlCommand("[dbo].[USP_Ajustes_Talla_Eliminar]", cnBD))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Transaction = trx;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = obe.Id;
cmd.Parameters.Add("@UsrCreador", SqlDbType.VarChar, 50).Value = obe.UsrModificador;
int counterMarker = 0;
object objRes = cmd.ExecuteScalar();
int.TryParse(objRes.ToString(), out counterMarker);
if (counterMarker > 0)
{
rpta = true;
}
else
{
msjError = objRes.ToString();
rpta = false;
}
}
return(rpta);
}
public void Inserta(TallaBE pItem)
{
try
{
TallaDL Talla = new TallaDL();
Talla.Inserta(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Actualiza(TallaBE pItem)
{
try
{
TallaDL Talla = new TallaDL();
Talla.Actualiza(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TallaBE pItem)
{
try
{
TallaDL Talla = new TallaDL();
Talla.Elimina(pItem);
}
catch (Exception ex)
{ throw ex; }
}
public TallaBE SeleccionaDescripcion(int IdCompany, string NameTalla)
{
try
{
TallaDL Talla = new TallaDL();
TallaBE objEmp = Talla.SeleccionaDescripcion(IdCompany, NameTalla);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public TallaBE Selecciona(int IdTalla)
{
try
{
TallaDL Talla = new TallaDL();
TallaBE objEmp = Talla.Selecciona(IdTalla);
return(objEmp);
}
catch (Exception ex)
{ throw ex; }
}
public void Elimina(TallaBE pItem)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Talla_Elimina");
db.AddInParameter(dbCommand, "pIdTalla", DbType.Int32, pItem.IdTalla);
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany);
db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login);
db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine);
db.ExecuteNonQuery(dbCommand);
}
private void frmManTallaEdit_Load(object sender, EventArgs e)
{
if (pOperacion == Operacion.Nuevo)
{
this.Text = "Talla - New";
}
else if (pOperacion == Operacion.Modificar)
{
this.Text = "Talla - Update";
TallaBE objE_Talla = null;
objE_Talla = new TallaBL().Selecciona(IdTalla);
if (objE_Talla != null)
{
txtDescripcion.Text = objE_Talla.NameTalla.Trim();
}
}
txtDescripcion.Select();
}
public bool Actualizar(TallaBE obe)
{
bool rpta = false;
SqlTransaction sqltrans;
using (SqlConnection con = new SqlConnection(strCnx))
{
con.Open();
sqltrans = con.BeginTransaction();
rpta = oTallaDA.Actualizar(con, sqltrans, obe);
if (rpta)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
}
return(rpta);
}
public TallaBE Selecciona(int IdTalla)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Talla_Selecciona");
db.AddInParameter(dbCommand, "pidTalla", DbType.Int32, IdTalla);
IDataReader reader = db.ExecuteReader(dbCommand);
TallaBE Talla = null;
while (reader.Read())
{
Talla = new TallaBE();
Talla.IdTalla = Int32.Parse(reader["idTalla"].ToString());
Talla.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Talla.NameTalla = reader["NameTalla"].ToString();
Talla.FlagState = Boolean.Parse(reader["FlagState"].ToString());
}
reader.Close();
reader.Dispose();
return(Talla);
}
public void InicializarModificar()
{
if (gvTalla.RowCount > 0)
{
TallaBE objTalla = new TallaBE();
objTalla.IdTalla = int.Parse(gvTalla.GetFocusedRowCellValue("IdTalla").ToString());
frmManTallaEdit objManTallaEdit = new frmManTallaEdit();
objManTallaEdit.pOperacion = frmManTallaEdit.Operacion.Modificar;
objManTallaEdit.IdTalla = objTalla.IdTalla;
objManTallaEdit.pTallaBE = objTalla;
objManTallaEdit.StartPosition = FormStartPosition.CenterParent;
objManTallaEdit.ShowDialog();
Cargar();
}
else
{
MessageBox.Show("No se pudo editar");
}
}
public async Task <IHttpActionResult> Actualizar(TallaBE obe)
{
try
{
TallaBL oTallaBL = new TallaBL(obe.IdCliente);
bool rpta = false;
rpta = oTallaBL.Actualizar(obe);
if (rpta)
{
return(Ok(Models.Util.GetBodyResponse(200, "OK")));
}
else
{
return(Ok(Models.Util.GetBodyResponse(300, "Ocurrió un error al actualizar.")));
}
}
catch (Exception ex)
{
//LogSA.GrabarLogError("SOL TR", model.user, "EditarTareas", ex);
return(Ok(Models.Util.GetBodyResponse(400, ex.Message)));
}
}
public List <TallaBE> ListaTodosActivo(int IdCompany)
{
Database db = DatabaseFactory.CreateDatabase("cnERPBD");
DbCommand dbCommand = db.GetStoredProcCommand("usp_Talla_ListaTodosActivo");
db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, IdCompany);
IDataReader reader = db.ExecuteReader(dbCommand);
List <TallaBE> Tallalist = new List <TallaBE>();
TallaBE Talla;
while (reader.Read())
{
Talla = new TallaBE();
Talla.IdTalla = Int32.Parse(reader["idTalla"].ToString());
Talla.IdCompany = Int32.Parse(reader["IdCompany"].ToString());
Talla.NameTalla = reader["NameTalla"].ToString();
Talla.FlagState = Boolean.Parse(reader["FlagState"].ToString());
Tallalist.Add(Talla);
}
reader.Close();
reader.Dispose();
return(Tallalist);
}
public List <TallaBE> ListarDatosIniciales(SqlConnection cnBD, string usuario,
out List <ReporteColumnas> loColumns, out List <TallaExportBE> loExport)
{
List <TallaBE> lobe = new List <TallaBE>();
TallaBE obe = new TallaBE();
loExport = new List <TallaExportBE>();
TallaExportBE obeX = new TallaExportBE();
//listado - columnas
loColumns = new List <ReporteColumnas>();
ReporteColumnas obeColumns = new ReporteColumnas();
using (SqlCommand cmd = new SqlCommand("[dbo].[USP_Ajustes_Talla_Lista]", cnBD))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add("@Usuario", SqlDbType.VarChar, 50).Value = usuario;
using (SqlDataReader drd = cmd.ExecuteReader())
{
if (drd.HasRows)
{
int pos_Id = drd.GetOrdinal("Id");
int pos_Nombre = drd.GetOrdinal("Nombre");
int pos_IdCliente = drd.GetOrdinal("IdCliente");
int pos_DesCliente = drd.GetOrdinal("DesCliente");
int pos_Estado = drd.GetOrdinal("Estado");
int pos_UsrCreador = drd.GetOrdinal("UsrCreador");
int pos_FchCreacion = drd.GetOrdinal("FchCreacion");
int pos_UsrModificador = drd.GetOrdinal("UsrModificador");
int pos_FchModificacion = drd.GetOrdinal("FchModificacion");
lobe = new List <TallaBE>();
loExport = new List <TallaExportBE>();
while (drd.Read())
{
obe = new TallaBE();
obe.Id = drd.GetInt32(pos_Id);
obe.Nombre = drd.GetString(pos_Nombre);
obe.IdCliente = drd.GetInt32(pos_IdCliente);
obe.DesCliente = drd.GetString(pos_DesCliente);
obe.Estado = drd.GetBoolean(pos_Estado);
obe.UsrCreador = drd.GetString(pos_UsrCreador);
obe.FchCreacion = drd.GetString(pos_FchCreacion);
obe.UsrModificador = drd.GetString(pos_UsrModificador);
obe.FchModificacion = drd.GetString(pos_FchModificacion);
lobe.Add(obe);
obeX = new TallaExportBE();
obeX.Id = drd.GetInt32(pos_Id);
obeX.Nombre = drd.GetString(pos_Nombre);
obeX.Estado = drd.GetBoolean(pos_Estado) ? "Activo" : "Inactivo";
obeX.UsrCreador = drd.GetString(pos_UsrCreador);
obeX.FchCreacion = drd.GetString(pos_FchCreacion);
obeX.UsrModificador = drd.GetString(pos_UsrModificador);
obeX.FchModificacion = drd.GetString(pos_FchModificacion);
loExport.Add(obeX);
}
}
drd.NextResult();
if (drd.HasRows)
{
#region ColumnasLista - columnas
int pos_field = drd.GetOrdinal("field");
int pos_header = drd.GetOrdinal("header");
int pos_width = drd.GetOrdinal("width");
#endregion ColumnasLista - columnas
loColumns = new List <ReporteColumnas>();
while (drd.Read())
{
#region ColumnasLista - campos
obeColumns = new ReporteColumnas();
obeColumns.field = drd.GetString(pos_field);
obeColumns.header = drd.GetString(pos_header);
obeColumns.width = drd.GetInt32(pos_width);
loColumns.Add(obeColumns);
#endregion ColumnasLista - campos
}
}
}
}
return(lobe);
}
