/*Crea el Objecto Account a partir de los bases de la base */
public List<AccountView> buildAccount(DataTable DaoResult)
{
List<AccountView> ViewList = new List<AccountView>();
foreach (DataRow row in DaoResult.Rows)
{
AccountView x = new AccountView();
if (DaoResult.Columns.Contains("UserGroupId") && row["UserGroupId"] != DBNull.Value) { x.UserGroupId = Convert.ToInt32(row["UserGroupId"]); }
if (DaoResult.Columns.Contains("Block") && row["Block"] != DBNull.Value) { x.Block = (bool)row["Block"]; }
if (DaoResult.Columns.Contains("Active") && row["Active"] != DBNull.Value) { x.Active = (bool)row["Active"]; }
if (DaoResult.Columns.Contains("Account") && row["Account"] != DBNull.Value) { x.Account = row["Account"].ToString(); }
if (DaoResult.Columns.Contains("Login") && row["Login"] != DBNull.Value) { x.Login = row["Login"].ToString(); }
if (DaoResult.Columns.Contains("Name") && row["Name"] != DBNull.Value) { x.Name = row["Name"].ToString(); }
if (DaoResult.Columns.Contains("LastName") && row["LastName"] != DBNull.Value) { x.LastName = row["LastName"].ToString(); }
if (DaoResult.Columns.Contains("GroupName") && row["GroupName"] != DBNull.Value) { x.GroupName = row["GroupName"].ToString(); }
ViewList.Add(x);
}
return ViewList;
}
/*
Funcion: Borra accounts de la base
Param: login
Return: status
*/
public String deleteAccount(AccountView account)
{
return context.InsertUpdateDeleteMSQL("EXEC deleteAccount @UserAccountLogin='******'");
}
protected void userDelete_Click(object sender, ImageClickEventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
if (HttpContext.Current.Session["UserId"] != null)
{
AccountService accountService = new AccountService();
AccountView delete = new AccountView();
delete.Login = UserNameText.Text;//key
CUDView crud = accountService.deleteAccount(delete);
if (crud.delete == false)
{
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Could not delete the Account')", true);
}
else
{
clearFields();
fillAccountTable();
}
}
}
}
/*Funcion: inserta una nueva cuenta
Param: accountView
Return: status
*/
public CUDView deleteAccount(AccountView account)
{
AccountDao Dao = new AccountDao();
String state = Dao.deleteAccount(account);
return CUDVerifyLogic.verifierInsertDeleteUpdate("delete", state);
}
