public async Task <ActionResult> loadInvoice(int id)
{
Cls_Invoice_mowrid Cls_Invoice_mowrid = new Cls_Invoice_mowrid();
Invoice_Mowrid Invoice_Mowrid = await db.Invoice_Mowrid.FindAsync(id);
if (Invoice_Mowrid != null)
{
Cls_Invoice_mowrid.User = Invoice_Mowrid.User;
Cls_Invoice_mowrid.ID = Invoice_Mowrid.ID;
Cls_Invoice_mowrid.Mowrid_id = Invoice_Mowrid.Mowrid_id;
Cls_Invoice_mowrid.Mowrid_Name = Invoice_Mowrid.Mowrid.Name;
Cls_Invoice_mowrid.Date_Invoice = Invoice_Mowrid.Date_Invoice.ToString("yyyy-mm-dd");
Cls_Invoice_mowrid.Date_Invoice_Hijri = Invoice_Mowrid.Date_Invoice_Hijri;
Cls_Invoice_mowrid.Price = Invoice_Mowrid.Price;
Cls_Invoice_mowrid.Total_Sadad = Invoice_Mowrid.Total_Sadad;
Cls_Invoice_mowrid.User_ID = Invoice_Mowrid.User_ID;
Cls_Invoice_mowrid.ComputerName = Invoice_Mowrid.ComputerName;
Cls_Invoice_mowrid.ComputerUser = Invoice_Mowrid.ComputerUser;
Cls_Invoice_mowrid.InDate = Invoice_Mowrid.InDate.ToString("yyyy-mm-dd");
Cls_Invoice_mowrid.ClsInvoiceMowrid_Product = new List <ClsInvoiceMowrid_Product>();
foreach (var item in Invoice_Mowrid.Invoice_Mowrid_Product)
{
Cls_Invoice_mowrid.ClsInvoiceMowrid_Product.Add(
new ClsInvoiceMowrid_Product
{
ID = item.ID,
Invoice_Mowrid_Id = item.Invoice_Mowrid_Id,
Product_Id = item.Product_Id,
Product_Name = item.Product.Name,
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,
Amount_ByJumla = item.Amount_ByJumla,
Carton_Count = item.Carton_Count,
Amount_ByUnit = item.Amount_ByUnit,
Price = item.Price,
Store_id = 1 //*****************************
}
);
}
}
var list = JsonConvert.SerializeObject(Cls_Invoice_mowrid,
Formatting.None,
new JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
});
return(Content(list, "application/json"));
}
public async Task <ActionResult> InsertInvoice(Cls_Invoice_mowrid Cls_Invoice_mowrid)
{
DateTime Date_Invoice = DateTime.ParseExact(Cls_Invoice_mowrid.Date_Invoice, "yyyy-MM-dd", CultureInfo.InvariantCulture);
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_Mowrid _Invoice_Mowrid = new Invoice_Mowrid
{
Mowrid_id = Cls_Invoice_mowrid.Mowrid_id,
Date_Invoice = Date_Invoice,
Date_Invoice_Hijri = Date_Invoice_Hijri,
Price = Cls_Invoice_mowrid.Price,
Total_Sadad = 0,
User_ID = int.Parse(Session["UserID"].ToString()),
ComputerName = computerDetails[0],
ComputerUser = computerDetails[1],
InDate = DateTime.Now
};
db.Invoice_Mowrid.Add(_Invoice_Mowrid);
await db.SaveChangesAsync();
foreach (var item in Cls_Invoice_mowrid.ClsInvoiceMowrid_Product)
{
int index = Cls_Invoice_mowrid.ClsInvoiceMowrid_Product.IndexOf(item);
int count = Cls_Invoice_mowrid.ClsInvoiceMowrid_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_Mowrid_Product Invoice_Mowrid_Product = new Invoice_Mowrid_Product
{
Invoice_Mowrid_Id = _Invoice_Mowrid.ID,
Product_Id = item.Product_Id,
Store_id = 1, //// ** محتاج تعديل
Date_Poduction = Date_Poduction,
Date_Poduction_Hijri = Date_Poduction_Hijri,
Date_Expiration = Date_Expiration,
Date_Expiration_Hijri = Date_Expiration_Hijri,
Amount_ByJumla = item.Amount_ByJumla,
Carton_Count = item.Carton_Count,
Amount_ByUnit = item.Amount_ByUnit,
Price = item.Price
};
db.Invoice_Mowrid_Product.Add(Invoice_Mowrid_Product);
}
}
await db.SaveChangesAsync();
//db.Invoice_Mowrid.Add(_Invoice_Mowrid);
Error.ErrorName = "تم الإضافة بنجاح ... جاري إعادة تحميل الصفحة";
Error.ID = _Invoice_Mowrid.ID;
return(Json(Error, JsonRequestBehavior.AllowGet));
}