public ActionResult DeleteConfirmed(int?id)
{
CodeReason codeReason = db.CodeReason
.Where(p => p.SysId == id)
.FirstOrDefault();
db.CodeReason.Remove(codeReason);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SysId,Vender,ProductType,ReasonCode,CodeType,AllowShip,ProcessType,EngDesc,ChtDesc,ChsDesc,Duty,Outsourcing,DefaultUsed,DefaultEcn,RequireRemark,RequireRelabel,RequireSwapInfo,RequireCustSn,RequireMfgSn,RequireBios,RequierAttn,Active,CreateDate,CreateUser,ModiDate,ModiUser")] CodeReason codeReason)
{
if (ModelState.IsValid)
{
db.Entry(codeReason).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(codeReason));
}
public async Task <CodeModel> CreateEmailCode(string email, CodeReason codeReason)
{
var props = _codeConfiguration.Data[Enum.GetName(typeof(CodeReason), codeReason)];
return(await _codeRepository.Create(new CodeModel
{
Email = email,
Code = GenerateCode(props.CodeLength),
ReasonType = codeReason,
DateExpiration = DateTime.UtcNow.AddMinutes(props.LifeTime)
}));
}
public async Task <bool> CheckEmailCodeExists(string email, string code, CodeReason codeReason, bool deactivate = true)
{
var dbCode = await _codeRepository.GetByEmail(email, code, codeReason);
if (deactivate)
{
dbCode.IsActive = false;
await _codeRepository.Update(dbCode);
}
return(dbCode?.IsActive == true && dbCode.DateExpiration > DateTime.UtcNow);
}
// GET: CodeReasons/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CodeReason codeReason = db.CodeReason.Find(id);
if (codeReason == null)
{
return(HttpNotFound());
}
return(View(codeReason));
}
public async Task <bool> CheckPhoneCodeExists(string phone, string code, CodeReason codeReason, bool deactivate = true)
{
var dbCode = await _codeRepository.GetByPhone(phone, code, codeReason);
var result = dbCode?.IsActive == true && dbCode.DateExpiration > DateTime.UtcNow;
if (dbCode != null && deactivate)
{
dbCode.IsActive = false;
await _codeRepository.Update(dbCode);
}
return(result);
}
// GET: CodeReasons/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CodeReason codeReason = db.CodeReason
.Where(p => p.SysId == id)
.FirstOrDefault();
if (codeReason == null)
{
return(HttpNotFound());
}
return(View(codeReason));
}
public async Task <CodeModel> GetByEmail(string email, string code, CodeReason codeReason)
{
using IDbConnection db = new NpgsqlConnection(ConnectionString);
return(await db.QueryFirstOrDefaultAsync <CodeModel>(
@$ "
{GetBaseSelectQuery()}
WHERE Email = @Email
AND Code = @Code
AND ReasonId = @ReasonId
",
new
{
Email = email,
Code = code,
CodeReason = codeReason
}
));
}
public async Task <CodeModel> GetByPhone(string phone, string code, CodeReason codeReason)
{
using IDbConnection db = new NpgsqlConnection(ConnectionString);
return(await db.QueryFirstOrDefaultAsync <CodeModel>(
@$ "
{GetBaseSelectQuery()}
WHERE Phone = @Phone
AND Code = @Code
AND ReasonId = @ReasonId
",
new
{
Phone = phone,
Code = code,
CodeReason = codeReason
}
));
}
public ActionResult Create([Bind(Include = "Vender,ProductType,ReasonCode,CodeType,AllowShip,ProcessType,EngDesc,ChtDesc,ChsDesc,Duty,Outsourcing,DefaultUsed,DefaultEcn,RequireRemark,RequireRelabel,RequireSwapInfo,RequireCustSn,RequireMfgSn,RequireBios,RequierAttn")] CodeReasonCreateViewModel codeReasonViewModel)
{
if (ModelState.IsValid)
{
CodeReason codeReason = new CodeReason()
{
Vender = codeReasonViewModel.Vender,
ProductType = codeReasonViewModel.ProductType,
ReasonCode = codeReasonViewModel.ReasonCode,
CodeType = codeReasonViewModel.CodeType,
AllowShip = codeReasonViewModel.AllowShip,
ProcessType = codeReasonViewModel.ProcessType,
EngDesc = codeReasonViewModel.EngDesc,
ChtDesc = codeReasonViewModel.ChsDesc,
ChsDesc = codeReasonViewModel.ChsDesc,
Duty = codeReasonViewModel.Duty,
Outsourcing = codeReasonViewModel.Outsourcing,
DefaultUsed = codeReasonViewModel.DefaultUsed,
DefaultEcn = codeReasonViewModel.DefaultEcn,
RequireRemark = codeReasonViewModel.RequireRemark,
RequireRelabel = codeReasonViewModel.RequireRelabel,
RequireSwapInfo = codeReasonViewModel.RequireSwapInfo,
RequireCustSn = codeReasonViewModel.RequireCustSn,
RequireMfgSn = codeReasonViewModel.RequireMfgSn,
RequireBios = codeReasonViewModel.RequireBios,
RequierAttn = codeReasonViewModel.RequierAttn,
Active = "Y",
CreateDate = DateTime.Now,
CreateUser = "******"
};
db.CodeReason.Add(codeReason);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
