public void Delete(Franchisee model)
{
var sql = "delete from Franchisee where AutoId=@AutoId";
var conn = DbConnectionFactory.CreateConnection();
conn.Execute(sql, model);
}
public void Update(Franchisee model)
{
var sql = "update Franchisee set Name=@Name,Email=@Email,Weixin=@Weixin,Phone=@Phone,Address=@Address,Remark=@Remark,ApplyTime=@ApplyTime,ProcessTime=@ProcessTime,Status=@Status where AutoId=@AutoId";
var conn = DbConnectionFactory.CreateConnection();
conn.Execute(sql, model);
}
// GET: Store Index - shows inventory for the user's store.
public async Task <IActionResult> Index(string productName, int threshold, int id = 1)
{
FetchStore();
int storeID = Store.StoreID;
Franchisee franchisee = new Franchisee(_context, UserID, storeID);
List <StoreInventory> inventory = await franchisee.GetStoreInventory();
// Eager loading the Product table - join between StoreInventory and the Product table.
var productQuery = _context.StoreInventory.Include(x => x.Product).Where(p => p.StoreID == storeID);
if (!string.IsNullOrWhiteSpace(productName))
{
inventory = await franchisee.GetStoreInventory(productName);
// Storing the search into ViewBag to populate the textbox with the same value for convenience.
ViewBag.ProductName = productName;
}
if (threshold != 0)
{
inventory = await franchisee.GetStoreInventoryBelowThreshold(threshold);
// Storing the search into ViewBag to populate the textbox with the same value for convenience.
ViewBag.Threshold = threshold;
}
//Passing a List<OwnerInventory> model object to the View.
return(View(inventory));
}
public CustomerController(MagicMVCContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
_userManager = userManager;
customer = new Customer(_context);
franchisee = new Franchisee(_context);
}
public async Task <FranchiseeDto> AddOrUpdateFranchisee(Franchisee franchisee)
{
if (franchisee == null)
{
throw new ArgumentNullException(nameof(franchisee));
}
ClcWorldContext.Franchisees.AddOrUpdate(franchisee);
return(await SaveAsync() ? franchisee.ToMap <FranchiseeDto>() : null);
}
public int Insert(Franchisee model)
{
var connection = DbConnectionFactory.CreateConnection();
var id = connection.Query <int>(@"Insert into Franchisee(Name,Email,Weixin,Phone,Address,Remark,ApplyTime,ProcessTime,Status)
values (@Name,@Email,@Weixin,@Phone,@Address,@Remark,@ApplyTime,@ProcessTime,@Status);SELECT LAST_INSERT_ID()",
model).FirstOrDefault();
return(id);
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Franchisee franchisee = await db.Franchisees.FindAsync(id);
db.Franchisees.Remove(franchisee);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <bool> DeleteFranchiseeById(int id)
{
var franchisee = new Franchisee {
Id = id
};
ClcWorldContext.Franchisees.Attach(franchisee);
ClcWorldContext.Franchisees.Remove(franchisee);
return(await SaveAsync());
}
public async Task <ActionResult> Edit([Bind(Include = "Id,date,name,email,contact,login,password,rid,image,Type,status")] Franchisee franchisee)
{
if (ModelState.IsValid)
{
db.Entry(franchisee).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(franchisee));
}
public async Task DeleteFranchiseeAsync(Franchisee franchisee)
{
try
{
dbContext.Franchisees.Remove(franchisee);
await dbContext.SaveChangesAsync();
}
catch (Exception)
{
throw;
}
}
public async Task <Franchisee> AddFranchiseeAsync(Franchisee franchisee)
{
try
{
dbContext.Franchisees.Add(franchisee);
await dbContext.SaveChangesAsync();
}
catch (Exception)
{
throw;
}
return(franchisee);
}
// GET: Auth/Franchisees/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Franchisee franchisee = await db.Franchisees.FindAsync(id);
if (franchisee == null)
{
return(HttpNotFound());
}
return(View(franchisee));
}
// GET: Unstocked Items - show items in Owner Inventory which Store does not have in stock.
public async Task <IActionResult> Unstocked()
{
FetchStore();
int storeID = Store.StoreID;
Franchisee franchisee = new Franchisee(_context, UserID, storeID);
// Load products in OwnerInventory that aren't in this Store's Inventory
var storeInventory = await franchisee.GetStoreInventory();
List <OwnerInventory> inventory = await _context.OwnerInventory.Include(i => i.Product).Where(o => !storeInventory.Any(s => s.ProductID == o.ProductID)).ToListAsync();
//Passing a List<OwnerInventory> model object to the View.
return(View(inventory));
}
public async Task <Franchisee> UpdateFranchiseeAsync(Franchisee franchisee)
{
try
{
var franchiseeExist = dbContext.Franchisees.FirstOrDefault(p => p.Id == franchisee.Id);
if (franchiseeExist != null)
{
dbContext.Update(franchisee);
await dbContext.SaveChangesAsync();
}
}
catch (Exception)
{
throw;
}
return(franchisee);
}
public async Task <IdentityResult> CreateAsync(User user, CancellationToken cancellationToken)
{
try
{
// Insert the user
await DbContext.AddAsync(user, cancellationToken);
// Assign the user to it's default role based on it's type
await AddToRoleAsync(user, user switch
{
Administrator _ => Role.Admin,
Customer _ => Role.Customer,
Employee _ => Role.Employee,
Franchisee _ => Role.Franchisee,
_ => throw new ArgumentException($"Unknown user type {user.GetType()}")
}, cancellationToken);
await DbContext.SaveChangesAsync(cancellationToken);
return(IdentityResult.Success);
}
public async Task CreateNewFranchisee()
{
var user = new Franchisee
{
FirstName = Input.FirstName,
LastName = Input.LastName,
Email = Input.Email,
PhoneNumber = Input.PhoneNumber,
Location = Input.Location
};
IdentityResult result = await UserManager.CreateAsync(user, Input.Password);
if (result.Succeeded)
{
Logger.LogInformation("Franchisee created a new account with password.");
await EmailManager.SendConfirmationEmailAsync(user);
}
await BlazoredModal.Close(ModalResult.Ok(true));
}
public ActionResult MyCompanyContact(int FranchiseeId)
{
var listEClass = new List <Franchisee>();
var eclass = new Franchisee();
var cDetails = (from p in DB.tbl_Franchise_Contacts where p.FranchiseID == FranchiseeId select p);
foreach (var details in cDetails)
{
var det = details;
var phone = (from d in DB.tbl_PhoneType where d.PhoneTypeID == det.PhoneTypeID select d).FirstOrDefault();
if (phone != null)
{
eclass.FranchiseID = details.FranchiseID;
eclass.PhoneType = phone.PhoneType;
eclass.PhoneNumber = details.PhoneNumber;
eclass.PhoneTypeID = details.PhoneTypeID;
eclass.ContactName = details.ContactName;
eclass.FranchiseContactID = details.FranchiseContactID;
var summary = new Franchisee
{
FranchiseContactID = eclass.FranchiseContactID,
PhoneTypeID = eclass.PhoneTypeID,
FranchiseID = eclass.FranchiseID,
PhoneNumber = eclass.PhoneNumber,
PhoneType = eclass.PhoneType,
ContactName = eclass.ContactName
};
listEClass.Add(summary);
}
}
return(Json(listEClass));
}
public void UpdateFranchisee(Franchisee model)
{
franchiseeRepository.Update(model);
}
public void DeleteFranchisee(Franchisee model)
{
throw new NotImplementedException();
}
public int AddFranchisee(Franchisee model)
{
return(franchiseeRepository.Insert(model));
}
public Franchisee_StockRequestsController(MagicMVCContext context, UserManager <ApplicationUser> userManager)
{
_context = context;
franchisee = new Franchisee(_context);
_userManager = userManager;
}