/*Funcion: obtiene los grupos de equipos
Param:
Return: status
*/
public List<EquipmentGroupView> getEquipmentGroup()
{
EquipmentDao Dao = new EquipmentDao();
DataTable DaoResult = Dao.getEquipmentGroup();
List<EquipmentGroupView> ViewList = new List<EquipmentGroupView>();
foreach (DataRow row in DaoResult.Rows)
{
EquipmentGroupView x = new EquipmentGroupView();
if (DaoResult.Columns.Contains("EquipmentGroupId") && row["EquipmentGroupId"] != DBNull.Value) { x.EquipmentGroupId = Convert.ToInt32(row["EquipmentGroupId"]); }
if (DaoResult.Columns.Contains("EquipmentGroupName") && row["EquipmentGroupName"] != DBNull.Value) { x.EquipmentGroupName = row["EquipmentGroupName"].ToString(); }
ViewList.Add(x);
}
return ViewList;
}
/*
Metodo para actualizar un grupo
*/
private void updateGroupAux()
{
if (HttpContext.Current.Session["EquipmentGroupId"] != null)
{
string value = ValueGroup.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();
EquipmentGroupView groupView = new EquipmentGroupView();
groupView.EquipmentGroupId = Int32.Parse(HttpContext.Current.Session["EquipmentGroupId"].ToString());
groupView.EquipmentGroupName = value;
CUDView crud = equipmentService.UpdateEquipmentGroup(groupView, audit);
if (crud.update == false)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true);
}
else
{
ValueGroup.Text = "";
filEquipmentGroupTable();
upModalSuccess.Update();
}
HttpContext.Current.Session["operation"] = "create";
showGroupModal();
}
}
}
protected void UpdateGroup_Click(object sender, EventArgs e)
{
if (HttpContext.Current.Session["EquipmentGroupId"] != null) {
string value = ValueGroup.Text;
if (value != "")
{
EquipmentService equipmentService = new EquipmentService();
EquipmentGroupView groupView = new EquipmentGroupView();
groupView.EquipmentGroupId = Int32.Parse(HttpContext.Current.Session["EquipmentGroupId"].ToString());
groupView.EquipmentGroupName = value;
CUDView crud = equipmentService.UpdateEquipmentGroup(groupView);
if (crud.update == false)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not update the Value')", true);
}
else
{
ValueGroup.Text = "";
filEquipmentGroupTable();
upModalSuccess.Update();
}
}
}
}
/*
Funcion: Actualiza un grupo de equipos
Param: EquipmentGroupId, EquipmentGroup
Return: Status
*/
public String updateEquipmentGroup(EquipmentGroupView groupView)
{
return context.InsertUpdateDeleteMSQL("EXEC updateEquipmentGroup @EquipmentGroupId=" + groupView.EquipmentGroupId + ", @EquipmentName='" + groupView.EquipmentGroupName+ "';");
}
/*Funcion: actualizar equipos por grupos
Param: EquipmentGroupView,AuditDataFromWeb
Return: status
*/
public CUDView UpdateEquipmentGroup(EquipmentGroupView groupEquipment, AuditDataFromWeb audit)
{
CUDView logic = new CUDView();
AuditDao auditDao = new AuditDao();
DataTable auditDaoResult = auditDao.getEquipmentGroupOldValues(groupEquipment.EquipmentGroupId);
String OldValues = "EquipmentGroupId: " + groupEquipment.EquipmentGroupId;
foreach (DataRow row in auditDaoResult.Rows)
{
if (auditDaoResult.Columns.Contains("EquipmentGroupName") && row["EquipmentGroupName"] != DBNull.Value) { OldValues = OldValues + ", EquipmentGroupName: " + row["EquipmentGroupName"].ToString(); }
}
EquipmentDao Dao = new EquipmentDao();
String state = Dao.updateEquipmentGroup(groupEquipment);
logic= CUDVerifyLogic.verifierInsertDeleteUpdate("update", state);
if (logic.update == true)
{
AuditService auditservice = new AuditService();
String Action = "Update EquipmentGroup";
String newValues = "EquipmentGroupId: " + groupEquipment.EquipmentGroupId;
newValues = newValues + ", EquipmentGroupName: " + groupEquipment.EquipmentGroupName;
auditservice.formUpdate(Action, newValues, OldValues, audit);
}
return logic;
}
