public ActionResult DefineStructure(StructureDetails viewModel) { IStructuredetailRepository objstruct = new StructuredetailRepository(); var validate = objstruct.Getcondition(viewModel.CompanyCode, viewModel.CityCode, viewModel.CityName).FirstOrDefault(); var validate1 = objstruct.Getcondition1(viewModel.CompanyCode, viewModel.CityCode).FirstOrDefault(); var validate3 = objstruct.Getcondition2(viewModel.CityCode, viewModel.CityName).FirstOrDefault(); var check = objstruct.Getcondition3(viewModel.CityCode).FirstOrDefault(); var check1 = objstruct.Getcondition4(viewModel.CityName).FirstOrDefault(); var check2 = objstruct.Getcondition5(viewModel.CompanyCode).FirstOrDefault(); if (validate == null && validate3 != null || validate1 == null && check1 == null || !objstruct.GetAll().Any()) { if (ModelState.IsValid) { objstruct.Add(viewModel.CompanyCode, viewModel.CityCode, viewModel.CompanyName, viewModel.CityName); objstruct.Save(); RedirectToAction("StructureList", "Home"); TempData["SuccessMessage"] = "Structure Created"; } else { TempData["ErrorMessage"] = "Unable to Add"; } } else if (validate1 != null) { TempData["ErrorMessage"] = ("CompanyCode " + viewModel.CompanyCode + " with CityCode " + viewModel.CityCode + "Already Exists"); } else if (validate3 != null) { TempData["ErrorMessage"] = ("City Code " + viewModel.CityCode + " with City " + viewModel.CityName + " already Exists"); } else if (validate != null && validate1 != null && validate3 != null) { TempData["ErrorMessage"] = ("Company Code " + viewModel.CompanyCode + " with City Code " + viewModel.CityCode + "and" + viewModel.CityName + " Already Exists"); } else { TempData["ErrorMessage"] = ("City with Name " + viewModel.CityName + " already Exists in Company Code " + viewModel.CompanyCode + ""); } return(View(viewModel)); }