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)); } }