public outputresetpassword Updatepassword(string Updatepassword, paramresetpassword pr)
{
outputresetpassword output = new outputresetpassword();
try
{
var dtUsers = _context.User.Where(p => p.email == pr.email).FirstOrDefault();
dtUsers.password = pr.password;
_context.SaveChanges();
if (dtUsers.userid != null && dtUsers.userid != 0)
{
output.Result = "OK";
output.user = dtUsers.userid;
output.Message = "Reset password Success";
}
else
{
output.Result = "NG";
output.Message = "Failed Update Employee";
}
}
catch (Exception ex)
{
output.Result = "NG";
output.Message = ex.ToString();
}
return(output);
}
public outputchangepassword Changepassword(string Changepassword, paramchangepassword pr)
{
outputchangepassword output = new outputchangepassword();
try
{
var dtUsers = _context.User.Where(p => p.userid == pr.userid && p.password != null).FirstOrDefault();
dtUsers.password = pr.password;
_context.SaveChanges();
if (dtUsers.userid != null && dtUsers.userid != 0)
{
output.Result = "OK";
output.user = dtUsers.userid;
output.Message = "Change Password Success";
}
else
{
output.Result = "NG";
output.Message = "Failed Change Password";
}
}
catch (Exception ex)
{
output.Result = "NG";
output.Message = ex.ToString();
}
return(output);
}
public outputSignUp PostUser(paramSignUp pr)
{
outputSignUp output = new outputSignUp();
var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
var stringChars = new char[8];
var random = new Random();
for (int i = 0; i < stringChars.Length; i++)
{
stringChars[i] = chars[random.Next(chars.Length)];
}
var finalString = new String(stringChars);
try
{
User dtUser = new User();
dtUser.userid = pr.userid;
dtUser.password = pr.password;
dtUser.phone = pr.phone;
dtUser.school = pr.school;
dtUser.major = pr.major;
dtUser.interest = pr.interest;
dtUser.email = pr.email;
dtUser.dateofbirth = Convert.ToDateTime(pr.dateofbirth);
dtUser.createdon = DateTime.Now;
dtUser.age = pr.age;
dtUser.fullname = pr.fullname;
dtUser.gender = pr.gender;
dtUser.participantcode = finalString;
dtUser.role = pr.role;
dtUser.profilepicture = pr.profilepicture;
_context.User.Add(dtUser);
_context.SaveChanges();
if (dtUser.userid != null && dtUser.userid != 0)
{
output.Result = "OK";
output.users = dtUser.userid;
output.Message = "Insert Success";
}
else
{
output.Result = "NG";
output.Message = "Failed Insert Employee";
}
}
catch (Exception ex)
{
output.Result = "NG";
output.Message = ex.ToString();
}
return(output);
}
//public async Task<ActionResult<HistoryProduct>> PostHistoryProduct(HistoryProduct historyProduct)
public async Task <outputScanQr> PostHistoryProduct(paramScanQr pr)
{
//_context.HistoryProduct.Add(historyProduct);
//await _context.SaveChangesAsync();
outputScanQr output = new outputScanQr();
var result = new resultScanQr();
try
{
HistoryProduct dtPrd = new HistoryProduct();
dtPrd.hisproid = pr.hisproid;
dtPrd.productid = pr.productid;
dtPrd.userid = pr.userid;
dtPrd.scantime = pr.scantime;
_context.HistoryProduct.Add(dtPrd);
_context.SaveChanges();
var dtlogin = (from x in _context.HistoryProduct.Where(ahha => ahha.productid == pr.productid)
join prd in _context.Product on x.productid equals prd.productid
//where x.productid == pr.productid
//orderby x.commentid descending
select new Product
{
productid = prd.productid,
productname = prd.productname,
productdetail = prd.productdetail,
productcode = prd.productcode,
bannerproduct = prd.bannerproduct,
linkstring = prd.linkstring
}).ToList();
if (dtlogin != null)
{
//result = dtlogin;
output.Result = "OK";
output.products = dtlogin;
output.Message = "Success";
}
else
{
output.Result = "NG";
output.Message = "GagalBosque";
}
}
catch (Exception ex)
{
output.Result = "NG";
output.Message = ex.ToString();
}
return(output);
}
