public static LaneAttendance Create(Lane lane, User supervisor) { LaneAttendance inst = Create(); TSB tsb = TSB.GetCurrent(); if (null != tsb) { tsb.AssignTo(inst); } if (null != lane) { lane.AssignTo(inst); } if (null != supervisor) { supervisor.AssignTo(inst); } return(inst); }
/// <summary> /// Create Lane Payment. /// </summary> /// <param name="lane">The Lane instance.</param> /// <param name="collector">The User instance.</param> /// <param name="payment">The Payment instance.</param> /// <param name="date">The payment date time.</param> /// <param name="amount">The payment amount.</param> /// <returns>Returns LanePayment instance.</returns> public static NDbResult <LanePayment> Create(Lane lane, User collector, Payment payment, DateTime date, decimal amount) { var result = new NDbResult <LanePayment>(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } LanePayment inst = Create(); var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); } else { if (null != tsb) { tsb.AssignTo(inst); } if (null != lane) { lane.AssignTo(inst); } if (null != collector) { collector.AssignTo(inst); } if (null != payment) { payment.AssignTo(inst); } inst.PaymentDate = date; inst.Amount = amount; result.Success(inst); } return(result); }
/// <summary> /// Gets Current Lane Attendance by Lane. /// </summary> /// <param name="lane">The Lane instance.</param> /// <returns>Returns LaneAttendance instance.</returns> public static NDbResult <LaneAttendance> GetCurrentByLane(Lane lane) { var result = new NDbResult <LaneAttendance>(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == lane) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = string.Empty; cmd += "SELECT * "; cmd += " FROM LaneAttendanceView "; cmd += " WHERE LaneId = ? "; cmd += " AND End = ? "; cmd += " ORDER BY UserId, Begin"; var ret = NQuery.Query <FKs>(cmd, lane.LaneId, DateTime.MinValue).FirstOrDefault(); var data = (null != ret) ? ret.ToModel() : null; result.Success(data); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }
/// <summary> /// Search. /// </summary> /// <param name="lane">The Lane instance.</param> /// <returns>Returns List of LaneAttendance.</returns> public static NDbResult <List <LaneAttendance> > Search(Lane lane) { var result = new NDbResult <List <LaneAttendance> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == lane) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = string.Empty; cmd += "SELECT * "; cmd += " FROM LaneAttendanceView "; cmd += " WHERE LaneId = ? "; cmd += " ORDER BY UserId, Begin"; var rets = NQuery.Query <FKs>(cmd, lane.LaneId).ToList(); var results = rets.ToModels(); result.Success(results); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }