public ActionResult AutoInvoice(JuridicalInvoicesList SendInvoice)
{
string DocName = "JuridicalInvoce";
var path = System.IO.Path.GetTempPath();
var fileName = DocName + ".pdf";
var var = System.IO.Path.Combine(path, fileName);
bool isFromDiller = false;
string htmlString = RenderViewAsString("Utils", "~/Views/Utils/JuridicalInvoce.cshtml", SendInvoice, isFromDiller);
string baseUrl = ""; // collection["TxtBaseUrl"];
string pdf_page_size = "A4"; // collection["DdlPageSize"];
SelectPdf.PdfPageSize pageSize = (SelectPdf.PdfPageSize)Enum.Parse(typeof(SelectPdf.PdfPageSize),
pdf_page_size, true);
string pdf_orientation = "Portrait";// collection["DdlPageOrientation"];
SelectPdf.PdfPageOrientation pdfOrientation =
(SelectPdf.PdfPageOrientation)Enum.Parse(typeof(SelectPdf.PdfPageOrientation),
pdf_orientation, true);
string pdf_align = "Justify";// collection["DdlPageOrientation"];
SelectPdf.PdfTextHorizontalAlign pdfTextAlign =
(SelectPdf.PdfTextHorizontalAlign)Enum.Parse(typeof(SelectPdf.PdfTextHorizontalAlign),
pdf_align, true);
int webPageWidth = 1024;
int webPageHeight = 0;
SelectPdf.HtmlToPdf converter = new SelectPdf.HtmlToPdf();
// set converter options
converter.Options.PdfPageSize = pageSize;
converter.Options.PdfPageOrientation = pdfOrientation;
converter.Options.WebPageWidth = webPageWidth;
converter.Options.WebPageHeight = webPageHeight;
// create a new pdf document converting an url
SelectPdf.PdfDocument doc = converter.ConvertHtmlString(htmlString, baseUrl);
var FolderName = (@"C:\JuridicalInvoice\Invoice\" + DateTime.Now.ToString("dd -MM-yyyy"));
if (!Directory.Exists(FolderName))
{
Directory.CreateDirectory(FolderName);
}
var name = SplitAddresName("DigitalTv Invoice " + SendInvoice.Invoices_Code);
doc.Save(FolderName + '\\' + name);
return(null);
}
public void Execute(IJobExecutionContext context)
{
List <int> OneTicketMessed = new List <int>();
RandomMessed(OneTicketMessed);
try
{
using (DataContext _db = new DataContext())
{
var Invoce_Code = _db.InvoiceLoggings.Select(s => s.invoce_code).ToList();
if (Invoce_Code != null) // განმეორებადი კოდის გამორიცხვა
{
OneTicketMessed = OneTicketMessed.Except(Invoce_Code).ToList();
}
string _Image = ImageConvert();
DateTime dateFrom = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0);
//ViewBag.FilePath = _db.Params.Where(p => p.Name == "FTPHost").Select(p => p.Value).First() + "invoce/";
var _CustumerI = _db.Customers.Include("Cards").Include("CustomerSellAttachments").Where(c => c.Type == CustomerType.Juridical).ToList();
InvoicesList _invoce = new InvoicesList();
List <DisruptInvoice> Disrupt = new List <DisruptInvoice>();
//Task<CardInfo> _info;
foreach (var item in _CustumerI)
{
decimal balanceSum = 0; bool send_invoce = false;
foreach (var card_item in item.Cards)
{
_card = _db.Cards.Where(c => c.Id == card_item.Id).Include("Customer").Include("Subscribtions.SubscriptionPackages.Package").Select(c => new CardDetailData
{
PaymentAmount = c.Payments.Sum(p => (decimal?)p.Amount) ?? 0,
ChargeAmount = c.CardCharges.Select(s => (decimal?)s.Amount).Sum() ?? 0,
Card = c,
CustomerType = c.Customer.Type,
IsBudget = c.Customer.IsBudget,
SubscribAmount = c.Subscribtions.Where(s => s.Status).FirstOrDefault().Amount,
MinPrice = c.Subscribtions.FirstOrDefault(s => s.Status).SubscriptionPackages.Sum(p => p.Package.MinPrice),
CasIds = c.Subscribtions.FirstOrDefault(s => s.Status).SubscriptionPackages.Select(sp => (short)sp.Package.CasId)
}).FirstOrDefault();
decimal balance = Utils.Utils.GetBalance(_card.PaymentAmount, _card.ChargeAmount);
if (/*_info.Balances.Select(s => s.CurrentBalance).LastOrDefault()*/ balance < 0)
{
DisruptInvoice _disrup_invoice = new DisruptInvoice();
_disrup_invoice.Debts = balance;
_disrup_invoice.abonent_number = card_item.AbonentNum;
_disrup_invoice.Invoices_Code = _card.Card.Customer.Code;
_disrup_invoice.CompanyName = item.Name;
Disrupt.Add(_disrup_invoice);
balanceSum += balance;
}
}
if (balanceSum < 0)
{
//var ID = item.Cards.Select(s => s.Id).FirstOrDefault();
//var pack = _db.Subscribtions.Include("SubscriptionPackages").Where(c => c.CardId == ID).Select(ss => ss).ToList();
////var card_packages = pack.Where(c => c.CardId == ID).SelectMany(s => s.SubscriptionPackages).ToList();
JuridicalInvoicesList juridical_invoice = new JuridicalInvoicesList()
{
Name = item.Name,
dateFrom = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0),
dateTo = DateTime.Now,//,
_attachment = item.CustomerSellAttachments.Select(s => s).ToList(),
balance = Math.Abs(balanceSum),
Count = item.Cards.Count(),
Invoices_Code = _card.Card.Customer.Code,
PackagesPrice = _card.SubscribAmount,
Ramdom_Generator = OneTicketMessed[0],
Image = _Image,
Phone = item.Phone1
};
var SellAttachments = _db.SellAttachments.ToList();
var result = AutoInvoice(juridical_invoice);
var _result = DisruptAutoInvoice(Disrupt);
Disrupt.Clear();
bool send_sms = false;
bool send_email = SendMail(item.Email, juridical_invoice.Name, _db.Params.Where(c => c.Name == "SystemEmail").Select(s => s.Value).FirstOrDefault(), _db.Params.Where(c => c.Name == "SystemEmailPassword").Select(s => s.Value).FirstOrDefault(), juridical_invoice.Invoices_Code);
bool _send_email_Accounting = SendMail("*****@*****.**", juridical_invoice.Name, _db.Params.Where(c => c.Name == "SystemEmail").Select(s => s.Value).FirstOrDefault(), _db.Params.Where(c => c.Name == "SystemEmailPassword").Select(s => s.Value).FirstOrDefault(), juridical_invoice.Invoices_Code);
bool _send_email_aprove = SendMail(_db.Params.Where(c => c.Name == "SystemEmail").Select(s => s.Value).FirstOrDefault(), juridical_invoice.Name, _db.Params.Where(c => c.Name == "SystemEmail").Select(s => s.Value).FirstOrDefault(), _db.Params.Where(c => c.Name == "SystemEmailPassword").Select(s => s.Value).FirstOrDefault(), juridical_invoice.Invoices_Code);
bool _send_email_disrupt = Disrupt_SendMail("*****@*****.**", juridical_invoice.Name, _db.Params.Where(c => c.Name == "SystemEmail").Select(s => s.Value).FirstOrDefault(), _db.Params.Where(c => c.Name == "SystemEmailPassword").Select(s => s.Value).FirstOrDefault(), juridical_invoice.Invoices_Code);
if (item.Email != null)
{
send_sms = SendSms("568304304");
send_sms = SendSms(item.Phone1);
}
var _invoice = new InvoceLogging
{
tdate = DateTime.Now,
custumer_id = item.Id,
name = item.Name,
invoce_code = OneTicketMessed[0],
send_email = send_email,
send_sms = send_sms
};
_db.InvoiceLoggings.Add(_invoice);
_db.SaveChanges();
OneTicketMessed.Remove(OneTicketMessed[0]);
Thread.Sleep(60000);
}
}
}
}
catch (Exception ex)
{
Utils.Utils.ErrorLogging(ex, @"C:\DigitalTV\InvoiceLog\log.txt");
}
}