public JsonResult Event_Import_Event_Info(int rowIndex) { List <Message> ms_error = new List <Message>(); if (Session["event_payment_error"] != null) { ms_error = (List <Message>)Session["list_file_error"]; } Message ms = new Message(); DataTable dt = (DataTable)Session["event_payment"]; DataTable dt2 = (DataTable)Session["history_payment"]; DataTable dt3 = (DataTable)Session["service_cost"]; var rowCurrent = dt.Rows[rowIndex]; int id_Admin = Services_Admin_Info.Instance().Get_ID_Admin(rowCurrent[1].ToString()); if (id_Admin == 0) { ms.code = "1"; ms.msg = "Code admin của bạn không tồn tại , vui lòng kiểm tra lại . Cảm ơn !"; return(Json(ms)); } Event_Info model = new Event_Info() { Id_Admin_Info = id_Admin, Abbott_Code = !string.IsNullOrEmpty(rowCurrent[2].ToString()) ? rowCurrent[2].ToString() : "", Name = !string.IsNullOrEmpty(rowCurrent[3].ToString()) ? rowCurrent[3].ToString() : "", Event_Time = !string.IsNullOrEmpty(rowCurrent[4].ToString()) ? DateTime.Parse(rowCurrent[4].ToString()) : (DateTime?)null, Request_Date = !string.IsNullOrEmpty(rowCurrent[5].ToString()) ? DateTime.Parse(rowCurrent[5].ToString()) : (DateTime?)null, Area = !string.IsNullOrEmpty(rowCurrent[6].ToString()) ? rowCurrent[6].ToString() : "", Description = !string.IsNullOrEmpty(rowCurrent[7].ToString()) ? rowCurrent[7].ToString() : "", Note = !string.IsNullOrEmpty(rowCurrent[8].ToString()) ? rowCurrent[8].ToString() : "", Status = "Actived", Create_User = Session["user"].ToString(), Create_Date = DateTime.Now }; ms = Services_Event_Info.Instance().Event_Import_Event_Info(model, rowIndex); var id_event = int.Parse(ms.sub_code); if (ms.code == "0") { dt2 = (DataTable)Session["history_payment"]; rowCurrent = dt2.Rows[rowIndex]; bool invoice_abb = false; if (rowCurrent[12].ToString().Equals("0")) { invoice_abb = true; } History_Payment add2 = new History_Payment() { HCP_Code = !string.IsNullOrEmpty(rowCurrent[1].ToString()) ? rowCurrent[1].ToString() : "", Number_Contract = !string.IsNullOrEmpty(rowCurrent[2].ToString()) ? rowCurrent[2].ToString() : "", FromDate = !string.IsNullOrEmpty(rowCurrent[3].ToString()) ? DateTime.Parse(rowCurrent[3].ToString()) : (DateTime?)null, ToDate = !string.IsNullOrEmpty(rowCurrent[4].ToString()) ? DateTime.Parse(rowCurrent[4].ToString()) : (DateTime?)null, Value_Contract = !string.IsNullOrEmpty(rowCurrent[5].ToString()) ? Double.Parse(rowCurrent[5].ToString()) : (Double?)null, PPL_GetContract_Date = !string.IsNullOrEmpty(rowCurrent[6].ToString()) ? DateTime.Parse(rowCurrent[6].ToString()) : (DateTime?)null, Rep_Name = !string.IsNullOrEmpty(rowCurrent[7].ToString()) ? rowCurrent[7].ToString() : "", Sup_Name = !string.IsNullOrEmpty(rowCurrent[8].ToString()) ? rowCurrent[8].ToString() : "", Description = !string.IsNullOrEmpty(rowCurrent[9].ToString()) ? rowCurrent[9].ToString() : "", PPL_Payment_Date = !string.IsNullOrEmpty(rowCurrent[10].ToString()) ? DateTime.Parse(rowCurrent[10].ToString()) : (DateTime?)null, Payment_Value = !string.IsNullOrEmpty(rowCurrent[11].ToString()) ? Double.Parse(rowCurrent[11].ToString()) : (Double?)null, Invoice_Abbott = invoice_abb, Report_Abbott_Date = !string.IsNullOrEmpty(rowCurrent[13].ToString()) ? DateTime.Parse(rowCurrent[13].ToString()) : (DateTime?)null, Note = !string.IsNullOrEmpty(rowCurrent[14].ToString()) ? rowCurrent[14].ToString() : "", Status = "Actived", Create_User = Session["user"].ToString(), Create_Date = DateTime.Now }; ms = Services_History_Payment.Instance().Event_Import_History_Payment(add2, rowIndex, id_event); } if (ms.code == "0") { if (dt3.Rows.Count > (rowIndex)) { dt3 = (DataTable)Session["service_cost"]; rowCurrent = dt3.Rows[rowIndex]; Service_Cost add3 = new Service_Cost() { ID_Service_Criteria = int.Parse(rowCurrent[0].ToString()), Honorarium_fee = Double.Parse(rowCurrent[1].ToString()), Air_ticket = Double.Parse(rowCurrent[2].ToString()), Meal_fee = Double.Parse(rowCurrent[3].ToString()), Hotel_fee = Double.Parse(rowCurrent[4].ToString()), Car_rental = Double.Parse(rowCurrent[5].ToString()), Other_fees = Double.Parse(rowCurrent[6].ToString()), Total_costs = Double.Parse(rowCurrent[7].ToString()), Status = "Actived", Create_User = Session["user"].ToString(), Create_Date = DateTime.Now }; ms = Services_service_costs.Instance().Event_Import_Service_Cost(add3, rowIndex, id_event); } } if (ms.code == "1") { ms_error.Add(ms); ms.code = "0"; } if (rowIndex == dt.Rows.Count - 1) { if (ms_error.Count > 0) { Session["list_file_error"] = ms_error; ms.code = "1"; ms.msg = "Vui lòng xem file Excel Lỗi !"; ms.sub_code = "Danh Sách Thông Tin Sự Kiện & Thanh Toán Lỗi"; } else { ms.code = "2"; ms.msg = "Đã Up Danh Sách Thông Tin Sự Kiện & Thanh Toán Thành Công"; } } else { Session["list_file_error"] = ms_error; } return(Json(ms)); }
public JsonResult Event_Add_Edit_Event_Info(string data) { AddEventInfoClass temp = JsonConvert.DeserializeObject <AddEventInfoClass>(data); Message ms = new Message(); using (var db = new HCB_ABBOTTEntities()) { //add event #region event Event_Info ei = new Event_Info(); ei.Abbott_Code = temp.form["Abbott_Code"]; ei.Id_Admin_Info = Int32.Parse(temp.form["Id_Admin_Info"]); ei.Name = temp.form["Name"]; ei.Event_Time = DateTime.Parse(temp.form["Event_Time"]); ei.Request_Date = DateTime.Parse(temp.form["Request_Date"]); ei.Area = temp.form["Area"]; ei.Description = temp.form["Description"]; ei.Note = temp.form["Note"]; ei.Status = "Actived"; ei.Create_Date = DateTime.Now; ei.Create_User = temp.form["CreateUser"]; db.Event_Info.Add(ei); db.SaveChanges(); #endregion //add s cost #region add sv cost string usr = Session["user"].ToString(); int id_username = db.UserNames.FirstOrDefault(r => r.UserName1 == usr).ID; for (int i = 1; i <= 8; i++) { var fee = temp.FeeJson[i.ToString()]; Service_Cost sc = new Service_Cost(); sc.ID_Event = ei.ID; sc.ID_Service_Criteria = i; sc.Honorarium_fee = fee.Fee; sc.Air_ticket = temp.TicketJson[i.ToString()].Tickets; sc.Meal_fee = temp.MealJson[i.ToString()].Meals; sc.Hotel_fee = temp.HotelJson[i.ToString()].Hotels; sc.Car_rental = temp.CarJson[i.ToString()].Cars; sc.Other_fees = temp.OtherJson[i.ToString()].Others; sc.Total_costs = double.Parse(temp.Totalrow[i - 1]); db.Service_Cost.Add(sc); db.SaveChanges(); } #endregion //add rate #region add rate //for (int i = 1; i <= 8; i++) //{ // if (i==2 || i==4 || i==7) { // User_Create_Rate us_cr = new User_Create_Rate(); // us_cr.Id_User_Name = id_username; // us_cr.Rate = temp.RateJson[i.ToString()].Ratenames; // us_cr.Status = "Actived"; // us_cr.Create_Date = DateTime.Now; // us_cr.Create_User = temp.form["CreateUser"]; // if(i == 2) { us_cr.Id_rate = 1; } // if (i == 4) { us_cr.Id_rate = 2; } // if (i == 7) { us_cr.Id_rate = 3; } // db.User_Create_Rate.Add(us_cr); // db.SaveChanges(); // } //} #endregion //add history payment #region history payment bool invoice_1 = false; if (temp.form["Invoice_Abbott"].ToString() == "0") { invoice_1 = true; } History_Payment hp = new History_Payment(); hp.Id_Event = ei.ID; hp.HCP_Code = temp.form["HCP_Code"]; hp.Number_Contract = temp.form["Number_Contract"]; hp.FromDate = DateTime.Parse(temp.form["FromDate"]); hp.ToDate = DateTime.Parse(temp.form["ToDate"]); hp.Value_Contract = double.Parse(temp.form["Value_Contract"]); hp.PPL_GetContract_Date = DateTime.Parse(temp.form["PPL_GetContract_Date"]); hp.Rep_Name = temp.form["Rep_Name"]; hp.Sup_Name = temp.form["Sup_Name"]; hp.Description = temp.form["Description"]; //hp.Requested_Value = double.Parse(temp.form["Requested_Value"]); //hp.Requested_Date = DateTime.Parse(temp.form["Requested_Date"]); hp.PPL_Payment_Date = DateTime.Parse(temp.form["PPL_Payment_Date"]); hp.Payment_Value = double.Parse(temp.form["Payment_Value"]); hp.Invoice_Abbott = invoice_1; hp.Report_Abbott_Date = DateTime.Parse(temp.form["Report_Abbott_Date"]); //hp.Account_Name = temp.form["Account_Name"]; hp.Note = temp.form["Note"]; hp.Status = "Actived"; hp.Create_User = temp.form["CreateUser"]; hp.Create_Date = DateTime.Now; db.History_Payment.Add(hp); db.SaveChanges(); #endregion ms.code = "0"; ms.msg = "Thêm Thành Công !"; } Session["idEvent"] = ms.sub_code; return(Json(ms)); }