/*Funcion: obtiene los marcas de un equipo Param: Return: Lista EquipmentBrand */ public List<BrandView> getEquipmentBrand() { EquipmentDao Dao = new EquipmentDao(); DataTable DaoResult = Dao.getEquipmentBrand(); List<BrandView> ViewList = new List<BrandView>(); foreach (DataRow row in DaoResult.Rows) { BrandView x = new BrandView(); if (DaoResult.Columns.Contains("BrandId") && row["BrandId"] != DBNull.Value) { x.BrandId = Convert.ToInt32(row["BrandId"]); } if (DaoResult.Columns.Contains("BrandName") && row["BrandName"] != DBNull.Value) { x.BrandName = row["BrandName"].ToString(); } ViewList.Add(x); } return ViewList; }
/* Metodo para actualizar un brand */ private void updateBrandAux() { if (HttpContext.Current.Session["BrandGroupId"] != null) { string value = valueBrand.Text; if (value != "") { String reason = Session["reason"].ToString(); String user = Context.User.Identity.Name; AuditDataFromWeb audit = new AuditDataFromWeb(); audit.Reason = reason; audit.StationIP = General.getIp(this.Page); audit.UserName = user; EquipmentService equipmentService = new EquipmentService(); BrandView brandView = new BrandView(); brandView.BrandId = Int32.Parse(HttpContext.Current.Session["BrandGroupId"].ToString()); brandView.BrandName = value; CUDView crud = equipmentService.updateBrand(brandView, audit); if (crud.update == false) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true); } else { valueBrand.Text = ""; fillBrandGroupTable(); updateBrandModal.Update(); } HttpContext.Current.Session["operation"] = "create"; showBrandModal(); } } }
protected void updateBrand_Click(object sender, EventArgs e) { if (HttpContext.Current.Session["BrandGroupId"] != null) { string value = valueBrand.Text; if (value != "") { EquipmentService equipmentService = new EquipmentService(); BrandView brandView = new BrandView(); brandView.BrandId = Int32.Parse(HttpContext.Current.Session["BrandGroupId"].ToString()); brandView.BrandName = value; CUDView crud = equipmentService.updateBrand(brandView); if (crud.update == false) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true); } else { valueBrand.Text = ""; fillBrandGroupTable(); updateBrandModal.Update(); } } } }
/* Funcion: Actualiza los brand Param: BrandId, BrandName Return: status */ public String updateBrand(BrandView brandUpdate) { return context.InsertUpdateDeleteMSQL("EXEC updateBrand @BrandId=" + brandUpdate.BrandId + ", @BrandName='" + brandUpdate.BrandName + "';"); }
/*Funcion: actualizar las marcas Param: BrandView,AuditDataFromWeb Return: status */ public CUDView updateBrand(BrandView brandUpdateView, AuditDataFromWeb audit) { CUDView logic = new CUDView(); AuditDao auditDao = new AuditDao(); DataTable auditDaoResult = auditDao.getEquipmentBrandOldValues(brandUpdateView.BrandId); String OldValues = "EquipmentBrandId: " + brandUpdateView.BrandId; foreach (DataRow row in auditDaoResult.Rows) { if (auditDaoResult.Columns.Contains("BrandName") && row["BrandName"] != DBNull.Value) { OldValues = OldValues + ", BrandName: " + row["BrandName"].ToString(); } } EquipmentDao Dao = new EquipmentDao(); String state = Dao.updateBrand(brandUpdateView); logic= CUDVerifyLogic.verifierInsertDeleteUpdate("update", state); if (logic.update == true) { AuditService auditservice = new AuditService(); String Action = "Update EquipmentBrand"; String newValues = "EquipmentBrandId: " + brandUpdateView.BrandId; newValues = newValues + ", EquipmentGroupName: " + brandUpdateView.BrandName; auditservice.formUpdate(Action, newValues, OldValues, audit); } return logic; }