public void Post([FromBody] StockTransfer_Join store) { if (ModelState.IsValid) { StockTransfer_JoinRepository.Add(store); } }
public void Put(int STJ_ID, [FromBody] StockTransfer_Join store) { store.STJ_ID = STJ_ID; if (ModelState.IsValid) { StockTransfer_JoinRepository.Update(store); } }
public void Update(StockTransfer_Join stock) { using (IDbConnection dbConnection = Connection) { string sQuery = " UPDATE StockTransfer_Join SET StockTransferID=@StockTransferID,Warehouse=@Warehouse,ProductID=@ProductID,ExpiryDate=@ExpiryDate,Qty=@Qty" + " WHERE STJ_ID = @STJ_ID"; dbConnection.Open(); dbConnection.Execute(sQuery, stock); } }
public void Add(StockTransfer_Join stock) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO StockTransfer (Date , Kitchen )" + " VALUES(@Date , @Kitchen)"; dbConnection.Open(); dbConnection.Execute(sQuery, stock); } }
public void Add(StockTransfer_Join stock) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO StockTransfer_Join (StockTransferID,Warehouse, ProductID,ExpiryDate,Qty )" + " VALUES(@StockTransferID,@Warehouse,@ProductID,@ExpiryDate,@Qty)"; dbConnection.Open(); dbConnection.Query(sQuery, stock); } }
public ActionResult DeleteContact(StockTransfer_Join cat) { using (var client = new HttpClient()) { client.BaseAddress = new Uri(Baseurl); client.DefaultRequestHeaders.Clear(); //Define request data format client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); //Sending request to find web api REST service resource GetAllEmployees using HttpClient HttpResponseMessage Res = client.DeleteAsync("api/StockTransfer_Join/" + cat.STJ_ID).Result; //Checking the response is successful or not which is sent using HttpClient if (Res.IsSuccessStatusCode) { //Storing the response details recieved from web api var CatResponse = Res.Content.ReadAsStringAsync().Result; ViewBag.Name = JsonConvert.SerializeObject(CatResponse); //Deserializing the response recieved from web api and storing into the Employee list //CatInfo = JsonConvert.DeserializeObject<List<Category>>(CatResponse); } } return(RedirectToAction("Hotel")); }