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
}
