public ActionResult ReviewByTimePartialView(string start, string end, int? type)
{
try
{
if (Session["User"] == null)
{
return null;
}
if ((int)Session["UserRole"] != 1)
{
return null;
}
ReportBusiness business = new ReportBusiness();
if (type == null)
{
type = 1;
}
if (type == 1)
{
DateTime startDate;
DateTime endDate;
if (start == null || end == null)
{
startDate = DateTime.Now.FirstDayOfWeek().AddDays(-21);
endDate = DateTime.Now.LastDayOfWeek();
}
else
{
startDate = DateTime.ParseExact(start, "dd/MM/yyyy", CultureInfo.InvariantCulture);
endDate = DateTime.ParseExact(end, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
List<sp_GetIncomeWeekly_Result> result = business.GetIncomeWeeklyStore(startDate, endDate);
return PartialView("ReviewIncomeWeeklyPartialView", result);
}
if (type == 2)
{
DateTime startMonth = DateTime.ParseExact(start, "MM/yyyy", CultureInfo.InvariantCulture);
DateTime endMonth = DateTime.ParseExact(end, "MM/yyyy", CultureInfo.InvariantCulture);
List<sp_GetIncomeMonthly_Result> result = business.GetIncomeMonthlyStore(startMonth.Month,
startMonth.Year, endMonth.Month, endMonth.Year);
return PartialView("ReviewIncomeMonthlyPartialView", result);
}
if (type == 3)
{
int startYear = DateTime.ParseExact(start, "yyyy", CultureInfo.InvariantCulture).Year;
int endYear = DateTime.ParseExact(end, "yyyy", CultureInfo.InvariantCulture).Year;
List<sp_GetIncomeYearly_Result> result = business.GetIncomeYearlyStore(startYear, endYear);
return PartialView("ReviewIncomeYearlyPartialView", result);
}
return null;
}
catch (Exception)
{
return null;
}
}
public TndnTaxDeclaration GeTndnTaxDeclaration(int year)
{
TndnTaxDeclaration result = db.TndnTaxDeclarations.FirstOrDefault(m => m.Year == year);
{
if (result == null)
{
result = new TndnTaxDeclaration();
StoreInfo storeInfo = db.StoreInfoes.FirstOrDefault();
if (storeInfo != null)
{
result.StoreOwnerName = storeInfo.OwnerName;
result.StoreTaxCode = storeInfo.TaxCode;
result.StoreAddress = storeInfo.Address;
result.StoreDistrict = storeInfo.District;
result.StoreProvince = storeInfo.Province;
result.StorePhone = storeInfo.Phonenumber;
result.StoreFax = storeInfo.Fax;
result.StoreEmail = storeInfo.Email;
result.SignName = storeInfo.OwnerName;
result.Year = year;
}
ReportBusiness business = new ReportBusiness();
List<sp_GetIncomeYearly_Result> incomeYearly = business.GetIncomeYearlyStore(year, year);
var revenue = incomeYearly.ElementAt(0).Revenue;
result.Value1 = revenue ?? 0;
result.Value2 = 0;
result.Value4 = 0;
result.Value5 = 0;
result.Value6 = 0;
result.Value7 = 0;
result.Value3 = result.Value4 + result.Value5 + result.Value6 + result.Value7;
result.Value8 = 0;
var materialExpense = incomeYearly.ElementAt(0).MaterialExpense;
result.Value10 = materialExpense ?? 0;
List<OtherExpense> value11List =
db.OtherExpenses.Where(m => m.Type == 11 && m.OtherExpenseYearTime == year).ToList();
result.Value11 = 0;
foreach (OtherExpense otherExpense in value11List)
{
result.Value11 += otherExpense.OtherExpenseAmount;
}
List<OtherExpense> value12List = db.OtherExpenses.Where(m => m.Type == 12 && m.OtherExpenseYearTime == year).ToList();
result.Value12 = 0;
foreach (OtherExpense otherExpense in value12List)
{
result.Value12 += otherExpense.OtherExpenseAmount;
}
result.Value9 = result.Value10 + result.Value11 + result.Value12;
result.Value13 = 0;
result.Value14 = 0;
result.Value15 = result.Value1 - result.Value3 + result.Value8 - result.Value9 - result.Value13;
result.Value16 = 0;
result.Value17 = 0;
result.Value18 = result.Value16 - result.Value17;
result.Value19 = result.Value15 + result.Value18;
result.ValueA1 = result.Value19;
result.ValueB1 = 0;
result.ValueB2 = 0;
result.ValueB3 = 0;
result.ValueB4 = 0;
result.ValueB5 = 0;
result.ValueB6 = 0;
result.ValueB7 = 0;
result.ValueB8 = 0;
result.ValueB9 = 0;
result.ValueB10 = 0;
result.ValueB11 = 0;
result.ValueB12 = result.ValueA1;
result.ValueB14 = 0;
result.ValueB13 = result.ValueB12 - result.ValueB14;
result.ValueC1 = result.ValueB13;
result.ValueC2 = 0;
result.ValueC3 = 0;
result.ValueC3a = 0;
result.ValueC3b = 0;
result.ValueC4 = result.ValueC1;
result.ValueC5 = 0;
result.ValueC6 = result.ValueC4 - result.ValueC5;
// Bug Hard code
int tndnTaxRate = 0;
TaxRate taxRate = db.TaxRates.FirstOrDefault(m => m.TaxRateId == 2);
if (taxRate != null)
{
tndnTaxRate = taxRate.TaxRateValue;
}
if (tndnTaxRate == 22)
{
result.ValueC7 = result.ValueC4;
}
else
{
result.ValueC7 = 0;
}
if (tndnTaxRate == 20)
{
result.ValueC8 = result.ValueC4;
}
else
{
result.ValueC8 = 0;
}
if (tndnTaxRate != 22 && tndnTaxRate != 20)
{
result.ValueC9 = result.ValueC4;
result.ValueC9a = tndnTaxRate;
}
else
{
result.ValueC9 = 0;
result.ValueC9a = 0;
}
result.ValueC10 = (int)(result.ValueC7 / 5 + result.ValueC8 * 0.22 + result.ValueC9 * result.ValueC9a / 100);
result.ValueC11 = 0;
result.ValueC12 = 0;
result.ValueC13 = 0;
result.ValueC14 = 0;
result.ValueC15 = 0;
result.ValueC16 = result.ValueC10 - result.ValueC11 - result.ValueC12 - result.ValueC15;
result.ValueD1 = result.ValueC16;
result.ValueD2 = 0;
result.ValueD3 = 0;
result.ValueD = result.ValueD1 + result.ValueD2 + result.ValueD3;
result.ValueE = 0;
result.ValueE2 = 0;
result.ValueE3 = 0;
result.ValueE1 = 0;
result.ValueG1 = result.ValueD1 - result.ValueE1;
result.ValueG2 = result.ValueD2 - result.ValueE2;
result.ValueG3 = result.ValueD3 - result.ValueE3;
result.ValueG = result.ValueG1 + result.ValueG2 + result.ValueG3;
result.ValueH = result.ValueD / 5;
result.ValueI = result.ValueG - result.ValueH;
result.ValueL1 = false;
}
}
return result;
}