public ActionResult DbSearchresult(Unit_Of_Measure Unit_Of_Measure)
{
if (Unit_Of_Measure.unit_name != null && Unit_Of_Measure.unit_code != null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_name.StartsWith(Unit_Of_Measure.unit_name) && u.unit_code.StartsWith(Unit_Of_Measure.unit_code)
select u;
return View("Index", result.ToList());
}
else if (Unit_Of_Measure.unit_name != null && Unit_Of_Measure.unit_code == null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_name.StartsWith(Unit_Of_Measure.unit_name)
select u;
return View("Index", result.ToList());
}
else if (Unit_Of_Measure.unit_name == null && Unit_Of_Measure.unit_code != null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_code.StartsWith(Unit_Of_Measure.unit_code)
select u;
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
public ActionResult Create(Unit_Of_Measure unit_Of_Measure)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(23))
{
if (ModelState.IsValid)
{
var is_exist = (from u in db.Unit_Of_Measure where u.unit_name == unit_Of_Measure.unit_name select u).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Unit Of Measure Already Exist";
}
else
{
db.Unit_Of_Measure.Add(unit_Of_Measure);
db.SaveChanges();
TempData["errorMessage"] = "Unit Of Measure Added Successfully";
db.SaveChanges();
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult Create(Unit_Of_Measure unit_Of_Measure)
{
if (ModelState.IsValid)
{
var is_exist = (from u in db.Unit_Of_Measure where u.unit_name == unit_Of_Measure.unit_name select u).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Unit Of Measure Already Exist";
}
else
{
db.Unit_Of_Measure.Add(unit_Of_Measure);
db.SaveChanges();
TempData["errorMessage"] = "Unit Of Measure Added Successfully";
db.SaveChanges();
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
public ActionResult Edit(Unit_Of_Measure unit_Of_Measure)
{
int id = Convert.ToInt32(TempData["id"]);
if (ModelState.IsValid)
{
var is_exist = (from u in db.Unit_Of_Measure where u.unit_name == unit_Of_Measure.unit_name && u.unit_id != id select u).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Unit Of Measure Already Exist";
}
else
{
unit_Of_Measure.unit_id = id;
db.Entry(unit_Of_Measure).State = EntityState.Modified;
db.SaveChanges();
TempData["errorMessage"] = "Edited Successfully";
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
public ActionResult Edit(Unit_Of_Measure unit_Of_Measure)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(23))
{
int id = Convert.ToInt32(TempData["id"]);
if (ModelState.IsValid)
{
var is_exist = (from u in db.Unit_Of_Measure where u.unit_name == unit_Of_Measure.unit_name && u.unit_id != id select u).Count();
if (is_exist > 0)
{
TempData["errorMessage"] = "This Unit Of Measure Already Exist";
}
else
{
unit_Of_Measure.unit_id = id;
db.Entry(unit_Of_Measure).State = EntityState.Modified;
db.SaveChanges();
TempData["errorMessage"] = "Edited Successfully";
}
return RedirectToAction("Index");
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
public ActionResult DbSearchresult(Unit_Of_Measure Unit_Of_Measure)
{
if (Session["login_status"] != null)
{
int[] z = (int[])Session["function_id"];
if (z.Contains(23))
{
if (Unit_Of_Measure.unit_name != null && Unit_Of_Measure.unit_code != null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_name.StartsWith(Unit_Of_Measure.unit_name) && u.unit_code.StartsWith(Unit_Of_Measure.unit_code)
select u;
return View("Index", result.ToList());
}
else if (Unit_Of_Measure.unit_name != null && Unit_Of_Measure.unit_code == null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_name.StartsWith(Unit_Of_Measure.unit_name)
select u;
return View("Index", result.ToList());
}
else if (Unit_Of_Measure.unit_name == null && Unit_Of_Measure.unit_code != null)
{
var result = from u in db.Unit_Of_Measure
where u.unit_code.StartsWith(Unit_Of_Measure.unit_code)
select u;
return View("Index", result.ToList());
}
return RedirectToAction("Index");
}
else
{
return RedirectToAction("../Home/Dashboard");
}
}
else
{
return RedirectToAction("../Home");
}
}
