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