public IHttpActionResult UpdateSale(SalesDS salesDS)
{
var isupdate = _salesRepository.UpdateSales(salesDS);
if (isupdate == true)
{
return(Ok(isupdate));
}
return(BadRequest());
}
public bool UpdateSales(SalesDS salesDS)
{
DateTime now = DateTime.Now;
salesDS.ModifiedDate = now;
int rowsAffected = this._db.Execute("UPDATE SalesMaster SET ModifiedBy=1, ModifiedDate = @ModifiedDate,PosId=@PosId WHERE Id = " +
salesDS.Id, salesDS);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
public bool CreateSales(SalesDS salesDS)
{
DateTime now = DateTime.Now;
salesDS.CreatedDate = now;
salesDS.ModifiedDate = now;
salesDS.SalesDate = now;
int rowsAffected = this._db.Execute(@"INSERT SalesMaster(IsActive,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate,SalesDate,PosId,CustomerId) values (1,1,@CreatedDate,1,@ModifiedDate,@SalesDate,@PosId,@CustomerId)",
new { IsActive = 1, CreatedBy = 1, CreatedDate = salesDS.CreatedDate, ModifiedBy = 1, ModifiedDate = salesDS.ModifiedDate, SalesDate = salesDS.SalesDate, PosId = salesDS.PosId, CustomerId = salesDS.CustomerId });
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
