public ActionResult UserSignup(SignupModel obj)
{
if (ModelState.IsValid)
{
RMSEntities rtx = new RMSEntities();
var data = rtx.Customers.FirstOrDefault(i => i.Userid == obj.Userid);
if (data != null)
{
ModelState.AddModelError("", "Username already exists");
return(View("Signup"));
}
Customer c = new Customer();
c.Username = obj.Username;
c.Userid = obj.Userid;
c.password = obj.Password;
c.Usercity = obj.Usercity;
c.Uphonenum = long.Parse(obj.Userphno);
rtx.Customers.Add(c);
rtx.SaveChanges();
return(RedirectToAction("UserLogin"));
}
else
{
return(View("Signup"));
}
}
public JsonResult AddToCart2(Cart c1)
{
RMSEntities ctx = new RMSEntities();
var data = from a in ctx.Menus.ToList()
where a.Rname == Session["Rname"].ToString() &&
a.Itemsname == c1.Fooditems
select new
{
a.Itemsname,
a.price,
a.Rname,
};
foreach (var item in data)
{
Cart c = new Cart();
c.Fooditems = item.Itemsname;
c.Price = item.price;
c.Rname = item.Rname;
c.Quantity = c1.Quantity;
ctx.Carts.Add(c);
ctx.SaveChanges();
break;
}
return(Json(c1, JsonRequestBehavior.AllowGet));
}
public JsonResult GetCart2()
{
RMSEntities ctx = new RMSEntities();
//List<UserRest> listRest = new List<UserRest>();
//foreach (var item in ctx.Restaurants.ToList())
//{
// UserRest u = new UserRest();
// u.RName = item.RName;
// u.Branch = item.Branch;
// u.RType = item.RType;
// u.Logo = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(item.Logo));
// listRest.Add(u);
//}
var data = (from a in ctx.Carts.ToList()
//where (r1.City==a.City && r1.RName==a.RName)
select new
{
a.Fooditems,
a.Price,
a.Rname,
a.Quantity
}).ToList();
return(Json(data,
JsonRequestBehavior.AllowGet));
}
public ActionResult FinalUpdateMenu(Menu r1, HttpPostedFileBase pfile1)
{
RMSEntities ctx = new RMSEntities();
if (pfile1 != null)
{
BinaryReader brd = new BinaryReader(pfile1.InputStream);
byte[] bt = brd.ReadBytes((int)pfile1.InputStream.Length);
foreach (var item in ctx.Menus)
{
if (r1.Rname == item.Rname && r1.Itemsname == item.Itemsname)
{
item.Itemimage = bt;
item.price = (int)r1.price;
break;
}
}
}
else
{
foreach (var item in ctx.Menus)
{
if (r1.Rname == item.Rname && r1.Itemsname == item.Itemsname)
{
item.price = (int)r1.price;
break;
}
}
}
ctx.SaveChanges();
return(RedirectToAction("EditMenu"));
}
public JsonResult PlaceOrder2()
{
{
RMSEntities ctx = new RMSEntities();
foreach (var item in ctx.Carts)
{
OrderedFood h1 = new OrderedFood()
{
Userid = Session["Userid"].ToString(),
Rname = item.Rname,
Itemname = item.Fooditems,
Price = item.Price,
Quantity = item.Quantity.ToString(),
Date = DateTime.Now
};
ctx.OrderedFoods.Add(h1);
}
var rows = from a in ctx.Carts
select a;
foreach (var row in rows)
{
ctx.Carts.Remove(row);
}
ctx.SaveChanges();
int d = 1;
return(Json(d, JsonRequestBehavior.AllowGet));
}
}
public ActionResult AddBranch2(Branch r1, HttpPostedFileBase pfile1)
{
try
{
RMSEntities ctx = new RMSEntities();
Branch obj = new Branch();
var data = ctx.Branches.FirstOrDefault(i => (i.Location == r1.Location && i.bcity == r1.bcity && i.Rname == r1.Rname));
if (data == null)
{
BinaryReader brd = new BinaryReader(pfile1.InputStream);
byte[] bt = brd.ReadBytes((int)pfile1.InputStream.Length);
r1.bimage = bt;
ctx.Branches.Add(r1);
ctx.SaveChanges();
//ViewBag.Message = "Restaurant Added";
TempData["success"] = "Branch Added";
return(RedirectToAction("AddBranch"));
}
TempData["Error"] = "Duplicate Entry!";
return(RedirectToAction("AddBranch"));
}
catch (Exception ex)
{
return(RedirectToAction("Error", "Home"));
}
}
private static void CreateLevel(RMSEntities dbContext)
{
try
{
var levels = new List <string>()
{
"100", "200", "300", "400", "500"
};
foreach (var level in levels)
{
if (!dbContext.Levels.Any(c => c.Name == level))
{
dbContext.Levels.Add(new Level()
{
Name = level, CreatedAt = DateTime.UtcNow
});
dbContext.SaveChanges();
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public PurchaseEntryViewModel(PurchaseParams purchaseParams) : base(purchaseParams != null ? purchaseParams.ShowAllCompanies : false)
{
if (purchaseParams != null && purchaseParams.ShowAllCompanies)
{
Title = "Purchase Entry*";
}
else
{
Title = "Purchase Entry";
}
var count = RMSEntitiesHelper.Instance.RMSEntities.Companies.ToList();
_purchaseDetailsList = new ObservableCollection <PurchaseDetailExtn>();
_purchaseDetailsList.CollectionChanged += PurchaseDetailsListCollectionChanged;
_purchaseParams = purchaseParams;
RMSEntitiesHelper.Instance.AddPurchaseNotifier(this);
RMSEntitiesHelper.Instance.SelectRunningBillNo(_categoryId);
_rmsEntities = new RMSEntities();
if (purchaseParams != null)
{
if (purchaseParams.Billno.HasValue)
{
//Amend Bill
OnEditBill(purchaseParams.Billno.Value);
Title = "Purchase Bill Amend : " + _runningBillNo;
IsVisible = System.Windows.Visibility.Visible;
return;
}
}
}
private static void CreateSemester(RMSEntities dbContext)
{
try
{
var roles = new List <string>()
{
"Harmattan", "Rain"
};
foreach (var role in roles)
{
if (!dbContext.Semeters.Any(c => c.Name == role))
{
dbContext.Semeters.Add(new Semeter()
{
Name = role, CreatedAt = DateTime.UtcNow
});
dbContext.SaveChanges();
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public JsonResult GetRests2()
{
RMSEntities ctx = new RMSEntities();
var data = from a in ctx.Branches.ToList() where a.bcity == Session["Usercity"].ToString()
select new { name = a.Rname };
var data1 = from a in ctx.Restaurants.ToList() join b in data.ToList() on a.Rname equals b.name
select new { type = a.Category };
string s = data1.ToList()[0].type;
List <UserRest> listRest = new List <UserRest>();
foreach (var item in ctx.Branches.ToList())
{
if (Session["Usercity"].ToString() == item.bcity)
{
UserRest u = new UserRest();
u.Rname = item.Rname;
u.Location = item.Location;
u.bcity = item.bcity;
u.Category = s;
u.bimage = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(item.bimage));
listRest.Add(u);
}
}
return(Json(listRest,
JsonRequestBehavior.AllowGet));
}
public ActionResult ValidateUser(Credentials obj)
{
if (ModelState.IsValid)
{
RMSEntities mtx = new RMSEntities();
Customer c1 = mtx.Customers.FirstOrDefault(i => i.Userid == obj.Userid);
if (c1 == null)
{
TempData["userloginerror"] = "User not found!";
return(RedirectToAction("UserLogin"));
}
if (obj.Userid == c1.Userid && obj.Password == c1.password)
{
Session["Userid"] = c1.Userid;
Session["Username"] = c1.Username;
Session["Usercity"] = obj.Usercity;
return(RedirectToAction("Home", "User")); /// add user function link here
}
else
{
ModelState.AddModelError("", "Invalid User name or password");
TempData["userloginerror"] = "Invalid User name or password";
return(RedirectToAction("UserLogin"));
}
}
else
{
TempData["userloginerror"] = "Enter valid data";
return(RedirectToAction("UserLogin"));
}
}
public JsonResult GetAllName()
{
RMSEntities stx = new RMSEntities();
var d = from a in stx.Restaurants.ToList()
select a.Rname;
return(Json(d.ToList(), JsonRequestBehavior.AllowGet));
}
public CustomerViewModel()
{
//var names = RMSEntitiesHelper.RMSEntities.Customers.SelectMany(c => c.Name);
_customer = new Customer();
_rmsEntities = new RMSEntities();
var cnt = _rmsEntities.Categories.Count();
_customerCategory = _rmsEntities.Categories.Where(c => c.parentId == 1).ToList();
}
public JsonResult GetAllMenu(Menu m1)
{
RMSEntities stx = new RMSEntities();
var d = from a in stx.Menus.ToList()
where a.Rname == m1.Rname
select a.Rname;
return(Json(d.ToList(), JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllCity(Branch b1)
{
RMSEntities stx = new RMSEntities();
var d = from a in stx.Branches.ToList() where a.Rname == b1.Rname
select a.bcity;
d = d.Distinct().ToList();
return(Json(d.ToList(), JsonRequestBehavior.AllowGet));
}
public JsonResult Rest5(Restaurant b1)
{
RMSEntities stx = new RMSEntities();
var d = from a in stx.Restaurants.ToList()
where a.Rname == b1.Rname
select a.Category;
d = d.Distinct().ToList();
return(Json(d.ToList(), JsonRequestBehavior.AllowGet));
}
public ActionResult UserLogin(string Role)
{
RMSEntities rtx = new RMSEntities();
var list = from a in rtx.Branches select new { bcity = a.bcity };
list = list.Distinct();
ViewBag.list = new SelectList(list.ToList(), "", "bcity");
return(View());
}
public ProductsViewModel()
{
_product = new Product();
_rmsEntities = new RMSEntities();
var cnt = _rmsEntities.Categories.Count();
_productsCategory = _rmsEntities.Categories.Where(c => c.parentId == 3).ToList().OrderBy(p => p.name);
_unitOfMeasureList = _rmsEntities.MeasuringUnits.ToList().OrderBy(p => p.unit);
_companiesList = _rmsEntities.Companies.ToList().OrderBy(c => c.Name);
}
public static void InitializeIdentityForEf(ApplicationDbContext db)
{
var authContext = new ApplicationDbContext();
var rmsContext = new RMSEntities();
var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(authContext));
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>());
SetupHelper.SetupRoles(roleManager);
CrateStartupAdminUsers(userManager);
CreateLevel(rmsContext);
CreateSemester(rmsContext);
}
public JsonResult GetTotalPrice2()
{
RMSEntities ctx =
new RMSEntities();
int data = 0;
foreach (var item in ctx.Carts.ToList())
{
data = data + ((int)item.Price * (int)item.Quantity);
}
return(Json(data,
JsonRequestBehavior.AllowGet));
}
public JsonResult ChangeQuantity2(Cart F)
{
RMSEntities ctx = new RMSEntities();
foreach (var item in ctx.Carts.ToList())
{
if (item.Fooditems == F.Fooditems)
{
item.Quantity = F.Quantity;
break;
}
}
ctx.SaveChanges();
return(Json(F, JsonRequestBehavior.AllowGet));
}
public JsonResult DelItem2(Menu f1)
{
RMSEntities ctx = new RMSEntities();
foreach (var item in ctx.Menus)
{
if (f1.Rname == item.Rname && f1.Itemsname == item.Itemsname)
{
ctx.Menus.Remove(item);
break;
}
}
ctx.SaveChanges();
return(Json(f1));
}
public ActionResult AddMenu2(Menu b1, HttpPostedFileBase pfile1)
{
RMSEntities ctx = new RMSEntities();
string cat = Request.Form["type2"].ToString();
try
{
foreach (var item in ctx.Restaurants)
{
Menu obj = new Menu();
if (cat == "BOTH")
{
BinaryReader brd = new BinaryReader(pfile1.InputStream);
byte[] bt = brd.ReadBytes((int)pfile1.InputStream.Length);
b1.Itemimage = bt;
ctx.Menus.Add(b1);
TempData["menu_succ"] = "Menu Added";
break;
}
else
{
if (item.Rname == b1.Rname && item.Category == b1.Foodtype)
{
BinaryReader brd = new BinaryReader(pfile1.InputStream);
byte[] bt = brd.ReadBytes((int)pfile1.InputStream.Length);
b1.Itemimage = bt;
ctx.Menus.Add(b1);
TempData["menu_succ"] = "Menu Added";
break;
}
else
{
//TempData["dup_msg"] = "Kindly Check Data...";
// return RedirectToAction("AddMenu");
}
}
}
ctx.SaveChanges();
return(RedirectToAction("AddMenu"));
}
catch (Exception ex)
{
return(View("Error",
new HandleErrorInfo(ex, "Admin", "AddBranch")));
//return View("Error");
}
}
public JsonResult DeleteItem2(Cart F)
{
RMSEntities ctx = new RMSEntities();
foreach (var item in ctx.Carts.ToList())
{
if (item.Fooditems == F.Fooditems)
{
ctx.Carts.Remove(item);
break;
}
}
ctx.SaveChanges();
return(Json(F, JsonRequestBehavior.AllowGet));
}
public ReturnSalesViewModel(bool showRestrictedCustomers) : base(showRestrictedCustomers)
{
_returnSalesDetailsList = new ObservableCollection <ReturnSaleDetailExtn>();
_returnSalesDetailsList.CollectionChanged += (s, e) =>
{
if (e.Action == System.Collections.Specialized.NotifyCollectionChangedAction.Remove)
{
TotalAmount = _returnSalesDetailsList.Sum(r => r.Amount);
}
};
_rmsEntities = RMSEntitiesHelper.Instance.GetNewInstanceOfRMSEntities();
//_returnPriceList = _rmsEntities.PriceDetails.ToList();
var cnt = _rmsEntities.Products.ToList();
//var cnt1= _returnPriceList.Count();
this.Title = "Return Sales Entry";
}
public ActionResult AddRestaurant2(Restaurant r1, HttpPostedFileBase pfile1)
{
try
{
RMSEntities ctx = new RMSEntities();
BinaryReader brd = new BinaryReader(pfile1.InputStream);
byte[] bt = brd.ReadBytes((int)pfile1.InputStream.Length);
r1.Rimages = bt;
ctx.Restaurants.Add(r1);
ctx.SaveChanges();
TempData["rest_msg"] = "Restaurant Added";
return(RedirectToAction("AddRest"));
}
catch (Exception ex)
{
return(RedirectToAction("Error", "Home"));
}
}
public JsonResult GetMenu2()
{
RMSEntities ctx = new RMSEntities();
List <Mymenu> listMenu = new List <Mymenu>();
foreach (var item in ctx.Menus.ToList())
{
if (Session["Rname"].ToString() == item.Rname)
{
Mymenu u = new Mymenu();
u.Itemsname = item.Itemsname;
u.price = (int)item.price;
u.Itemimage = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(item.Itemimage));
listMenu.Add(u);
}
}
return(Json(listMenu,
JsonRequestBehavior.AllowGet));
}
public JsonResult GetHistory2()
{
RMSEntities ctx = new RMSEntities();
var data = (from a in ctx.OrderedFoods.ToList()
where (a.Userid == Session["Userid"].ToString())
select new
{
a.Userid,
a.Rname,
a.Itemname,
a.Price,
a.Quantity,
Date = a.Date.ToString()
//a.DaTi
//DaTi = a.DaTi.ToString().Substring(
// 0, a.ReleaseDate.ToString().IndexOf(' ')),
//DaTi = a.DaTi.ToString()
}).ToList();
ctx.SaveChanges();
return(Json(data, JsonRequestBehavior.AllowGet));
}
public JsonResult Menu5(Menu f1)
{
RMSEntities ctx = new RMSEntities();
List <Mymenu> listMenu = new List <Mymenu>();
foreach (var item in ctx.Menus.ToList())
{
if (f1.Rname == item.Rname)
{
Mymenu m = new Mymenu();
m.Itemsname = item.Itemsname;
m.price = (int)item.price;
m.Itemimage = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(item.Itemimage));
m.Foodtype = item.Foodtype;
listMenu.Add(m);
}
}
var data1 = from a in ctx.Menus.ToList() where (a.Rname == f1.Rname) select a.Itemsname;
return(Json(data1.ToList(),
JsonRequestBehavior.AllowGet));
}
public JsonResult Branch3(Branch f1)
{
RMSEntities ctx = new RMSEntities();
List <Mybranch> listM = new List <Mybranch>();
foreach (var item in ctx.Branches.ToList())
{
if (f1.Rname == item.Rname && f1.bcity == item.bcity && f1.Location == item.Location)
{
Mybranch m = new Mybranch();
m.Rname = item.Rname;
m.bcity = item.bcity;
m.Location = item.Location;
m.bimage = String.Format("data:image/jpg;base64,{0}", Convert.ToBase64String(item.bimage));
m.bphonenum = item.bphonenum;
listM.Add(m);
}
}
var data1 = from a in ctx.Branches.ToList() where a.Rname == f1.Rname && a.bcity == f1.bcity && a.Location == f1.Location select new { a.bphonenum, a.bimage };
return(Json(listM, JsonRequestBehavior.AllowGet));
}
