public ActionResult Create(Ship_ArrivalModel ship_arrivalModel) { Ship_Arrival ship_arrival = new Ship_Arrival(); DateTime shipp_arrival_date = Convert.ToDateTime(ship_arrivalModel.day_code); var year = shipp_arrival_date.Year; var month = shipp_arrival_date.Month; var day = shipp_arrival_date.Day; var day_2 = "D"+day.ToString("00"); var month_2 = "M"+month.ToString("00"); var day_code = year + month_2 + day_2; var ship_code = ""; var state_name = ""; var day_id = 0; var ship_code1 = from s in db.Ships where s.ship_id == ship_arrivalModel.shipp_id select s.ship_code_1; foreach (var item in ship_code1) { ship_code = item; } var geography_code1 = from s in db.States where s.state_id == ship_arrivalModel.state_id select s.state_name; foreach (var item in geography_code1) { state_name = item; } var day_code1 = from d in db.Days where d.day_code == day_code select d.day_id; foreach (var item in day_code1) { day_id = item; } if (ModelState.IsValid) { var is_exist = (from sa in db.Ship_Arrival where sa.shipp_id == ship_arrivalModel.shipp_id && sa.day_id == day_id select sa).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Ship Arrival Already Exist"; } else { ship_arrival.shipp_id = ship_arrivalModel.shipp_id; ship_arrival.state_id = ship_arrivalModel.state_id; ship_arrival.day_id = day_id; ship_arrival.ship_arrival_code = ship_code + " " + state_name + " " + day_code; ship_arrival.status_id = 1; ship_arrival.created_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); ship_arrival.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Ship_Arrival.Add(ship_arrival); db.SaveChanges(); TempData["errorMessage"] = "Ship Arrival Added Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); }
// // GET: /Manage_Ship_Arrival/Edit/5 public ActionResult Edit(int id = 0) { Ship_Arrival ship_arrival = db.Ship_Arrival.Find(id); if (ship_arrival == null) { return HttpNotFound(); } var country_id = 0; var country_name = ""; var geography_id = 0; var geography_name = ""; var state_name = ""; var day_code = ""; var geography = from sa in db.Ship_Arrival join s in db.States on sa.state_id equals s.state_id join c in db.Countries on s.country_id equals c.country_id join g in db.Geographies on c.geography_id equals g.geography_id join d in db.Days on sa.day_id equals d.day_id where s.state_id == ship_arrival.state_id && d.day_id == ship_arrival.day_id select new {c.country_id, c.country_name, g.geography_id, g.geography_name, s.state_name, s.state_id, d.day_code}; foreach(var item in geography) { country_id = item.country_id; country_name = item.country_name; geography_id = item.geography_id; geography_name = item.geography_name; state_name = item.state_name; day_code = item.day_code; } ViewBag.ships = new HomeController().Ship(); ViewBag.geography_id = new HomeController().Geography(); ViewBag.day = new HomeController().Day(); ViewBag.status = new HomeController().Status(); ViewBag.country_id = new SelectList(geography, "country_id", "country_name"); ViewBag.state_id = new SelectList(geography, "state_id", "state_name"); TempData["id"] = ship_arrival.ship_arrival_id; TempData["created_date"] = ship_arrival.created_date; var result = CustomSplit(day_code, new string[] { "", "", "" }); var year_value = result[0]; var month_value = result[1]; var day_value = result[2]; var month_number = Regex.Match(month_value, @"\d+").Value; var day_number = Regex.Match(day_value, @"\d+").Value; var day = year_value + "-" + month_number + "-" + day_number; Ship_ArrivalModel ship_arrivalModel = new Ship_ArrivalModel(); ship_arrivalModel.shipp_id = ship_arrival.shipp_id; ship_arrivalModel.geography_id = geography_id; ship_arrivalModel.country_id = country_id; ship_arrivalModel.state_id = ship_arrival.state_id; ship_arrivalModel.state_id = ship_arrival.day_id; ship_arrivalModel.status_id = ship_arrival.status_id; ship_arrivalModel.ship_arrival_id = ship_arrival.ship_arrival_id; ship_arrivalModel.day_code = day; return View(ship_arrivalModel); }
public ActionResult Edit(Ship_ArrivalModel ship_arrivalModel) { int id = Convert.ToInt32(TempData["id"]); var created_date = TempData["created_date"].ToString(); Ship_Arrival ship_arrival = new Ship_Arrival(); DateTime shipp_arrival_date = Convert.ToDateTime(ship_arrivalModel.day_code); var year = shipp_arrival_date.Year; var month = shipp_arrival_date.Month; var day = shipp_arrival_date.Day; var day_2 = "D" + day.ToString("00"); var month_2 = "M" + month.ToString("00"); var day_code = year + month_2 + day_2; var ship_code = ""; var geography_code = ""; var day_id = 0; var ship_code1 = from s in db.Ships where s.ship_id == ship_arrivalModel.shipp_id select s.ship_code_1; foreach (var item in ship_code1) { ship_code = item; } var geography_code1 = from s in db.States join c in db.Countries on s.country_id equals c.country_id join g in db.Geographies on c.geography_id equals g.geography_id where s.state_id == ship_arrivalModel.state_id select g.geography_name; foreach (var item in geography_code1) { geography_code = item; } var day_code1 = from d in db.Days where d.day_code == day_code select d.day_id; foreach (var item in day_code1) { day_id = item; } if (ModelState.IsValid) { var is_exist = (from sa in db.Ship_Arrival where sa.shipp_id == ship_arrivalModel.shipp_id && sa.day_id == day_id && sa.ship_arrival_id != id select sa).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Ship Arrival Already Exist"; } else { ship_arrival.status_id = ship_arrivalModel.status_id; ship_arrival.shipp_id = ship_arrivalModel.shipp_id; ship_arrival.state_id = ship_arrivalModel.state_id; ship_arrival.day_id = day_id; ship_arrival.ship_arrival_code = ship_code + " " + geography_code + " " + day_code; ship_arrival.ship_arrival_id = id; ship_arrival.created_date = created_date; ship_arrival.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Entry(ship_arrival).State = EntityState.Modified; db.SaveChanges(); TempData["errorMessage"] = "Edited Successfully"; } return RedirectToAction("Index"); } return View(ship_arrival); }
public ActionResult DbSearchresult(Ship_ArrivalModel ship_arrival) { if (ship_arrival.shipp_id != 0 && ship_arrival.geography_id != 0) { var result = from sa in db.Ship_Arrival join s in db.Ships on sa.shipp_id equals s.ship_id join st in db.States on sa.state_id equals st.state_id join c in db.Countries on st.country_id equals c.country_id join g in db.Geographies on c.geography_id equals g.geography_id join d in db.Days on sa.day_id equals d.day_id where sa.shipp_id == ship_arrival.shipp_id && g.geography_id == ship_arrival.geography_id select new Ship_ArrivalModel { ship_arrival_id = sa.ship_arrival_id, shipp_name = s.ship_name, country = c.country_name, state = st.state_name, day_code = d.day_code, status_id = sa.status_id, ship_arrival_code = sa.ship_arrival_code }; return View("Index", result.ToList()); } else if (ship_arrival.shipp_id != 0 && ship_arrival.geography_id == 0) { var result = from sa in db.Ship_Arrival join s in db.Ships on sa.shipp_id equals s.ship_id join st in db.States on sa.state_id equals st.state_id join c in db.Countries on st.country_id equals c.country_id join g in db.Geographies on c.geography_id equals g.geography_id join d in db.Days on sa.day_id equals d.day_id where sa.shipp_id == ship_arrival.shipp_id select new Ship_ArrivalModel { ship_arrival_id = sa.ship_arrival_id, shipp_name = s.ship_name, country = c.country_name, state = st.state_name, day_code = d.day_code, status_id = sa.status_id, ship_arrival_code = sa.ship_arrival_code }; return View("Index", result.ToList()); } else if (ship_arrival.shipp_id == 0 && ship_arrival.geography_id != 0) { var result = from sa in db.Ship_Arrival join s in db.Ships on sa.shipp_id equals s.ship_id join st in db.States on sa.state_id equals st.state_id join c in db.Countries on st.country_id equals c.country_id join g in db.Geographies on c.geography_id equals g.geography_id join d in db.Days on sa.day_id equals d.day_id where g.geography_id == ship_arrival.geography_id select new Ship_ArrivalModel { ship_arrival_id = sa.ship_arrival_id, shipp_name = s.ship_name, country = c.country_name, state = st.state_name, day_code = d.day_code, status_id = sa.status_id, ship_arrival_code = sa.ship_arrival_code }; return View("Index", result.ToList()); } return RedirectToAction("Index"); }