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");
}