private void PopulateCBEditFoodID()
{
SQLiteDataReader reader = conn.ViewTable("Food");
while (reader.Read())
{
Console.WriteLine($"{reader["id"].ToString()}, {reader["name"].ToString()}");
int id = int.Parse(reader["id"].ToString());
string name = (string)reader["name"];
double price = (double)reader["price"];
string desc = (string)reader["desc"];
string image = (string)reader["img"];
Main_Category main = (Main_Category)Enum.Parse(typeof(Main_Category), reader["mainctgr"].ToString());
Sub_Category sub = (Sub_Category)Enum.Parse(typeof(Sub_Category), reader["subctgr"].ToString());
Food food = new Food
{
Name = name,
Price = price,
Description = desc,
Img = image,
MainCtgr = main,
SubCtgr = sub
};
lFood.Add(food);
cbEditName.Items.Add(food.Name);
}
reader.Close();
}
private void bEdit_Click(object sender, RoutedEventArgs e)
{
try
{
string name = cbEditName.Text;
double price = double.Parse(tbEditPrice.Text);
string desc = tbEditDesc.Text;
string img = TelemealPath(tbEditImage.Text);
Main_Category main = Main_Category.All;
Sub_Category sub = (Sub_Category)Enum.Parse(typeof(Sub_Category), cbEditCategory.Text);
Food food = new Food
{
Name = name,
Price = price,
Description = desc,
Img = img,
MainCtgr = main,
SubCtgr = sub
};
conn.UpdateFood(food);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
// GET: Client
public ActionResult ClientProducts(Main_Category maincat)
{
var query = from c in db.Products
where c.category_ID == maincat.category_ID
select c;
return(View(query.ToList()));
}
public ActionResult ProductDetailActionIndex(Main_Category model)
{
// Product p = db.Products.SingleOrDefault(g => g.category_ID == model.category_ID);
var query = from c in db.Products
where c.category_ID == model.category_ID
select c;
// List<Product> a = db.Products.ToList();
return(View(query.ToList()));
}
public ActionResult ProductAction(ProductModel myProductModel)
{
Main_cat_Data = (Main_Category)Session["CategoryOBj"];
ActionResult myAction = RedirectToAction("ProductDetailActionIndex", "ProductDetail", Main_cat_Data);
Product ProdData = new Product();
try
{
if (SignUpModel.sharedInstance == null || Session["CategoryOBj"] == null)
{
return(myAction);
}
Vendor_Data = SignUpModel.sharedInstance;
ProdData.category_ID = Main_cat_Data.category_ID;
ProdData.product_Maker = myProductModel.Product_Maker;
ProdData.product_Name = myProductModel.Product_Name;
ProdData.vendor_ID = Vendor_Data.Id;
ProdData.product_Quantity = myProductModel.Product_Quantity;
ProdData.product_Type = Main_cat_Data.cat_Data;
ProdData.product_Detail = myProductModel.Product_Details;
ProdData.is_Active = true;
ProdData.Is_Deleted = false;
ProdData.created_Date = Convert.ToString(DateTime.Now);
ProdData.Update_Date = null;
ProdData.Discounted_Prize = myProductModel.Product_Prize;
ProdData.created_By = Vendor_Data.Email;
ProdData.Update_Date = null;
#region Save Image on Server
string FileName = Path.GetFileNameWithoutExtension(myProductModel.Image_new2.FileName);
string Extension = Path.GetExtension(myProductModel.Image_new2.FileName);
FileName = FileName + DateTime.Now.ToString("yymmssff") + Extension;
ProdData.image = "~/Pictures/" + FileName;
FileName = Path.Combine(Server.MapPath("~/Pictures/"), FileName);
myProductModel.Image_new2.SaveAs(FileName);
#endregion
DB.Products.Add(ProdData);
DB.SaveChanges();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(myAction);
}
public ActionResult PhonesNTablets()
{
ActionResult myaction = RedirectToAction("ProductDetailActionIndex", "ProductDetail");
string Item = "PhonesNTablets";
try
{
Main_Category maincat = db.Main_Category.Single(w => w.cat_Data == Item);
// var a = db.Main_Category.Where(w => w.Cat_Name.StartsWith(Elect)).ToList();
if (maincat != null)
{
Session["CategoryOBj"] = maincat;
if (SignUpModel.sharedInstance.UserType == null)
{
myaction = RedirectToAction("ClientProducts", "Client", maincat);
}
else
{
if (SignUpModel.sharedInstance.UserType == "Vendor")
{
myaction = RedirectToAction("ProductDetailActionIndex", "ProductDetail", maincat);
}
else
{
myaction = RedirectToAction("ClientProducts", "Client", maincat);
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
return(myaction);
}
private void bAddFoodItem_Click(object sender, RoutedEventArgs e)
{
Button b = sender as Button;
string fName = "";
double fPrice;
string fDesc = "";
string fImg = "";
Main_Category fMain = Main_Category.All;
Sub_Category fSub;
try
{
if ((fName = tbAddName.Text) == "")
{
throw new ArgumentNullException("Missing Name");
}
if (tbAddPrice.Text == "")
{
throw new ArgumentNullException("Missing Price");
}
fPrice = double.Parse(tbAddPrice.Text);
fDesc = tbAddDesc.Text;
fImg = TelemealPath(tbAddImage.Text);
if (cbAddCategory.Text == "")
{
throw new ArgumentNullException("Missing Category");
}
fSub = (Sub_Category)Enum.Parse(typeof(Sub_Category), cbAddCategory.Text);
Food food = new Food
{
Name = fName,
Price = fPrice,
Description = fDesc,
Img = fImg,
MainCtgr = fMain,
SubCtgr = fSub
};
conn.InsertFood(food);
lFood.Add(food);
tbAddName.Clear();
tbAddImage.Clear();
tbAddDesc.Clear();
tbAddPrice.Clear();
cbAddCategory.SelectedIndex = -1;
cbEditName.Items.Add(food.Name);
}
catch (ArgumentNullException ex)
{
MessageBox.Show(ERROR_CODE_MRF + ex.ParamName);
}
catch (FormatException ex)
{
MessageBox.Show(ERROR_CODE_IDT);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
