// // GET: /Manage_Ship_Departure/Edit/5 public ActionResult Edit(int id = 0) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(28)) { Ship_Departure ship_departure = db.Ship_Departure.Find(id); if (ship_departure == 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_Departure 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_departure.state_id && d.day_id == ship_departure.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_departure.ship_departure_id; TempData["created_date"] = ship_departure.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_DepartureModel ship_departureModel = new Ship_DepartureModel(); ship_departureModel.shipp_id = ship_departure.shipp_id; ship_departureModel.geography_id = geography_id; ship_departureModel.country_id = country_id; ship_departureModel.state_id = ship_departure.state_id; ship_departureModel.state_id = ship_departure.day_id; ship_departureModel.status_id = ship_departure.status_id; ship_departureModel.ship_departure_id = ship_departure.ship_departure_id; ship_departureModel.day_code = day; return View(ship_departureModel); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult Create(Ship_DepartureModel ship_departureModel) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(28)) { Ship_Departure ship_departure = new Ship_Departure(); DateTime shipp_departure_date = Convert.ToDateTime(ship_departureModel.day_code); var year = shipp_departure_date.Year; var month = shipp_departure_date.Month; var day = shipp_departure_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_departureModel.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_departureModel.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_Departure where sa.shipp_id == ship_departureModel.shipp_id && sa.day_id == day_id select sa).Count(); if (is_exist > 0) { TempData["errorMessage"] = "This Ship Departure Already Exist"; } else { ship_departure.shipp_id = ship_departureModel.shipp_id; ship_departure.state_id = ship_departureModel.state_id; ship_departure.day_id = day_id; ship_departure.ship_departure_code = ship_code + " " + state_name + " " + ship_departureModel.day_code; ship_departure.status_id = 1; ship_departure.starting_date = Convert.ToDateTime(ship_departureModel.day_code); ship_departure.created_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); ship_departure.updated_date = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd"); db.Ship_Departure.Add(ship_departure); db.SaveChanges(); TempData["errorMessage"] = "Ship Departure Added Successfully"; } return RedirectToAction("Index"); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }
public ActionResult DbSearchresult(Ship_DepartureModel ship_departure) { if (Session["login_status"] != null) { int[] z = (int[])Session["function_id"]; if (z.Contains(28)) { if (ship_departure.shipp_name != null && ship_departure.geography_id != 0) { var result = from sa in db.Ship_Departure 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 s.ship_name.Contains(ship_departure.shipp_name) && g.geography_id == ship_departure.geography_id select new Ship_DepartureModel { ship_departure_id = sa.ship_departure_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_departure_code = sa.ship_departure_code }; return View("Index", result.ToList()); } else if (ship_departure.shipp_name != null && ship_departure.geography_id == 0) { var result = from sa in db.Ship_Departure 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 s.ship_name.Contains(ship_departure.shipp_name) select new Ship_DepartureModel { ship_departure_id = sa.ship_departure_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_departure_code = sa.ship_departure_code }; return View("Index", result.ToList()); } else if (ship_departure.shipp_name == null && ship_departure.geography_id != 0) { var result = from sa in db.Ship_Departure 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_departure.geography_id select new Ship_DepartureModel { ship_departure_id = sa.ship_departure_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_departure_code = sa.ship_departure_code }; return View("Index", result.ToList()); } return RedirectToAction("Index"); } else { return RedirectToAction("../Home/Dashboard"); } } else { return RedirectToAction("../Home"); } }