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> /// 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); }
/// <summary> /// Gets TSB Addition Balance. /// </summary> /// <param name="tsb">The target TSB to get balance.</param> /// <returns>Returns TSB Addition balance. If TSB not found returns null.</returns> public static TSBAdditionBalance GetCurrent(TSB tsb) { if (null == tsb) { return(null); } lock (sync) { string cmd = @" SELECT TSB.TSBId , TSB.TSBNameEN , TSB.TSBNameTH , (( SELECT IFNULL(SUM(AdditionalBHTTotal), 0) FROM TSBAdditionTransaction WHERE ( TSBAdditionTransaction.TransactionType = 0 OR TSBAdditionTransaction.TransactionType = 1 ) -- Initial = 0, Borrow = 1 AND TSBAdditionTransaction.TSBId = TSB.TSBId ) - ( SELECT IFNULL(SUM(AdditionalBHTTotal), 0) FROM TSBAdditionTransaction WHERE TSBAdditionTransaction.TransactionType = 2 -- Returns = 2 AND TSBAdditionTransaction.TSBId = TSB.TSBId )) AS AdditionalBHTTotal FROM TSB WHERE TSB.TSBId = ? " ; var ret = NQuery.Query <FKs>(cmd, tsb.TSBId).FirstOrDefault(); return((null != ret) ? ret.ToTSBAdditionBalance() : null); } }
/// <summary> /// Gets TSB Coupon summaries. /// </summary> /// <param name="tsb">The target TSB to get balance.</param> /// <returns>Returns List of TSB Coupon balance. If TSB not found returns null.</returns> public static NDbResult <List <TSBCouponSummary> > GetTSBCouponSummaries(TSB tsb) { var result = new NDbResult <List <TSBCouponSummary> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == tsb) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = @" SELECT * FROM TSBCouponSummarryView WHERE TSBId = ? " ; var rets = NQuery.Query <FKs>(cmd, tsb.TSBId).ToList(); var results = rets.ToModels(); result.Success(results); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }
public static TSBCouponTransaction GetInitial(TSB tsb) { if (null == tsb) { return(null); } lock (sync) { string cmd = string.Empty; cmd += "SELECT TSBCouponTransaction.* "; cmd += " , TSB.TSBNameEN, TSB.TSBNameTH "; cmd += " FROM TSBCouponTransaction, TSB "; cmd += " WHERE TSBCouponTransaction.TSBId = TSB.TSBId "; cmd += " AND TSBCouponTransaction.TSBId = ? "; cmd += " AND TSBCouponTransaction.TransactionType = ? "; var ret = NQuery.Query <FKs>(cmd, tsb.TSBId, TransactionTypes.Initial).FirstOrDefault(); TSBCouponTransaction inst; if (null == ret) { inst = Create(); tsb.AssignTo(inst); inst.TransactionType = TransactionTypes.Initial; } else { inst = ret.ToTSBCouponTransaction(); } return(inst); } }
/// <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> /// Gets TSB Coupon transactions. /// </summary> /// <param name="tsb">The target TSB to get coupon transaction.</param> /// <returns>Returns TSB Coupon transactions. If TSB not found returns null.</returns> public static List <TSBCouponTransaction> Gets(TSB tsb) { if (null == tsb) { return(null); } lock (sync) { string cmd = string.Empty; cmd += "SELECT TSBCouponTransaction.* "; cmd += " , TSB.TSBNameEN, TSB.TSBNameTH "; cmd += " FROM TSBCouponTransaction, TSB "; cmd += " WHERE TSBCouponTransaction.TSBId = TSB.TSBId "; cmd += " AND TSBCouponTransaction.TSBId = ? "; var rets = NQuery.Query <FKs>(cmd, tsb.TSBId).ToList(); if (null == rets) { return(new List <TSBCouponTransaction>()); } else { var results = new List <TSBCouponTransaction>(); rets.ForEach(ret => { results.Add(ret.ToTSBCouponTransaction()); }); return(results); } } }
public static ToTSBCoupons Create(TSB tsb, List <UserCouponTransaction> coupons) { var ret = new ToTSBCoupons(); ret.TSB = tsb; ret.Coupons = coupons; return(ret); }
public static ByUser Create(TSB tsb, User user) { var ret = new ByUser(); ret.User = user; ret.TSB = tsb; return(ret); }
/// <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 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 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 Filter Create(TSB tsb, Guid groupId, TSBExchangeTransaction.TransactionTypes transactionType) { var ret = new Filter(); ret.TSB = tsb; ret.GroupId = groupId; ret.TransactionType = transactionType; return(ret); }
public static List <Plaza> GetTSBPlazas(TSB value) { lock (sync) { if (null == value) { return(new List <Plaza>()); } return(GetTSBPlazas(value.TSBId)); } }
public static List <Lane> GetTSBLanes(TSB value) { lock (sync) { if (null == value) { return(new List <Lane>()); } return(GetTSBLanes(value.TSBId)); } }
/// <summary> /// Gets List of BHT35 by User in target TSB. /// </summary> /// <param name="tsb">The target TSB instance.</param> /// <param name="user">The user instance.</param> /// <returns>Returns List of BHT35.</returns> public static NDbResult <List <UserCouponTransaction> > GetUserBHT35Coupons( TSB tsb, User user) { var result = new NDbResult <List <UserCouponTransaction> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == tsb) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = string.Empty; cmd += "SELECT * "; cmd += " FROM UserCouponTransactionView "; cmd += " WHERE TSBId = ? "; cmd += " AND CouponType = ? "; if (null != user) { cmd += " AND UserId = ? "; } List <FKs> rets; if (null != user) { rets = NQuery.Query <FKs>(cmd, tsb.TSBId, CouponType.BHT35, user.UserId).ToList(); } else { rets = NQuery.Query <FKs>(cmd, tsb.TSBId, CouponType.BHT35).ToList(); } var results = rets.ToModels(); result.Success(results); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }
public static NDbResult <List <TSBExchangeGroup> > GetTSBExchangeGroups(TSB tsb, StateTypes state, FinishedFlags flag, DateTime reqBegin, DateTime reqEnd) { var result = new NDbResult <List <TSBExchangeGroup> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } if (null == tsb) { result.ParameterIsNull(); return(result); } lock (sync) { MethodBase med = MethodBase.GetCurrentMethod(); try { string cmd = string.Empty; cmd += "SELECT * "; cmd += " FROM TSBExchangeGroupView "; cmd += " WHERE TSBId = ? "; cmd += " AND FinishFlag = ? "; if (state != StateTypes.None) { cmd += " AND State = ? "; } if (reqBegin != DateTime.MinValue) { cmd += " AND RequestDate >= ? "; if (reqEnd != DateTime.MinValue) { cmd += " AND RequestDate <= ? "; } } var rets = NQuery.Query <FKs>(cmd, tsb.TSBId, flag, state, reqBegin, reqEnd).ToList(); var results = rets.ToModels(); result.Success(results); } catch (Exception ex) { med.Err(ex); result.Error(ex); } return(result); } }
public static Filter Create(TSB tsb, TSBExchangeGroup.StateTypes state = TSBExchangeGroup.StateTypes.None, TSBExchangeGroup.FinishedFlags flag = TSBExchangeGroup.FinishedFlags.None) { var ret = new Filter(); ret.TSB = tsb; ret.State = state; ret.FinishedFlag = flag; ret.ReqBegin = DateTime.MinValue; ret.ReqEnd = DateTime.MinValue; return(ret); }
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); } }
/// <summary> /// Gets PlazaGroups (By TSB). /// </summary> /// <param name="value">The TSB instance.</param> /// <returns>Returns List of PlazaGroup.</returns> public static NDbResult <List <PlazaGroup> > GetTSBPlazaGroups(TSB value) { var result = new NDbResult <List <PlazaGroup> >(); SQLiteConnection db = Default; if (null == db) { result.DbConenctFailed(); return(result); } lock (sync) { return(GetTSBPlazaGroups(value.TSBId)); } }
/// <summary> /// Gets Plazas (By TSB). /// </summary> /// <param name="value">The TSB Instance.</param> /// <returns>Returns List of Plaza.</returns> public static NDbResult <List <Plaza> > GetTSBPlazas(TSB value) { var result = new NDbResult <List <Plaza> >(); SQLiteConnection db = Default; if (null == value) { result.ParameterIsNull(); return(result); } lock (sync) { return(GetTSBPlazas(value.TSBId)); } }
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); }
/// <summary> /// Gets User Credit transactions. /// </summary> /// <param name="tsb">The target TSB to get transactions.</param> /// <returns>Returns User Credit transactions. If TSB not found returns null.</returns> public static List <UserCreditTransaction> Gets(TSB tsb) { if (null == tsb) { return(null); } lock (sync) { string cmd = string.Empty; cmd += "SELECT UserCreditTransaction.* "; cmd += " , TSB.TSBNameEN, TSB.TSBNameTH "; cmd += " , PlazaGroup.PlazaGroupNameEN, PlazaGroup.PlazaGroupNameTH, PlazaGroup.Direction "; cmd += " , User.UserId, User.FullNameEN, User.FullNameTH "; cmd += " , UserCredit.UserCreditDate, "; cmd += " , UserCredit.State, UserCredit.BagNo, UserCredit.BeltNo "; cmd += " FROM UserCreditTransaction, TSB, PlazaGroup, User, UserCredit "; cmd += " WHERE PlazaGroup.TSBId = TSB.TSBId "; cmd += " AND UserCredit.TSBId = TSB.TSBId "; cmd += " AND UserCredit.PlazaGroupId = PlazaGroup.PlazaGroupId "; cmd += " AND UserCredit.UserId = User.UserId "; cmd += " AND UserCreditTransaction.UserCreditId = UserCredit.UserCreditId "; cmd += " AND UserCredit.TSBId = ? "; var rets = NQuery.Query <FKs>(cmd, tsb.TSBId).ToList(); if (null == rets) { return(new List <UserCreditTransaction>()); } else { var results = new List <UserCreditTransaction>(); rets.ForEach(ret => { results.Add(ret.ToUserCreditTransaction()); }); return(results); } } }