public TransactionStatus CreateCity(CityBo cityBo)
{
var transactionStatus = new TransactionStatus();
var city = BuiltCityDomain(cityBo);
//CemexDb.City.Add(city);
//CemexDb.SaveChanges();
CemexDb con = new CemexDb();
SqlConnection conn = con.GetConnection();
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.proc_AddCity", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@City_Name", cityBo.City_Name);
cmd.Parameters.AddWithValue("@opReturnValue", SqlDbType.Int);
cmd.ExecuteNonQuery();
return(transactionStatus);
}
//for connection string
private City BuiltCityDomain(CityBo cityBo)
{
return((City) new City().InjectFrom(cityBo));
}
