public void Post([FromBody] Purchase_Join Purchase_Join)
{
if (ModelState.IsValid)
{
Purchase_JoinRepository.Add(Purchase_Join);
}
}
public void Put(int id, [FromBody] Purchase_Join Purchase_Join)
{
Purchase_Join.SP_ID = id;
if (ModelState.IsValid)
{
Purchase_JoinRepository.Update(Purchase_Join);
}
}
public void Update(Purchase_Join Purchase_Join)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "UPDATE Purchase SET PurchaseID=@PurchaseID, ProductID=@ProductID, Qty=@Qty, Price=@Price,TotalAmount=@TotalAmount,Warehouse=@Warehouse,HasExpirydate=@HasExpirydate,ExpiryDate=@ExpiryDate"
+ " WHERE SP_ID = @Id";
dbConnection.Open();
dbConnection.Query(sQuery, Purchase_Join);
}
}
public void Add(Purchase_Join Purchase_Join)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO Purchase_Join(PurchaseID, ProductID, Qty, Price,TotalAmount,Warehouse,HasExpirydate,ExpiryDate)"
+ " VALUES(@PurchaseID, @ProductID, @Qty, @Price,@TotalAmount,@Warehouse,@HasExpirydate,@ExpiryDate)";
dbConnection.Open();
dbConnection.Execute(sQuery, Purchase_Join);
}
}
