public async Task <IActionResult> Register(RegisterViewModel model, string returnUrl = null)
{
ViewData["ReturnUrl"] = returnUrl;
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await _userManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
_logger.LogInformation("User created a new account with password.");
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.EmailConfirmationLink(user.Id, code, Request.Scheme);
await _emailSender.SendEmailConfirmationAsync(model.Email, callbackUrl);
await _signInManager.SignInAsync(user, isPersistent : false);
await _userManager.AddToRoleAsync(user, model.RoleName);
_logger.LogInformation("User created a new account with password.");
#region set table connection
//connect with our own user table here.
Login lg = _context.Login.Where(p => p.Email == model.Email).FirstOrDefault();
if (lg == null)
{
lg = new Login();
lg.Email = model.Email;
lg.Password = "******";
_context.Add(lg);
_context.SaveChanges();
MyUser u = new MyUser();
u.Name = model.Name;
u.DeptId = _context.Department.Where(p => p.Name == model.Department).FirstOrDefault().DeptId;
u.RoleId = _context.Role.Where(p => p.Name == model.RoleName).FirstOrDefault().RoleId;
u.Email = model.Email;
_context.Add(u);
_context.SaveChanges();
}
#endregion
return(RedirectToLocal(returnUrl));
}
AddErrors(result);
}
return(View(model));
}
public Retrieval GenRetrievalAndReturn(Retrieval r1)
{
dbcontext.Retrievals.Add(r1);
dbcontext.SaveChanges();
Retrieval r = dbcontext.Retrievals.Include(m => m.Clerk).FirstOrDefault(x => x.Id == r1.Id);
return(r);
}
public PurchaseOrder Create(PurchaseOrder po)
{
dbcontext.PurchaseOrders.Add(po);
dbcontext.SaveChanges();
int id = po.Id;
PurchaseOrder newpo = dbcontext.PurchaseOrders.FirstOrDefault(m => m.Id == id);
return(newpo);
}
public void DeleteAdvDetails(AdjustmentVoucherDetail avd)
{
AdjustmentVoucherDetail original = dbcontext.AdjustmentVoucherDetails.FirstOrDefault(m => m.Id == avd.Id);
if (original != null)
{
dbcontext.AdjustmentVoucherDetails.Remove(original);
}
dbcontext.SaveChanges();
}
public bool UpdatePurchaseOrderDetail(PurchaseOrderDetail pod)
{
var original = dbcontext.PurchaseOrderDetails.Find(pod.Id);
if (original == null)
{
throw new Exception();
}
original.QtyReceived = pod.QtyReceived;
original.ReceivedByClerkId = pod.ReceivedByClerkId;
original.ReceivedDate = pod.ReceivedDate;
original.SupplierDeliveryNo = pod.SupplierDeliveryNo;
original.Remark = pod.Remark;
original.Status = pod.Status;
dbcontext.SaveChanges();
return(true);
}
public bool UpdateCollectionPoint(string deptid, int collectionpointId)
{
try
{
var original = dbcontext.Departments.Find(deptid);
if (original == null)
{
throw new Exception();
}
original.CollectionPointId = collectionpointId;
dbcontext.SaveChanges();
return(true);
}
catch
{
throw new Exception("Error updating collection point");
}
}
public RequisitionDetail UpdateRetrievalId(RequisitionDetail rd)
{
dbcontext.RequisitionDetails.Update(rd);
dbcontext.SaveChanges();
return(dbcontext.RequisitionDetails.Include(m => m.Requisition)
.Include(m => m.Product)
.Include(m => m.Retrieval)
.Include(m => m.Retrieval).FirstOrDefault(x => x.Id == rd.Id));
}
public Employee AssignDelegateDate(Employee emp)
{
try
{
Employee original = dbcontext.Employees.FirstOrDefault(m => m.Id == emp.Id);
if (original != null)
{
original.DelegateFromDate = emp.DelegateFromDate;
original.DelegateToDate = emp.DelegateToDate;
}
dbcontext.SaveChanges();
return(original);
}
catch (Exception)
{
throw new Exception("Error saving delegate dates");
}
}
public bool UpdateTop3Supplier(List <TenderQuotation> tqlist, int currentyear)
{
string productIdtoUpdate = tqlist[0].ProductId;
List <TenderQuotation> originTQList = dbcontext.TenderQuotations.Where(m => m.ProductId == productIdtoUpdate && m.Year == currentyear).ToList();
foreach (TenderQuotation k in originTQList)
{
k.Rank = null;
}
foreach (TenderQuotation i in tqlist)
{
foreach (TenderQuotation j in originTQList)
{
if (i.SupplierId == j.SupplierId)
{
j.Rank = i.Rank;
}
}
}
dbcontext.SaveChanges();
return(true);
}
public async Task <IActionResult> Index(List <int> numlist)
{
PurchaseOrder po = new PurchaseOrder();
var itemContext = from m in _context.Item.Include(p => p.Cat) where m.Cat.Supplier1 == supplierId || m.Cat.Supplier2 == supplierId || m.Cat.Supplier3 == supplierId select m;
try
{
po.SupplierId = supplierId;
po.PurchaseDate = DateTime.Now.Date;
_context.Add(po);
await _context.SaveChangesAsync();
var pocontext = from m in _context.PurchaseOrder select m;
List <PurchaseOrder> polist = await pocontext.ToListAsync();
int PoId = polist[polist.Count - 1].PoId;
foreach (string s in idlist)
{
PODetails pods = new PODetails();
pods.ItemId = s;
pods.Item = itemContext.Where(p => p.ItemId == s).ToList().First();
pods.PoId = PoId;
pods.QtyOrdered = numlist[idlist.IndexOf(s)];
_context.Add(pods);
_context.SaveChanges();
}
}
catch (Exception e)
{
System.Console.Write(e.ToString());
return(NotFound());
}
List <PODetails> podlist = new List <PODetails>();
idlist = new List <string>();
IsPosted = true;
return(RedirectToAction(nameof(ViewOrderHistory)));
}
public AdjustmentVoucher SaveNewAdjustmentVoucher(AdjustmentVoucher av)
{
dbcontext.AdjustmentVouchers.Add(av);
dbcontext.SaveChanges();
return(av);
}
public bool SaveNewTransaction(Transaction t1)
{
dbcontext.Transactions.Add(t1);
dbcontext.SaveChanges();
return(true);
}
public Requisition SaveNewRequisition(Requisition req)
{
dbcontext.Requisitions.Add(req);
dbcontext.SaveChanges();
return(req);
}
public bool AddNewPurchaseRequestDetail(PurchaseRequestDetail prd1)
{
dbcontext.PurchaseRequestDetails.Add(prd1);
dbcontext.SaveChanges();
return(true);
}