public static void UpdatePeriod(Model.Period period) { string query = "BEGIN " + "period_pkg.update_period(" + period.Id + ", " + period.Employee_Id + ", '" + period.Login_Time.ToString(string.Format("dd/MMM/yyyy")) + "', '" + period.Logout_Time.ToString(string.Format("dd/MMM/yyyy")) + "'); " + "END;"; DB_Handler.ExecuteQuery(query); }
public static Model.Period RowToEntity(DataRow row) { Model.Period period = new Model.Period { Id = Int32.Parse(row["Id"].ToString()), Employee_Id = Int32.Parse(row["Employee_Id"].ToString()), Login_Time = Convert.ToDateTime(row["Login_Time"]), Logout_Time = Convert.ToDateTime(row["Logout_Time"]) }; return(period); }