public async Task <ActionResult> InsertInvoice(Cls_Invoice_Moshtary Cls_Invoice_Moshtary) { DateTime Date_Invoice = DateTime.Now; System.Globalization.DateTimeFormatInfo HijriDTFI; HijriDTFI = new System.Globalization.CultureInfo("ar-SA", false).DateTimeFormat; HijriDTFI.Calendar = new System.Globalization.HijriCalendar(); HijriDTFI.ShortDatePattern = "dd/MM/yyyy"; string Date_Invoice_Hijri = Date_Invoice.Date.ToString("dd/MM/yyyy", HijriDTFI); WindowsIdentity identity = HttpContext.Request.LogonUserIdentity; List <string> computerDetails = identity.Name.Split('\\').ToList(); Invoice_Moshtary _Invoice_Moshtary = new Invoice_Moshtary { Moshtary_id = Cls_Invoice_Moshtary.Moshtary_id, Date_Invoice = Date_Invoice, Date_Invoice_Hijri = Date_Invoice_Hijri, Price = Cls_Invoice_Moshtary.Price, Total_Sadad = 0, User_ID = int.Parse(Session["UserID"].ToString()), ComputerName = computerDetails[0], ComputerUser = computerDetails[1], InDate = Date_Invoice }; db.Invoice_Moshtary.Add(_Invoice_Moshtary); await db.SaveChangesAsync(); foreach (var item in Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product) { int index = Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product.IndexOf(item); int count = Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product.Count; if (index < (count - 1)) { Invoice_Moshtary_Product Invoice_Moshtary_Product = new Invoice_Moshtary_Product { Invoice_Moshtary_Id = _Invoice_Moshtary.ID, Product_Id = item.Product_Id, Amount = item.Amount, Price = item.Price }; db.Invoice_Moshtary_Product.Add(Invoice_Moshtary_Product); } } await db.SaveChangesAsync(); //db.Invoice_Moshtary.Add(_Invoice_Moshtary); Error.ErrorName = "تم الإضافة بنجاح ... جاري إعادة تحميل الصفحة"; Error.ID = _Invoice_Moshtary.ID; return(Json(Error, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> loadInvoice(int id) { Cls_Invoice_Moshtary Cls_Invoice_Moshtary = new Cls_Invoice_Moshtary(); Invoice_Moshtary Invoice_Moshtary = await db.Invoice_Moshtary.FindAsync(id); Cls_Invoice_Moshtary.ID = Invoice_Moshtary.ID; Cls_Invoice_Moshtary.Moshtary_id = Invoice_Moshtary.Moshtary_id; Cls_Invoice_Moshtary.Moshtary_Name = (Invoice_Moshtary.Moshtary_id != null) ?Invoice_Moshtary.Moshtary.Name:""; Cls_Invoice_Moshtary.Date_Invoice = Invoice_Moshtary.Date_Invoice.ToString("yyyy-mm-dd"); Cls_Invoice_Moshtary.Date_Invoice_Hijri = Invoice_Moshtary.Date_Invoice_Hijri; Cls_Invoice_Moshtary.Price = Invoice_Moshtary.Price; Cls_Invoice_Moshtary.Total_Sadad = Invoice_Moshtary.Total_Sadad; Cls_Invoice_Moshtary.User_ID = Invoice_Moshtary.User_ID; Cls_Invoice_Moshtary.ComputerName = Invoice_Moshtary.ComputerName; Cls_Invoice_Moshtary.ComputerUser = Invoice_Moshtary.ComputerUser; Cls_Invoice_Moshtary.InDate = Invoice_Moshtary.InDate.ToString("yyyy-mm-dd"); Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product = new List <ClsInvoiceMoshtary_Product>(); foreach (var item in Invoice_Moshtary.Invoice_Moshtary_Product) { Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product.Add( new ClsInvoiceMoshtary_Product { ID = item.ID, Invoice_Moshtary_Id = item.Invoice_Moshtary_Id, Product_Id = item.Product_Id, Product_Name = item.Product.Name, Amount = item.Amount, Price = item.Price, Taxes = item.Taxes, TotalPrice = item.TotalPrice } ); } var list = JsonConvert.SerializeObject(Cls_Invoice_Moshtary, Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore }); return(Content(list, "application/json")); }
public async Task <ActionResult> PrintInvoice(int id) { Cls_Invoice_Moshtary Cls_Invoice_Moshtary = new Cls_Invoice_Moshtary(); Invoice_Moshtary Invoice_Moshtary = await db.Invoice_Moshtary.FindAsync(id); Cls_Invoice_Moshtary.ID = Invoice_Moshtary.ID; Cls_Invoice_Moshtary.Moshtary_id = Invoice_Moshtary.Moshtary_id; Cls_Invoice_Moshtary.Moshtary_Name = (Invoice_Moshtary.Moshtary_id != null) ? Invoice_Moshtary.Moshtary.Name : ""; Cls_Invoice_Moshtary.Date_Invoice = Invoice_Moshtary.Date_Invoice.ToString("yyyy-mm-dd"); Cls_Invoice_Moshtary.Date_Invoice_Hijri = Invoice_Moshtary.Date_Invoice_Hijri; Cls_Invoice_Moshtary.Price = Invoice_Moshtary.Price; Cls_Invoice_Moshtary.Total_Sadad = Invoice_Moshtary.Total_Sadad; Cls_Invoice_Moshtary.User_ID = Invoice_Moshtary.User_ID; Cls_Invoice_Moshtary.ComputerName = Invoice_Moshtary.ComputerName; Cls_Invoice_Moshtary.ComputerUser = Invoice_Moshtary.ComputerUser; Cls_Invoice_Moshtary.InDate = Invoice_Moshtary.InDate.ToString("yyyy-mm-dd"); Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product = new List <ClsInvoiceMoshtary_Product>(); foreach (var item in Invoice_Moshtary.Invoice_Moshtary_Product) { Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product.Add( new ClsInvoiceMoshtary_Product { ID = item.ID, Invoice_Moshtary_Id = item.Invoice_Moshtary_Id, Product_Id = item.Product_Id, Product_Name = item.Product.Name, Amount = item.Amount, Price = item.Price, Taxes = item.Taxes, TotalPrice = item.TotalPrice } ); } string fileName = ExportReport(Cls_Invoice_Moshtary.ClsInvoiceMoshtary_Product); if (fileName != "") { string _path = System.Web.HttpContext.Current.Server.MapPath(@"~/Reports/pdf"); string path = Path.Combine(_path, fileName + ".pdf"); return(File(path, "application/pdf")); } //if (Session["UserID"] != null) //{ // decimal UserID = decimal.Parse(Session["UserID"].ToString()); // checkAccess = userRep.checkUserAccess(UserID, URLReport); // if (Session["Role"].ToString() == "1" || (checkAccess != null && checkAccess.Save == 1)) // { // string fileName = listExportRep.ExportBarCodeReport(id); // if (fileName != "") // { // if (Session["RoleName"].ToString() != "BigBoss") // { // ActionModel.ID = ActionRep.GetID(); // ActionModel.UserName = Session["Name"].ToString(); // ActionModel.ProgramUserID = decimal.Parse(Session["UserID"].ToString()); // ActionModel.Tim = time[0] + "h:" + time[1] + "m:" + Math.Round(decimal.Parse(time[2])) + "s"; // ActionModel.Dat = "14" + date[2] + "/" + date[1] + "/" + date[0]; // ActionModel.Action = "طباعة الباركود للمعاملة الصادرة التي تحمل الرقم المسلسل : " + id; // ActionModel.Operation = ((Operation)5).ToString(); // ActionModel.ViewName = viewName; // ActionRep.AddNewRecord(ActionModel); // } // string path = Path.Combine(UniversalRepository.GlobalVariables.GlobalReportPath, fileName + ".pdf"); // return File(path, "application/pdf"); // } // else // { // Error.ErrorFullNumber = "AR-Print-007"; // Error.ErrorNumber = "007"; // Error.Url = "/Home"; // Error.ErrorName = "حدث خطأ أثناء طباعة الملف برجاء المحاولة مرة آخري"; // return View("~/Views/Shared/ErrorPage.cshtml", Error); // } // } // else // { // Error.ErrorFullNumber = "AR-Print-000"; // Error.ErrorNumber = "000"; // Error.Url = "/Home"; // Error.ErrorName = "ليس لديك صلاحية طباعة الباركود للمعاملة الصادرة"; // return View("~/Views/Shared/ErrorPage.cshtml", Error); // } //} else { Error.ErrorFullNumber = "AR-Logout-089"; Error.ErrorNumber = "089"; Error.Url = "/ListExport/Operation/" + id; Error.ErrorName = "تم تسجيل خروجك آلياً لانتهاء المدة المسموح بها"; return(View("~/Views/Shared/ErrorPage.cshtml", Error)); } }