public async Task <ActionResult> loadInvoice(int id) { Cls_Invoice_Cancel Cls_Invoice_Cancel = new Cls_Invoice_Cancel(); Invoice_Cancel Invoice_Cancel = await db.Invoice_Cancel.FindAsync(id); Cls_Invoice_Cancel.ID = Invoice_Cancel.ID; Cls_Invoice_Cancel.Moshtary_id = Invoice_Cancel.Moshtary_id; Cls_Invoice_Cancel.Moshtary_Name = (Invoice_Cancel.Moshtary_id != null) ?Invoice_Cancel.Moshtary.Name:""; Cls_Invoice_Cancel.Date_Invoice = Invoice_Cancel.Date_Invoice.ToString("yyyy-mm-dd"); Cls_Invoice_Cancel.Date_Invoice_Hijri = Invoice_Cancel.Date_Invoice_Hijri; Cls_Invoice_Cancel.Price = Invoice_Cancel.Price; Cls_Invoice_Cancel.Total_Sadad = Invoice_Cancel.Total_Sadad; Cls_Invoice_Cancel.User_ID = Invoice_Cancel.User_ID; Cls_Invoice_Cancel.ComputerName = Invoice_Cancel.ComputerName; Cls_Invoice_Cancel.ComputerUser = Invoice_Cancel.ComputerUser; Cls_Invoice_Cancel.InDate = Invoice_Cancel.InDate.ToString("yyyy-mm-dd"); Cls_Invoice_Cancel.ClsInvoiceCancel_Product = new List <ClsInvoiceCancel_Product>(); foreach (var item in Invoice_Cancel.Invoice_Cancel_Product) { Cls_Invoice_Cancel.ClsInvoiceCancel_Product.Add( new ClsInvoiceCancel_Product { ID = item.ID, Invoice_Cancel_Id = item.Invoice_Cancel_Id, Product_Id = item.Product_Id, Product_Name = item.Product.Name, Amount = item.Amount, Price = item.Price, Taxes = item.Taxes, TotalPrice = item.TotalPrice, Date_Poduction = item.Date_Poduction.ToString("yyyy-mm-dd"), Date_Poduction_Hijri = item.Date_Poduction_Hijri, Date_Expiration = item.Date_Expiration.ToString("yyyy-mm-dd"), Date_Expiration_Hijri = item.Date_Expiration_Hijri, } ); } var list = JsonConvert.SerializeObject(Cls_Invoice_Cancel, Formatting.None, new JsonSerializerSettings() { ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore }); return(Content(list, "application/json")); }
public async Task <ActionResult> InsertInvoice(Cls_Invoice_Cancel Cls_Invoice_Cancel) { 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_Cancel _Invoice_Cancel = new Invoice_Cancel { Moshtary_id = Cls_Invoice_Cancel.Moshtary_id, Date_Invoice = Date_Invoice, Date_Invoice_Hijri = Date_Invoice_Hijri, Price = Cls_Invoice_Cancel.Price, Total_Sadad = 0, User_ID = int.Parse(Session["UserID"].ToString()), ComputerName = computerDetails[0], ComputerUser = computerDetails[1], InDate = Date_Invoice }; db.Invoice_Cancel.Add(_Invoice_Cancel); await db.SaveChangesAsync(); foreach (var item in Cls_Invoice_Cancel.ClsInvoiceCancel_Product) { int index = Cls_Invoice_Cancel.ClsInvoiceCancel_Product.IndexOf(item); int count = Cls_Invoice_Cancel.ClsInvoiceCancel_Product.Count; if (index < (count - 1)) { DateTime Date_Poduction = DateTime.ParseExact(item.Date_Poduction, "yyyy-MM-dd", CultureInfo.InvariantCulture); DateTime Date_Expiration = DateTime.ParseExact(item.Date_Expiration, "yyyy-MM-dd", CultureInfo.InvariantCulture); string Date_Poduction_Hijri = Date_Poduction.Date.ToString("dd/MM/yyyy", HijriDTFI); string Date_Expiration_Hijri = Date_Expiration.Date.ToString("dd/MM/yyyy", HijriDTFI); Invoice_Cancel_Product Invoice_Cancel_Product = new Invoice_Cancel_Product { Invoice_Cancel_Id = _Invoice_Cancel.ID, Product_Id = item.Product_Id, Amount = item.Amount, Price = item.Price, Store_id = 1, //// ** محتاج تعديل Date_Poduction = Date_Poduction, Date_Poduction_Hijri = Date_Poduction_Hijri, Date_Expiration = Date_Expiration, Date_Expiration_Hijri = Date_Expiration_Hijri, }; db.Invoice_Cancel_Product.Add(Invoice_Cancel_Product); } } await db.SaveChangesAsync(); //db.Invoice_Cancel.Add(_Invoice_Cancel); Error.ErrorName = "تم الإضافة بنجاح ... جاري إعادة تحميل الصفحة"; Error.ID = _Invoice_Cancel.ID; return(Json(Error, JsonRequestBehavior.AllowGet)); }