public JsonResult SaveProduct(Product product) { POS_TutorialEntities db = new POS_TutorialEntities(); bool isSuccess = true; if (product.ProductId > 0) { db.Entry(product).State = EntityState.Modified; } else { product.Status = 1; product.Name = "aaa"; db.Products.Add(product); } try { db.SaveChanges(); } catch (Exception) { isSuccess = false; } return(Json(isSuccess, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveInvoiceSale(Sale sale, List <SalesDetail> salesDetails) { PointOfSale.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); POS_TutorialEntities db = new POS_TutorialEntities(); retMessage.IsSuccess = true; foreach (var item in salesDetails) { sale.SalesDetails.Add(new SalesDetail { ProductId = item.ProductId, UnitPrice = item.UnitPrice, Quantity = item.Quantity, LineTotal = item.LineTotal }); var prd = db.ProductStocks.Where(x => x.ProductId == item.ProductId && x.Quantity > 0).FirstOrDefault(); prd.Quantity = prd.Quantity - item.Quantity; db.Entry(prd).State = EntityState.Modified; } db.Sales.Add(sale); retMessage.Messagae = "Save Success!"; try { db.SaveChanges(); } catch (Exception) { retMessage.IsSuccess = false; } return(Json(retMessage, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveProductStock(ProductStock stock) { PointOfSale.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); POS_TutorialEntities db = new POS_TutorialEntities(); retMessage.IsSuccess = true; if (stock.ProductQtyId > 0) { db.Entry(stock).State = EntityState.Modified; retMessage.Messagae = "Update Success!"; } else { db.ProductStocks.Add(stock); retMessage.Messagae = "Save Success!"; } try { db.SaveChanges(); } catch (Exception) { retMessage.IsSuccess = false; } return(Json(retMessage, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveUser(User user) { POS_TutorialEntities db = new POS_TutorialEntities(); bool isSuccess = true; if (user.UserId > 0) { db.Entry(user).State = EntityState.Modified; } else { user.Status = 1; user.Password = AppHelper.GetMd5Hash(user.Password); db.Users.Add(user); } try { db.SaveChanges(); } catch (Exception) { isSuccess = false; } return(Json(isSuccess, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInvoiceBySalesId(int salesId) { POS_TutorialEntities db = new POS_TutorialEntities(); List <Sale> dataList = (from sd in db.SalesDetails.ToList() join s in db.Sales on sd.SalesId equals s.SalesId where sd.SalesId == salesId select new Sale { SalesId = (int)sd.SalesId, OrderNo = s.OrderNo, CustomerName = s.CustomerName, CustomerPhone = s.CustomerPhone, CustomerAddress = s.CustomerAddress, OrderDate = s.OrderDate, PaymentMethod = s.PaymentMethod, TotalAmout = s.TotalAmout, SalesDetailId = sd.SalesDetailId, ProductId = sd.ProductId, UnitPrice = sd.UnitPrice, Subtotal = s.Subtotal, Quantity = sd.Quantity, LineTotal = sd.LineTotal, DiscountParcentage = s.DiscountParcentage, VatParcentage = s.VatParcentage }).ToList(); return(Json(dataList, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllUser() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Users.Where(x => x.Status == 1).ToList(); return(Json(dataList, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllCategory() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Categories.Where(x => x.Status == 1).ToList(); return(Json(dataList, JsonRequestBehavior.AllowGet)); //string json = JsonConvert.SerializeObject(dataList, Formatting.None); //return Json(json, JsonRequestBehavior.AllowGet); }
public JsonResult GetAllBatch() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Batches.ToList(); var modefiedData = dataList.Select(x => new { BatchId = x.BatchId, BatchName = x.BatchName, }).ToList(); return(Json(modefiedData, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllGetegory() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Categories.Where(x => x.Status == 1).ToList(); var data = dataList.Select(x => new { CategoryId = x.CategoryId, Name = x.Name, Status = x.Status }); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllProduct() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Products.Include("Category").ToList(); var modefiedData = dataList.Select(x => new { ProductId = x.ProductId, CategoryId = x.CategoryId, Name = x.Name, Status = x.Status, CategoryName = x.Category.Name }).ToList(); return(Json(modefiedData, JsonRequestBehavior.AllowGet)); }
public JsonResult EditInvoiceSale(Sale sale, List <SalesDetail> salesDetails, List <int> deleted) { PointOfSale.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); POS_TutorialEntities db = new POS_TutorialEntities(); retMessage.IsSuccess = true; if (deleted != null) { foreach (var item in deleted) { var data = db.SalesDetails.Where(x => x.SalesDetailId == item).SingleOrDefault();; db.SalesDetails.Remove(data); } } foreach (var item in salesDetails) { if (item.SalesDetailId > 0) { db.Entry(item).State = EntityState.Modified; retMessage.Messagae = "Update Success!"; } else { sale.SalesDetails.Add(new SalesDetail { ProductId = item.ProductId, UnitPrice = item.UnitPrice, Quantity = item.Quantity, LineTotal = item.LineTotal }); var prd = db.ProductStocks.Where(x => x.ProductId == item.ProductId && x.Quantity > 0).FirstOrDefault(); prd.Quantity = prd.Quantity - item.Quantity; db.Entry(prd).State = EntityState.Modified; db.Sales.Add(sale); retMessage.Messagae = "Save Success!"; } } try { db.SaveChanges(); } catch (Exception) { retMessage.IsSuccess = false; } return(Json(retMessage, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllSales() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.Sales.ToList(); var modefiedData = dataList.Select(x => new { SalesId = x.SalesId, OrderNo = x.OrderNo, CustomerName = x.CustomerName, CustomerPhone = x.CustomerPhone, CustomerAddress = x.CustomerAddress, OrderDate = x.OrderDate, TotalAmout = x.TotalAmout }).ToList(); return(Json(modefiedData, JsonRequestBehavior.AllowGet)); }
public override void OnAuthorization(AuthorizationContext authorizationContext) { POS_TutorialEntities db = new POS_TutorialEntities(); string username = Convert.ToString(System.Web.HttpContext.Current.Session["Username"]); string role = Convert.ToString(System.Web.HttpContext.Current.Session["Role"]); string actionName = authorizationContext.ActionDescriptor.ActionName; string controllerName = authorizationContext.ActionDescriptor.ControllerDescriptor.ControllerName; string tag = controllerName + actionName; // tag = controller + action // tag = "HOME" + "Index" if (authorizationContext.ActionDescriptor.IsDefined(typeof(AllowAnonymousAttribute), true) || authorizationContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(AllowAnonymousAttribute), true)) { // Don't check for authorization as AllowAnonymous filter is applied to the action or controller return; } // Check for authorization if (System.Web.HttpContext.Current.Session["Username"] == null) { authorizationContext.Result = new HttpUnauthorizedResult(); } if (username != null && username != "") { bool isPermitted = false; var viewPermission = db.RolePermissions.Where(x => x.Role == role && x.Tag == tag).SingleOrDefault(); if (viewPermission != null) { isPermitted = true; } if (isPermitted == false) { authorizationContext.Result = new RedirectToRouteResult( new RouteValueDictionary { { "controller", "Home" }, { "action", "AccessDenied" } }); } } }
public JsonResult GetAllProductStocks() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = db.ProductStocks.Include("Product").Include("Batch").ToList(); var modefiedData = dataList.Select(x => new { ProductQtyId = x.ProductQtyId, ProductId = x.ProductId, ProductName = x.Product.Name, Quantity = x.Quantity, BatchId = x.BatchId, BatchName = x.Batch.BatchName, PurchasePrice = x.PurchasePrice, SalesPrice = x.SalesPrice }).ToList(); return(Json(modefiedData, JsonRequestBehavior.AllowGet)); }
public JsonResult CheckLogin(string username, string password) { POS_TutorialEntities db = new POS_TutorialEntities(); string md5StringPassword = AppHelper.GetMd5Hash(password); var dataItem = db.Users.Where(x => x.Username == username && x.Password == md5StringPassword).SingleOrDefault(); bool isLogged = true; if (dataItem != null) { Session["Username"] = dataItem.Username; Session["Role"] = dataItem.Role; isLogged = true; } else { isLogged = false; } return(Json(isLogged, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllProduct() { POS_TutorialEntities db = new POS_TutorialEntities(); var dataList = (from prd in db.Products.Include("Category").ToList() join stk in db.ProductStocks on prd.ProductId equals stk.ProductId where stk.Quantity > 0 select new { ProductId = prd.ProductId, CategoryId = prd.CategoryId, Name = prd.Name, Status = prd.Status, CategoryName = prd.Category.Name, PurchasePrice = stk.PurchasePrice, SalesPrice = stk.SalesPrice }).ToList(); return(Json(dataList, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveBatch(Batch batch) { PointOfSale.Helper.AppHelper.ReturnMessage retMessage = new AppHelper.ReturnMessage(); POS_TutorialEntities db = new POS_TutorialEntities(); retMessage.IsSuccess = true; if (batch.BatchId > 0) { db.Entry(batch).State = EntityState.Modified; retMessage.Messagae = "Update Success!"; } else { batch.BatchName = batch.BatchName + db.Batches.Count(); var batchData = db.Batches.Where(x => x.BatchName.Equals(batch.BatchName)).SingleOrDefault(); if (batchData == null) { db.Batches.Add(batch); retMessage.Messagae = "Save Success!"; } else { retMessage.IsSuccess = false; retMessage.Messagae = "This batch already exist!Please refresh and again try!"; } } try { db.SaveChanges(); } catch (Exception) { retMessage.IsSuccess = false; } return(Json(retMessage, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveCategory(Category cat) { POS_TutorialEntities db = new POS_TutorialEntities(); bool isSuccess = true; if (cat.CategoryId > 0) { db.Entry(cat).State = EntityState.Modified; } else { cat.Status = 1; db.Categories.Add(cat); } try { db.SaveChanges(); } catch (Exception) { isSuccess = false; } return(Json(isSuccess, JsonRequestBehavior.AllowGet)); }