// GET: SalesReport
public ActionResult Index()
{
var db1 = new SainiShopEntities1();
var query = db1.ProductMasters.Select(c => new SelectListItem
{
Value = c.Product_id.ToString(),
Text = c.Product_name,
//Selected = c.Product_id.Equals(3)
}).ToList();
var query1 = db1.WattMasters.Select(c => new SelectListItem
{
Value = c.product_id.ToString(),
Text = c.watt.ToString(),
}).ToList();
var model = new SalesDetailModel {
Productname = query.ToList(), wattmain = query1.ToList()
};
return(View(model));
//return View();
}
public JsonResult GetPurchaseHome(string suplid, string Productname, string Quantity, string Desc, decimal Price, string Addcomments)
{
PurchaseDetail obj1 = new PurchaseDetail();
obj1.SupplierName = suplid;
obj1.product_name = Productname;
obj1.Description = Desc;
obj1.Quantity = Quantity;
obj1.price = Price;
obj1.additionalComment = Addcomments;
obj1.Description = Desc;
obj1.PurchaseDate = DateTime.Now.ToString();
//obj.watt = Watts;
//obj.Product_name = Item;
//obj.Product_price = Price;
//obj.Quantity = Quantity;
//obj.Amount = TotalAmo;
//obj.sales_date = DateTime.Now.ToString();
//obj.AdditionalComments = Addcomments;
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.PurchaseDetails.Add(obj1);
objDb.SaveChanges();
}
var response = new Response(true, "Contact Successfully Submitted");
return(Json(response));
}
public ActionResult Register1(RegiterModal regiterModal)
{
try
{
if (ModelState.IsValid)
{
Regitration regi = new Regitration();
//regi.username = regiterModal.username;
//regi.UserPassword = regiterModal.UserPassword;
//regi.Email = regiterModal.Email;
//regi.mobile = regiterModal.mobile;
//regi.registerdate = DateTime.Now.ToString();
//regi.city = regiterModal.city;
var finalData = Mapper.Map <RegiterModal, Regitration>(regiterModal);
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.Regitrations.Add(finalData);
objDb.SaveChanges();
}
}
return(View());
}
catch (Exception ex)
{
log.Error("Page Load failed : " + ex.InnerException + ex.StackTrace);
return(View());
}
}
// GET: Cart
public ActionResult Index()
{
using (SainiShopEntities1 obj = new SainiShopEntities1())
{
var model = obj.Product_Master?.ToList();
return(View(model));
}
}
public override string[] GetRolesForUser(string username)
{
SainiShopEntities1 objDb = new SainiShopEntities1();
string s = objDb.Users.Where(x => x.Username == username).FirstOrDefault().Role;
string[] result = { s };
return(result);
}
public JsonResult TotalAmount(string Unitprice, string Quantity, int Productid)
{
SainiShopEntities1 objDb = new SainiShopEntities1();
var margin = objDb.ProductMasters.Where(z => z.Product_id == Productid).Select(x => x.marginPerUnit).FirstOrDefault();
var response = TotalPrice(Unitprice, Quantity, margin);
return(Json(response));
}
public ActionResult salesDataTable([ModelBinder(typeof(DataTablesBinder))] IDataTablesRequest requestModel)
{
SainiShopEntities1 objDb = new SainiShopEntities1();
//var records = objDb.Sales_Details;
IQueryable <Sales_Details> query = objDb.Sales_Details;
var totalCount = query.Count();
#region Filtering
// Apply filters for searching
if (requestModel.Search.Value != string.Empty)
{
var value = requestModel.Search.Value.Trim();
query = query.Where(p => p.Product_name.Contains(value) ||
p.Quantity.Contains(value) ||
p.sales_date.Contains(value) ||
p.Product_price.Contains(value)
);
}
var filteredCount = query.Count();
#endregion Filtering
#region Sorting
// Sorting
var sortedColumns = requestModel.Columns.GetSortedColumns();
var orderByString = String.Empty;
foreach (var column in sortedColumns)
{
orderByString += orderByString != String.Empty ? "," : "";
orderByString += (column.Data) + (column.SortDirection == Column.OrderDirection.Ascendant ? " asc" : " desc");
}
query = query.OrderBy(x => x.sales_date ?? "Product_price asc");//orderByString == string.Empty ? "Product_price asc" : orderByString);
#endregion Sorting
// Paging
query = query.Skip(requestModel.Start).Take(requestModel.Length);
var data = query.Select(asset => new
{
Id = asset.id,
ProductName = asset.Product_name,
ProductPrice = asset.Product_price,
SalesDate = asset.sales_date,
Quantity = asset.Quantity
}).ToList();
return(Json(new DataTablesResponse(requestModel.Draw, data, filteredCount, totalCount), JsonRequestBehavior.AllowGet));
}
public IQueryable <Product_Summary> GetProduct(int id)
{
SainiShopEntities1 obj = new SainiShopEntities1();
var model = obj.Product_Master.Where(x => x.P_id == id).Join(obj.Cart_Details,
c => c.P_id,
o => o.Product_Categoris,
(c, o) => new Product_Summary
{
Produc_id = o.P_id, // .P_id,
Product_Name = c.Product_Name,
Sub_Product_Name = o.Sub_Product_Name,
Product_Price = o.Sub_Product_Price
});
return(model);
}
//public ActionResult GetPurchaseHome(PurchasemasterModal request)
//{
// PurchaseDetail obj1 = new PurchaseDetail();// {Product_name=request.product_name, };
// obj1.SupplierName = request.SupplierName;
// // obj1.product_name = request.product_name;
// obj1.Quantity = request.Quantity;
// obj1.price = request.price;
// using (SainiShopEntities1 objDb = new SainiShopEntities1())
// {
// objDb.PurchaseDetails.Add(obj1);
// //objDb.ProductMasters.Add(obj1);
// objDb.SaveChanges();
// }
// return View();
//}
public ActionResult fillProductName(int supplierid)
{
SainiShopEntities1 objDb = new SainiShopEntities1();
var sup = (from supm in objDb.SupplierMasters
join prom in objDb.ProductMasters
on supm.SupplierId equals prom.Product_id
where supm.SupplierId == supplierid
select new
{
id = supm.SupplierId,
sup = prom.Product_name,
description = prom.Description,
//price = prom.UnitperPrice
}).ToList();
return(Json(sup, JsonRequestBehavior.AllowGet));
}
public ActionResult FillWatt(int Productid)
{
SainiShopEntities1 objDb = new SainiShopEntities1();
var watt = (from prod in objDb.ProductMasters
join wat in objDb.WattMasters
on prod.Product_id equals wat.product_id
where prod.Product_id == Productid
select new
{
id = prod.Product_id,
watt = wat.watt,
description = prod.Description,
price = prod.UnitperPrice
}).ToList();
return(Json(watt, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPurchaseHome()
{
var purchasemasterModal = new PurchasemasterModal();
var db1 = new SainiShopEntities1();
var query = db1.SupplierMasters.Select(c => new SelectListItem
{
Value = c.SupplierId.ToString(),
Text = c.SupplierName,
//Selected = c.Product_id.Equals(3)
}).ToList();
var model = new PurchasemasterModal {
supplier_Name = query.ToList()
};
return(View(model));
}
public bool IsValid(string _username, string _password)
{
var encodepassword = Encode(_password);
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
User users = (from u in objDb.Users
where u.Username.Equals(_username) && u.Password.Equals(encodepassword)
select u).FirstOrDefault();
if (users != null)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult Index()
{
var use = User.Identity.Name.ToString();
var ause = User.Identity;
var db1 = new SainiShopEntities1();
var query = db1.ProductMasters.Select(c => new SelectListItem
{
Value = c.Product_id.ToString(),
Text = c.Product_name,
//Selected = c.Product_id.Equals(3)
}).ToList();
var model = new SalesDetailModel {
Productname = query.ToList()
};
return(View(model));
}
public ActionResult Register1(RegiterModal regiterModal)
{
if (ModelState.IsValid)
{
Regitration regi = new Regitration();
regi.username = regiterModal.username;
regi.UserPassword = regiterModal.UserPassword;
regi.Email = regiterModal.Email;
regi.mobile = regiterModal.mobile;
regi.registerdate = DateTime.Now.ToString();
regi.city = regiterModal.city;
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.Regitrations.Add(regi);
objDb.SaveChanges();
}
}
return(View());
}
public JsonResult Index(string Quantity, string Item, int Watts, string TotalAmo, string Desc, string Price, string Addcomments)
{
Sales_Details obj = new Sales_Details();
obj.Description = Desc;
obj.watt = Watts;
obj.Product_name = Item;
obj.Product_price = Price;
obj.Quantity = Quantity;
obj.Amount = TotalAmo;
obj.sales_date = DateTime.Now.ToString();
obj.AdditionalComments = Addcomments;
using (SainiShopEntities1 objDb = new SainiShopEntities1())
{
objDb.Sales_Details.Add(obj);
objDb.SaveChanges();
}
var response = new Response(true, "Contact Successfully Submitted");
return(Json(response));
}
