public JsonResult UpdateData(string finYear, DateTime fDate, DateTime tDate, string command)
{
List <Vat6P9P1_1> Part1 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part2 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part3 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part4 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part5 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part6 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part7 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part8 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part9 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part10 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part11 = new List <Vat6P9P1_1>();
string today = DateTime.Today.ToString("yyyy/MM/dd");
int month = fDate.Day;
int year = fDate.Year;
//@ProjCode, @BranchCode, @FinYear,@Year, @Month, @fdate,@tdate
//VM_rpt9P1_P1 '','','2019-20',2019,7,'2019-7-1','2019-7-31'
string sql = string.Format("EXEC VM_rpt9P1_P1 '','',''," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part1 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P2 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + today + "','64',1");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part2 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P3 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part3 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P4 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part4 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P5 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part5 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P6 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part6 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P7 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part7 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P8 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part8 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P9 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part9 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P10 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part10 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P11 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part11 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
Part1Part2Model finalItem = new Part1Part2Model();
finalItem.P1_1PArt1 = Part1;
finalItem.P1_1PArt2 = Part2;
finalItem.P1_1PArt3 = Part3;
finalItem.P1_1PArt4 = Part4;
finalItem.P1_1PArt5 = Part5;
finalItem.P1_1PArt6 = Part6;
finalItem.P1_1PArt7 = Part7;
finalItem.P1_1PArt8 = Part8;
finalItem.P1_1PArt9 = Part9;
finalItem.P1_1PArt10 = Part10;
finalItem.P1_1PArt11 = Part11;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate);
return(Json(new
{
redirectUrl = Url.Action("TransWiseVat6P9P1_1RptPdf", "VATRpt"),
finalItem,
isRedirect = true
}));
}
public ActionResult TransWiseVat6P9P1_1RptPdf(string finYear, DateTime fDate, DateTime tDate, string command)
{
List <Vat6P9P1_1> Part1 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part2 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part3 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part4 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part5 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part6 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part7 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part8 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part9 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part10 = new List <Vat6P9P1_1>();
List <Vat6P9P1_1> Part11 = new List <Vat6P9P1_1>();
string today = DateTime.Today.ToString("yyyy/MM/dd");
int month = fDate.Day;
int year = fDate.Year;
//@ProjCode, @BranchCode, @FinYear,@Year, @Month, @fdate,@tdate
//VM_rpt9P1_P1 '','','2019-20',2019,7,'2019-7-1','2019-7-31'
string sql = string.Format("EXEC VM_rpt9P1_P1 '','',''," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part1 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P2 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "','" + today + "','64',1");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part2 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P3 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part3 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P4 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part4 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P5 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part5 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P6 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part6 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P7 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part7 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P8 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part8 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P9 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part9 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P10 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part10 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
sql = string.Format("EXEC VM_rpt9P1_P11 '','','" + finYear + "'," + year + "," + month + ",'" + fDate.ToString("yyyy/MM/dd") + "','" + tDate.ToString("yyyy/MM/dd") + "'");
using (AcclineERPContext dbContext = new AcclineERPContext())
{
Part11 = dbContext.Database.SqlQuery <Vat6P9P1_1>(sql).ToList();
}
Part1Part2Model finalItem = new Part1Part2Model();
finalItem.P1_1PArt1 = Part1;
finalItem.P1_1PArt2 = Part2;
finalItem.P1_1PArt3 = Part3;
finalItem.P1_1PArt4 = Part4;
finalItem.P1_1PArt5 = Part5;
finalItem.P1_1PArt6 = Part6;
finalItem.P1_1PArt7 = Part7;
finalItem.P1_1PArt8 = Part8;
finalItem.P1_1PArt9 = Part9;
finalItem.P1_1PArt10 = Part10;
finalItem.P1_1PArt11 = Part11;
ViewBag.fDate = InWord.GetAbbrMonthNameDate(fDate);
ViewBag.tDate = InWord.GetAbbrMonthNameDate(tDate);
//bool process = false;
//For us Culture Ex: 0.00
const string culture = "en-US";
CultureInfo ci = CultureInfo.GetCultureInfo(culture);
Thread.CurrentThread.CurrentCulture = ci;
Thread.CurrentThread.CurrentUICulture = ci;
if (command == "Preview")
{
return(View(finalItem));
}
//return Json(process, JsonRequestBehavior.AllowGet);
else
{
sql = string.Format("exec Count_MRPrint " + year + "," + month + "");
}
IEnumerable <MonthlyReturn> MontlyReturnLst;
using (AcclineERPContext dbContext = new AcclineERPContext())
{
MontlyReturnLst = dbContext.Database.SqlQuery <MonthlyReturn>(sql).ToList();
}
return(View("TransWiseVat6P9P1_1RptPdf - Copy", finalItem));
//return new Rotativa.ViewAsPdf("TransWiseVat6P9P1_1RptPdf", "", finalItem)
//{
// //PageMargins= new Rotativa.Options.Margins(2,2,0,1),
// PageSize = Rotativa.Options.Size.A4, // (14f, 8.5f),
// // PageOrientation = Rotativa.AspNetCore.Options.Orientation.Landscape,
// PageOrientation = Rotativa.Options.Orientation.Portrait,
// CustomSwitches = "--footer-left \"Reporting Date: " + DateTime.Now.ToString("dd-MM-yyyy") + "\" " + "--footer-right \"Page: [page] of [toPage]\" --footer-line --footer-font-size \"9\" --footer-spacing 5 --footer-font-name \"calibri light\""
//};
}
