public ActionResult DefineSlPurchOrg(tblOrganizationStructure obj) { IStructuredetailRepository objstruct = new StructuredetailRepository(); var validate = objstruct.Getcondition1(obj.CompanyCode, Convert.ToInt32(obj.CityCode)).FirstOrDefault(); var validate1 = objstruct.Getvalidation(obj.CompanyCode, Convert.ToInt32(obj.CityCode), obj.StorageLocation, obj.PurchaseOrganization).FirstOrDefault(); var validate2 = context.tblOrganizationStructures .Where(a => a.CompanyCode == obj.CompanyCode) .Where(b => b.CityCode == obj.CityCode).FirstOrDefault(); var validate3 = context.tblOrganizationStructures .Where(c => c.StorageLocation == obj.StorageLocation) .Where(d => d.PurchaseOrganization == obj.PurchaseOrganization).FirstOrDefault(); if (validate == null) { TempData["ErrorMessage"] = ("CompanyCode " + obj.CompanyCode + " with CityCode " + obj.CityCode + " Does not Exists"); } else if (validate2 != null && validate3 != null) { TempData["ErrorMessage"] = (" Storage Location " + obj.StorageLocation + " with Purchase Organization " + obj.PurchaseOrganization + "Already Exists for Company Code " + obj.CompanyCode + " and City Code " + obj.CityCode + " "); } else if (validate != null && validate1 == null && validate3 == null && validate2 != null) { if (ModelState.IsValid) { List <object> lst = new List <object>(); lst.Add(obj.CompanyCode); lst.Add(obj.CityCode); lst.Add(obj.StorageLocation); lst.Add(obj.PurchaseOrganization); object[] item = lst.ToArray(); int output1 = context.Database.ExecuteSqlCommand("insert into tblOrganizationStructure(CompanyCode,CityCode,StorageLocation,PurchaseOrganization) values(@p0,@p1,@p2,@p3)", item); if (output1 > 0) { TempData["SuccessMessage"] = ("Storage Location " + obj.StorageLocation + " and Purchase Org " + obj.PurchaseOrganization + " Defined for Company Code " + obj.CompanyCode + " and City Code " + obj.CityCode + ""); } } else { TempData["ErrorMessage"] = "Unable to Add"; } } else if (validate2 == null && validate3 != null || validate2 == null && validate3 == null) { if (ModelState.IsValid) { List <object> lst = new List <object>(); lst.Add(obj.CompanyCode); lst.Add(obj.CityCode); lst.Add(obj.StorageLocation); lst.Add(obj.PurchaseOrganization); object[] item = lst.ToArray(); int output1 = context.Database.ExecuteSqlCommand("insert into tblOrganizationStructure(CompanyCode,CityCode,StorageLocation,PurchaseOrganization) values(@p0,@p1,@p2,@p3)", item); if (output1 > 0) { TempData["SuccessMessage"] = ("Storage Location " + obj.StorageLocation + " and Purchase Org " + obj.PurchaseOrganization + " Defined for Company Code " + obj.CompanyCode + " and City Code " + obj.CityCode + ""); } } else { TempData["ErrorMessage"] = "Unable to Add"; } } else { TempData["ErrorMessage"] = (" Storage Location " + obj.StorageLocation + " with Purchase Organization " + obj.PurchaseOrganization + "Already Exists for Company Code " + obj.CompanyCode + " and City Code " + obj.CityCode + " "); } return(View(obj)); }