public ActionResult AddInvoice2(int custId, int custShipId, string orderIds, string orderServiceIds, int billingTemplateId, int billingTypeId, int timeTypeId, string jobNo, string billing_code, string remark, double discount, double amount, string month, string date, int customer_ship_length, int customer_ship_teus, string isShowShipLengthRule, string isShowShipTEUSRule, float? ratio1, float? ratio2, float? ratio3, float? ratio4, float? ratio5, float? ratio6, float? ratio7, float? minTime, string jsonArrayItems, string jsonArraySummaryItems) { this.Internationalization(); using (TransactionScope trans = new TransactionScope()) { try { List<string> strOrderIDs = orderIds.Split(',').ToList(); List<int> iOrderIDs = new List<int>(); if (strOrderIDs != null) { foreach (var item in strOrderIDs) { iOrderIDs.Add(TugBusinessLogic.Module.Util.toint(item)); } } TugDataEntities db = new TugDataEntities(); { //0.验证账单编号是否已存在 var tmp = db.Billing.FirstOrDefault(u => u.BillingCode.Trim() == billing_code.Trim()); if (tmp != null) { var ret2 = new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret2, JsonRequestBehavior.AllowGet); } //1.插入账单 TugDataModel.Billing aScheduler = new Billing(); aScheduler.CustomerID = custId; aScheduler.JobNo = jobNo; aScheduler.IsShowShipLengthRule = isShowShipLengthRule; aScheduler.IsShowShipTEUSRule = isShowShipTEUSRule; aScheduler.InvoiceType = "普通账单"; aScheduler.BillingTemplateID = billingTemplateId; aScheduler.BillingTypeID = billingTypeId; //aScheduler.BillingCode = TugBusinessLogic.Utils.AutoGenerateBillCode(); aScheduler.BillingCode = billing_code.Trim() ; aScheduler.BillingName = ""; aScheduler.TimeTypeID = timeTypeId; aScheduler.Discount = discount; aScheduler.TotalRebate = 0; aScheduler.Amount = amount; aScheduler.Remark = remark; aScheduler.Month = month; aScheduler.UserDefinedCol10 = date; if (ratio1 != null) aScheduler.Ratio1 = (int?)Math.Round((float)ratio1, 2); if (ratio2 != null) aScheduler.Ratio2 = (int?)Math.Round((float)ratio2, 2); if (ratio3 != null) aScheduler.Ratio3 = (int?)Math.Round((float)ratio3, 2); if (ratio4 != null) aScheduler.Ratio4 = (int?)Math.Round((float)ratio4, 2); if (ratio5 != null) aScheduler.Ratio5 = (int?)Math.Round((float)ratio5, 2); if (ratio6 != null) aScheduler.Ratio6 = (int?)Math.Round((float)ratio6, 2); if (ratio7 != null) aScheduler.Ratio7 = (int?)Math.Round((float)ratio7, 2); if (minTime != null) aScheduler.MinTime = (int?)Math.Round((float)minTime, 2); aScheduler.TimesNo = 0; aScheduler.Status = "创建"; aScheduler.Phase = 0; aScheduler.OwnerID = -1; aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); aScheduler.UserID = Session.GetDataFromSession<int>("userid"); aScheduler.UserDefinedCol1 = ""; aScheduler.UserDefinedCol2 = ""; aScheduler.UserDefinedCol3 = ""; aScheduler.UserDefinedCol4 = ""; aScheduler.UserDefinedCol9 = ""; aScheduler = db.Billing.Add(aScheduler); db.SaveChanges(); //2.插入账单、多个订单 List<BillingOrder> listBillingOrder = new List<BillingOrder>(); foreach (int orderId in iOrderIDs) { BillingOrder bo = new BillingOrder(); bo.BillingID = aScheduler.IDX; bo.OrderID = orderId; listBillingOrder.Add(bo); } db.BillingOrder.AddRange(listBillingOrder); db.SaveChanges(); //3.插入账单的收费项目 List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = aScheduler.IDX; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); db.SaveChanges(); } } //4.插入账单的汇总项目 List<InVoiceSummaryItem> listInVoiceSummaryItems = new List<InVoiceSummaryItem>(); listInVoiceSummaryItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceSummaryItem>(jsonArraySummaryItems); if (listInVoiceSummaryItems != null) { foreach (InVoiceSummaryItem item in listInVoiceSummaryItems) { AmountSum amtSum = new AmountSum(); amtSum.CustomerID = custId; amtSum.CustomerShipID = custShipId; amtSum.BillingID = aScheduler.IDX; amtSum.BillingDateTime = TugBusinessLogic.Utils.CNDateTimeToDateTime(aScheduler.CreateDate); amtSum.SchedulerID = item.SchedulerID; amtSum.Amount = item.Amount; amtSum.FuelAmount = item.FuelPrice; amtSum.Currency = item.Currency; amtSum.Hours = item.Hours; amtSum.Year = aScheduler.Month.Split('-')[0];//DateTime.Now.Year.ToString(); amtSum.Month = aScheduler.Month.Split('-')[1];// aScheduler.Month; amtSum.OwnerID = -1; amtSum.CreateDate = amtSum.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); amtSum.UserID = Session.GetDataFromSession<int>("userid"); amtSum = db.AmountSum.Add(amtSum); db.SaveChanges(); } } //5.更新订单的字段 V_OrderInfor_HasInvoice 是否已有帳單 { List<OrderInfor> odList = db.OrderInfor.Where(u => iOrderIDs.Contains(u.IDX)).ToList(); //throw new Exception(); if (odList != null) { foreach (OrderInfor od in odList) { od.HasInvoice = "是"; od.HasInFlow = "否"; db.Entry(od).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } //6.更新订单服务表里的字段 HasBilling、HasBillingInFlow 是否已有帳單 { List<string> strOrderServiceIDs = orderServiceIds.Split(',').ToList(); List<int> iOrderServiceIDs = new List<int>(); if (strOrderServiceIDs != null) { foreach (var item in strOrderServiceIDs) { iOrderServiceIDs.Add(TugBusinessLogic.Module.Util.toint(item)); } } List<OrderService> ordSrvList = db.OrderService.Where(u => iOrderServiceIDs.Contains((int)u.IDX)).ToList(); //throw new Exception(); if (ordSrvList != null) { foreach (OrderService ods in ordSrvList) { ods.HasBilling = "是"; ods.HasBillingInFlow = "否"; ods.BillingType = 0; db.Entry(ods).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } } //7.更新客户船的船长、箱量 { CustomerShip cs = db.CustomerShip.FirstOrDefault(u => u.IDX == custShipId); if (cs != null) { cs.Length = customer_ship_length; cs.TEUS = customer_ship_teus; db.Entry(cs).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } trans.Complete(); var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE, billing_id = aScheduler.IDX }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret, JsonRequestBehavior.AllowGet); } } catch (Exception ex) { trans.Dispose(); var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE, billing_id = -1 }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret, JsonRequestBehavior.AllowGet); } } }
public ActionResult EditInvoice2(int billingId, int billingTemplateId, int billingTypeId, int timeTypeId, string jobNo, string remark, string billing_code, double discount, double amount, string month, string date, int customer_ship_length, int customer_ship_teus, string jsonArrayItems, string isShowShipLengthRule, float? ratio1, float? ratio2, float? ratio3, float? ratio4, float? ratio5, float? ratio6, float? ratio7, float? minTime, string isShowShipTEUSRule, string jsonArraySummaryItems) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); { Billing oldBilling = db.Billing.FirstOrDefault(u => u.IDX == billingId); Billing tmp = db.Billing.FirstOrDefault(u => u.BillingCode.Trim() == billing_code.Trim()); if (tmp != null) { if (tmp.IDX != oldBilling.IDX) { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } if (oldBilling != null) { oldBilling.BillingTemplateID = billingTemplateId; oldBilling.BillingTypeID = billingTypeId; oldBilling.TimeTypeID = timeTypeId; oldBilling.Discount = discount; oldBilling.Amount = amount; oldBilling.BillingCode = billing_code.Trim(); oldBilling.JobNo = jobNo; if (ratio1 != null) oldBilling.Ratio1 = (double?)Math.Round((double)ratio1, 2); if (ratio2 != null) oldBilling.Ratio2 = (double?)Math.Round((double)ratio2, 2); if (ratio3 != null) oldBilling.Ratio3 = (double?)Math.Round((double)ratio3, 2); if (ratio4 != null) oldBilling.Ratio4 = (double?)Math.Round((double)ratio4, 2); if (ratio5 != null) oldBilling.Ratio5 = (double?)Math.Round((double)ratio5, 2); if (ratio6 != null) oldBilling.Ratio6 = (double?)Math.Round((double)ratio6, 2); if (ratio7 != null) oldBilling.Ratio7 = (double?)Math.Round((double)ratio7, 2); if (minTime != null) oldBilling.MinTime = (double?)Math.Round((double)minTime, 2); oldBilling.Remark = remark; oldBilling.Month = month; oldBilling.UserDefinedCol10 = date; oldBilling.IsShowShipLengthRule = isShowShipLengthRule; oldBilling.IsShowShipTEUSRule = isShowShipTEUSRule; oldBilling.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); db.Entry(oldBilling).State = System.Data.Entity.EntityState.Modified; int ret = db.SaveChanges(); if (ret > 0) { #region 更新客户船长、箱量 V_Billing2 vb2 = db.V_Billing2.FirstOrDefault(u => u.IDX == billingId); if (vb2 != null) { //vb2.ShipID; CustomerShip cs = db.CustomerShip.FirstOrDefault(u => u.IDX == vb2.ShipID); if (cs != null) { cs.Length = customer_ship_length; cs.TEUS = customer_ship_teus; db.Entry(cs).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } #endregion #region 订单收费项 //1.订单收费项 List<BillingItem> invoiceItems = db.BillingItem.Where(u => u.BillingID == billingId).ToList(); if (invoiceItems != null) { db.BillingItem.RemoveRange(invoiceItems); ret = db.SaveChanges(); if (ret > 0) { List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = billingId; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); ; bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); ret = db.SaveChanges(); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } else { List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = billingId; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); ; bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); ret = db.SaveChanges(); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } #endregion #region 账单的汇总项目 //2.插入账单的汇总项目 List<AmountSum> oldAmountSumList = db.AmountSum.Where(u => u.BillingID == oldBilling.IDX).ToList(); db.AmountSum.RemoveRange(oldAmountSumList); db.SaveChanges(); List<InVoiceSummaryItem> listInVoiceSummaryItems = new List<InVoiceSummaryItem>(); listInVoiceSummaryItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceSummaryItem>(jsonArraySummaryItems); if (listInVoiceSummaryItems != null) { V_Invoice2 vi2 = db.V_Invoice2.FirstOrDefault(u => u.BillingID == oldBilling.IDX); foreach (InVoiceSummaryItem item in listInVoiceSummaryItems) { AmountSum amtSum = new AmountSum(); amtSum.CustomerID = vi2.CustomerID; amtSum.CustomerShipID = vi2.ShipID; amtSum.BillingID = oldBilling.IDX; amtSum.BillingDateTime = TugBusinessLogic.Utils.CNDateTimeToDateTime(oldBilling.CreateDate); amtSum.SchedulerID = item.SchedulerID; amtSum.Amount = item.Amount; amtSum.FuelAmount = item.FuelPrice; amtSum.Currency = item.Currency; amtSum.Hours = item.Hours; amtSum.Year = oldBilling.Month.Split('-')[0];//DateTime.Now.Year.ToString(); amtSum.Month = oldBilling.Month.Split('-')[1];//oldBilling.Month; amtSum.OwnerID = -1; amtSum.CreateDate = amtSum.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); amtSum.UserID = Session.GetDataFromSession<int>("userid"); amtSum = db.AmountSum.Add(amtSum); db.SaveChanges(); } } #endregion #region 更新回扣单编号 System.Linq.Expressions.Expression<Func<Credit, bool>> expCredit = u => u.BillingID == billingId; List<Credit> tmpCredit = db.Credit.Where(expCredit).Select(u => u).ToList<Credit>(); //Credit tmpCredit = db.Credit.Where(expCredit).FirstOrDefault(); if (tmpCredit.Count != 0) { foreach (var item in tmpCredit) { item.CreditCode = "C" + billing_code.Substring(1, billing_code.Length - 1); db.Entry(item).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } #endregion } else { return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_CODE }, JsonRequestBehavior.AllowGet); } } else { return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet); } } } catch (Exception ex) { return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }, JsonRequestBehavior.AllowGet); } return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }, JsonRequestBehavior.AllowGet); }
public ActionResult AddInvoice(int orderId, int billingTemplateId, int billingTypeId, int timeTypeId, string jobNo, string remark, double discount, double amount, string month, string jsonArrayItems) { this.Internationalization(); using (TransactionScope trans = new TransactionScope()) { try { TugDataEntities db = new TugDataEntities(); { TugDataModel.Billing aScheduler = new Billing(); aScheduler.BillingTemplateID = billingTemplateId; //aScheduler.BillingCode = TugBusinessLogic.Utils.AutoGenerateBillCode(); aScheduler.BillingName = ""; aScheduler.BillingTypeID = billingTypeId; aScheduler.CreateDate = aScheduler.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); aScheduler.Month = DateTime.Now.Month.ToString(); aScheduler.OrderID = orderId; aScheduler.OwnerID = -1; aScheduler.Phase = 0; aScheduler.Remark = ""; aScheduler.Status = "创建"; aScheduler.TimesNo = 0; aScheduler.TimeTypeID = timeTypeId; aScheduler.UserID = Session.GetDataFromSession<int>("userid"); aScheduler.Discount = discount; aScheduler.JobNo = jobNo; aScheduler.Remark = remark; aScheduler.Amount = amount; aScheduler.Month = month; aScheduler.UserDefinedCol1 = ""; aScheduler.UserDefinedCol2 = ""; aScheduler.UserDefinedCol3 = ""; aScheduler.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"].Trim() != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim()); //if (Request.Form["UserDefinedCol6"].Trim() != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim()); //if (Request.Form["UserDefinedCol7"].Trim() != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim()); //if (Request.Form["UserDefinedCol8"].Trim() != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim()); aScheduler.UserDefinedCol9 = ""; aScheduler.UserDefinedCol10 = ""; aScheduler = db.Billing.Add(aScheduler); db.SaveChanges(); List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = aScheduler.IDX; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"].Trim() != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim()); //if (Request.Form["UserDefinedCol6"].Trim() != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim()); //if (Request.Form["UserDefinedCol7"].Trim() != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim()); //if (Request.Form["UserDefinedCol8"].Trim() != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim()); bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); db.SaveChanges(); } } //更新订单的字段 V_OrderInfor_HasInvoice 是否已有帳單 { OrderInfor od = db.OrderInfor.FirstOrDefault(u => u.IDX == orderId); //throw new Exception(); if (od != null) { od.HasInvoice = "是"; db.Entry(od).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } } trans.Complete(); var ret = new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }; //Response.Write(@Resources.Common.SUCCESS_MESSAGE); return Json(ret, JsonRequestBehavior.AllowGet); } } catch (Exception) { trans.Dispose(); var ret = new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }; //Response.Write(@Resources.Common.EXCEPTION_MESSAGE); return Json(ret, JsonRequestBehavior.AllowGet); } } }
public ActionResult EditInvoice(int orderId, int billingId, int billingTemplateId, int billingTypeId, int timeTypeId, string jobNo, string remark, double discount, double amount, string month, string jsonArrayItems) { this.Internationalization(); try { TugDataEntities db = new TugDataEntities(); { Billing oldBilling = db.Billing.FirstOrDefault(u => u.IDX == billingId); if (oldBilling != null) { oldBilling.BillingTemplateID = billingTemplateId; oldBilling.BillingTypeID = billingTypeId; oldBilling.TimeTypeID = timeTypeId; oldBilling.Discount = discount; oldBilling.Amount = amount; oldBilling.JobNo = jobNo; oldBilling.Remark = remark; oldBilling.Month = month; oldBilling.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); db.Entry(oldBilling).State = System.Data.Entity.EntityState.Modified; int ret = db.SaveChanges(); if(ret > 0) { List<BillingItem> invoiceItems = db.BillingItem.Where(u => u.BillingID == billingId).ToList(); if (invoiceItems != null) { db.BillingItem.RemoveRange(invoiceItems); ret = db.SaveChanges(); if (ret > 0) { List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = billingId; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); ; bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"].Trim() != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim()); //if (Request.Form["UserDefinedCol6"].Trim() != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim()); //if (Request.Form["UserDefinedCol7"].Trim() != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim()); //if (Request.Form["UserDefinedCol8"].Trim() != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim()); bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); ret = db.SaveChanges(); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } else { List<InVoiceItem> listInVoiceItems = new List<InVoiceItem>(); listInVoiceItems = TugBusinessLogic.Utils.JSONStringToList<InVoiceItem>(jsonArrayItems); if (listInVoiceItems != null) { foreach (InVoiceItem item in listInVoiceItems) { BillingItem bi = new BillingItem(); bi.BillingID = billingId; bi.SchedulerID = item.SchedulerID; bi.ItemID = item.ItemID; bi.UnitPrice = item.UnitPrice; bi.Currency = item.Currency; bi.OwnerID = -1; bi.UserID = Session.GetDataFromSession<int>("userid"); ; bi.CreateDate = bi.LastUpDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); bi.UserDefinedCol1 = ""; bi.UserDefinedCol2 = ""; bi.UserDefinedCol3 = ""; bi.UserDefinedCol4 = ""; //if (Request.Form["UserDefinedCol5"].Trim() != "") // aScheduler.UserDefinedCol5 = Convert.ToDouble(Request.Form["UserDefinedCol5"].Trim()); //if (Request.Form["UserDefinedCol6"].Trim() != "") // aScheduler.UserDefinedCol6 = Util.toint(Request.Form["UserDefinedCol6"].Trim()); //if (Request.Form["UserDefinedCol7"].Trim() != "") // aScheduler.UserDefinedCol7 = Util.toint(Request.Form["UserDefinedCol7"].Trim()); //if (Request.Form["UserDefinedCol8"].Trim() != "") // aScheduler.UserDefinedCol8 = Util.toint(Request.Form["UserDefinedCol8"].Trim()); bi.UserDefinedCol9 = ""; bi.UserDefinedCol10 = ""; bi = db.BillingItem.Add(bi); ret = db.SaveChanges(); } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } } else { return Json(new { code = Resources.Common.FAIL_CODE, message = Resources.Common.FAIL_MESSAGE }, JsonRequestBehavior.AllowGet); } } else { return Json(new { code = Resources.Common.ERROR_CODE, message = Resources.Common.ERROR_MESSAGE }, JsonRequestBehavior.AllowGet); } } } catch (Exception) { return Json(new { code = Resources.Common.EXCEPTION_CODE, message = Resources.Common.EXCEPTION_MESSAGE }, JsonRequestBehavior.AllowGet); } return Json(new { code = Resources.Common.SUCCESS_CODE, message = Resources.Common.SUCCESS_MESSAGE }); }