// GET: BattReturn
public ActionResult BattReturnIndex()
{
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Employee> list = db.Employees.ToList();
ViewBag.EmpName = new SelectList(list, "emp_id", "emp_name");
List <Customer> listi = db.Customers.ToList();
ViewBag.CustName = new SelectList(listi, "cust_id", "cust_name");
List <Size> listl = db.Sizes.ToList();
ViewBag.SizeName = new SelectList(listl, "size_id", "size1");
List <Supplier> listp = db.Suppliers.ToList();
ViewBag.SupplierName = new SelectList(listp, "supplier_id", "Supplier_name");
List <Terminal> listt = db.Terminals.ToList();
ViewBag.TerminalName = new SelectList(listt, "terminal_id", "terminal_name");
List <Height> listy = db.Heights.ToList();
ViewBag.HeightName = new SelectList(listy, "height_id", "height_name");
return(View());
}
// GET: RimySale
public ActionResult RimSaleIndex()
{
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Rim_hub> list = db.Rim_hub.ToList();
ViewBag.HubName = new SelectList(list, "hub_id", "hub_name");
List <Rim_size> liste = db.Rim_size.ToList();
ViewBag.SizeNo = new SelectList(liste, "size_id", "size_number");
List <Rim_Type> listp = db.Rim_Type.ToList();
ViewBag.TypeName = new SelectList(listp, "type_id", "type_name");
List <Rim_Peg> listj = db.Rim_Peg.ToList();
ViewBag.PegNo = new SelectList(listj, "peg_id", "peg_no");
List <Customer> listiw = db.Customers.ToList();
ViewBag.CustName = new SelectList(listiw, "cust_id", "cust_name");
List <Employee> listi = db.Employees.ToList();
ViewBag.EmpName = new SelectList(listi, "emp_id", "emp_name");
return(View());
}
public ActionResult BattReturnSave(BattReturn model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Batt_Return batt_ret = new Batt_Return();
batt_ret.return_date = model.ReturnDate;
batt_ret.purchase_date = model.PurchaseDate;
batt_ret.emp_id = model.Emp_id;
batt_ret.cust_id = model.Cust_id;
batt_ret.size_id = model.Size_id;
batt_ret.height_id = model.Height_id;
batt_ret.terminal_id = model.Terminal_id;
batt_ret.supplier_id = model.Supplier_id;
batt_ret.batt_quant_return = model.QuantityReturn;
db.Batt_Return.Add(batt_ret);
db.SaveChanges();
int latestProdId = batt_ret.batt_return_id;
TempData["status"] = "Battery Return Successfully Submitted";
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("BattReturnIndex"));
}
public ActionResult AddyRimSave(AddyRim model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Rim addRim = new Rim();
addRim.peg_id = model.Peg_id;
addRim.hub_id = model.Hub_id;
addRim.type_id = model.Type_id;
addRim.size_id = model.Size_id;
addRim.Date = model.Date;
addRim.Rim_description = model.Rim_description;
addRim.Rim_quantity = model.Rim_quantity;
addRim.Rim_unit_price = model.Rim_unit_price;
db.Rims.Add(addRim);
db.SaveChanges();
int latestProdId = addRim.rim_id;
TempData["status"] = "Success";
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("AddyRimIndex"));
}
public ActionResult BattAddSave(AddyBattery model)
{
try
{
//Assigning the data value
SalesLayanEntities14 db = new SalesLayanEntities14();
Battery addBatt = new Battery();
addBatt.terminal_id = model.Terminal_id;
addBatt.supplier_id = model.Supplier_id;
addBatt.height_id = model.Height_id;
addBatt.batt_id = model.Batt_id;
addBatt.Batt_quantity = model.Batt_quantity;
addBatt.size_id = model.Size_id;
addBatt.Batt_Unit_Price = model.Batt_Unit_Price;
addBatt.Date = model.Date;
addBatt.Batt_description = model.Batt_description;
db.Batteries.Add(addBatt);
db.SaveChanges();
int latestProdId = addBatt.batt_id;
TempData["status"] = "Success";
}
catch (Exception ex)
{
throw ex;
}
//return back to the index page
return(RedirectToAction("BattAddIndex"));
}
public ActionResult SaveRecord(ProductForm model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Product prod = new Product();
prod.prod_name = model.Prod_name;
prod.prod_model = model.Prod_model;
prod.prod_quantity = model.Prod_quantity;
prod.prod_description = model.Prod_description;
prod.prod_unit_cost_price = model.Prod_unit_cost_price;
prod.cat_id = model.Cat_id;
db.Products.Add(prod);
db.SaveChanges();
int latestProdId = prod.prod_id;
TempData["status"] = "Success";
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Product_Category> list = db.Product_Category.ToList();
ViewBag.ProductName = new SelectList(list, "cat_id", "cat_name");
return(View());
}
public ActionResult RimReturnSave(RimReturn model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Rim_Return Rim_ret = new Rim_Return();
Rim_ret.rim_return_date = model.ReturnDate;
Rim_ret.rim_purchase_date = model.PurchaseDate;
Rim_ret.emp_id = model.Emp_id;
Rim_ret.cust_id = model.Cust_id;
Rim_ret.peg_id = model.Peg_id;
Rim_ret.hub_id = model.Hub_id;
Rim_ret.type_id = model.Type_id;
Rim_ret.size_id = model.Size_id;
Rim_ret.rim_quant_return = model.RimQuantReturn;
db.Rim_Return.Add(Rim_ret);
db.SaveChanges();
int latestProdId = Rim_ret.rim_return_id;
TempData["status"] = "Battery Return Successfully Submitted";
string sql = "update Rims set Rim_quantity = Rim_quantity + @sold_quantity where hub_id= @hub_id and peg_id = @peg_id and type_id = @type_id and size_id = @size_id";
using (var sqlCon = new SqlConnection(@"Data Source=servername;Initial Catalog=SalesLayan;User ID=sa;Password=password;"))
using (var cmd = new SqlCommand(sql, sqlCon))
{
//Have to guess at types and lengths here. Use actual types and lengths from the database
cmd.Parameters.Add("@sold_quantity", SqlDbType.SmallInt).Value = model.RimQuantReturn;
cmd.Parameters.Add("@hub_id", SqlDbType.SmallInt).Value = model.Hub_id;
cmd.Parameters.Add("@peg_id", SqlDbType.SmallInt).Value = model.Peg_id;
cmd.Parameters.Add("@type_id", SqlDbType.SmallInt).Value = model.Type_id;
cmd.Parameters.Add("@size_id", SqlDbType.SmallInt).Value = model.Size_id;
sqlCon.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("RimReturnIndex"));
}
public ActionResult RimSaleSaves(RimSale model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Rim_Sale_Record RimSales = new Rim_Sale_Record();
RimSales.hub_id = model.Hub_id;
RimSales.size_id = model.Size_id;
RimSales.peg_id = model.Peg_id;
RimSales.type_id = model.Type_id;
RimSales.emp_id = model.Emp_id;
RimSales.cust_id = model.Cust_id;
RimSales.rim_quantity_purchase = model.Rim_quantity_purchase;
RimSales.rim_date_sold = model.Rim_date_sold;
RimSales.rim_unit_price_sold = model.Rim_unit_price_sold;
db.Rim_Sale_Record.Add(RimSales);
db.SaveChanges();
int latestProdId = RimSales.rim_sales_id;
TempData["status"] = "Success";
string sql = "update Rims set Rim_quantity = Rim_quantity - @sold_quantity where hub_id= @hub_id and peg_id = @peg_id and type_id = @type_id and size_id = @size_id";
using (var sqlCon = new SqlConnection(@"Data Source=sourcename;Initial Catalog=SalesLayan;User ID=sa;Password=Password;"))
using (var cmd = new SqlCommand(sql, sqlCon))
{
//Have to guess at types and lengths here. Use actual types and lengths from the database
cmd.Parameters.Add("@sold_quantity", SqlDbType.SmallInt).Value = model.Rim_quantity_purchase;
cmd.Parameters.Add("@hub_id", SqlDbType.SmallInt).Value = model.Hub_id;
cmd.Parameters.Add("@peg_id", SqlDbType.SmallInt).Value = model.Peg_id;
cmd.Parameters.Add("@type_id", SqlDbType.SmallInt).Value = model.Type_id;
cmd.Parameters.Add("@size_id", SqlDbType.SmallInt).Value = model.Size_id;
sqlCon.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("RimSaleIndex"));
}
public ActionResult BattSaleSave(BattSales model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
batt_sales_record battSales = new batt_sales_record();
battSales.supplier_id = model.Supplier_id;
battSales.size_id = model.Size_id;
battSales.terminal_id = model.Terminal_id;
battSales.height_id = model.Height_id;
battSales.emp_id = model.Emp_id;
battSales.cust_id = model.Cust_id;
battSales.batt_quantity_purchased = model.Batt_quantity_purchased;
battSales.batt_unit_price_purchased = model.Batt_unit_price_purchased;
battSales.batt_date_sold = model.Batt_date_sold;
db.batt_sales_record.Add(battSales);
db.SaveChanges();
int latestProdId = battSales.batt_sale_id;
TempData["status"] = "Success";
string sql = "update battery set batt_quantity = batt_quantity - @sold_quantity where supplier_id= @supplier_id and size_id = @size and terminal_id = @terminal_id and height_id = @height_id";
using (var sqlCon = new SqlConnection(@"Data Source=servername;Initial Catalog=SalesLayan;User ID=sa;Password=password;"))
using (var cmd = new SqlCommand(sql, sqlCon))
{
//Have to guess at types and lengths here. Use actual types and lengths from the database
cmd.Parameters.Add("@sold_quantity", SqlDbType.SmallInt).Value = model.Batt_quantity_purchased;
cmd.Parameters.Add("@supplier_id", SqlDbType.SmallInt).Value = model.Supplier_id;
cmd.Parameters.Add("@terminal_id", SqlDbType.SmallInt).Value = model.Terminal_id;
cmd.Parameters.Add("@height_id", SqlDbType.SmallInt).Value = model.Height_id;
cmd.Parameters.Add("@size", SqlDbType.SmallInt).Value = model.Size_id;
sqlCon.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("BattSaleIndex"));
}
public ActionResult SalesIndex()
{
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Product> list = db.Products.ToList();
ViewBag.SalesName = new SelectList(list, "prod_id", "prod_name");
List <Employee> listi = db.Employees.ToList();
ViewBag.EmpName = new SelectList(listi, "emp_id", "emp_name");
List <Customer> listiw = db.Customers.ToList();
ViewBag.CustName = new SelectList(listiw, "cust_id", "cust_name");
return(View());
}
public ActionResult SaveSales(SalesForm model)
{
try
{
SalesLayanEntities14 db = new SalesLayanEntities14();
Sales_Record sale_prod = new Sales_Record();
sale_prod.unit_price = model.Unit_price;
sale_prod.unit_purchase = model.Unit_purchase;
sale_prod.prod_id = model.Prod_id;
sale_prod.emp_id = model.Emp_id;
sale_prod.Dates = model.Dates;
sale_prod.cust_id = model.Cust_id;
db.Sales_Record.Add(sale_prod);
db.SaveChanges();
int latestProdId = sale_prod.sales_id;
TempData["status"] = "Success";
string sql = "update product set prod_quantity=prod_quantity- @sold_quantity where prod_id= @Prod_ID";
using (var sqlCon = new SqlConnection(@"Data Source=LAPTOP-L99NV78V\LAYANSQL;Initial Catalog=SalesLayan;User ID=sa;Password=Layangrade@17;"))
using (var cmd = new SqlCommand(sql, sqlCon))
{
//Have to guess at types and lengths here. Use actual types and lengths from the database
cmd.Parameters.Add("@sold_quantity", SqlDbType.SmallInt).Value = model.Unit_purchase;
cmd.Parameters.Add("@Prod_ID", SqlDbType.SmallInt).Value = model.Prod_id;
sqlCon.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("SalesIndex"));
}
// GET: AddyRims
public ActionResult AddyRimIndex()
{
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Rim_hub> list = db.Rim_hub.ToList();
ViewBag.HubName = new SelectList(list, "hub_id", "hub_name");
List <Rim_size> liste = db.Rim_size.ToList();
ViewBag.SizeNo = new SelectList(liste, "size_id", "size_number");
List <Rim_Type> listp = db.Rim_Type.ToList();
ViewBag.TypeName = new SelectList(listp, "type_id", "type_name");
List <Rim_Peg> listj = db.Rim_Peg.ToList();
ViewBag.PegNo = new SelectList(listj, "peg_id", "peg_no");
return(View());
}
// GET: AddyBattery
public ActionResult BattAddIndex()
{
//Dropdownlist
SalesLayanEntities14 db = new SalesLayanEntities14();
List <Terminal> list = db.Terminals.ToList();
ViewBag.TerminalName = new SelectList(list, "terminal_id", "terminal_name");
List <Size> liste = db.Sizes.ToList();
ViewBag.SizeName = new SelectList(liste, "size_id", "size1");
List <Height> listq = db.Heights.ToList();
ViewBag.HeightName = new SelectList(listq, "height_id", "height_name");
List <Supplier> listw = db.Suppliers.ToList();
ViewBag.SupplierName = new SelectList(listw, "supplier_id", "supplier_name");
return(View());
}
