public static void Backup(DateTime date)
{
Validate(date);
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
RedBloodDataContext db = new RedBloodDataContext();
if (db.PackRemainDailies.Where(r => r.Date.Value.Date == date.Date).Count() > 0)
{
LogBLL.LogsFailAndThrow(err + "Existing data.");
}
IQueryable <Pack> rows = db.Packs.Where(r => r.Status == Pack.StatusX.Product);
//Insert
foreach (Pack item in rows)
{
PackRemainDaily r = new PackRemainDaily();
r.PackID = item.ID;
r.Status = item.Status;
r.Date = date;
r.Note = "Process on: " + DateTime.Now.ToString();
db.PackRemainDailies.InsertOnSubmit(r);
}
db.SubmitChanges();
LogBLL.Logs();
}
public static int CountPackRemainByStoreFinalize(DateTime date)
{
RedBloodDataContext db = new RedBloodDataContext();
var v = db.StoreFinalizes.Where(r => r.Date == date.Date &&
r.Type == PackTransaction.TypeX.Remain)
.Select(r => r.Count);
if (v.Count() > 1)
{
LogBLL.LogsFailAndThrow("Data Err.");
}
int?i = v.FirstOrDefault();
return(i.HasValue ? i.Value : 0);
}
private static bool Validate(DateTime date)
{
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
if (date.Date > DateTime.Now.Date)
{
LogBLL.LogsFailAndThrow(MyMethodBase.Current.Caller, err + "Date is in future.");
}
RedBloodDataContext db = new RedBloodDataContext();
if (db.PackRemainDailies.Where(r => r.Date.Value.Date > date.Date).Count() > 0)
{
LogBLL.LogsFailAndThrow(MyMethodBase.Current.Caller, err + "Existing newer data.");
}
return(true);
}
public static int Add(DateTime date, PackTransaction.TypeX type, int count)
{
if (Get(date, type) != null)
{
LogBLL.LogsFailAndThrow("Existing datat.");
}
RedBloodDataContext db = new RedBloodDataContext();
StoreFinalize s = new StoreFinalize();
s.Date = date;
s.Type = type;
s.Count = count;
s.Note = "Process on: " + DateTime.Now.ToString();
db.StoreFinalizes.InsertOnSubmit(s);
db.SubmitChanges();
return(1);
}
public static int CountPackRemainByPackStatus()
{
DateTime date = DateTime.Now.Date;
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
RedBloodDataContext db = new RedBloodDataContext();
if (db.PackTransactions.Where(r => r.Date.Value.Date > date).Count() > 0)
{
LogBLL.LogsFailAndThrow(err + "Data error. Having pack transaction in future.");
}
if (db.Packs.Where(r => r.Date.Value.Date > date).Count() > 0)
{
LogBLL.LogsFailAndThrow(err + "Data error. Having pack in future.");
}
int count = db.Packs.Where(r => r.Status == Pack.StatusX.Product).Count();
return(count);
}
public static int CountPackRemainByLastDayRemain(DateTime date)
{
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
if (date.Date > DateTime.Now.Date)
{
LogBLL.LogsFailAndThrow(err + "Date is in future.");
}
RedBloodDataContext db = new RedBloodDataContext();
DateTime previousDate = date.Date.AddDays(-1);
int previousRemain = CountPackRemainByStoreFinalize(previousDate);
var v1 = CountPackTransaction(date);
int?i = (previousRemain
+ v1.Where(r => r.Type > 0).Sum(r => r.Count)
- v1.Where(r => r.Type < 0).Sum(r => r.Count)
);
return(i.HasValue ? i.Value : 0);
}
public static void Clear(DateTime date)
{
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
if (date.Date > DateTime.Now.Date)
{
LogBLL.LogsFailAndThrow(err + "Date is in future.");
}
RedBloodDataContext db = new RedBloodDataContext();
if (db.StoreFinalizes.Where(r => r.Date.Value.Date > date.Date).Count() > 0)
{
LogBLL.LogsFailAndThrow(err + "Existing newer data.");
}
var v = db.StoreFinalizes.Where(r => r.Date == date.Date);
db.StoreFinalizes.DeleteAllOnSubmit(v);
db.SubmitChanges();
LogBLL.Logs();
}
static bool GetAndValidateFinalizeData()
{
GetLastFinalizeDate();
if (
!lastFinalizeDate.HasValue &&
!lastPackTransactionDate.HasValue &&
!lastBackupPackRemainDate.HasValue
)
{
return(true);
}
if (
lastFinalizeDate.HasValue && lastFinalizeDate.Value.Date > DateTime.Now.Date ||
(lastPackTransactionDate.HasValue && lastPackTransactionDate.Value.Date > DateTime.Now.Date) ||
(lastBackupPackRemainDate.HasValue && lastBackupPackRemainDate.Value.Date > DateTime.Now.Date)
)
{
LogBLL.LogsFailAndThrow("Error. Data or Date in future.");
}
if (lastFinalizeDate < lastBackupPackRemainDate)
{
LogBLL.LogsFailAndThrow("Error. lastFinalizeDate != lastBackupPackRemainDate");
}
if (lastFinalizeDate.HasValue &&
!lastPackTransactionDate.HasValue
)
{
if (lastFinalizeDate == firstFinalizeDate)
{
}
else
{
LogBLL.LogsFailAndThrow("Error. lastFinalizeDate.HasValue && !lastPackTransactionDate.HasValue");
}
}
if (lastPackTransactionDate.HasValue)
{
if (lastFinalizeDate.HasValue)
{
int days = (lastPackTransactionDate.Value.Date - lastFinalizeDate.Value.Date).Days;
if (days == 0 || days == 1)
{
}
else
{
//LogBLL.LogsFailAndThrow("Error. days == 0 || days == 1 fail.");
}
}
else
{
if (firstPackTransactionDate != lastPackTransactionDate)
{
LogBLL.LogsFailAndThrow("firstPackTransactionDate != lastPackTransactionDate");
}
}
}
return(true);
}
public static void FinalizeStore(DateTime date, bool overwrite)
{
string err = "Process for day: " + date.Date.ToShortDateString() + ". ";
DateTime?firstFinalizeDate;
DateTime?lastFinalizeDate;
DateTime?lastPackTransactionDate;
DateTime?firstPackTransactionDate;
DateTime?lastBackupPackRemainDate;
RedBloodSystemBLL.GetLastFinalizeDate(out firstFinalizeDate, out lastFinalizeDate, out lastPackTransactionDate, out firstPackTransactionDate, out lastBackupPackRemainDate);
if (date.Date > DateTime.Now.Date ||
lastFinalizeDate.HasValue && lastFinalizeDate.Value.Date > DateTime.Now.Date ||
(lastPackTransactionDate.HasValue && lastPackTransactionDate.Value.Date > DateTime.Now.Date) ||
(lastBackupPackRemainDate.HasValue && lastBackupPackRemainDate.Value.Date > DateTime.Now.Date)
)
{
LogBLL.LogsFailAndThrow(err + "Error. Data or Date in future.");
}
//Data in DB is newer. Data error or system datetime error
if (
(lastFinalizeDate.HasValue && lastFinalizeDate.Value.Date > date.Date) ||
(lastPackTransactionDate.HasValue && lastPackTransactionDate.Value.Date > date.Date) ||
(lastBackupPackRemainDate.HasValue && lastBackupPackRemainDate.Value.Date > date.Date)
)
{
LogBLL.LogsFailAndThrow(err + "Newer data in DB.");
}
if (lastFinalizeDate.HasValue)
{
int daysBefore = (date.Date - lastFinalizeDate.Value.Date).Days;
if (daysBefore != 0 &&
daysBefore != 1)
{
LogBLL.LogsFailAndThrow(err + "Data should be finalized with in or 1 day before.");
}
if (daysBefore == 0)
{
if (overwrite)
{
//Clear StoreFinalizes
StoreFinalizeBLL.Clear(date);
//Clear PackRemainDailies
PackRemainDailyBLL.Clear(date);
}
else
{
LogBLL.LogsFailAndThrow(err + "Aldready finilized. Set overwrite=true to re-finilized.");
}
}
}
StoreFinalizeBLL.CountPackTransaction(date).Select(r => StoreFinalizeBLL.Add(r.Date.Value, r.Type, r.Count.Value)).ToList();
StoreFinalizeBLL.Add(date, PackTransaction.TypeX.Remain, StoreFinalizeBLL.CountPackRemainByPackStatus());
PackRemainDailyBLL.Backup(date);
LogBLL.Logs(err);
}