public async Task <ActionResult> Get(DailyRevenueConfirmFCViewModel Filter) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter string filetype = HttpContext.Request.Query["FileType"].ToString().ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); StringBuilder sqlStringBuilder = new StringBuilder(); sqlStringBuilder.Append("EXEC sp_PDC_Report_DailyRevenueConfirmFC_Get '"); sqlStringBuilder.Append(Filter.ConfirmBy); sqlStringBuilder.Append("','"); sqlStringBuilder.Append(UserData.Username); sqlStringBuilder.Append("','"); sqlStringBuilder.Append(Filter.BranchList); sqlStringBuilder.Append("','"); sqlStringBuilder.Append(dateFrom.ToString("yyyyMMdd", enUS)); sqlStringBuilder.Append("','"); sqlStringBuilder.Append(dateTo.ToString("yyyyMMdd", enUS)); sqlStringBuilder.Append("'"); string strSQL = sqlStringBuilder.ToString(); List <DailyRevenueConfirmFC> DailyRevenues = await DB.DailyRevenueConfirmFC.FromSql(strSQL).ToListAsync(); if (filetype.Equals("excel")) { return(ExportExcelDailyRevenueConfirmFC(DailyRevenues)); } int totalCount = DailyRevenues.Count(); DailyRevenues = DailyRevenues.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = DailyRevenues; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = DailyRevenues.Count(), totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> Get(BranchMonthlyViewModel Filter) { Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); string FileType = Request.Query["FileType"]; string Type = Request.Query["Type"]; if (Type == null) { Type = ""; } DateTime monthYear = DateTime.ParseExact(Filter.MonthYear, "MM/yyyy", enUS); StringBuilder SQLStringBuilder = new StringBuilder(); SQLStringBuilder.Append("EXEC sp_RPT313_DHLVerifyReport '"); SQLStringBuilder.Append(UserData.Username); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(Filter.BranchList); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(monthYear.Month.ToString()); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(monthYear.Year.ToString()); SQLStringBuilder.Append("'"); string sql = SQLStringBuilder.ToString(); List <DHLVerify> DHLVerify = await DB.DHLVerify.FromSql(sql).ToListAsync(); if (FileType != null) { if (FileType.Equals("excel")) { //return ExportExcelLINEPayRemittance(Type, LINEPayRemittance); } } int totalCount = DHLVerify.Count; DHLVerify = DHLVerify.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = DHLVerify; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = DHLVerify.Count, totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> Get(BranchMonthlyViewModel Filter, String FileType) { Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); // Ref Page string type = Request.Query["Type"]; string VerifyID = ""; switch (type) { case "acc": VerifyID = "EXPENSE_VERIFY_FOR_ACC"; break; } DateTime monthYear = DateTime.ParseExact(Filter.MonthYear, "MM/yyyy", enUS); string exec = $"sp_RPT300_FN_MonthlyExpenseSync '{UserData.Username}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}'"; _logger.LogInformation(exec); await DB.Database.ExecuteSqlCommandAsync(exec); exec = $"EXEC sp_RPT310_GetMonthlyExpense '{UserData.Username}', '{Filter.BranchList}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}', '{VerifyID}'"; _logger.LogInformation(exec); List <MonthlyExpense> MonthlyExpense = await DB.MonthlyExpense.FromSql(exec).ToListAsync(); if (FileType != null) { if (FileType.Equals("excel")) { return(ExportExcelMonthlyExpense(MonthlyExpense)); } } int totalCount = MonthlyExpense.Count(); MonthlyExpense = MonthlyExpense.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = MonthlyExpense; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = MonthlyExpense.Count(), totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> Get(TypeBranchDateFromDateToViewModel Filter, string FileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter string filetype = (FileType ?? "").ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data string userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); string parameter = "'" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + dateTo.ToString("yyyyMMdd", enUS) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'"; string sql = "EXEC sp_PDC_Report_DailyRevenueVerify_Get " + parameter; _logger.LogInformation(sql); IQueryable <DailyRevenueVerify> queryableDailyRevenueVerify = DB.DailyRevenueVerify.FromSql(sql); if (filetype.Equals("excel")) { //string exec = $"sp_PDC_Dashboard_EODCoverPage_Get '{dateFrom.ToString("yyyyMMdd", new CultureInfo("en-US"))}', '" + dateTo.ToString("yyyyMMdd", enUS) + "', '{UserData.Username}', '{filter.BranchList}'"; string exec = $"sp_PDC_Dashboard_CloseShopCoverPage_Get '{dateFrom.ToString("yyyyMMdd", new CultureInfo("en-US"))}', '{dateTo.ToString("yyyyMMdd", new CultureInfo("en-US"))}', '{UserData.Username}', '{Filter.BranchList}'"; IQueryable <EOD> queryableEOD = DB.EOD.FromSql(exec); return(ExportExcelDailyRevenueVerify(dateFrom, dateTo, Filter.BranchList, await queryableDailyRevenueVerify.ToListAsync(), await queryableEOD.ToListAsync())); } int totalCount = queryableDailyRevenueVerify.Count(); List <DailyRevenueVerify> DailyRevenueVerify = queryableDailyRevenueVerify.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = DailyRevenueVerify; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = DailyRevenueVerify.Count(), totalCount }; DB.Dispose(); return(Json(Response.Render())); }
// GET Api/<controller> public async Task <ActionResult> Get(BranchMonthlyViewModel Filter, String FileType, String Type) { Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); if (Type == null) { Type = ""; } DateTime monthYear = DateTime.ParseExact(Filter.MonthYear, "MM/yyyy", enUS); string exec = $"sp_RPT300_FN_MonthlyExpenseSync '{UserData.Username}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}'"; _logger.LogInformation(exec); await DB.Database.ExecuteSqlCommandAsync(exec); exec = $"EXEC sp_PDC_Report_MonthlyCommissionSummary_Get '{UserData.Username}', '{Filter.BranchList}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}', { (Type.Equals("rt") ? "0" : "1") }, ''"; _logger.LogInformation(exec); List <MonthlySummaryCommission> MonthlySummaryCommission = await DB.MonthlySummaryCommission.FromSql(exec).ToListAsync(); if (FileType != null) { if (FileType.Equals("excel")) { return(ExportExcelMonthlyCommission(Type, MonthlySummaryCommission, monthYear)); } } int totalCount = MonthlySummaryCommission.Count(); MonthlySummaryCommission = MonthlySummaryCommission.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = MonthlySummaryCommission; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = MonthlySummaryCommission.Count(), totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <Object> Post(BranchDateFromDateToViewModel Filter) { Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); string FileType = Request.Form["filetype"]; string Type = Request.Form["Type"]; if (Type == null) { Type = ""; } DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); string sql = $"EXEC sp_PDC_Report_DCTopUpVerify_Get '{dateFrom.ToString("yyyyMMdd", enUS)}', '{dateTo.ToString("yyyyMMdd", enUS)}', '{UserData.Username}', '{Filter.BranchList}'"; _logger.LogInformation(sql); List <LINEPayRemittance> LINEPayRemittance = await DB.LINEPayRemittance.FromSql(sql).ToListAsync(); if (FileType != null) { if (FileType.Equals("excel")) { return(ExportExcel(dateFrom, dateTo, LINEPayRemittance)); } } int totalCount = LINEPayRemittance.Count; LINEPayRemittance = LINEPayRemittance.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = LINEPayRemittance; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = LINEPayRemittance.Count, totalCount = totalCount }; DB.Dispose(); return(Response.Render()); }
public async Task <object> Detail(string id, DateTime ReportDate) { try { var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); var date = ReportDate.ToString("yyyyMMdd", enUS); //DateTime dateStr = DateTime.ParseExact(ReportDate, "dd/MM/yyyy", enUS); string exec = $"EXEC sp_PDC_Report_DailyRevenueVerifyMatchCash_Get '{UserData.Username}', '{id}', '{ReportDate.ToString("yyyyMMdd", enUS)}'"; //string exec1 = $"EXEC sp_PDC_Report_DailyRevenueVerifyMatchCash_Get '{id}', '{ReportDate.ToString("yyyyMMdd", enUS)}'"; _logger.LogInformation(exec); DailyRevenueDetailCash Detail = await DB.DailyRevenueDetailCash.FromSql(exec).FirstOrDefaultAsync(); if (Detail == null) { return(ResponseNotFound(id)); } Response.Success = true; Response.Result = Detail; DB.Dispose(); return(Response.Render()); } catch (Exception ex) { string mss = ex.Message.ToString(); return(null); } // Auth Data }
public async Task <ActionResult> Get(ShopDailyViewModel Filter) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter string type = HttpContext.Request.Query["Type"].ToString().ToLower(); string filetype = HttpContext.Request.Query["FileType"].ToString().ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime date = DateTime.ParseExact(Filter.Date, "dd/MM/yyyy", new CultureInfo("en-US")); List <DashboardShopDaily> DashboardShopDaily = await DB.DashboardShopDaily .FromSql($"EXEC sp_RPT316_ShopDaily '{UserData.Username}', '{Filter.BranchList}', '{date.ToString("yyyyMMdd", new CultureInfo("en-US"))}'") .ToListAsync(); Response.Success = true; Response.Result = DashboardShopDaily; DB.Dispose(); return(Json(Response.Render())); }
private async Task <IActionResult> Report(int id, ViewResult viewResult, string with) { // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); switch (with) { case "BranchList": ViewData["BranchList"] = await DB.BranchList.FromSql("EXEC sp_RPT309_GetUserShopListByProfileId '" + UserData.Username + "', '" + null + "', 0").ToListAsync(); break; case "BranchListWithERP": ViewData["BranchList"] = await DB.BranchList.FromSql("EXEC sp_RPT309_GetUserShopListByProfileId '" + UserData.Username + "', '" + null + "', 1").ToListAsync(); break; case "UserProfile": ViewData["UserProfile"] = await DB.UserProfile.ToListAsync(); break; case "MonthlyExpenseUpdateRT": ViewData["UserProfile"] = await DB.UserProfile.ToListAsync(); break; case "DC-SHOP": ViewData["BranchList"] = await DB.BranchList.FromSql("EXEC sp_RPT301_GetBranchList '" + UserData.Username + "', 'DC-SHOP'").ToListAsync(); break; } List <Package> PackageAll = await DB.Package.OrderBy(p => p.UnitPrice).ToListAsync(); ViewData["PackageAll"] = PackageAll; var searchPackage = new List <string> { "PKG03", "PKG04", "PKG05", /*"PKG06",*/ "PKG07", "PKG08", "PKG18" }; ViewData["PackageList"] = PackageAll .Where(p => searchPackage.Contains(p.PackageID)) .ToList(); ViewData["SupplyList"] = PackageAll .Where(p => (new[] { 4, 5 }).Contains(p.PackageType.Value)) .OrderBy(p => p.UnitPrice) .ToList(); DB.Dispose(); return(viewResult); }
// GET: /<controller>/Type public async Task <object> Type() { // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); string sql = $"EXEC sp_PDC_BranchType_Get_Auth'{ UserData.Username }'"; Response.Success = true; Response.Result = await DB.BranchType.FromSql(sql) .GroupBy(t => t.TypeGroup, (key, list) => new { TypeGroupId = key, Types = list }) .ToListAsync(); DB.Dispose(); return(Response.Render()); }
public async Task <ActionResult> Get(TypeBranchDateFromDateToViewModel Filter, string FileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter string filetype = (FileType ?? "").ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); string parameter = "'" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + dateTo.ToString("yyyyMMdd", enUS) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'"; string sql = "EXEC sp_PDC_Report_StockOrder_Get " + parameter; _logger.LogInformation(sql); List <StockOrder> StockOrder = await DB.StockOrder.FromSql(sql).ToListAsync(); if (filetype.Equals("excel")) { return(ExportExcel(dateFrom, dateTo, StockOrder)); } int totalCount = StockOrder.Count(); StockOrder = StockOrder.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = StockOrder; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = StockOrder.Count(), totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <JsonResult> Post(UpdatePRViewModel UpdatePR) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime monthYear = DateTime.ParseExact(UpdatePR.MonthYear, "MM/yyyy", enUS); StringBuilder SQLStringBuilder = new StringBuilder(); for (int i = 0; i < UpdatePR.BranchID.Count(); i++) { SQLStringBuilder.AppendLine($"EXEC sp_RPT312_UpdatePR '{UserData.Username}', '{UpdatePR.BranchID[i]}', '{UpdatePR.PR[i]}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}'"); } string strSQL = SQLStringBuilder.ToString(); #region Product if (_hostingEnvironment.IsProduction()) { SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync(); Response.Success = save.code.Equals("000"); Response.Messages.Add(save.desc); } #endregion #region Tester else { Response.Success = true; Response.Messages.Add("Test"); } #endregion DB.Dispose(); return(Json(Response.Render())); }
// GET: /<controller>/ public async Task <IActionResult> Index() { // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); // Parameter string profile_id = HttpContext.Request.Query["FC"].ToString().ToUpper(); if (profile_id.Equals("ALL")) { profile_id = ""; } Response.Success = true; Response.Result = await DB.BranchList.FromSql("EXEC sp_RPT309_GetUserShopListByProfileId '" + UserData.Username + "', '" + profile_id + "'").ToListAsync(); DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> DiscountReport(ReqDiscount ReqDiscount, string FileType) { try { string[] lines = ReqDiscount.BranchList.Split(","); Pagination pagination = new Pagination(HttpContext); string filetype = (FileType ?? "").ToLower(); DateTime DateTo = DateTime.ParseExact(ReqDiscount.DateTo, "dd/MM/yyyy", new CultureInfo("en-US")); DateTime DateFrom = DateTime.ParseExact(ReqDiscount.DateFrom, "dd/MM/yyyy", new CultureInfo("en-US")); if (filetype.Equals("excel")) { return(ExportExcelDiscountReport(ReqDiscount, DateTo, DateFrom)); } List <BranchIdList> _items = new List <BranchIdList>(); foreach (var branch in lines) { BranchIdList _b = new BranchIdList { BranchId = branch.ToString() }; _items.Add(_b); } List <DiscountTypeList> _Dis = new List <DiscountTypeList>(); foreach (var DiscountType in ReqDiscount.DiscountTypeList) { DiscountTypeList _d = new DiscountTypeList { DiscountType = DiscountType.ToString() }; _Dis.Add(_d); } ReqDiscountType DiscountTypeList = new ReqDiscountType { DateFrom = DateFrom.ToString("yyyyMMdd"), DateTo = DateTo.ToString("yyyyMMdd"), BranchIdList = _items, DiscountTypeList = _Dis }; string json = JsonConvert.SerializeObject(DiscountTypeList); SqlParameter jsonInput = new SqlParameter() { ParameterName = "@jsonreq", SqlDbType = SqlDbType.NVarChar, SqlValue = json, Size = int.MaxValue }; SqlParameter jsonOutput = new SqlParameter() { ParameterName = "@jsonOutput", SqlDbType = SqlDbType.NVarChar, Direction = ParameterDirection.Output, Size = int.MaxValue }; DB.Database.ExecuteSqlCommand(" sp_PDC_Discount_Report_Detail @jsonreq, @jsonOutput OUTPUT ", jsonInput, jsonOutput); var data = jsonOutput.Value.ToString(); if (data == "" || data == null) { Response.Success = false; Response.Result = DiscountTypeList; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = 0, totalCount = 0 }; return(Json(Response.Render())); } //JObject dd = JObject.Parse("[" + jsonOutput.Value.ToString() + "]"); ResResultDiscount Discount = JsonConvert.DeserializeObject <ResResultDiscount>(jsonOutput.Value.ToString()); //GlobalVal._listDiscount = Discount; List <DiscountModel> disc = new List <DiscountModel>(); foreach (var item in Discount.Result) { DiscountModel dc = new DiscountModel { BranchType = item.BranchType, ERPID = item.ERPID, BranchId = item.BranchId, ReceiptNo = item.ReceiptNo, ReceiptDate = item.ReceiptDate, MemberId = item.MemberId, SenderName = item.SenderName, SenderMobile = item.SenderMobile, DiscountCode = item.DiscountCode, DiscountType = item.DiscountType, Surcharge = item.Surcharge, DiscountAmount = item.DiscountAmount }; disc.Add(dc); } GlobalVal._listDiscount = disc; int totalCount = Discount.Result.Count(); var _discount = Discount.Result.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = disc; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = _discount.Count(), totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); } catch (Exception ex) { var mss = ex.Message.ToString(); return(null); } }
public async Task <ActionResult> Get(ReportViewModel Filter, string type, string fileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter type = (type ?? "").ToLower(); fileType = (fileType ?? "").ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); int count = 0; int totalCount = 0; object result = new List <object>(); StringBuilder SQLStringBuilder = new StringBuilder(); SQLStringBuilder.Append("EXEC sp_PDC_Report_Insurance '"); SQLStringBuilder.Append(dateFrom.ToString("yyyyMMdd", enUS)); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(dateTo.ToString("yyyyMMdd", enUS)); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(UserData.Username); SQLStringBuilder.Append("', '"); SQLStringBuilder.Append(Filter.BranchList); SQLStringBuilder.Append("'"); String sqlStr = SQLStringBuilder.ToString(); List <Insurance> Insurances = await DB.Insurance.FromSql(sqlStr).ToListAsync(); if (fileType.Equals("excel")) { return(ExportExcelInsurance(Insurances, dateFrom, dateTo)); } totalCount = Insurances.Count(); Insurances = Insurances.Skip(pagination.From()).Take(pagination.To()).ToList(); result = Insurances; count = Insurances.Count(); Response.Success = true; Response.Result = result; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = count, totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public object BillPayment(BranchesBillDateRangeViewModel model) { try { if (!ModelState.IsValid) { return(Response.RenderError(ModelState)); } List <BranchIdList> _items = new List <BranchIdList>(); foreach (var branch in model.BranchIdList) { BranchIdList _b = new BranchIdList { BranchId = branch }; _items.Add(_b); } ReqReconcile _line = new ReqReconcile { DateFrom = DateTime.ParseExact(model.DateFrom, "dd/MM/yyyy", new CultureInfo("en-US")).ToString("yyyyMMdd"), DateTo = DateTime.ParseExact(model.DateTo, "dd/MM/yyyy", new CultureInfo("en-US")).ToString("yyyyMMdd"), //DateTo = DateTime.Parse(model.DateTo, new CultureInfo("en-US")).ToString("yyyyMMdd"), BranchIdList = _items }; string json = JsonConvert.SerializeObject(_line); SqlParameter jsonInput = new SqlParameter() { ParameterName = "@jsonreq", SqlDbType = SqlDbType.NVarChar, SqlValue = json, Size = int.MaxValue }; SqlParameter jsonOutput = new SqlParameter() { ParameterName = "@jsonOutput", SqlDbType = SqlDbType.NVarChar, Direction = ParameterDirection.Output, Size = int.MaxValue }; List <DailyRevenueReconcileBillPayment> dailyRevenueReconcile = DB.DailyRevenueReconcileBillPayment .FromSql( "EXEC sp_PDC_Report_DailyRevenueReconcileBillPayment_Get {0}, {1}, {2}, {3}, {4}" ).ToList(); DB.Database.ExecuteSqlCommand(" sp_PDC_Reconcile_Report_DailyRevenue_Bill_Payment_Verify_Summary @jsonreq, @jsonOutput OUTPUT ", jsonInput, jsonOutput); //JObject dd = JObject.Parse("[" + jsonOutput.Value.ToString() + "]"); List <SumMatching> RevenueData = JsonConvert.DeserializeObject <List <SumMatching> >("[" + jsonOutput.Value.ToString() + "]"); //0 Unmatch, 1 Match, 2 Not found data Response.Success = true; Response.Result = RevenueData; //Response.ResultInfo = new //{ // page = model.Page, // perPage = model.PerPage, // count = _line //}; DB.Dispose(); return(Response.Render()); } catch (Exception ex) { return(Response.RenderError(ModelState)); } }
public async Task <IActionResult> Login(LoginViewModel model, string returnUrl = null) { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Dashboard")); } if (!ModelState.IsValid) { return(RedirectToAction("Login", "Users")); } try { if (model.option == "ssgn") { //var ad = _api.LoginAD(model.Username, model.Password); //SSOService EDI = new SSOService(); //EDI = JsonConvert.DeserializeObject<SSOService>(ad); //if (EDI.ResultCode == "406" || EDI.ResultCode == "405") //{ // string LandingPage = EDI.LandingPage.ToString(); // //return RedirectToAction("Login", "Users"); // return RedirectToAction("Login", new RouteValueDictionary( // new { controller = "Users", action = "Login", LandingPage = LandingPage, status = EDI.ResultCode })); // //return Redirect(EDI.LandingPage.ToString()); //} //if (EDI.ResultCode != "200") //{ // ModelState.AddModelError("failed", "Plase login by Single Sign On Only."); // return RedirectToAction("Login", "Users"); //} UserMapRole user = new UserMapRole(); UserRole users = await DB.UserRole.FromSql("EXEC sp_PDC_Login_Get '" + model.Username + "'").Where(u => u.status != false).FirstAsync(); List <UserMenuRole> UserMenu = await DB.UserMenuRole.FromSql("EXEC sp_PDC_Get_Menu '" + model.Username + "'").ToListAsync(); user.UserMenu = UserMenu; user.Username = users.user_id; user.Name = users.user_name; user.RoleId = users.user_role; user.email = users.user_role; user.LastLogin = users.last_login; //User user = await DB.User // .Include(u => u.UserGroup) // .Include(u => u.UserMenu) // .Include(u => u.UserProfile) // .Where(u => u.email.Equals(EDI.Email.ToLower())) // .FirstAsync(); var AuthUser = DB.AuthUser.SingleOrDefault(c => c.user_id == model.Username); AuthUser.last_login = DateTime.Now; DB.SaveChanges(); _logger.LogInformation($"Logged in {model.Username}."); List <Claim> claims = new List <Claim> { new Claim(ClaimTypes.NameIdentifier, user.Username, ClaimValueTypes.String), new Claim(ClaimTypes.Name, user.Name, ClaimValueTypes.String), new Claim(ClaimTypes.Role, user.RoleId.ToString(), ClaimValueTypes.String), new Claim("User", JsonConvert.SerializeObject(user), new User().GetType().ToString()), }; List <Menu> menus; Stream fs = System.IO.File.OpenRead($@"{_hostingEnvironment.ContentRootPath}\menus.json"); using (StreamReader reader = new StreamReader(fs)) { menus = JsonConvert.DeserializeObject <List <Menu> >(await reader.ReadToEndAsync()); } fs.Dispose(); AddRole(user, menus, claims); ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "ApplicationCookie"); ClaimsPrincipal userPrincipal = new ClaimsPrincipal(userIdentity); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, userPrincipal); //await DB.SaveChangesAsync(); DB.Dispose(); } else { UserMapRole user = new UserMapRole(); UserRole users = await DB.UserRole.FromSql("EXEC sp_PDC_Login_Get '" + model.Username + "'").Where(u => u.status != false).FirstAsync(); List <UserMenuRole> UserMenu = await DB.UserMenuRole.FromSql("EXEC sp_PDC_Get_Menu '" + model.Username + "'").ToListAsync(); user.UserMenu = UserMenu; user.Username = users.user_id; user.Name = users.user_name; user.RoleId = users.user_role; user.email = users.user_role; user.LastLogin = users.last_login; bool is_auth = DB.AuthUser.Any(c => c.email == user.email); if (is_auth) { ModelState.AddModelError("failed", "Plase login by Single Sign On Only."); return(RedirectToAction("Login", "Users")); } user.LastLogin = DateTime.Now; DB.SaveChanges(); //var users = DB.User.FromSql("SELECT userid AS Username, username AS name, role_id AS RoleId, profile_id AS ProfileId FROM tb_master_user AS u WITH(NOLOCK) WHERE userid = '" + model.Username + "' AND pwd = '" + model.Password + "'"); _logger.LogInformation($"Logged in {model.Username}."); user.Password = string.Empty; List <Claim> claims = new List <Claim> { new Claim(ClaimTypes.NameIdentifier, user.Username, ClaimValueTypes.String), new Claim(ClaimTypes.Name, user.Name, ClaimValueTypes.String), new Claim(ClaimTypes.Role, user.RoleId.ToString(), ClaimValueTypes.String), new Claim("User", JsonConvert.SerializeObject(user), new User().GetType().ToString()), }; List <Menu> menus; Stream fs = System.IO.File.OpenRead($@"{_hostingEnvironment.ContentRootPath}\menus.json"); using (StreamReader reader = new StreamReader(fs)) { menus = JsonConvert.DeserializeObject <List <Menu> >(await reader.ReadToEndAsync()); } fs.Dispose(); AddRole(user, menus, claims); ClaimsIdentity userIdentity = new ClaimsIdentity(claims, "ApplicationCookie"); ClaimsPrincipal userPrincipal = new ClaimsPrincipal(userIdentity); await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, userPrincipal); //await DB.SaveChangesAsync(); var email = user.email; if (email == null || email == "") { TempData["email"] = "email"; TempData["username"] = user.Username; } else { TempData["email"] = user.email; } DB.Dispose(); } return(RedirectToLocal(returnUrl)); } catch (Exception e) { _logger.LogWarning($"Failed to login {model.Username}."); _logger.LogCritical(e.Message); ModelState.AddModelError("failed", "Invalid login attempt."); return(RedirectToAction("Login", "Users")); } }
public async Task <ActionResult> Get(ReportViewModel Filter, string type, string fileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter type = (type ?? "").ToLower(); fileType = (fileType ?? "").ToLower(); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); string parameter = "'" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + dateTo.ToString("yyyyMMdd", enUS) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'"; int count = 0; int totalCount = 0; object result = new List <object>(); #region ShopDailyRevenue if (type.Equals("shopdailyrevenue")) { List <ShopDailyRevenue> DailyRevenues = await DB.ShopDailyRevenue.FromSql("EXEC sp_RPT304_ShopDailyRevenue " + parameter + ", " + Filter.OrderBy.ToString()).ToListAsync(); if (fileType.Equals("excel")) { return(ExportExcelShopDailyRevenue(dateFrom, dateTo, DailyRevenues)); } totalCount = DailyRevenues.Count(); DailyRevenues = DailyRevenues.Skip(pagination.From()).Take(pagination.To()).ToList(); result = DailyRevenues; count = DailyRevenues.Count(); } #endregion #region Receipt else if (type.Equals("receipt")) { List <Receipt> Receipts = await DB.Receipt.FromSql("EXEC sp_RPT305_ReceiptReport " + parameter).ToListAsync(); if (fileType.Equals("excel")) { return(ExportExcelReceipt(Receipts, dateFrom, dateTo)); } totalCount = Receipts.Count(); Receipts = Receipts.Skip(pagination.From()).Take(pagination.To()).ToList(); result = Receipts; count = Receipts.Count(); } #endregion #region TaxInvoice else if (type.Equals("taxinvoice")) { List <TaxInvoice> TaxInvoices = await DB.TaxInvoice.FromSql("EXEC sp_RPT306_TaxInvoiceReport " + parameter + ", " + (Filter.Canceled == null || Filter.Canceled.Equals(false) ? "0" : "1")).ToListAsync(); if (fileType.Equals("excel")) { return(ExportExcelTaxInvoice(TaxInvoices, dateFrom, dateTo)); } totalCount = TaxInvoices.Count(); TaxInvoices = TaxInvoices.Skip(pagination.From()).Take(pagination.To()).ToList(); result = TaxInvoices; count = TaxInvoices.Count(); } #endregion #region MonthlyCommission else if (type.Equals("commission")) { DateTime MonthYear = DateTime.ParseExact(Filter.MonthYear, "MM/yyyy", enUS); List <MonthlyCommission> MonthlyCommissions = await DB.MonthlyCommission.FromSql("EXEC sp_RPT307_MonthlyCommission '" + MonthYear.ToString("yyyyMM", enUS) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'").ToListAsync(); if (fileType.Equals("excel")) { dateFrom = MonthYear; dateTo = MonthYear.AddMonths(1).AddDays(-1); List <DailyCommission> DailyCommissions = await DB.DailyCommission.FromSql("EXEC sp_RPT307_DailyCommission '" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + dateTo.ToString("yyyyMMdd", enUS) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'").ToListAsync(); return(ExportExcelMonthlyCommissions(DailyCommissions, MonthlyCommissions)); } totalCount = MonthlyCommissions.Count(); MonthlyCommissions = MonthlyCommissions.Skip(pagination.From()).Take(pagination.To()).ToList(); result = MonthlyCommissions; count = MonthlyCommissions.Count(); } #endregion #region LINEPay else if (type.Equals("linepay")) { string LineType = HttpContext.Request.Query["TypeLine"].ToString().ToLower(); List <LINEPay> LINEPay = new List <Models.LINEPay> { }; List <LINETopUp> LINETopUp = new List <Models.LINETopUp> { }; if (LineType.Equals("payment") || fileType.Equals("excel")) { LINEPay = await DBPMGW.LINEPay.FromSql("EXEC sp_RLP001_LINEPayReport '" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + Filter.BranchList + "'").ToListAsync(); totalCount = LINEPay.Count(); LINEPay = LINEPay.Skip(pagination.From()).Take(pagination.To()).ToList(); result = LINEPay; count = LINEPay.Count(); } if (LineType.Equals("topup") || fileType.Equals("excel")) { LINETopUp = await DBPMGW.LINETopUp.FromSql("EXEC sp_RLP002_LINETopUpReport '" + dateFrom.ToString("yyyyMMdd", enUS) + "', '" + Filter.BranchList + "'").ToListAsync(); totalCount = LINETopUp.Count(); LINETopUp = LINETopUp.Skip(pagination.From()).Take(pagination.To()).ToList(); result = LINETopUp; count = LINETopUp.Count(); } if (fileType.Equals("excel")) { return(ExportExcelLINEPay(LINEPay, LINETopUp)); } } #endregion #region LINEPayRemittance else if (type.Equals("linetopupremittance")) { DateTime dateRemittance = DateTime.ParseExact(Filter.DateRemittance, "dd/MM/yyyy", enUS); string date = DateTime.Now.ToString("yyyyMMdd"); StringBuilder sqlStringBuilder = new StringBuilder(); sqlStringBuilder.Append("EXEC sp_RPT308_LINEPayRemittanceReport '"); //sqlStringBuilder.Append(dateFrom.ToString("yyyyMMdd", enUS)); //sqlStringBuilder.Append("','"); //sqlStringBuilder.Append(dateTo.ToString("yyyyMMdd", enUS)); //sqlStringBuilder.Append("','"); sqlStringBuilder.Append(dateRemittance.ToString("yyyyMMdd", enUS)); sqlStringBuilder.Append("'"); List <LINEPayRemittance> LINEPayRemittance = await DB.LINEPayRemittance.FromSql(sqlStringBuilder.ToString()).ToListAsync(); if (fileType.Equals("excel")) { return(ExportExcelLINEPayRemittance(LINEPayRemittance)); } else if (fileType.Equals("pdf")) { return(ExportPdfLINEPayRemittance(LINEPayRemittance, dateRemittance)); } totalCount = LINEPayRemittance.Count(); LINEPayRemittance = LINEPayRemittance.Skip(pagination.From()).Take(pagination.To()).ToList(); result = LINEPayRemittance; count = LINEPayRemittance.Count(); } #endregion Response.Success = true; Response.Result = result; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = count, totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> Get(CloseShopViewModel Filter, string Type, string FileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter Type = Type ?? string.Empty; FileType = FileType ?? string.Empty; Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", new CultureInfo("en-US")); string parameter = "'" + dateFrom.ToString("yyyyMMdd", new CultureInfo("en-US")) + "', '" + UserData.Username + "', '" + Filter.BranchList + "'"; int count = 0; int totalCount = 0; object result = new List <object>(); string EXEC = "EXEC sp_PDC_Dashboard_CloseShop_Get "; if (Type.Equals("confirm")) { //EXEC = "EXEC sp_RPT302_DailyRevenueConfirmed "; } string sql = EXEC + parameter; _logger.LogInformation(sql); if (Type.Equals("closeshop")) { IQueryable <CloseShop> CloseShop = DB.CloseShop.FromSql(sql); if (FileType.Equals("excel")) { //return await ExportExcelVerify(DailyRevenue); } count = await CloseShop.Skip(pagination.From()).Take(pagination.To()).CountAsync(); totalCount = CloseShop.Count(); result = await CloseShop.Skip(pagination.From()).Take(pagination.To()).ToListAsync(); } //else if (type.Equals("confirm")) //{ // IQueryable<DailyRevenueConfirm> DailyRevenue = DB.DailyRevenueConfirm.FromSql(EXEC + parameter); // if (filetype.Equals("excel")) // { // //return await ExportExcelConfirm(DailyRevenue); // } // count = await DailyRevenue.Skip(pagination.From()).Take(pagination.To()).CountAsync(); // totalCount = DailyRevenue.Count(); // result = await DailyRevenue.Skip(pagination.From()).Take(pagination.To()).ToListAsync(); //} Response.Success = true; Response.Result = result; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count, totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <ActionResult> Get(TypeBranchDateFromDateToViewModel Filter, string FileType) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } // Parameter string filetype = (FileType ?? "").ToLower(); bool withReviewBalance = filetype.Equals("excelreviewbalance"); Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); string parameter = $"'{ dateFrom.ToString("yyyyMMdd", enUS) }', '{ dateTo.ToString("yyyyMMdd", enUS) }', '{ UserData.Username }', '{ Filter.BranchList }'"; string sql = "EXEC sp_PDC_Report_DailyRevenueConfirm_Get " + parameter; _logger.LogInformation(sql); List <DailyRevenueConfirm> DailyRevenueConfirm = await DB.DailyRevenueConfirm.FromSql(sql).ToListAsync(); if (withReviewBalance) { string[] branchList = Filter.BranchList.Split(',', StringSplitOptions.RemoveEmptyEntries); ReviewBalanceReport = DB.ReviewBalanceReport .Where( rb => rb.ReportDate.Value >= dateFrom && rb.ReportDate <= dateTo && branchList.Contains(rb.BranchID)) .OrderBy(rb => rb.OracleDC) .OrderBy(rb => rb.ReceiptDate) .ToList(); } if (filetype.Equals("excel") || filetype.Equals("excelreviewbalance")) { return(ExportExcelDailyRevenueConfirm(dateFrom, dateTo, DailyRevenueConfirm, withReviewBalance, ReviewBalanceReport)); } int totalCount = DailyRevenueConfirm.Count(); DailyRevenueConfirm = DailyRevenueConfirm.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = DailyRevenueConfirm; Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = DailyRevenueConfirm.Count(), totalCount }; DB.Dispose(); return(Json(Response.Render())); }
public async Task <IActionResult> Get(ServicePointDaliyGetViewModel Filter) { if (!ModelState.IsValid) { return(Json(Response.RenderError(ModelState))); } Pagination pagination = new Pagination(HttpContext); // Auth Data var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value; UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData); DateTime dateFrom = DateTime.ParseExact(Filter.DateFrom, "dd/MM/yyyy", enUS); DateTime dateTo = DateTime.ParseExact(Filter.DateTo, "dd/MM/yyyy", enUS); StringBuilder sqlStringBuilder = new StringBuilder(); sqlStringBuilder.Append("EXEC sp_SynRTSP07_GetCommisionFee N'"); sqlStringBuilder.Append("<dbxml>"); sqlStringBuilder.Append("<req>"); sqlStringBuilder.Append($"<date_from>{ dateFrom.ToString("yyyyMMdd", enUS) }</date_from>"); sqlStringBuilder.Append($"<date_to>{ dateTo.ToString("yyyyMMdd", enUS) }</date_to>"); sqlStringBuilder.Append($"<project_id>PSP</project_id>"); sqlStringBuilder.Append("</req>"); string[] profiles = (Filter.ProfileIds ?? "ALL").Split(','); foreach (string profile in profiles) { sqlStringBuilder.Append($"<profile><profile_id>{ profile }</profile_id></profile>"); } sqlStringBuilder.Append("</dbxml>'"); string strSQL = sqlStringBuilder.ToString(); _logger.LogInformation(strSQL); List <DailyCommission> DailyCommission = await DBRTSP.DailyCommission.FromSql(strSQL) .OrderBy(d => d.Verified) .ToListAsync(); if (Filter.Excel ?? false) { return(ExportExcel(DailyCommission)); } int totalCount = DailyCommission.Count(); DailyCommission = DailyCommission.Skip(pagination.From()).Take(pagination.To()).ToList(); Response.Success = true; Response.Result = DailyCommission.Select(c => new { id = $"{c.ProfileId}-{c.ReportDate.ToString("yyyyMMdd", enUS)}", c.ProfileId, c.ReportDate, c.ProfileName, c.BranchId, c.Consignment, c.Boxes, c.Cash, c.Verified }); Response.ResultInfo = new { page = pagination.Page, perPage = pagination.PerPage, count = DailyCommission.Count(), totalCount = totalCount }; DB.Dispose(); return(Json(Response.Render())); }