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>
/// Save Plaza Revenue.
/// </summary>
/// <param name="value">The UserShiftRevenue instance.</param>
/// <param name="revenueDate">The Revenue Date.</param>
/// <param name="revenueId">The Revenue Id.</param>
/// <returns>Returns save UserShiftRevenue instance.</returns>
public static NDbResult <UserShiftRevenue> SavePlazaRevenue(UserShiftRevenue value,
DateTime revenueDate, string revenueId)
{
var result = new NDbResult <UserShiftRevenue>();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
value.RevenueDate = revenueDate;
value.RevenueId = revenueId;
// save.
result = Save(value);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <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);
}
}
/// <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 NDbResult SaveUsers(List <User> users)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == users || users.Count <= 0)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
db.BeginTransaction();
var roles = Models.Role.GetRoles().Value();
users.ForEach(user =>
{
User match = User.GetUser(user.UserId).Value();
if (null == match)
{
Save(user); // insert
}
else
{
match.UserId = user.UserId;
match.PrefixEN = user.PrefixEN;
match.PrefixTH = user.PrefixTH;
match.FirstNameEN = user.FirstNameEN;
match.FirstNameTH = user.FirstNameTH;
match.MiddleNameEN = user.MiddleNameEN;
match.MiddleNameTH = user.MiddleNameTH;
match.LastNameEN = user.LastNameEN;
match.LastNameTH = user.LastNameTH;
match.Password = user.Password;
Save(match); // update
}
});
db.Commit();
}
catch (Exception ex)
{
med.Err(ex);
db.Rollback();
}
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);
}
}
/// <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);
}
}
/// <summary>
/// Begin User Shift.
/// </summary>
/// <param name="value">The UserShift instance.</param>
/// <returns>Returns Begin User Shift Result.</returns>
public static NDbResult BeginUserShift(UserShift value)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
var last = GetUserShift(value.TSBId, value.UserId);
if (null != last && null != last.data && !last.errors.hasError)
{
// not enter revenue entry.
result.Error(new Exception("ยังมีกะที่ยังไม่ได้ป้อนรายได้"));
result.errors.errNum = -10;
return(result);
}
// Begin new shift.
if (value.Begin == DateTime.MinValue)
{
value.Begin = DateTime.Now;
}
var saveRet = Save(value);
result.errors = saveRet.errors;
if (!result.errors.hasError)
{
result.Success();
}
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <summary>
/// Change Shift.
/// </summary>
/// <param name="value">The TSBShift instance.</param>
/// <returns>Returns Change Shift result.</returns>
public static NDbResult ChangeShift(TSBShift value)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
var last = GetTSBShift(value.TSBId).Value();
if (null != last)
{
// End shift.
last.End = DateTime.Now;
Save(last);
}
// Begin new shift.
if (value.Begin == DateTime.MinValue)
{
value.Begin = DateTime.Now;
}
var saveRet = Save(value);
result.errors = saveRet.errors;
if (!result.errors.hasError)
{
result.Success();
}
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <summary>
/// Gets Plazas (By PlazaGroup).
/// </summary>
/// <param name="value">The PlazaGroup Instance.</param>
/// <returns>Returns List of Plaza.</returns>
public static NDbResult <List <Plaza> > GetPlazaGroupPlazas(PlazaGroup value)
{
var result = new NDbResult <List <Plaza> >();
SQLiteConnection db = Default;
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
return(GetPlazaGroupPlazas(value.TSBId, value.PlazaGroupId));
}
}
/// <summary>
/// Search.
/// </summary>
/// <param name="shift">The User Shift instance.</param>
/// <returns>Returns List of LaneAttendance.</returns>
public static NDbResult <List <LaneAttendance> > Search(UserShift shift)
{
var result = new NDbResult <List <LaneAttendance> >();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == shift)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM LaneAttendanceView ";
cmd += " WHERE UserId = ? ";
cmd += " AND (Begin >= ? AND Begin <= ?) ";
cmd += " AND ( (End >= ? AND End <= ?) " +
" OR End = ?)";
cmd += " ORDER BY UserId, Begin";
DateTime end = (shift.End == DateTime.MinValue) ? DateTime.Now : shift.End;
var rets = NQuery.Query <FKs>(cmd,
shift.UserId,
shift.Begin, end,
shift.Begin, end,
DateTime.MinValue).ToList();
var results = rets.ToModels();
result.Success(results);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
public static NDbResult SyncTransaction(TSBCouponTransaction value)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM TSBCouponTransactionView ";
cmd += " WHERE TSBId = ? ";
cmd += " AND CouponId = ? ";
var ret = NQuery.Query <FKs>(cmd,
value.TSBId, value.CouponId).FirstOrDefault().ToModel();
if (null != ret)
{
// exist so set id for update.
value.TransactionId = ret.TransactionId;
}
return(TSBCouponTransaction.Save(value));
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
public static NDbResult <List <TSBExchangeGroup> > GetRequestApproveTSBExchangeGroups(TSB tsb)
{
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 (State = ? OR State = ?)";
cmd += " AND FinishFlag = ? ";
var rets = NQuery.Query <FKs>(cmd, tsb.TSBId,
StateTypes.Request, StateTypes.Approve,
FinishedFlags.Avaliable).ToList();
var results = rets.ToModels();
result.Success(results);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <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 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>
/// Create Plaza Revenue.
/// </summary>
/// <param name="shift">The UserShift instance.</param>
/// <param name="plazaGroup">The PlazaGroup instance.</param>
/// <returns>Returns UserShiftRevenue instance.</returns>
public static NDbResult <UserShiftRevenue> CreatePlazaRevenue(
UserShift shift, PlazaGroup plazaGroup)
{
var result = new NDbResult <UserShiftRevenue>();
if (null == shift || null == plazaGroup)
{
result.ParameterIsNull();
result.data = null;
}
else
{
UserShiftRevenue inst = Create();
plazaGroup.AssignTo(inst);
shift.AssignTo(inst);
result.data = inst;
result.Success();
}
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 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 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>
/// End User Shift.
/// </summary>
/// <param name="value">The UserShift instance.</param>
/// <returns>Returns End User Shift Result.</returns>
public static NDbResult EndUserShift(UserShift value)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
// End shift.
if (value.End == DateTime.MinValue)
{
value.End = DateTime.Now;
}
var saveRet = Save(value);
result.errors = saveRet.errors;
if (!result.errors.hasError)
{
result.Success();
}
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <summary>
/// Save Transaction.
/// </summary>
/// <param name="value">The transaction instance.</param>
/// <returns>Returns Save TSB Coupon transactions.</returns>
public static NDbResult <TSBCouponTransaction> SaveTransaction(TSBCouponTransaction value)
{
var result = new NDbResult <TSBCouponTransaction>();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
if (value.TransactionDate == DateTime.MinValue)
{
value.TransactionDate = DateTime.Now;
}
return(TSBCouponTransaction.Save(value));
}
/// <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>
/// Gets Plaza Revenue.
/// </summary>
/// <param name="shift">The Shift instance.</param>
/// <param name="plazaGroup">The PlazaGroup instance.</param>
/// <returns>Returns UserShiftRevenue instance.</returns>
public static NDbResult <UserShiftRevenue> GetPlazaRevenue(
UserShift shift, PlazaGroup plazaGroup)
{
var result = new NDbResult <UserShiftRevenue>();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == shift || null == plazaGroup)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM UserShiftRevenueView ";
cmd += " WHERE UserShiftId = ? ";
cmd += " AND PlazaGroupId = ? ";
var ret = NQuery.Query <FKs>(cmd,
shift.UserShiftId, plazaGroup.PlazaGroupId).FirstOrDefault();
result.data = (null != ret) ? ret.ToModel() : null;
result.Success();
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
public static NDbResult SaveLaneAttendances(List <LaneAttendance> values)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == values)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
db.BeginTransaction();
foreach (var r in values)
{
SaveLaneAttendance(r);
}
db.Commit();
result.Success();
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
db.Rollback();
}
return(result);
}
}
/// <summary>
/// Search.
/// </summary>
/// <param name="revenue">The Revenue Entry instance.</param>
/// <returns>Returns List of LaneAttendance.</returns>
public static NDbResult <List <LaneAttendance> > Search(RevenueEntry revenue)
{
var result = new NDbResult <List <LaneAttendance> >();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == revenue)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM LaneAttendanceView ";
cmd += " WHERE RevenueId = ? ";
cmd += " ORDER BY UserId, Begin";
var rets = NQuery.Query <FKs>(cmd,
revenue.RevenueId).ToList();
var results = rets.ToModels();
result.Success(results);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <summary>
/// Search.
/// </summary>
/// <param name="shift">The UserShift instance.</param>
/// <returns>Returns List of LanePayment.</returns>
public static NDbResult <List <LanePayment> > Search(UserShift shift)
{
var result = new NDbResult <List <LanePayment> >();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == shift)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM LanePaymentView ";
cmd += " WHERE Begin >= ? ";
cmd += " AND End <= ? ";
var rets = NQuery.Query <FKs>(cmd, shift.Begin, shift.End,
DateTime.MinValue).ToList();
var results = rets.ToModels();
result.Success(results);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
/// <summary>
/// Save Transactions.
/// </summary>
/// <param name="values">The List of transaction instance.</param>
/// <returns>Returns NDbResult.</returns>
public static NDbResult SaveTransactions(
List <TSBCouponTransaction> values)
{
var result = new NDbResult();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == values)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
db.BeginTransaction();
values.ForEach(value =>
{
SaveTransaction(value);
});
db.Commit();
}
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 LanePayment.</returns>
public static NDbResult <List <LanePayment> > Search(Lane lane)
{
var result = new NDbResult <List <LanePayment> >();
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 LanePaymentView ";
cmd += " WHERE LaneId = ? ";
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);
}
}
/// <summary>
/// Gets TSB Coupon Balance.
/// </summary>
/// <param name="tsb">The target TSB to get balance.</param>
/// <returns>Returns TSB Coupon balance. If TSB not found returns null.</returns>
public static NDbResult <TSBCouponBalance> GetTSBBalance(TSB tsb)
{
var result = new NDbResult <TSBCouponBalance>();
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 TSBCouponBalanceView
WHERE TSBId = ? " ;
var ret = NQuery.Query <FKs>(cmd, tsb.TSBId).FirstOrDefault();
var data = ret.ToModel();
result.Success(data);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
public static NDbResult <LaneAttendance> SaveLaneAttendance(LaneAttendance value)
{
var result = new NDbResult <LaneAttendance>();
SQLiteConnection db = Default;
if (null == db)
{
result.DbConenctFailed();
return(result);
}
if (null == value)
{
result.ParameterIsNull();
return(result);
}
lock (sync)
{
MethodBase med = MethodBase.GetCurrentMethod();
try
{
// Search.
string cmd = string.Empty;
cmd += "SELECT * ";
cmd += " FROM LaneAttendanceView ";
cmd += " WHERE TSBId = ? ";
cmd += " AND PlazaGroupId = ? ";
cmd += " AND PlazaId = ? ";
cmd += " AND LaneId = ? ";
cmd += " AND UserId = ? ";
cmd += " AND JobId = ? ";
cmd += " AND Begin = ? ";
var ret = NQuery.Query <FKs>(cmd,
value.TSBId, value.PlazaGroupId, value.PlazaId,
value.LaneId, value.UserId, value.JobId, value.Begin).FirstOrDefault();
var data = (null != ret) ? ret.ToModel() : null;
if (null != data)
{
value.PKId = data.PKId; // exists so assigned key.
if (string.IsNullOrEmpty(value.RevenueId) &&
!string.IsNullOrEmpty(data.RevenueId))
{
// set revenue id
value.RevenueId = data.RevenueId;
}
if (value.RevenueDate == DateTime.MinValue &&
data.RevenueDate != DateTime.MinValue)
{
// set revenue date
value.RevenueDate = data.RevenueDate;
}
}
result = LaneAttendance.Save(value);
}
catch (Exception ex)
{
med.Err(ex);
result.Error(ex);
}
return(result);
}
}
