public IEnumerable <BuffetReport> getBuffetExpenseReport(DateTime date)
{
using (ClubDBEntities club = new ClubDBEntities())
{
var bresult = (from o in club.BuffetMovs
where o.Date == date
select o).FirstOrDefault();
var cresult = (from o in club.CashMovs
where o.Date == date
select o).FirstOrDefault();
var eresult = (from o in club.ExpensesMovs
where o.Date == date
select o).FirstOrDefault();
BuffetReport buffet = new BuffetReport();
if (eresult != null)
{
buffet.Date = date.ToString("yyyy/MM/dd");
buffet.EBalance = eresult.Balance.ToString("0.00");
buffet.EExpenses = eresult.Expenses.ToString("0.00");
buffet.EMigBalance = eresult.MigBalance.ToString("0.00");
buffet.EPlusBalance = eresult.PlusBalance.ToString("0.00");
buffet.EPreBalance = eresult.PreBalance.ToString("0.00");
}
if (cresult != null)
{
buffet.Date = date.ToString("yyyy/MM/dd");
buffet.CBalance = cresult.Balance.ToString("0.00");
buffet.CBank = cresult.Bank.ToString("0.00");
buffet.CBuffetIncome = cresult.BuffetIncome.ToString("0.00");
buffet.CExpenses = cresult.Expenses.ToString("0.00");
buffet.CInvIncome = cresult.InvIncome.ToString("0.00");
buffet.CMigBalance = cresult.MigBalance.ToString("0.00");
buffet.CPreBalance = cresult.PreBalance.ToString("0.00");
}
if (bresult != null)
{
buffet.Date = date.ToString("yyyy/MM/dd");
buffet.BBalance = bresult.Balance.ToString("0.00");
buffet.BMigBalance = bresult.MigBalance.ToString("0.00");
buffet.BPreBalance = bresult.PreBalance.ToString("0.00");
buffet.BPurchase = bresult.Purchase.ToString("0.00");
buffet.BSales = bresult.Sales.ToString("0.00");
}
List <BuffetReport> ii = new List <BuffetReport>();
ii.Add(buffet);
return(ii.AsEnumerable());
}
}
protected void tbDate_TextChanged(object sender, EventArgs e)
{
if (!(string.IsNullOrEmpty(tbDate.Text)))
{
DateTime date = Convert.ToDateTime(tbDate.Text);
if (show)
{
BuffetReport buff = new BuffetReport();
using (ClubDBEntities club = new ClubDBEntities())
{
var re = club.getBuffetExpenseReport(date).First();
if (string.IsNullOrEmpty(re.CBalance))
{
reset();
lblError.Visible = true;
lblError.Text = "لا يوجد بيانات لعرضها";
}
else
{
cbEdit.Visible = true;
// cash
tbCBank.Text = re.CBank;
tbCExpenses.Text = re.CExpenses;
tbCIncome.Text = re.CInvIncome;
tbCMigBalance.Text = re.CMigBalance;
tbCPreBalance.Text = re.CPreBalance;
tbCTotal.Text = re.CBalance;
// buffet
//tbMigBalance.Text = re.BMigBalance;
//tbIncome.Text = re.BPurchase;
//tbTIncome.Text = re.BBalance;
//tbSales.Text = re.BSales;
//tbPreBalance.Text = re.BPreBalance;
Date = date;
// expenses
//tbOBalance.Text = re.EPlusBalance;
//tbOExpenses.Text = re.EExpenses;
//tbOMigBlanace.Text = re.EMigBalance;
//tbOPreBalance.Text = re.EPreBalance;
//tbOTBalance.Text = re.EBalance;
readOnly(true);
}
}
}
else
{
DateTime predate = date.AddDays(-1);
string day = cul.DateTimeFormat.DayNames[(int)date.DayOfWeek];
if (day == "Saturday")
{
predate = date.AddDays(-2);
}
using (ClubDBEntities club = new ClubDBEntities())
{
var buffet = (from o in club.BuffetMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
var cash = (from o in club.CashMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
var ex = (from o in club.ExpensesMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
//tbPreBalance.Text = buffet.ToString("0.00");
tbCPreBalance.Text = cash.ToString("0.00");
// get income
var sum = club.Deposits.Where(a => a.Date == date).Sum(a => (decimal?)a.Amount);
tbCIncome.Text = sum == null? "0" : sum.ToString();
var exp = club.Withdraws.Where(a => a.Date == date && a.BankID == null).Sum(a => (decimal?)a.Amount);
tbCExpenses.Text = exp == null ? "0": exp.ToString();
tbCTotal.Text = getSub(getSum(tbCIncome.Text, tbCPreBalance.Text), tbCExpenses.Text);
//tbOMigBlanace.Text = getSub(tbOTBalance.Text, tbOExpenses.Text);
tbCMigBalance.Text = getSub(tbCTotal.Text, tbCBank.Text);
}
}
}
}
protected void tbDate_TextChanged(object sender, EventArgs e)
{
if (!(string.IsNullOrEmpty(tbDate.Text)))
{
DateTime date = Convert.ToDateTime(tbDate.Text);
if (show)
{
BuffetReport buff = new BuffetReport();
using (ClubDBEntities club = new ClubDBEntities())
{
var re = club.getBuffetExpenseReport(date).First();
if (string.IsNullOrEmpty(re.BBalance))
{
lblError.Visible = true;
lblError.Text = "لا يوجد بيانات لعرضها";
}
else
{
// cash
tbCBank.Text = re.CBalance;
tbCBuffet.Text = re.CBuffetIncome;
tbCExpenses.Text = re.CExpenses;
tbCIncome.Text = re.CInvIncome;
tbCMigBalance.Text = re.CMigBalance;
tbCPreBalance.Text = re.CPreBalance;
tbCTotal.Text = re.CBalance;
// buffet
tbMigBalance.Text = re.BMigBalance;
tbIncome.Text = re.BPurchase;
tbTIncome.Text = re.BBalance;
tbSales.Text = re.BSales;
tbPreBalance.Text = re.BPreBalance;
// expenses
tbOBalance.Text = re.EPlusBalance;
tbOExpenses.Text = re.EExpenses;
tbOMigBlanace.Text = re.EMigBalance;
tbOPreBalance.Text = re.EPreBalance;
tbOTBalance.Text = re.EBalance;
readOnly();
}
}
}
else
{
DateTime predate = date.AddDays(-1);
using (ClubDBEntities club = new ClubDBEntities())
{
var buffet = (from o in club.BuffetMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
var cash = (from o in club.CashMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
var ex = (from o in club.ExpensesMovs
where o.Date == predate
select o.MigBalance).FirstOrDefault();
tbPreBalance.Text = buffet.ToString("0.00");
tbCPreBalance.Text = cash.ToString("0.00");
tbOPreBalance.Text = ex.ToString("0.00");
}
}
}
}
