コード例 #1
0
        public ActionResult GetAllCustomerRevenueWeekly(DateTime startDate, DateTime endDate)
        {
            try
            {
                // Check autherization
                if (Session["User"] == null)
                {
                    return RedirectToAction("Index", "Home");
                }
                if (Session["UserRole"] != null && (int)Session["UserRole"] != 1)
                {
                    return RedirectToAction("Index", "StoreInfor");
                }

                ReportBusiness business = new ReportBusiness();
                List<sp_GetAllCustomerRevenueWeekly_Result> result = business.GetAllCustomerRevenueWeekly(startDate, endDate);

                if (result.Count > 10)
                {
                    ViewBag.Title = "Doanh thu theo khách hàng";
                    ViewBag.TreeView = "report";
                    ViewBag.TreeViewMenu = "customerRevenue";
                    return View(result);
                }
                else
                {
                    return RedirectToAction("ReviewRevenueByProduct", "Report");
                }
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }
コード例 #2
0
        public ActionResult Top10ProductIncomeDetail(string query)
        {
            try
            {
                // Check autherization
                if (Session["User"] == null)
                {
                    return RedirectToAction("Index", "Home");
                }
                if ((int)Session["UserRole"] != 1)
                {
                    return RedirectToAction("Index", "StoreInfor");
                }
                if (!query.IsEmpty())
                {
                    ViewBag.Title = "Chi tiết lợi nhuận từ sản phẩm";
                    string[] tempStrings = query.Split(';');

                    int id = Convert.ToInt32(tempStrings[0].Trim());

                    if (tempStrings[1].Length == 23)
                    {
                        DateTime startDate = DateTime.ParseExact(tempStrings[1].Substring(0, 10), "dd/MM/yyyy",
                            CultureInfo.InvariantCulture);
                        DateTime endDate = DateTime.ParseExact(tempStrings[1].Substring(13, 10), "dd/MM/yyyy",
                            CultureInfo.InvariantCulture);

                        ReportBusiness business = new ReportBusiness();

                        ReportProductIncomeViewModel result = business.GetReportProductIncomeViewModel(id, startDate, endDate, null, null,
                            null, null);

                        ViewBag.Title = "Lợi nhuận theo sản phẩm";
                        ViewBag.TreeViewMenu = "incomeProduct";
                        ViewBag.TreeView = "report";
                        return View("Top10ProductIncomeWeeklyDetail", result);
                    }
                    else if (tempStrings[1].Length == 17)
                    {
                        DateTime startDate = DateTime.ParseExact(tempStrings[1].Substring(0, 7), "MM/yyyy",
                            CultureInfo.InvariantCulture);
                        DateTime endDate = DateTime.ParseExact(tempStrings[1].Substring(10, 7), "MM/yyyy",
                            CultureInfo.InvariantCulture);

                        ReportBusiness business = new ReportBusiness();

                        ReportProductIncomeViewModel result = business.GetReportProductIncomeViewModel(id, null, null, startDate.Month,
                            startDate.Year, endDate.Month, endDate.Year);

                        ViewBag.Title = "Lợi nhuận theo sản phẩm";
                        ViewBag.TreeViewMenu = "incomeProduct";
                        ViewBag.TreeView = "report";
                        return View("Top10ProductIncomeMonthlyDetail", result);

                    }
                    else if (tempStrings[1].Length == 11)
                    {
                        int startYear = Convert.ToInt32(tempStrings[1].Substring(0, 4));
                        int endYear = Convert.ToInt32(tempStrings[1].Substring(7, 4));

                        ReportBusiness business = new ReportBusiness();

                        ReportProductIncomeViewModel result = business.GetReportProductIncomeViewModel(id, null, null, null, startYear,
                            null, endYear);

                        ViewBag.Title = "Lợi nhuận theo sản phẩm";
                        ViewBag.TreeViewMenu = "incomeProduct";
                        ViewBag.TreeView = "report";
                        return View("Top10ProductIncomeYearlyDetail", result);

                    }
                }
                return RedirectToAction("Index", "Home");
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }
コード例 #3
0
        public ActionResult ReviewRevenuePerCustomerPartialView(string start, string end, int? type)
        {
            try
            {
                // Check autherization
                if (Session["User"] == null)
                {
                    return null;
                }
                if (Session["UserRole"] != null && (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;
                    }
                    else
                    {
                        startDate = DateTime.ParseExact(start, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                        endDate = DateTime.ParseExact(end, "dd/MM/yyyy", CultureInfo.InvariantCulture);
                    }

                    List<sp_GetTop10CustomerRevenueWeekly_Result> result = business.GetTop10CustomerRevenueWeekly(startDate, endDate);
                    return PartialView("Top10CustomerRevenueWeeklyPartialView", result);
                }
                else if (type == 2)
                {
                    DateTime startDate = DateTime.ParseExact(start, "MM/yyyy", CultureInfo.InvariantCulture);
                    DateTime endDate = DateTime.ParseExact(end, "MM/yyyy", CultureInfo.InvariantCulture);

                    List<sp_GetTop10CustomerRevenueMonthly_Result> result =
                        business.GetTop10CustomerRevenueMonthly(startDate, endDate);

                    return PartialView("Top10CustomerRevenueMonthlyPartialView", result);
                }
                else if (type == 3)
                {
                    DateTime startDate = DateTime.ParseExact(start, "yyyy", CultureInfo.InvariantCulture);
                    DateTime endDate = DateTime.ParseExact(end, "yyyy", CultureInfo.InvariantCulture);

                    List<sp_GetTop10CustomerRevenueYearly_Result> result =
                        business.GetTop10CustomerRevenueYearly(startDate, endDate);

                    return PartialView("Top10CustomerRevenueYearlyPartialView", result);
                }

                return null;
            }
            catch (Exception)
            {
                return null;
            }
        }
コード例 #4
0
 public ActionResult ReviewIncomeYearlyDetail(int year)
 {
     try
     {
         // Check autherization
         if (Session["User"] == null)
         {
             return RedirectToAction("Index", "Home");
         }
         if ((int)Session["UserRole"] != 1)
         {
             return RedirectToAction("Index", "StoreInfor");
         }
         ViewBag.Title = "Lợi nhuận năm " + year;
         ViewBag.TreeView = "report";
         ViewBag.TreeViewMenu = "incomeReport";
         ReportBusiness reportBusiness = new ReportBusiness();
         ReportIncomeViewModel reportIncome = reportBusiness.ReviewIncomeYearlyDetail(year);
         return View(reportIncome);
     }
     catch (Exception)
     {
         return RedirectToAction("ManageError", "Error");
     }
 }
コード例 #5
0
 public ActionResult ReviewIncomeWeeklyDetail(DateTime startDate, DateTime endDate)
 {
     try
     {
         // Check autherization
         if (Session["User"] == null)
         {
             return RedirectToAction("Index", "Home");
         }
         if ((int)Session["UserRole"] != 1)
         {
             return RedirectToAction("Index", "StoreInfor");
         }
         ViewBag.Title = "Lợi nhuận từ " + startDate.ToString("dd/MM/yyyy") + " đến " + endDate.ToString("dd/MM/yyyy");
         ViewBag.TreeView = "report";
         ViewBag.TreeViewMenu = "incomeReport";
         ReportBusiness reportBusiness = new ReportBusiness();
         ReportIncomeViewModel reportIncome = reportBusiness.ReviewIncomeWeeklyDetail(startDate, endDate);
         return View(reportIncome);
     }
     catch (Exception)
     {
         return RedirectToAction("ManageError", "Error");
     }
 }
コード例 #6
0
        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;
            }
        }
コード例 #7
0
        public ActionResult GetAllProductIncomeYearly(int startYear, int endYear)
        {
            try
            {
                // Check autherization
                if (Session["User"] == null)
                {
                    return RedirectToAction("Index", "Home");
                }
                if (Session["UserRole"] != null && (int)Session["UserRole"] != 1)
                {
                    return RedirectToAction("Index", "StoreInfor");
                }

                DateTime startDate = new DateTime(startYear, 1, 1);
                DateTime endDate = new DateTime(endYear, 1, 1);

                ReportBusiness business = new ReportBusiness();
                List<sp_GetAllProductIncomeYearly_Result> result = business.GetAllProductIncomeYearly(startDate, endDate);

                if (result.Count > 10)
                {
                    ViewBag.Title = "Lợi nhuận theo sản phẩm";
                    ViewBag.TreeViewMenu = "incomeProduct";
                    ViewBag.TreeView = "report";
                    return View(result);
                }
                else
                {
                    return RedirectToAction("ReviewRevenueByProduct", "Report");
                }
            }
            catch (Exception)
            {
                return RedirectToAction("ManageError", "Error");
            }
        }
コード例 #8
0
ファイル: TaxBusiness.cs プロジェクト: truonggiang25493/BMA
        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;
        }