public void Post([FromBody] Temp_Stock_RM TemR) { if (ModelState.IsValid) { Temp_Stock_RMRepository.Add(TemR); } }
public void Put(int id, [FromBody] Temp_Stock_RM TemR) { TemR.Id = id; if (ModelState.IsValid) { Temp_Stock_RMRepository.Update(TemR); } }
public void Update(Temp_Stock_RM TemR) { using (IDbConnection dbConnection = Connection) { string sQuery = " UPDATE Temp_Stock_RM SET ProductID = @ProductID,Qty = @Qty" + " WHERE Id = @Id"; dbConnection.Open(); dbConnection.Execute(sQuery, TemR); } }
public void Add(Temp_Stock_RM TemR) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO Temp_Stock_RM ( ProductID , Qty)" + " VALUES( @ProductID, @Qty)"; dbConnection.Open(); dbConnection.Query(sQuery, TemR); } }