public async Task <ActionResult> DeleteConfirmed(int id)
{
ReadingOfFiscalMemory readingOfFiscalMemory = await db.ReadingOfFiscalMemories.FindAsync(id);
Module module = await db.Modules.FindAsync(readingOfFiscalMemory.ModuleId);
if (module == null)
{
return(HttpNotFound());
}
//usun odczyt tylko w przypadku jesli pamiec fiskalna jest ostatnim modułem (cały czas aktywna)
if (!module.Active)
{
ModelState.AddModelError(string.Empty, "Nie można usunąć rekordu");
return(PartialView(readingOfFiscalMemory));
}
module.Status = "FISKALNY";
db.ReadingOfFiscalMemories.Remove(readingOfFiscalMemory);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException /* ex*/)
{
ModelState.AddModelError(string.Empty, "Nie można usunąć rekordu, ponieważ jest powiązany z innymi rekordami w bazie danych");
return(PartialView(readingOfFiscalMemory));
}
return(Json(new { url = Url.Action("Index", "ReadingOfFiscalMemories"), success = true }));
}
public async Task <ActionResult> Create([Bind(Include = "ReadingOfFiscalMemoryId,ModuleId,CustomerName,CustomerNIP,CustomerAddress,InstallationAddress,UniqueNumber,SerialNumber," +
"RegistrationNumber,DateOfFiscalization,ReadingReason,ReadingType,FromReport,ToReport,FromReportDate,ToReportDate," +
"S_PTU_A_old,S_PTU_B_old,S_PTU_C_old,S_PTU_D_old,S_PTU_E_old,S_PTU_F_old,S_PTU_G_old," +
"VAT_A_old,VAT_B_old,VAT_C_old,VAT_D_old,VAT_E_old,VAT_F_old,VAT_G_old," +
"PTU_A_old,PTU_B_old,PTU_C_old,PTU_D_old,PTU_E_old,PTU_F_old," +
"S_PTU_A_new,S_PTU_B_new,S_PTU_C_new,S_PTU_D_new,S_PTU_E_new,S_PTU_F_new,S_PTU_G_new," +
"VAT_A_new,VAT_B_new,VAT_C_new,VAT_D_new,VAT_E_new,VAT_F_new,VAT_G_new," +
"PTU_A_new,PTU_B_new,PTU_C_new,PTU_D_new,PTU_E_new,PTU_F_new," +
"TotalAmount,TotalAmountPTU,MemoryResetCount,NumberOfFiscalRecipt,NumberOfReciptCanceled,ValueOfCanceledRecipt,Addnotations,DatesOfInterimReviews,City,DateOfCompletion")] ReadingOfFiscalMemory readingOfFiscalMemory)
{
if (ModelState.IsValid)
{
Module module = await db.Modules.FindAsync(readingOfFiscalMemory.ModuleId);
if (module == null)
{
return(HttpNotFound());
}
//module.Active = false;
module.Status = "ODCZYT";
db.Entry(module).State = EntityState.Modified;
db.ReadingOfFiscalMemories.Add(readingOfFiscalMemory);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.VatOld = GetVatOldList();
ViewBag.VatNew = GetVatNewList();
ViewBag.VatZW = GetVatZWList();
return(View(readingOfFiscalMemory));
}
// GET: /ReadingOfFiscalMemories/Create
public ActionResult Create(int?deviceId)
{
if (deviceId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var deviceReadMemoryDetails = (from d in db.Devices
join m in db.Modules on d.DeviceId equals m.DeviceId
join df in db.DevicesFolders on d.DevicesFolderId equals df.DevicesFolderId
join fm in db.FiscalizationsToModules on m.ModuleId equals fm.ModuleId
join a in db.Addresses on fm.AddressId equals a.AddressId
join f in db.Fiscalizations on fm.FiscalizationId equals f.FiscalizationId
join c in db.Customers on f.CustomerId equals c.CustomerId
where ((m.Status == "FISKALNY") & (m.Active == true))
select new
{
ModuleId = m.ModuleId,
DeviceName = df.Name,
SerialNumber = d.SerialNumber,
UniqueNumber = m.UniqueNumber,
RegistrationNumber = d.RegistrationNumber,
DateOdFiscalization = f.FiscalizationDate,
//nie uwzglednia numeru lokalu
InstallationAddress = a.City == a.Post ? (a.Street == null ? a.City + " " + a.HomeNumber + ", " + a.ZipCode + " " + a.Post : "ul. " + a.Street + " " + a.HomeNumber + ", " + a.ZipCode + " " + a.Post):
(a.Street == null ? a.City + " " + a.HomeNumber + ", " + a.ZipCode + " " + a.Post : a.City + ", ul. " + a.Street + " " + a.HomeNumber + ", " + a.ZipCode + " " + a.Post),
CustomerName = c.Name,
CustomerNIP = c.Nip,
CustomerAddress = c.City == c.Post ? (c.Street == null ? c.City + " " + c.HomeNumber + ", " + c.ZipCode + " " + c.Post : "ul. " + c.Street + " " + c.HomeNumber + ", " + c.ZipCode + " " + c.Post) :
(c.Street == null ? c.City + " " + c.HomeNumber + ", " + c.ZipCode + " " + c.Post : c.City + ", ul. " + c.Street + " " + c.HomeNumber + ", " + c.ZipCode + " " + c.Post),
}).SingleOrDefault();
if (deviceReadMemoryDetails == null)
{
return(HttpNotFound());
}
ReadingOfFiscalMemory readMemory = new ReadingOfFiscalMemory();
readMemory.ModuleId = deviceReadMemoryDetails.ModuleId;
readMemory.SerialNumber = deviceReadMemoryDetails.SerialNumber;
readMemory.UniqueNumber = deviceReadMemoryDetails.UniqueNumber;
readMemory.RegistrationNumber = deviceReadMemoryDetails.RegistrationNumber;
readMemory.FromReportDate = readMemory.DateOfFiscalization = deviceReadMemoryDetails.DateOdFiscalization.Date;
readMemory.ToReportDate = null;//DateTime.Now.Date;
readMemory.DateOfCompletion = DateTime.Now.Date;
readMemory.InstallationAddress = deviceReadMemoryDetails.InstallationAddress;
readMemory.CustomerName = deviceReadMemoryDetails.CustomerName;
readMemory.CustomerNIP = deviceReadMemoryDetails.CustomerNIP;
readMemory.CustomerAddress = deviceReadMemoryDetails.CustomerAddress;
ViewBag.VatOld = GetVatOldList();
ViewBag.VatNew = GetVatNewList();
ViewBag.VatZW = GetVatZWList();
return(View(readMemory));
}
public async Task <ActionResult> GetReportPdf(int id)
{
ReadingOfFiscalMemory readerFiscalMemory = await db.ReadingOfFiscalMemories.FindAsync(id);
if (readerFiscalMemory == null)
{
return(HttpNotFound());
}
XtraReport reportService = new XtraReport();
string pathToReportService = Server.MapPath("~/Reports/odczyt_page1.repx");
reportService.LoadLayout(pathToReportService);
reportService.Parameters["ID"].Value = id;
reportService.CreateDocument();
XtraReport reportCustomer = new XtraReport();
string pathToReportCustomer = Server.MapPath("~/Reports/odczyt_page2.repx");
reportCustomer.LoadLayout(pathToReportCustomer);
reportCustomer.Parameters["ID"].Value = id;
reportCustomer.CreateDocument();
XtraReport unregisterDevice = new XtraReport();
string pathToUnregisterDevice = Server.MapPath("~/Reports/wyrejestrowanie_kasy.repx");
unregisterDevice.LoadLayout(pathToUnregisterDevice);
unregisterDevice.Parameters["ID"].Value = id;
unregisterDevice.Parameters["MODULE_ID"].Value = readerFiscalMemory.ModuleId;
unregisterDevice.CreateDocument();
XtraReport applicationForReading = new XtraReport();
string pathToApplicationForReading = Server.MapPath("~/Reports/wniosek_dokonanie_odczytu.repx");
applicationForReading.LoadLayout(pathToApplicationForReading);
applicationForReading.Parameters["ID"].Value = id;
applicationForReading.Parameters["MODULE_ID"].Value = readerFiscalMemory.ModuleId;
applicationForReading.CreateDocument();
reportService.Pages.AddRange(reportCustomer.Pages);
reportService.Pages.AddRange(unregisterDevice.Pages);
reportService.Pages.AddRange(applicationForReading.Pages);
reportService.PrintingSystem.ContinuousPageNumbering = false;
var stream = new MemoryStream();
reportService.ExportToPdf(stream);
var cd = new System.Net.Mime.ContentDisposition
{
FileName = "odczyt.pdf",
Inline = false,
};
Response.AppendHeader("Content-Disposition", cd.ToString());
return(File(stream.GetBuffer(), "application/pdf"));
}
// GET: /ReadingOfFiscalMemories/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReadingOfFiscalMemory readingOfFiscalMemory = await db.ReadingOfFiscalMemories.FindAsync(id);
if (readingOfFiscalMemory == null)
{
return(HttpNotFound());
}
return(View(readingOfFiscalMemory));
}
public async Task <ActionResult> Edit([Bind(Include = "ReadingOfFiscalMemoryId,ModuleId,CustomerName,CustomerNIP,CustomerAddress,InstallationAddress,UniqueNumber,SerialNumber,RegistrationNumber,DateOfFiscalization,ReadingReason,ReadingType,FromReport,ToReport,FromReportDate,ToReportDate,S_PTU_A_old,S_PTU_B_old,S_PTU_C_old,S_PTU_D_old,S_PTU_E_old,S_PTU_F_old,S_PTU_G_old,VAT_A_old,VAT_B_old,VAT_C_old,VAT_D_old,VAT_E_old,VAT_F_old,VAT_G_old,PTU_A_old,PTU_B_old,PTU_C_old,PTU_D_old,PTU_E_old,PTU_F_old,S_PTU_A_new,S_PTU_B_new,S_PTU_C_new,S_PTU_D_new,S_PTU_E_new,S_PTU_F_new,S_PTU_G_new,VAT_A_new,VAT_B_new,VAT_C_new,VAT_D_new,VAT_E_new,VAT_F_new,VAT_G_new,PTU_A_new,PTU_B_new,PTU_C_new,PTU_D_new,PTU_E_new,PTU_F_new,TotalAmount,TotalAmountPTU,MemoryResetCount,NumberOfFiscalRecipt,NumberOfReciptCanceled,ValueOfCanceledRecipt,Addnotations,DatesOfInterimReviews,City,DateOfCompletion")] ReadingOfFiscalMemory readingOfFiscalMemory)
{
if (ModelState.IsValid)
{
db.Entry(readingOfFiscalMemory).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.VatOld = GetVatOldList();
ViewBag.VatNew = GetVatNewList();
ViewBag.VatZW = GetVatZWList();
return(View(readingOfFiscalMemory));
}
// GET: /ReadingOfFiscalMemories/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ReadingOfFiscalMemory readingOfFiscalMemory = await db.ReadingOfFiscalMemories.FindAsync(id);
if (readingOfFiscalMemory == null)
{
return(HttpNotFound());
}
ViewBag.VatOld = GetVatOldList();
ViewBag.VatNew = GetVatNewList();
ViewBag.VatZW = GetVatZWList();
return(View(readingOfFiscalMemory));
}
