public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Picture,Status")] Catagories catagories)
{
if (id != catagories.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(catagories);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CatagoriesExists(catagories.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(catagories));
}
public ActionResult Create(CatagoriesViewModel model)
{
try
{
if (ModelState.IsValid)
{
var categories = new Catagories();
categories.Id = model.Id;
categories.Name = model.Name;
categories.Stock = model.Stock;
bool isSave = _catagoriesManger.Add(categories);
// TODO: Add insert logic here
if (isSave)
{
return(RedirectToAction(nameof(Index)));
}
return(NotFound());
}
return(View());
}
catch
{
return(View());
}
}
public async Task <int> Do(Request request)
{
var catagory = new Catagories
{
Id = request.Id,
Catagory = request.Catagory
};
return(await _catagoryManager.UpdateCatagory(catagory));
}
public async Task <IActionResult> Create([Bind("Id,Name,Picture,Status")] Catagories catagories)
{
if (ModelState.IsValid)
{
_context.Add(catagories);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(catagories));
}
public async Task<IActionResult> Index(Catagories catagories)
{
if (ModelState.IsValid)
{
var msg = catagories.Catagory + " selected";
//return RedirectToAction("IndexSuccess", new { message = msg });
}
// If we got this far, something failed; redisplay form.
return View(catagories);
}
/// <summary>
/// Extracts the Catagories from the collection
/// </summary>
private void GetCatagories()
{
Catagories.Clear();
//adds the data to the collection
Catagories.Add("Housing");
Catagories.Add("Debt");
Catagories.Add("Health");
Catagories.Add("Food");
Catagories.Add("Personal");
Catagories.Add("Travel");
Catagories.Add("Work Related");
Catagories.Add("Other");
}
private void LoadData()
{
Catagories.Clear();
IList <Catagory> catList = this.administrationService.GetCatagories();
foreach (Catagory cat in catList)
{
Catagories.Add(new CatagoryVM(cat, administrationService));
}
CurrentCatagory = Catagories.First();
RaisePropertyChangedEvent(nameof(Catagories));
RaisePropertyChangedEvent(nameof(CurrentCatagory));
}
public async Task <Response> Do(Request requset)
{
var catagory = new Catagories
{
Catagory = requset.Catagory
};
await _catagoryManager.CreateCatagory(catagory);
return(new Response
{
Id = catagory.Id,
Catagory = catagory.Catagory
});
}
public List <Catagories> getAllCatagories()
{
List <Catagories> catagories = new List <Catagories>();
string sql = "SELECT * FROM Catagories";
SqlDataReader reader = DataProvider.ExecuteQueryWithDataReader(sql, CommandType.Text);
while (reader.Read())
{
Catagories catagorie = new Catagories
{
CatagoryId = reader.GetString(0),
CatagoryName = reader.GetString(1),
Description = reader.GetString(2),
Picture = reader.GetString(3),
};
catagories.Add(catagorie);
}
return(catagories);
}
public static List <Catagories> Get_Cat()
{
List <Catagories> list_det = new List <Catagories>();
DataTable dt = getdata();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
Catagories u = new Catagories();
u.cat_Id = Convert.ToInt32(dt.Rows[i]["cat_Id"]);
u.cat_Name = Convert.ToString(dt.Rows[i]["cat_Name"]);
list_det.Add(u);
}
return(list_det);
}
public static List <Catagories> Get_All()
{
List <Catagories> list_det = new List <Catagories>();
DataTable dt = get_all_Catagories();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
Catagories p = new Catagories();
p.cat_Name = Convert.ToString(dt.Rows[i]["cat_Name"]);
p.cat_disc = Convert.ToString(dt.Rows[i]["cat_disc"]);
p.cat_Img = Convert.ToString(dt.Rows[i]["cat_Img"]);
list_det.Add(p);
}
return(list_det);
}
public Task <int> UpdateCatagory(Catagories catagory)
{
_ctx.Categories.Update(catagory);
return(_ctx.SaveChangesAsync());
}
public Task <int> CreateCatagory(Catagories catagory)
{
_ctx.Categories.Add(catagory);
return(_ctx.SaveChangesAsync());
}
public Book(decimal price, int stock, string title, string author, string isbn, int catagory) : base(price, stock, title)
{
Author = author;
ISBN = isbn;
Catagory = (Catagories)catagory;
}
