private void eliminarProgramProductionDevelopmentToolStripMenuItem_Click(object sender, EventArgs e) { try { int IdProgramProductionDevelopment = 0; if (gvProgramProductionDevelopment.GetFocusedRowCellValue("IdProgramProductionDevelopment") != null) { IdProgramProductionDevelopment = int.Parse(gvProgramProductionDevelopment.GetFocusedRowCellValue("IdProgramProductionDevelopment").ToString()); } ProgramProductionDevelopmentBE objBE_ProgramProductionDevelopment = new ProgramProductionDevelopmentBE(); objBE_ProgramProductionDevelopment.IdProgramProductionDevelopment = IdProgramProductionDevelopment; objBE_ProgramProductionDevelopment.IdCompany = Parametros.intEmpresaId; objBE_ProgramProductionDevelopment.Login = Parametros.strUsuarioLogin; objBE_ProgramProductionDevelopment.Machine = WindowsIdentity.GetCurrent().Name.ToString(); ProgramProductionDevelopmentBL objBL_ProgramProductionDevelopment = new ProgramProductionDevelopmentBL(); objBL_ProgramProductionDevelopment.Elimina(objBE_ProgramProductionDevelopment); gvProgramProductionDevelopment.DeleteRow(gvProgramProductionDevelopment.FocusedRowHandle); gvProgramProductionDevelopment.RefreshData(); } catch (Exception ex) { XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public List <ProgramProductionDevelopmentBE> ListaTodosActivo(int IdProgramProduction, int IdProgramProductionDetail) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDevelopment_ListaTodosActivo"); db.AddInParameter(dbCommand, "pIdProgramProduction", DbType.Int32, IdProgramProduction); db.AddInParameter(dbCommand, "pIdProgramProductionDetail", DbType.Int32, IdProgramProductionDetail); IDataReader reader = db.ExecuteReader(dbCommand); List <ProgramProductionDevelopmentBE> ProgramProductionDevelopmentlist = new List <ProgramProductionDevelopmentBE>(); ProgramProductionDevelopmentBE ProgramProductionDevelopment; while (reader.Read()) { ProgramProductionDevelopment = new ProgramProductionDevelopmentBE(); ProgramProductionDevelopment.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); ProgramProductionDevelopment.IdProgramProduction = Int32.Parse(reader["IdProgramProduction"].ToString()); ProgramProductionDevelopment.IdProgramProductionDevelopment = Int32.Parse(reader["idProgramProductionDevelopment"].ToString()); ProgramProductionDevelopment.DevDate = DateTime.Parse(reader["DevDate"].ToString()); ProgramProductionDevelopment.Comment = reader["Comment"].ToString(); ProgramProductionDevelopment.IdSituation = Int32.Parse(reader["IdSituation"].ToString()); ProgramProductionDevelopment.Situation = reader["Situation"].ToString(); ProgramProductionDevelopment.FlagState = Boolean.Parse(reader["FlagState"].ToString()); ProgramProductionDevelopment.TipoOper = 4; //CONSULTAR ProgramProductionDevelopmentlist.Add(ProgramProductionDevelopment); } reader.Close(); reader.Dispose(); return(ProgramProductionDevelopmentlist); }
public ProgramProductionDevelopmentBE Selecciona(int IdProgramProductionDevelopment) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDevelopment_Selecciona"); db.AddInParameter(dbCommand, "pidProgramProductionDevelopment", DbType.Int32, IdProgramProductionDevelopment); IDataReader reader = db.ExecuteReader(dbCommand); ProgramProductionDevelopmentBE ProgramProductionDevelopment = null; while (reader.Read()) { ProgramProductionDevelopment = new ProgramProductionDevelopmentBE(); ProgramProductionDevelopment.IdCompany = Int32.Parse(reader["IdCompany"].ToString()); ProgramProductionDevelopment.IdProgramProduction = Int32.Parse(reader["IdProgramProduction"].ToString()); ProgramProductionDevelopment.IdProgramProductionDevelopment = Int32.Parse(reader["idProgramProductionDevelopment"].ToString()); ProgramProductionDevelopment.DevDate = DateTime.Parse(reader["DevDate"].ToString()); ProgramProductionDevelopment.Comment = reader["Comment"].ToString(); ProgramProductionDevelopment.IdSituation = Int32.Parse(reader["IdSituation"].ToString()); ProgramProductionDevelopment.Situation = reader["Situation"].ToString(); ProgramProductionDevelopment.FlagState = Boolean.Parse(reader["FlagState"].ToString()); } reader.Close(); reader.Dispose(); return(ProgramProductionDevelopment); }
public void Elimina(ProgramProductionDevelopmentBE pItem) { try { ProgramProductionDevelopmentDL ProgramProductionDevelopment = new ProgramProductionDevelopmentDL(); ProgramProductionDevelopment.Elimina(pItem); } catch (Exception ex) { throw ex; } }
public ProgramProductionDevelopmentBE Selecciona(int IdProgramProductionDevelopment) { try { ProgramProductionDevelopmentDL ProgramProductionDevelopment = new ProgramProductionDevelopmentDL(); ProgramProductionDevelopmentBE objEmp = ProgramProductionDevelopment.Selecciona(IdProgramProductionDevelopment); return(objEmp); } catch (Exception ex) { throw ex; } }
public void Elimina(ProgramProductionDevelopmentBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDevelopment_Elimina"); db.AddInParameter(dbCommand, "pIdProgramProductionDevelopment", DbType.Int32, pItem.IdProgramProductionDevelopment); 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); }
public void Actualiza(ProgramProductionDevelopmentBE pItem) { Database db = DatabaseFactory.CreateDatabase("cnERPBD"); DbCommand dbCommand = db.GetStoredProcCommand("usp_ProgramProductionDevelopment_Actualiza"); db.AddInParameter(dbCommand, "pIdProgramProductionDevelopment", DbType.Int32, pItem.IdProgramProductionDevelopment); db.AddInParameter(dbCommand, "pIdProgramProduction", DbType.Int32, pItem.IdProgramProduction); db.AddInParameter(dbCommand, "pIdProgramProductionDetail", DbType.Int32, pItem.IdProgramProductionDetail); db.AddInParameter(dbCommand, "pDevDate", DbType.Date, pItem.DevDate); db.AddInParameter(dbCommand, "pComment", DbType.String, pItem.Comment); db.AddInParameter(dbCommand, "pIdSituation", DbType.Int32, pItem.IdSituation); db.AddInParameter(dbCommand, "pFlagState", DbType.Boolean, pItem.FlagState); db.AddInParameter(dbCommand, "pLogin", DbType.String, pItem.Login); db.AddInParameter(dbCommand, "pMachine", DbType.String, pItem.Machine); db.AddInParameter(dbCommand, "pIdCompany", DbType.Int32, pItem.IdCompany); db.ExecuteNonQuery(dbCommand); }
private void btnGrabar_Click(object sender, EventArgs e) { try { Cursor = Cursors.WaitCursor; if (!ValidarIngreso()) { ProgramProductionDevelopmentBL objBL_ProgramProductionDevelopment = new ProgramProductionDevelopmentBL(); //DETAIL List <ProgramProductionDevelopmentBE> lstProgramProductionDevelopment = new List <ProgramProductionDevelopmentBE>(); foreach (var item in mListaProgramProductionDevelopmentOrigen) { ProgramProductionDevelopmentBE objE_ProgramProductionDevelopment = new ProgramProductionDevelopmentBE(); objE_ProgramProductionDevelopment.IdCompany = Parametros.intEmpresaId; objE_ProgramProductionDevelopment.IdProgramProduction = IdProgramProduction; objE_ProgramProductionDevelopment.IdProgramProductionDetail = item.IdProgramProductionDetail; objE_ProgramProductionDevelopment.IdProgramProductionDevelopment = item.IdProgramProductionDevelopment; objE_ProgramProductionDevelopment.DevDate = item.DevDate; objE_ProgramProductionDevelopment.Comment = item.Comment; objE_ProgramProductionDevelopment.IdSituation = item.IdSituation; objE_ProgramProductionDevelopment.FlagState = true; objE_ProgramProductionDevelopment.Login = Parametros.strUsuarioLogin; objE_ProgramProductionDevelopment.Machine = WindowsIdentity.GetCurrent().Name.ToString(); objE_ProgramProductionDevelopment.TipoOper = item.TipoOper; lstProgramProductionDevelopment.Add(objE_ProgramProductionDevelopment); } objBL_ProgramProductionDevelopment.Actualiza(lstProgramProductionDevelopment); Application.DoEvents(); this.Close(); } } catch (Exception ex) { Cursor = Cursors.Default; XtraMessageBox.Show(ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } }