/// <summary> /// Updates a record in the SchedulerCheckin table. /// </summary> public bool Update(SchedulerCheckinEntity obj) { try { var p = Param(obj, "edit"); var res = unitOfWork.ProcedureExecute("Sp_SchedulerCheckin_Update", p); return(res); } catch (Exception ex) { Logging.PutError(ex.Message, ex); throw; } }
/// <summary> /// Saves a record to the SchedulerCheckin table. /// </summary> public long Insert(SchedulerCheckinEntity obj) { long res; try { var p = Param(obj); var flag = unitOfWork.ProcedureExecute("Sp_SchedulerCheckin_Insert", p); res = flag ? p.Get <long>("@Id") : 0; } catch (Exception ex) { Logging.PutError(ex.Message, ex); throw; } return(res); }
/// <summary> /// Saves a record to the SchedulerCheckin table. /// </summary> private DynamicParameters Param(SchedulerCheckinEntity obj, string action = "add") { var p = new DynamicParameters(); p.Add("@AccountId", obj.AccountId); p.Add("@LocaltionId", obj.LocaltionId); p.Add("@StartDate", obj.StartDate); p.Add("@EndDate", obj.EndDate); p.Add("@Description", obj.Description); if (action == "add") { p.Add("@Id", dbType: DbType.Int64, direction: ParameterDirection.Output); } else if (action == "edit") { p.Add("@Id", obj.Id); } return(p); }