/*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;
}
