//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)); }