public static string AddCity(string CityName)
{
// result 0 for not saved
// result -1 for some internal error
// result 1 or greater than 1 for successfuly saved
string result = "0";
CityDetail city = new CityDetail();
try
{
var IsCityExsist = Global.dc.CityDetails.FirstOrDefault(i => i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue) && i.CityName.ToLower() == CityName.ToLower());
if (IsCityExsist != null)
{
result = "2";
}
else
{
city.CityName = CityName;
city.IsActive = true;
city.IsDeleted = false;
Global.dc.CityDetails.Add(city);
int count = Global.dc.SaveChanges();
result = Convert.ToString(count);
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
public string DeleteCity(string ID)
{
string result = string.Empty;
try
{
int CityID = Convert.ToInt32(ID);
AreaDetail area = Global.dc.AreaDetails.FirstOrDefault(i => i.CityID == CityID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
if (area != null)
{
//City Is used in another
result = "4";
}
else
{
CityDetail city = Global.dc.CityDetails.FirstOrDefault(i => i.ID == CityID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
if (city != null)
{
city.IsDeleted = true;
int count = Global.dc.SaveChanges();
result = Convert.ToString(count);
}
else
{
result = "3";
}
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}
public string EditCity(string ID)
{
string result = string.Empty;
try
{
int CityID = Convert.ToInt32(ID);
CityDetail city = Global.dc.CityDetails.FirstOrDefault(i => i.ID == CityID && i.IsActive == true && (!i.IsDeleted.Value || !i.IsDeleted.HasValue));
if (city != null)
{
result = city.CityName;
}
else
{
result = "3";
}
}
catch (Exception)
{
result = "-1";
}
return(result);
}