/*Funcion: Construir unidades a partir del DAO Param: DataTable Return: Lista Unit */ public List<UnitView> buildUnits(DataTable DaoResult) { List<UnitView> ViewList = new List<UnitView>(); foreach (DataRow row in DaoResult.Rows) { UnitView x = new UnitView(); if (DaoResult.Columns.Contains("UnitId") && row["UnitId"] != DBNull.Value) { x.UnitId = Convert.ToInt32(row["UnitId"]); } if (DaoResult.Columns.Contains("UnitName") && row["UnitName"] != DBNull.Value) { x.UnitName = row["UnitName"].ToString(); } if (DaoResult.Columns.Contains("UnitSymbol") && row["UnitSymbol"] != DBNull.Value) { x.UnitSymbol = row["UnitSymbol"].ToString(); } ViewList.Add(x); } return ViewList; }
/*Funcion: Actualizar Units Param: UnitView,AuditDataFromWeb Return: Status */ public CUDView updateUnits(UnitView unit, AuditDataFromWeb audit) { AuditDao auditDao = new AuditDao(); DataTable auditDaoResult = auditDao.getUnitByUnitId(unit.UnitId); String OldValues = "UnitId: " + unit.UnitId; foreach (DataRow row in auditDaoResult.Rows) { if (auditDaoResult.Columns.Contains("UnitName") && row["UnitName"] != DBNull.Value) { OldValues = OldValues + ", UnitName: " + row["UnitName"].ToString(); } if (auditDaoResult.Columns.Contains("UnitSymbol") && row["UnitSymbol"] != DBNull.Value) { OldValues = OldValues + ", UnitSymbol: " + row["UnitSymbol"].ToString(); } } ParameterDao Dao = new ParameterDao(); String state = Dao.updateUnits(unit); CUDView logic = CUDVerifyLogic.verifierInsertDeleteUpdate("update", state); if (logic.update == true) { AuditService auditservice = new AuditService(); String Action = "Update unit"; String NewValues = "UnitId: " + unit.UnitId + ", UnitName: " + unit.UnitName + ", UnitSymbol: " + unit.UnitSymbol; auditservice.formUpdate(Action, NewValues, OldValues, audit); } return logic; }
/*Funcion: Obtener unidad para un parametro Param: ParameterId Return: Unit */ public UnitView getUnitFromParameter(int ParameterId ) { ParameterDao Dao = new ParameterDao(); DataTable DaoResult = Dao.getUnitFromParameter(ParameterId); UnitView View = new UnitView(); foreach (DataRow row in DaoResult.Rows) { if (DaoResult.Columns.Contains("UnitId") && row["UnitId"] != DBNull.Value) { View.UnitId = Convert.ToInt32(row["UnitId"]); } if (DaoResult.Columns.Contains("UnitName") && row["UnitName"] != DBNull.Value) { View.UnitName = row["UnitName"].ToString(); } if (DaoResult.Columns.Contains("UnitSymbol") && row["UnitSymbol"] != DBNull.Value) { View.UnitSymbol = row["UnitSymbol"].ToString(); } } return View; }
/* Metodo que se utiliza para actualizar la unidad */ private void updateUnitAux() { if (HttpContext.Current.Session["UnitId"] != null) { string Name = UnitName.Text; string Symbol = UnitSymbol.Text; if (Name != "" & Symbol != "") { ParameterService parameterService = new ParameterService(); 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; UnitView unit = new UnitView(); unit.UnitName = Name; unit.UnitSymbol = Symbol; unit.UnitId = Int32.Parse(HttpContext.Current.Session["UnitId"].ToString()); CUDView crud = parameterService.updateUnits(unit, audit); if (crud.update == false) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true); } else { UnitName.Text = ""; UnitSymbol.Text = ""; fillUnitGroupTable(); updateUnitModal.Update(); } HttpContext.Current.Session["operation"] = "create"; showUnitModal(); } } }
protected void updateUnit_Click(object sender, EventArgs e) { if (HttpContext.Current.Session["UnitId"] != null) { string Name = UnitName.Text; string Symbol = UnitSymbol.Text; if (Name != "" & Symbol != "") { ParameterService parameterService = new ParameterService(); UnitView unit = new UnitView(); unit.UnitName = Name; unit.UnitSymbol = Symbol; unit.UnitId = Int32.Parse(HttpContext.Current.Session["UnitId"].ToString()); CUDView crud = parameterService.updateUnits(unit); if (crud.update == false) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true); } else { UnitName.Text = ""; UnitSymbol.Text = ""; fillUnitGroupTable(); updateUnitModal.Update(); } } } }
/* Funcion: Actualiza Unidades Param: UnitId, UnitName, UnitSymbol Return: Status */ public String updateUnits(UnitView unit) { return context.InsertUpdateDeleteMSQL("EXEC updateUnit @UnitId=" + unit.UnitId + ", @UnitName='" + unit.UnitName + "', @UnitSymbol='" + unit.UnitSymbol + "'"); }