/// <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);
}
