public void End(WorkPeriodEnd Work) { using (IDbConnection dbConnection = Connection) { string sQuery = "INSERT INTO WorkPeriodEnd (ID,WPEnd)" + " VALUES(@id,@WPEnd)"; dbConnection.Open(); dbConnection.Execute(sQuery, Work); } }
public void Update(WorkPeriodEnd Work) { using (IDbConnection dbConnection = Connection) { string sQuery = " UPDATE Category SET WorkPeriodStart = @WPStart," + " Status = @Status" + " WHERE Id = @Id"; dbConnection.Open(); dbConnection.Execute(sQuery, Work); } }