public IActionResult Getpackage(string reference)
{
MSParameters par = new MSParameters("ref", reference);
Parameter.Add(par);
return(new JsonResult(MSutil.ExecuteStopProcedureToJson("Getpackage", Parameter)));
}
public IActionResult ChangePassword(UsersChangePassword usersChangePassword)
{
MSParameters par = new MSParameters("LoginUser", User.Claims.Where(c => c.Type == "http://schemas.xmlsoap.org/ws/2005/05/identity/claims/surname").Select(c => c.Value).DefaultIfEmpty("Failed").First());
Parameter.Add(par);
par = new MSParameters("LoginPassword", usersChangePassword.usr_Pswd_Old);
Parameter.Add(par);
GeneralFuntions functions;
DataTable LoginUser = MSutil.ExecuteStopProcedure("ps_ValidateUserLogin", Parameter);
if (LoginUser.Rows[0]["authentication"].ToString() == "Success")
{
Parameter.Clear();
Parameter.Add(new MSParameters("_usr_ID", functions.Base64Decode(LoginUser.Rows[0]["usr_ID"].ToString())));
Parameter.Add(new MSParameters("_usr_Pswd", usersChangePassword.usr_Pswd));
DataTable result = MSutil.ExecuteStopProcedure("pf_usr_change_password", Parameter);
TempData["result"] = result.Rows[0][0].ToString();
TempData["message"] = result.Rows[0][1].ToString();
}
else
{
TempData["changePasswordFailed"] = "Error al intentar cambiar la contraseña. Por favor ingrese las credenciales correctas...";
//return PartialView("Admin/_login");
}
return(PartialView("Admin/User/_ChangePassword"));
}
public IActionResult Attent(int id)
{
MSParameters par = new MSParameters("id", id.ToString());
Parameter.Add(par);
MSutil.ExecuteStopProcedureNotResult("Attent", Parameter);
return(new JsonResult("true"));
}
public IActionResult InactiveCoin(int id)
{
MSParameters par = new MSParameters("id", id.ToString());
Parameter.Add(par);
MSutil.ExecuteStopProcedureNotResult("SetInactivateCurrenPrice", Parameter);
return(new JsonResult("true"));
}
public IActionResult AddCoin(string name, string value, string bank)
{
MSParameters par = new MSParameters("name", name);
Parameter.Add(par);
par = new MSParameters("valor", value);
Parameter.Add(par);
par = new MSParameters("bank", bank);
Parameter.Add(par);
return(new JsonResult(MSutil.ExecuteStopProcedureToJson("AddCurrenPrice", Parameter)));
}
public IActionResult Setpackage(string reference, string detail, string progress)
{
MSParameters par = new MSParameters("ref", reference);
Parameter.Add(par);
par = new MSParameters("detail", detail);
Parameter.Add(par);
par = new MSParameters("progress", progress);
Parameter.Add(par);
MSutil.ExecuteStopProcedureNotResult("Setpackage", Parameter);
return(new JsonResult("true"));
}
public IActionResult Setpackage(PackageModel package)
{
MSParameters par = new MSParameters("ref", package.Pck_ref);
Parameter.Add(par);
par = new MSParameters("detailSend", package.Pck_detailSend);
Parameter.Add(par);
par = new MSParameters("progress", package.Pck_progress);
Parameter.Add(par);
par = new MSParameters("IdCustomer", package.Pck_IdCustomer);
Parameter.Add(par);
par = new MSParameters("NameCustomer", package.Pck_NameCustomer);
Parameter.Add(par);
par = new MSParameters("LastNameCustomer", package.Pck_LastNameCustomer);
Parameter.Add(par);
par = new MSParameters("AgeCustomer", package.Pck_AgeCustomer);
Parameter.Add(par);
par = new MSParameters("PhoneCustomer", package.Pck_PhoneCustomer[0] + ";" + package.Pck_PhoneCustomer[1] + ";" + package.Pck_PhoneCustomer[2]);
Parameter.Add(par);
par = new MSParameters("AddressCustomer", package.Pck_AddressCustomer);
Parameter.Add(par);
par = new MSParameters("EmailCustomer", package.Pck_EmailCustomer);
Parameter.Add(par);
par = new MSParameters("NameLastnamebeneficiary", package.Pck_NameLastnamebeneficiary);
Parameter.Add(par);
par = new MSParameters("Phonebeneficiary", package.Pck_Phonebeneficiary[0] + ";" + package.Pck_Phonebeneficiary[1] + ";" + package.Pck_Phonebeneficiary[2]);
Parameter.Add(par);
par = new MSParameters("Addressbeneficiary", package.Pck_Addressbeneficiary);
Parameter.Add(par);
par = new MSParameters("NameCollector", package.Pck_NameCollector);
Parameter.Add(par);
par = new MSParameters("IdCollector", package.Pck_IdCollector);
Parameter.Add(par);
par = new MSParameters("PriceByKg", package.Pck_PriceByKg);
Parameter.Add(par);
par = new MSParameters("KgInSuitCase", package.Pck_KgInSuitCase);
Parameter.Add(par);
par = new MSParameters("Coin", package.Pck_Coin);
Parameter.Add(par);
par = new MSParameters("TypeChange", package.Pck_TypeChange);
Parameter.Add(par);
par = new MSParameters("TotalPrice", package.Pck_TotalPrice);
Parameter.Add(par);
par = new MSParameters("Date", package.Pck_Date);
Parameter.Add(par);
par = new MSParameters("detailArticles", package.Pck_detailArticles);
Parameter.Add(par);
return(new JsonResult(MSutil.ExecuteStopProcedureToJson("Setpackage", Parameter)));
}
public IActionResult UpdateCoins(string id, string name, string value, string bank)
{
MSParameters par = new MSParameters("name", name);
Parameter.Add(par);
par = new MSParameters("valor", value);
Parameter.Add(par);
par = new MSParameters("bank", bank);
Parameter.Add(par);
par = new MSParameters("id", id);
Parameter.Add(par);
MSutil.ExecuteStopProcedureNotResult("UpdateCurrenPrice", Parameter);
return(new JsonResult("true"));
}
public IActionResult SendRecomendation(string name, string phone, string email, string message)
{
MSParameters par = new MSParameters("name", name);
Parameter.Add(par);
par = new MSParameters("phone", phone);
Parameter.Add(par);
par = new MSParameters("email", email);
Parameter.Add(par);
par = new MSParameters("message", message);
Parameter.Add(par);
MSutil.ExecuteStopProcedureNotResult("SendRecomendation", Parameter);
return(new JsonResult("true"));
}
//public class IndexModel: PageModel
//{
// private WebSettings WebSetting = new WebSettings();
// private List<MSParameters> Parameter = new List<MSParameters>();
// MSutils MSutil = new MSutils("SERVER=localhost;" + "DATABASE=gt;" + "UID=root;" + "PASSWORD=;");
public IActionResult Login(string usr, string pswd)
{
MSParameters par = new MSParameters("_user", usr);
Parameter.Add(par);
par = new MSParameters("pswd", pswd);
Parameter.Add(par);
DataTable _user = MSutil.ExecuteStopProcedure("ps_GetUserLogin", Parameter);
//User user = new User(_user.Rows[0][0], _user.Rows[0][1], _user.Rows[0][2], _user.Rows[0][3], _user.Rows[0][4], _user.Rows[0][5], _user.Rows[0][6], _user.Rows[0][7], _user.Rows[0][8]);
List <User> users = new List <User>();
foreach (DataRow row in _user.Rows)
{
User user = new User()
{
usr_Name = row[0].ToString(),
usr_Email = row[1].ToString(),
usr_Nameperson = row[2].ToString(),
usr_Birthday = Convert.ToDateTime(row[3].ToString()),
lan_ID = Convert.ToInt32(row[4].ToString()),
pro_id = Convert.ToInt32(row[5].ToString()),
pro_Name = row[6].ToString(),
acc_id = Convert.ToInt32(row[7].ToString()),
acc_key = row[8].ToString()
};
users.Add(user);
}
//List<User> users = new List<User> {
//};
return(PartialView("Admin/_menu", users));
//return new PartialViewResult {
// ViewName = "Admin/_menu",
// ViewData = new ViewDataDictionary<List<user>>(ViewData, user)
// };
//}
}
public async Task <IActionResult> Login(Users user)
{
ModelState.Remove("usr_ID");
ModelState.Remove("usr_Email");
ModelState.Remove("usr_Nameperson");
ModelState.Remove("usr_Birthday");
ModelState.Remove("lan_ID");
ModelState.Remove("pro_id");
ModelState.Remove("usr_is_deleted");
ModelState.Remove("usr_Pswd_Confirm");
//List<Users> users = new List<Users>();
if (ModelState.IsValid)
{
MSParameters par = new MSParameters("LoginUser", user.usr_Name);
Parameter.Add(par);
par = new MSParameters("LoginPassword", user.usr_Pswd);
Parameter.Add(par);
GeneralFuntions functions;
DataTable LoginUser = MSutil.ExecuteStopProcedure("ps_ValidateUserLogin", Parameter);
if (LoginUser.Rows[0]["authentication"].ToString() == "Success")
{
Parameter.Clear();
par = new MSParameters("usr_id", functions.Base64Decode(LoginUser.Rows[0]["usr_ID"].ToString()));
Parameter.Add(par);
DataTable UserDetails = MSutil.ExecuteStopProcedure("ps_GetUserById", Parameter);
user.usr_ID = UserDetails.Rows[0][0].ToString();
user.usr_Name = UserDetails.Rows[0][1].ToString();
user.usr_Email = UserDetails.Rows[0][2].ToString();
user.usr_Nameperson = UserDetails.Rows[0][3].ToString();
user.usr_Birthday = Convert.ToDateTime(UserDetails.Rows[0][4].ToString());
user.lan_ID = Convert.ToInt32(UserDetails.Rows[0][5].ToString());
user.pro_id = Convert.ToInt32(UserDetails.Rows[0][6].ToString());
user.OnGetProfileAccess();
ClaimsIdentity identity = new ClaimsIdentity(new[] {
new Claim(ClaimTypes.Name, user.usr_Nameperson),
new Claim(ClaimTypes.Email, user.usr_Email),
new Claim(ClaimTypes.NameIdentifier, user.usr_ID),
new Claim(ClaimTypes.DateOfBirth, user.usr_Birthday.ToString()),
new Claim(ClaimTypes.Surname, user.usr_Name)//,
//new Claim("abc", "abc", ClaimValueTypes.String)
}, CookieAuthenticationDefaults.AuthenticationScheme);
foreach (var item in user.userAccess)
{
identity.AddClaim(new Claim(item.acc_key, item.acc_key, ClaimValueTypes.String));
}
//identity.AddClaim
ClaimsPrincipal principal = new ClaimsPrincipal(identity);
await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, principal);
return(RedirectToAction("Index", "Admin"));
}
else
{
TempData["UserLoginFailed"] = "Error de inicio de sesion. Por favor ingrese las credenciales correctas...";
return(PartialView("Admin/_login"));
}
}
else
{
return(PartialView("Admin/_login"));
}
}
