//for connection string
//For City Master
public TransactionStatus AddCityMaster(CityMasterBo cityMasterBo)
{
var transactionStatus = new TransactionStatus();
var cityMaster = BuiltCityMasterDomain(cityMasterBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@City_Id", cityMaster.City_Id), //0
new SqlParameter("@location_Id", cityMaster.location_Id), //1
new SqlParameter("@Pincode_Id", cityMaster.Pincode_Id), //2
new SqlParameter("@opReturnValue", SqlDbType.Int) //3
};
Params[3].Direction = ParameterDirection.Output;
//string conStr = ConfigurationManager.ConnectionStrings["conCityOfLongBeach"].ToString();
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddCity_Master", Params);
ds.Locale = CultureInfo.InvariantCulture;
string test = Params[3].Value.ToString();
return(transactionStatus);
}
private CityMaster BuiltCityMasterDomain(CityMasterBo cityMasterBo)
{
return((CityMaster) new CityMaster().InjectFrom(cityMasterBo));
}
