/// <summary> /// Create UserShift. /// </summary> /// <param name="shift">The Shift instance.</param> /// <param name="supervisor">The User instance.</param> /// <returns>Returns UserShift instance.</returns> public static NDbResult <UserShift> Create(Shift shift, User supervisor) { var result = new NDbResult <UserShift>(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } UserShift inst = Create(); var tsb = TSB.GetCurrent().Value(); if (null != tsb) { tsb.AssignTo(inst); } if (null != shift) { shift.AssignTo(inst); } if (null != supervisor) { supervisor.AssignTo(inst); } result.Success(inst); return(result); }
/// <summary> /// Create Lane Attendance. /// </summary> /// <param name="lane">The Lane instance.</param> /// <param name="collector">The User instance.</param> /// <returns>Returns LaneAttendance instance.</returns> public static NDbResult <LaneAttendance> Create(Lane lane, User collector) { var result = new NDbResult <LaneAttendance>(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } LaneAttendance 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); } result.Success(inst); } return(result); }
public static LanePayment Create(Lane lane, User collector, Payment payment, DateTime date, decimal amount) { LanePayment inst = Create(); TSB tsb = TSB.GetCurrent(); 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; return(inst); }
/// <summary> /// Gets Active TSB Coupon balance. /// </summary> /// <returns>Returns Current Active TSB Coupon balance. If not found returns null.</returns> public static TSBCouponBalance GetCurrent() { lock (sync) { var tsb = TSB.GetCurrent(); return(GetCurrent(tsb)); } }
public static TSBCouponTransaction GetInitial() { lock (sync) { var tsb = TSB.GetCurrent(); return(GetInitial(tsb)); } }
/// <summary> /// Gets Active TSB Coupon transactions. /// </summary> /// <returns> /// Returns Current Active TSB Coupon transactions. If not found returns null. /// </returns> public static List <TSBCouponTransaction> Gets() { lock (sync) { var tsb = TSB.GetCurrent(); return(Gets(tsb)); } }
/// <summary> /// Gets Active TSB User Credit transactions. /// </summary> /// <returns>Returns Current Active TSB User Credit transactions. If not found returns null.</returns> public static List <UserCreditTransaction> Gets() { lock (sync) { var tsb = TSB.GetCurrent(); return(Gets(tsb)); } }
public static NDbResult <List <LaneAttendance> > GetAllNotHasRevenueEntryByUser(User user) { var result = new NDbResult <List <LaneAttendance> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == user) { result.ParameterIsNull(); return(result); } var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = string.Empty; cmd += "SELECT * "; cmd += " FROM LaneAttendanceView "; cmd += " WHERE TSBId = ? "; cmd += " AND (RevenueDate = ?"; cmd += " OR RevenueId IS NULL "; cmd += " OR RevenueId = ?) "; cmd += " AND UserId = ? "; cmd += " ORDER BY UserId, Begin"; var rets = NQuery.Query <FKs>(cmd, tsb.TSBId, DateTime.MinValue, string.Empty, user.UserId).ToList(); var results = rets.ToModels(); result.Success(results); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }
public static UserShift Create(Shift shift, User supervisor) { UserShift inst = Create(); TSB tsb = TSB.GetCurrent(); if (null != tsb) { tsb.AssignTo(inst); } if (null != shift) { shift.AssignTo(inst); } if (null != supervisor) { supervisor.AssignTo(inst); } return(inst); }
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 all LaneAttendance that has not enter revenue. /// </summary> /// <returns>Returns List of LaneAttendance.</returns> public static NDbResult <List <LaneAttendance> > GetAllNotHasRevenueEntry() { var result = new NDbResult <List <LaneAttendance> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); return(result); } result = GetAllNotHasRevenueEntry(tsb); return(result); }
/// <summary> /// Gets Active TSB Coupon transactions (all status). /// </summary> /// <returns> /// Returns Current Active TSB Coupon transactions. If not found returns null. /// </returns> public static NDbResult <List <TSBCouponTransaction> > GetTSBCouponTransactions() { var result = new NDbResult <List <TSBCouponTransaction> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); return(result); } result = GetTSBCouponTransactions(tsb); return(result); }
/// <summary> /// Gets TSB Coupon summaries. /// </summary> /// <param name="tsb">The target TSB to get balance.</param> /// <param name="user">The target User to get balance.</param> /// <returns>Returns List of TSB Coupon balance. If TSB not found returns null.</returns> public static NDbResult <List <TSBCouponSummary> > GetByUser(User user) { var result = new NDbResult <List <TSBCouponSummary> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); return(result); } result = GetByUser(tsb, user); return(result); }
/// <summary> /// Gets Un Close User Shifts (Active TSB). /// </summary> /// <returns>Returns List of User Shifts.</returns> public static NDbResult <List <UserShift> > GetUnCloseUserShifts() { var result = new NDbResult <List <UserShift> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } var tsb = TSB.GetCurrent().Value(); if (null == tsb) { result.ParameterIsNull(); return(result); } result = GetUnCloseUserShifts(tsb.TSBId); return(result); }