public void Post([FromBody] WorkPeriodStart Work)
{
if (ModelState.IsValid)
{
WorkPeriodRepository.Start(Work);
}
}
public void Put(int id, [FromBody] WorkPeriodStart Work)
{
Id = id;
if (ModelState.IsValid)
{
WorkPeriodRepository.Update(Work);
}
}
public void Start(WorkPeriodStart Work)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = "INSERT INTO WorkPeriodStart (WPStart ,Status)"
+ " VALUES(@WPStart, @Status)";
dbConnection.Open();
dbConnection.Execute(sQuery, Work);
}
}
public void Update(WorkPeriodStart Work)
{
using (IDbConnection dbConnection = Connection)
{
string sQuery = " UPDATE Category SET WorkPeriodStart = @WPStart,"
+ " Status = @Status"
+ " WHERE Id = @Id";
dbConnection.Open();
dbConnection.Execute(sQuery, Work);
}
}
