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