public DataSet AddLocation(ManageLocationBo locationBo) { var transactionStatus = new TransactionStatus(); var location = BuiltManageLocationDomain(locationBo); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@city", location.City), //1 new SqlParameter("@location", location.Location), //2 new SqlParameter("@pincode", location.Pincode), //3 new SqlParameter("@state", location.State), //4 }; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_AddCityLocation_Master", Params); ds.Locale = CultureInfo.InvariantCulture; return(ds); }
public TransactionStatus UpdateLocation(ManageLocationBo locationBo) { var transactionStatus = new TransactionStatus(); var location = BuiltManageLocationDomain(locationBo); CemexDb con = new CemexDb(); SqlParameter[] Params = { new SqlParameter("@id", location.Id), //0 new SqlParameter("@city", location.City), //1 new SqlParameter("@location", location.Location), //2 new SqlParameter("@pincode", location.Pincode), //3 new SqlParameter("@state", location.State), //4 new SqlParameter("@output", SqlDbType.Int), //4 }; Params[5].Direction = ParameterDirection.Output; DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "proc_UpdateCityLocation_Master", Params); ds.Locale = CultureInfo.InvariantCulture; return(transactionStatus); }
private ManageLocation BuiltManageLocationDomain(ManageLocationBo locationBo) { return((ManageLocation) new ManageLocation().InjectFrom(locationBo)); }