public void ProcessMonthEnd(DateTime onDate)
{
MonthEnd monthEnd = CalculateTotalIncome(db, onDate);
monthEnd = CalculateTotalExpenses(db, onDate, monthEnd);
monthEnd = CalculateSaleData(db, onDate, monthEnd);
monthEnd = CalculateSaleFinData(db, onDate, monthEnd);
monthEnd.EntryDate = DateTime.Today;
}
private MonthEnd CalculateTotalIncome(AprajitaRetailsContext db, DateTime onDate)
{
MonthEnd monthEnd = new MonthEnd();
monthEnd.TotalSaleIncome = db.DailySales.Where(c => DbFunctions.TruncateTime(c.SaleDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
monthEnd.TotalTailoringIncome = db.DailySales.Where(c => c.IsTailoringBill && DbFunctions.TruncateTime(c.SaleDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
monthEnd.TotalOtherIncome = 0; //TODO: Ohter Income group will be dealt with proper entry.
monthEnd.TotalRecipts = db.Receipts.Where(c => DbFunctions.TruncateTime(c.RecieptDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
return(monthEnd);
}
private MonthEnd CalculateTotalIncome(AprajitaRetailsContext db, DateTime onDate)
{
MonthEnd monthEnd = new MonthEnd
{
TotalSaleIncome = db.DailySales.Where(c => c.SaleDate.Month == (onDate).Month).Sum(c => c.Amount),
TotalTailoringIncome = db.DailySales.Where(c => c.IsTailoringBill && (c.SaleDate).Month == (onDate).Month).Sum(c => c.Amount),
TotalOtherIncome = 0, //TODO: Other Income group will be dealt with proper entry.
TotalRecipts = db.Receipts.Where(c => (c.RecieptDate).Month == (onDate).Month).Sum(c => c.Amount)
};
return(monthEnd);
}
public void ProcessMonthEnd(DateTime onDate)
{
MonthEnd monthEnd = null;
using (AprajitaRetailsContext db = new AprajitaRetailsContext())
{
monthEnd = CalculateTotalIncome(db, onDate);
monthEnd = CalculateTotalExpenses(db, onDate, monthEnd);
monthEnd = CalculateSaleData(db, onDate, monthEnd);
monthEnd = CalculateSaleFinData(db, onDate, monthEnd);
monthEnd.EntryDate = DateTime.Today;
}
}
public static List <MonthEnd> GetMonthEndList(string officeIDs, bool allOffices = false, bool showDeleted = false)
{
List <MonthEnd> MonthEndList = new List <MonthEnd>();
DataTable MonthEndTable = MonthEndDataAccess.GetInstance.GetMonthEndList(officeIDs, allOffices, showDeleted);
foreach (DataRow dr in MonthEndTable.Rows)
{
MonthEnd TheMonthEnd = DataRowToObject(dr);
MonthEndList.Add(TheMonthEnd);
}
return(MonthEndList);
}
public static MonthEnd DataRowToObject(DataRow dr)
{
MonthEnd TheMonthEnd = new MonthEnd
{
MonthEndID = int.Parse(dr["MonthEndID"].ToString()),
DateFrom = DateTime.Parse(dr["DateFrom"].ToString()).ToString(Micro.Commons.MicroConstants.DateFormat),
DateTo = DateTime.Parse(dr["DateTo"].ToString()).ToString(Micro.Commons.MicroConstants.DateFormat),
GraceDays = int.Parse(dr["GraceDays"].ToString()),
ClosingDate = DateTime.Parse(dr["ClosingDate"].ToString()).ToString(Micro.Commons.MicroConstants.DateFormat),
Status = bool.Parse(dr["Status"].ToString()),
OfficeID = int.Parse(dr["OfficeID"].ToString()),
OfficeName = dr["OfficeName"].ToString()
};
return(TheMonthEnd);
}
private async void btnPrintA_Click(object sender, RoutedEventArgs e)
{
DocumentDamageReturnsByMonth form = new DocumentDamageReturnsByMonth(
new HerbariumSheet().GetDamagedSheetReport(MonthStart.ToString(), MonthEnd.ToString()))
{
Year = MonthStart.Year,
Month = Months[MonthStart.Month - 1],
};
printHelper = new PrintHelper(this.PrintContainer);
printHelper.AddFrameworkElementToPrint(form);
var printHelperOptions = new PrintHelperOptions(false);
printHelperOptions.Orientation = PrintOrientation.Portrait;
await printHelper.ShowPrintUIAsync("Herbarium Management IS - List of New Deposits", printHelperOptions);
//printHelper.PreparePrintContent(new DocumentNewDeposit());
}
public MonthEnd CalculateSaleFinData(AprajitaRetailsContext db, DateTime onDate, MonthEnd mEnd)
{
mEnd.TotalAmountAccess = mEnd.TotalAmountFabric = mEnd.TotalAmountOthers = mEnd.TotalAmountRMZ = 0;
//TODO: to be in version 2 & 3 onwards
return(mEnd);
}
public MonthEnd CalculateSaleData(AprajitaRetailsContext db, DateTime onDate, MonthEnd mEnd)
{
var endofdays = db.EndOfDays.Where(c => DbFunctions.TruncateTime(c.EOD_Date).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month);
if (endofdays != null)
{
mEnd.TotalFabric = endofdays.Sum(c => c.Shirting) + endofdays.Sum(c => c.Suiting);
mEnd.TotalAccess = endofdays.Sum(c => c.Access);
mEnd.TotalRMZ = endofdays.Sum(c => c.FM_Arrow) + endofdays.Sum(c => c.RWT) + endofdays.Sum(c => c.USPA);
mEnd.TotalOthers = 0;
}
return(mEnd);
}
private MonthEnd CalculateTotalExpenses(AprajitaRetailsContext db, DateTime onDate, MonthEnd mEnd)
{
mEnd.TotalSalary = db.Salaries.Where(c => DbFunctions.TruncateTime(c.PaymentDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalTailoringExpenses = db.TailoringSalaries.Where(c => DbFunctions.TruncateTime(c.PaymentDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalCashExpenses = db.CashExpenses.Where(c => DbFunctions.TruncateTime(c.ExpDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalHomeExpenses = db.CashPayments.Where(c => DbFunctions.TruncateTime(c.PaymentDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalPayments = db.Payments.Where(c => DbFunctions.TruncateTime(c.PayDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalDuesOfMonth = db.DuesLists.Include(c => c.DailySale).Where(c => c.IsRecovered == false && DbFunctions.TruncateTime(c.DailySale.SaleDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
mEnd.TotalDues = db.DuesLists.Where(c => !c.IsRecovered).Sum(c => c.Amount);
mEnd.TotalDuesRecovered = db.DuesLists.Where(c => DbFunctions.TruncateTime(c.RecoveryDate).Value.Month == DbFunctions.TruncateTime(onDate).Value.Month).Sum(c => c.Amount);
return(mEnd);
}
private void UpdateMonthEnd(AprajitaRetailsContext db, MonthEnd mEnd, bool upDate)
{
//TODO: Save MonthEnd data to database.
}
private void btnLoadA_Click(object sender, RoutedEventArgs e)
{
string date = (cbxMonth.SelectedIndex + 1) + "/" + "1/" + cbxYear.SelectedItem;
DateTime startDate = DateTime.Parse(date);
DateTime endDate = startDate.AddMonths(1).AddDays(-1);
MonthStart = startDate;
MonthEnd = endDate;
dgrReportResult.ItemsSource = new HerbariumSheet().GetDamagedSheetReport(MonthStart.ToString(), MonthEnd.ToString());
btnPrintA.Visibility = Visibility.Visible;
}
