public IActionResult RmvSP(Roles roles) { var zAParam = new ZAParam("RoleId", roles.RoleId, AllSQLType.Guid); var zABase = new ZABase("[dbo].[Rmv_Role]", AllCmdType.SP, zAParam); TempData["LastRoleIdAdded"] = ZADB_.Post <IEnumerable <Roles> >(zABase).FirstOrDefault()?.RoleId; TempData["IsSuccess"] = TempData["LastRoleIdAdded"] == null; return(RedirectToAction("Index")); }
public IActionResult AddSP(Roles roles) { var zAParam = new ZAParam("RoleName", $"{roles.RoleName}", AllSQLType.VarChar, 150); var zABase = new ZABase("[dbo].[Add_Role]", AllCmdType.SP, zAParam); TempData["LastRoleIdAdded"] = ZADB_.Post <IEnumerable <Roles> >(zABase).FirstOrDefault()?.RoleId; TempData["IsSuccess"] = TempData["LastRoleIdAdded"] != null; return(RedirectToAction("Index")); }
private static void OnlySP(ZADB _db, AllCmdType _cmdType = AllCmdType.SP) { #region Insert and show field. // You able to put all into ZADBBase field but is more easier to read for separate object zAParam = new List <ZAParam>() { new ZAParam("UserName", "Test", AllSQLType.VarChar, 50), new ZAParam("Password", "Test".ToHash(), AllSQLType.VarChar, 64), new ZAParam("NameFull", "Test", AllSQLType.VarChar, 200), new ZAParam("Email", "*****@*****.**", AllSQLType.VarChar, 150) }; var zABase = new ZABase("[Add_User]", _cmdType, zAParam); var userInsert = _db.Post <IEnumerable <Users> >(zABase); ShowData("userInsert - SP", userInsert); // Show all data. #endregion #region Select * or all fields. zABase = new ZABase("[Get_AllUser]", _cmdType); var userSelectAll = _db.Post <IEnumerable <Users> >(zABase); ShowData("userSelectAll - SP", userSelectAll); // Show all data. #endregion #region Select with some fields. var UserId = userSelectAll.FirstOrDefault(x => x.UserName == "Test").UserId; zAParam = new ZAParam("UserId", UserId, AllSQLType.Guid); zABase = new ZABase("[Get_UserById]", _cmdType, zAParam); var userSelectExact = _db.Post <IEnumerable <Users> >(zABase); ShowData("userSelectExact - SP", userSelectExact); // Show all data. #endregion #region update and show field. zAParam = new List <ZAParam>() { new ZAParam("UserName", "Test1", AllSQLType.VarChar, 50), new ZAParam("Email", "*****@*****.**", AllSQLType.VarChar, 150) }; zABase = new ZABase("[Upd_User]", _cmdType, zAParam); var userUpdate = _db.Post <IEnumerable <Users> >(zABase); ShowData("userUpdate - SP", userUpdate); // Show all data. #endregion #region Delete and show field. zAParam = new ZAParam("UserName", "Test1", AllSQLType.VarChar, 50); zABase = new ZABase("[Rmv_User]", _cmdType, zAParam); var userDelete = _db.Post <IEnumerable <Users> >(zABase); ShowData("userDelete - SP", userDelete); // Show all data. #endregion }