public void Post([FromBody] Stock_Store store)
{
if (ModelState.IsValid)
{
Stock_StoreRepository.Add(store);
}
}
public void Put(int St_ID, [FromBody] Stock_Store store)
{
store.St_ID = St_ID;
if (ModelState.IsValid)
{
Stock_StoreRepository.Update(store);
}
}
public void Update(Stock_Store stock)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = " UPDATE Stock_Store SET Date=@Date,Remarks=@Remarks"
+ " WHERE St_ID = @St_ID";
dbConnection.Open();
dbConnection.Execute(sQuery, stock);
}
}
public void Add(Stock_Store stock)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO Stock_Store (St_ID,Date, Remarks )"
+ " VALUES(@St_ID,@Date , @Remarks)";
dbConnection.Open();
dbConnection.Query(sQuery, stock);
}
}
public ActionResult AddStock(Stock_Store Stock_Store, List <Stock_Store_myjoin> list)
{
return(RedirectToAction("MenuStock"));
}
public async Task <ActionResult> MenuItemsStock()
{
List <Stock_Store> Dish = new List <Stock_Store>();
List <Stock_Store_myjoin> mydata = new List <Stock_Store_myjoin>();
Stock_Store model1 = new Stock_Store();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(Baseurl);
client.DefaultRequestHeaders.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res = await client.GetAsync("api/Stock_Store");
if (Res.IsSuccessStatusCode)
{
var Curr = Res.Content.ReadAsStringAsync().Result;
Dish = JsonConvert.DeserializeObject <List <Stock_Store> >(Curr);
}
model1.St_ID = Dish.Select(s => s.St_ID).LastOrDefault();
model1.Date = Dish.Select(s => s.Date).LastOrDefault();
model1.Remarks = Dish.Select(s => s.Remarks).LastOrDefault();
}
// List<Category> Category = new List<Category>();
using (var client1 = new HttpClient())
{
client1.BaseAddress = new Uri(Baseurl);
client1.DefaultRequestHeaders.Clear();
client1.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res1 = await client1.GetAsync("api/Stock_Store_Join");
if (Res1.IsSuccessStatusCode)
{
var Curr = Res1.Content.ReadAsStringAsync().Result;
mydata = JsonConvert.DeserializeObject <List <Stock_Store_myjoin> >(Curr);
}
//model.Sid = Category.Select(s => s.Cat_Id).LastOrDefault();
List <SelectListItem> Items = new List <SelectListItem>();
foreach (var c in mydata)
{
Items.Add(new SelectListItem
{
Value = c.Dish,
Text = c.Dish
});
}
ViewBag.mydata = Items;
}
List <Kitchen> Kitchen = new List <Kitchen>();
using (var client2 = new HttpClient())
{
client2.BaseAddress = new Uri(Baseurl);
client2.DefaultRequestHeaders.Clear();
client2.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
HttpResponseMessage Res2 = await client2.GetAsync("api/Kitchen");
if (Res2.IsSuccessStatusCode)
{
var Curr1 = Res2.Content.ReadAsStringAsync().Result;
Kitchen = JsonConvert.DeserializeObject <List <Kitchen> >(Curr1);
}
List <SelectListItem> Items2 = new List <SelectListItem>();
//foreach (var c in Kitchen)
//{
// model1.Getdashdata.Add(new Stock_Store
// {
// StockId = c.,
// Dish = c.Kitchenname
// });
//}
ViewBag.Kichen = Items2;
Session["UserModel"] = Dish;
return(View(model1));
}
}
