public JsonResult SaveData(SiteUser model)
{
model.IsValid = false;
db.SiteUsers.Add(model);
db.SaveChanges();
BuildEmailTemplate(model.ID);
return(Json("Registration Successfull", JsonRequestBehavior.AllowGet));
}
// Save data in the product database
public JsonResult CreateStore(StoreViewModel storeViewModel)
{
Store store = new Store();
store.Name = storeViewModel.Name;
store.Address = storeViewModel.Address;
db.Stores.Add(store);
db.SaveChanges();
return(Json(storeViewModel, JsonRequestBehavior.AllowGet));
}
// Save data in the product database
public JsonResult CreateProduct(ProductViewModel productViewModel)
{
Product product = new Product();
product.Name = productViewModel.Name;
product.Price = productViewModel.Price;
db.Products.Add(product);
db.SaveChanges();
return(Json(productViewModel, JsonRequestBehavior.AllowGet));
}
// Save data in the Customer database
public JsonResult CreateCustomer(CustomerViewModel customerViewModel)
{
Customer customer = new Customer();
customer.Name = customerViewModel.Name;
customer.Address = customerViewModel.Address;
db.Customers.Add(customer);
db.SaveChanges();
return(Json(customerViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Create([Bind(Include = "ID,Name,Gender,Email,Salary")] Employee employee)
{
if (ModelState.IsValid)
{
db.Employees.Add(employee);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(employee));
}
public ActionResult Create([Bind(Include = "OrderId,CommodityID,CommodityAmount")] SellOrder sellOrder)
{
if (ModelState.IsValid)
{
db.SellOrders.Add(sellOrder);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sellOrder));
}
public ActionResult Create([Bind(Include = "CommodityId,CommodityName,CommodityPrice,CommodityAmount,CommodityImage,CommodityType")] Commodity commodity)
{
if (ModelState.IsValid)
{
db.Commodities.Add(commodity);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(commodity));
}
public ActionResult Create([Bind(Include = "Email,Name,Password,Status,Rank")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "id,Name,City,Age")] Dbfirstapproach dbfirstapproach)
{
if (ModelState.IsValid)
{
db.Dbfirstapproach.Add(dbfirstapproach);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dbfirstapproach));
}
// POST: ProductSolds/Create
public JsonResult CreateSales(SalesViewModel salesViewModel)
{
ProductSold sales = new ProductSold();
sales.CustomerID = salesViewModel.CustomerID;
sales.ProductID = salesViewModel.ProductID;
sales.StoreID = salesViewModel.StoreID;
sales.DateSold = salesViewModel.DateSold;
db.ProductSolds.Add(sales);
db.SaveChanges();
return(Json(salesViewModel, JsonRequestBehavior.AllowGet));
}
public ActionResult Index(MemberModel model)
{
string FileName = Path.GetFileNameWithoutExtension(model.ImageFile.FileName);
string FileExtension = Path.GetExtension(model.ImageFile.FileName);
FileName = DateTime.Now.ToString("yyyyMMdd") + "-" + FileName.Trim() + FileExtension;
string UploadPath = ConfigurationManager.AppSettings["UserUploadPath"].ToString();
model.ImagePath = UploadPath + FileName;
model.ImageFile.SaveAs(model.ImagePath);
tblMember member = new tblMember();
member.ImagePath = model.ImagePath;
member.MemberName = model.Name;
member.PhoneNumber = model.PhoneNumber;
using (MVCEntities entities = new MVCEntities())
{
entities.tblMembers.Add(member);
entities.SaveChanges();
}
return(View());
}
public ActionResult AddProducts(Product product)
{
if (ModelState.IsValid)
{
Product newProduct = new Product
{
Name = product.Name,
Price = product.Price
};
db.Products.Add(newProduct);
db.SaveChanges();
}
var allProducts = db.Products.Select(x => new { x.Id, x.Name, x.Price }).ToList();
return(Json(new { allProducts, success = "true" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddCustomers(Customer customer)
{
if (ModelState.IsValid)
{
Customer newCustomer = new Customer
{
Name = customer.Name,
Address = customer.Address
};
db.Customers.Add(newCustomer);
db.SaveChanges();
}
var allCustomers = db.Customers.Select(x => new { x.Id, x.Name, x.Address }).ToList();
return(Json(new { allCustomers, success = "true" }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddStores(Store store)
{
if (ModelState.IsValid)
{
Store newStore = new Store
{
Name = store.Name,
Address = store.Address
};
db.Stores.Add(newStore);
db.SaveChanges();
}
var allStores = db.Stores.Select(x => new { x.Id, x.Name, x.Address }).ToList();
return(Json(new { allStores, success = "true" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(int id)
{
MVCEntities db = new MVCEntities();
var data = db.employees.Where(x => x.id == id).First();
db.employees.Remove(data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddSales(Sale sale)
{
if (ModelState.IsValid)
{
Sale newSale = new Sale
{
CustomerId = sale.CustomerId,
ProductId = sale.ProductId,
StoreId = sale.StoreId,
DateSold = sale.DateSold
};
db.Sales.Add(newSale);
db.SaveChanges();
}
//var allSales = db.Sales.Select(x => new { x.CustomerId, x.ProductId, x.StoreId, x.DateSold }).ToList();
return(Json(new { /*allSales,*/ success = "true" }, JsonRequestBehavior.AllowGet));
}
public ActionResult SignUp(string Email, string Name, string Password)
{
User user = db.Users.Find(Email);
if (user != null)
{
ViewBag.ErrorMessage = "User already exist!";
return(View("SignUp"));
}
user = new User();
user.Email = Email;
user.Name = Name;
user.Password = Password;
user.Rank = 1;
user.Status = 1;
db.Users.Add(user);
db.SaveChanges();
return(View("Index"));
}
public ActionResult Create([Bind(Include = "PurchaseOrderId,CommodityId,CommodityAmount")] PurchaseOrder purchaseOrder)
{
if (ModelState.IsValid)
{
db.PurchaseOrders.Add(purchaseOrder);
db.SaveChanges();
}
ViewBag.PurchaseOrderId = purchaseOrder.PurchaseOrderId;
ViewBag.ID = GetCommodityID();
ViewBag.Commodity = GetCommodityFromOrder(purchaseOrder.PurchaseOrderId);
Commodity cc = db.Commodities.Find(purchaseOrder.CommodityId);
cc.CommodityAmount += purchaseOrder.CommodityAmount;
db.SaveChanges();
//foreach (var item in commdity.ToList())
//{
// System.Diagnostics.Debug.WriteLine(item.CommodityName);
//}
return(View(purchaseOrder));
}
public ActionResult Register(Register register)
{
db.Registers.Add(register);
int i = db.SaveChanges();
if (i > 0)
{
return(RedirectToAction("Login"));
}
else
{
return(View(register));
}
}
public ActionResult Edit(employee model)
{
MVCEntities db = new MVCEntities();
if (ModelState.IsValid)
{
var data = db.employees.Where(x => x.id == model.id).First();
data.Name = model.Name;
data.Gender = model.Gender;
data.Email = model.Email;
data.Age = model.Age;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Insertdetails(Mysite ms)
{
using (var dbctx = new MVCEntities())
{
dbctx.tbl_site.Add(new tbl_site
{
username = ms.username,
city = ms.city,
state = ms.state,
country = ms.country
});
dbctx.SaveChanges();
}
return(RedirectToAction("DisplayAll"));
}
public ActionResult InsertEmployee(EmployeeModel model)
{
try
{
MVCEntities db = new MVCEntities();
employee employ = new employee();
employ.Name = model.Name;
employ.Gender = model.Gender;
employ.Email = model.Email;
employ.Age = model.Age;
db.employees.Add(employ);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Index"));
}
public ActionResult Registration(UserDb u)
{
if (ModelState.IsValid)
{
#region//Email is already Exist
var isExist = IsEmailExist(u.EmailID);
if (isExist)
{
ViewBag.emailexist = "email already exist";
return(View(u));
}
#endregion
}
#region //save to database
using (MVCEntities dc = new MVCEntities())
{
dc.UserDbs.Add(u);
dc.SaveChanges();
}
#endregion
ViewBag.success = "registered successful";
return(View(u));
}
public void Save()
{
_context.SaveChanges();
}
