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); } }