public List <dynamic> AddCityDetails(CityDetailsDTO cityDetailsDTO)
{
string insertProcedure = "[CRUD_CityMaster] ";
Dictionary <string, string> input_parameters = new Dictionary <string, string>();
input_parameters.Add("@pkey_CityId", 1 + "#bigint#" + cityDetailsDTO.pkey_CityId);
input_parameters.Add("@CityName ", 1 + " # nvarchar #" + cityDetailsDTO.CityName);
input_parameters.Add("@UserID ", 1 + " #bigint# " + cityDetailsDTO.UserID);
input_parameters.Add("@IsDeleted ", 1 + "#int#" + cityDetailsDTO.IsDeleted);
input_parameters.Add("@Type", 1 + "#int#" + cityDetailsDTO.Type);
input_parameters.Add("@pkey_CityIdout", 2 + "#int#" + null);
input_parameters.Add("@ReturnValue", 2 + "#int#" + null);
return(obj.SqlCRUD(insertProcedure, input_parameters));
}
public IHttpActionResult PostCountry(CityDetailsDTO data)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
Country country = new Country();
City city = new City();
city.CityName = data.CityName;
country.countriesName = data.countriesName;
db.Cities.Add(city);
db.SaveChanges();
db.Countries.Add(country);
db.SaveChanges();
}
catch (Exception)
{
throw;
}
return(Ok(data));
}
public List <dynamic> GetCityDetailById(CityDetailsDTO cityDetailsDTO)
{
List <dynamic> objDynamic = new List <dynamic>();
string insertProcedure = "[Get_CityMasterByID]";
Dictionary <string, string> input_parameters = new Dictionary <string, string>();
input_parameters.Add("@pkey_CityId", 1 + "#bigint#" + cityDetailsDTO.pkey_CityId);
DataSet ds = obj.SelectSql(insertProcedure, input_parameters);
var myEnumerable = ds.Tables[0].AsEnumerable();
List <CityDetailsDTO> ordtl =
(from item in myEnumerable
select new CityDetailsDTO
{
pkey_CityId = item.Field <Int64>("pkey_city_id"),
CityName = item.Field <String>("city_name"),
}).ToList();
objDynamic.Add(ordtl);
return(objDynamic);
}
