예제 #1
0
 /// <summary>
 /// There are no comments for BookingPagosModel.getCustomersByName in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult <Customers> getCustomersByName(string name)
 {
     global::System.Data.Objects.ObjectParameter nameParameter;
     if ((name != null))
     {
         nameParameter = new global::System.Data.Objects.ObjectParameter("Name", name);
     }
     else
     {
         nameParameter = new global::System.Data.Objects.ObjectParameter("Name", typeof(string));
     }
     return(base.ExecuteFunction <Customers>("getCustomersByName", nameParameter));
 }
예제 #2
0
 public global::System.Data.Objects.ObjectResult<Students> GETSTUWOHOUSEWORKOT(global::System.Nullable<int> teaID, string semester)
 {
     global::System.Data.Objects.ObjectParameter teaIDParameter;
     if (teaID.HasValue)
     {
         teaIDParameter = new global::System.Data.Objects.ObjectParameter("TeaID", teaID);
     }
     else
     {
         teaIDParameter = new global::System.Data.Objects.ObjectParameter("TeaID", typeof(int));
     }
     global::System.Data.Objects.ObjectParameter semesterParameter;
     if ((semester != null))
     {
         semesterParameter = new global::System.Data.Objects.ObjectParameter("Semester", semester);
     }
     else
     {
         semesterParameter = new global::System.Data.Objects.ObjectParameter("Semester", typeof(string));
     }
     return base.ExecuteFunction<Students>("GETSTUWOHOUSEWORKOT", teaIDParameter, semesterParameter);
 }
예제 #3
0
 public global::System.Data.Objects.ObjectResult<UpAssignments> GETSTUWHOUSEWORK(global::System.Nullable<int> classID, string semester)
 {
     global::System.Data.Objects.ObjectParameter classIDParameter;
     if (classID.HasValue)
     {
         classIDParameter = new global::System.Data.Objects.ObjectParameter("ClassID", classID);
     }
     else
     {
         classIDParameter = new global::System.Data.Objects.ObjectParameter("ClassID", typeof(int));
     }
     global::System.Data.Objects.ObjectParameter semesterParameter;
     if ((semester != null))
     {
         semesterParameter = new global::System.Data.Objects.ObjectParameter("Semester", semester);
     }
     else
     {
         semesterParameter = new global::System.Data.Objects.ObjectParameter("Semester", typeof(string));
     }
     return base.ExecuteFunction<UpAssignments>("GETSTUWHOUSEWORK", classIDParameter, semesterParameter);
 }
 /// <summary>
 /// There are no comments for ThuongnghiepModel.InsertOrderDetails in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<DonDatHangChiTiet> InsertOrderDetails(string dathang, global::System.Nullable<int> accountID)
 {
     global::System.Data.Objects.ObjectParameter dathangParameter;
     if ((dathang != null))
     {
         dathangParameter = new global::System.Data.Objects.ObjectParameter("dathang", dathang);
     }
     else
     {
         dathangParameter = new global::System.Data.Objects.ObjectParameter("dathang", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter accountIDParameter;
     if (accountID.HasValue)
     {
         accountIDParameter = new global::System.Data.Objects.ObjectParameter("AccountID", accountID);
     }
     else
     {
         accountIDParameter = new global::System.Data.Objects.ObjectParameter("AccountID", typeof(int));
     }
     return base.ExecuteFunction<DonDatHangChiTiet>("InsertOrderDetails", dathangParameter, accountIDParameter);
 }
 /// <summary>
 /// There are no comments for ThuongnghiepModel.DonHangCuaNguoiDung in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<DonDatHang> DonHangCuaNguoiDung(global::System.Nullable<int> account, string trangThai)
 {
     global::System.Data.Objects.ObjectParameter accountParameter;
     if (account.HasValue)
     {
         accountParameter = new global::System.Data.Objects.ObjectParameter("Account", account);
     }
     else
     {
         accountParameter = new global::System.Data.Objects.ObjectParameter("Account", typeof(int));
     }
     global::System.Data.Objects.ObjectParameter trangThaiParameter;
     if ((trangThai != null))
     {
         trangThaiParameter = new global::System.Data.Objects.ObjectParameter("TrangThai", trangThai);
     }
     else
     {
         trangThaiParameter = new global::System.Data.Objects.ObjectParameter("TrangThai", typeof(string));
     }
     return base.ExecuteFunction<DonDatHang>("DonHangCuaNguoiDung", accountParameter, trangThaiParameter);
 }
예제 #6
0
 /// <summary>
 /// There are no comments for CornerSitesModels.SearchProperty in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<vw_CommercialPropertyAds> SearchProperty(global::System.Nullable<byte> propertyTypeID, global::System.Nullable<short> areaID, global::System.Nullable<short> cityID, global::System.Nullable<byte> bedrooms, string leaseType, global::System.Nullable<int> maxBudget, global::System.Nullable<int> minBudget, string brokerUserTyPeID, string builderUserTyPeID, string individualUserTyPeID, global::System.Nullable<int> userID)
 {
     global::System.Data.Objects.ObjectParameter propertyTypeIDParameter;
     if (propertyTypeID.HasValue)
     {
         propertyTypeIDParameter = new global::System.Data.Objects.ObjectParameter("PropertyTypeID", propertyTypeID);
     }
     else
     {
         propertyTypeIDParameter = new global::System.Data.Objects.ObjectParameter("PropertyTypeID", typeof(byte));
     }
     global::System.Data.Objects.ObjectParameter areaIDParameter;
     if (areaID.HasValue)
     {
         areaIDParameter = new global::System.Data.Objects.ObjectParameter("AreaID", areaID);
     }
     else
     {
         areaIDParameter = new global::System.Data.Objects.ObjectParameter("AreaID", typeof(short));
     }
     global::System.Data.Objects.ObjectParameter cityIDParameter;
     if (cityID.HasValue)
     {
         cityIDParameter = new global::System.Data.Objects.ObjectParameter("CityID", cityID);
     }
     else
     {
         cityIDParameter = new global::System.Data.Objects.ObjectParameter("CityID", typeof(short));
     }
     global::System.Data.Objects.ObjectParameter bedroomsParameter;
     if (bedrooms.HasValue)
     {
         bedroomsParameter = new global::System.Data.Objects.ObjectParameter("Bedrooms", bedrooms);
     }
     else
     {
         bedroomsParameter = new global::System.Data.Objects.ObjectParameter("Bedrooms", typeof(byte));
     }
     global::System.Data.Objects.ObjectParameter leaseTypeParameter;
     if ((leaseType != null))
     {
         leaseTypeParameter = new global::System.Data.Objects.ObjectParameter("LeaseType", leaseType);
     }
     else
     {
         leaseTypeParameter = new global::System.Data.Objects.ObjectParameter("LeaseType", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter maxBudgetParameter;
     if (maxBudget.HasValue)
     {
         maxBudgetParameter = new global::System.Data.Objects.ObjectParameter("MaxBudget", maxBudget);
     }
     else
     {
         maxBudgetParameter = new global::System.Data.Objects.ObjectParameter("MaxBudget", typeof(int));
     }
     global::System.Data.Objects.ObjectParameter minBudgetParameter;
     if (minBudget.HasValue)
     {
         minBudgetParameter = new global::System.Data.Objects.ObjectParameter("MinBudget", minBudget);
     }
     else
     {
         minBudgetParameter = new global::System.Data.Objects.ObjectParameter("MinBudget", typeof(int));
     }
     global::System.Data.Objects.ObjectParameter brokerUserTyPeIDParameter;
     if ((brokerUserTyPeID != null))
     {
         brokerUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("BrokerUserTyPeID", brokerUserTyPeID);
     }
     else
     {
         brokerUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("BrokerUserTyPeID", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter builderUserTyPeIDParameter;
     if ((builderUserTyPeID != null))
     {
         builderUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("BuilderUserTyPeID", builderUserTyPeID);
     }
     else
     {
         builderUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("BuilderUserTyPeID", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter individualUserTyPeIDParameter;
     if ((individualUserTyPeID != null))
     {
         individualUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("IndividualUserTyPeID", individualUserTyPeID);
     }
     else
     {
         individualUserTyPeIDParameter = new global::System.Data.Objects.ObjectParameter("IndividualUserTyPeID", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter userIDParameter;
     if (userID.HasValue)
     {
         userIDParameter = new global::System.Data.Objects.ObjectParameter("UserID", userID);
     }
     else
     {
         userIDParameter = new global::System.Data.Objects.ObjectParameter("UserID", typeof(int));
     }
     return base.ExecuteFunction<vw_CommercialPropertyAds>("SearchProperty", propertyTypeIDParameter, areaIDParameter, cityIDParameter, bedroomsParameter, leaseTypeParameter, maxBudgetParameter, minBudgetParameter, brokerUserTyPeIDParameter, builderUserTyPeIDParameter, individualUserTyPeIDParameter, userIDParameter);
 }
예제 #7
0
 /// <summary>
 /// There are no comments for CornerSitesModels.CreateUser in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<tblUser> CreateUser(string userTypeID, string fullName, string emailID, global::System.Nullable<short> cityID, global::System.Nullable<short> areaID, string mobileNumber, string landlineNumber, global::System.Nullable<bool> sMSFlag, string registeredOrgAddress, global::System.Nullable<bool> deleteFlag, string secure)
 {
     global::System.Data.Objects.ObjectParameter userTypeIDParameter;
     if ((userTypeID != null))
     {
         userTypeIDParameter = new global::System.Data.Objects.ObjectParameter("UserTypeID", userTypeID);
     }
     else
     {
         userTypeIDParameter = new global::System.Data.Objects.ObjectParameter("UserTypeID", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter fullNameParameter;
     if ((fullName != null))
     {
         fullNameParameter = new global::System.Data.Objects.ObjectParameter("FullName", fullName);
     }
     else
     {
         fullNameParameter = new global::System.Data.Objects.ObjectParameter("FullName", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter emailIDParameter;
     if ((emailID != null))
     {
         emailIDParameter = new global::System.Data.Objects.ObjectParameter("EmailID", emailID);
     }
     else
     {
         emailIDParameter = new global::System.Data.Objects.ObjectParameter("EmailID", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter cityIDParameter;
     if (cityID.HasValue)
     {
         cityIDParameter = new global::System.Data.Objects.ObjectParameter("CityID", cityID);
     }
     else
     {
         cityIDParameter = new global::System.Data.Objects.ObjectParameter("CityID", typeof(short));
     }
     global::System.Data.Objects.ObjectParameter areaIDParameter;
     if (areaID.HasValue)
     {
         areaIDParameter = new global::System.Data.Objects.ObjectParameter("AreaID", areaID);
     }
     else
     {
         areaIDParameter = new global::System.Data.Objects.ObjectParameter("AreaID", typeof(short));
     }
     global::System.Data.Objects.ObjectParameter mobileNumberParameter;
     if ((mobileNumber != null))
     {
         mobileNumberParameter = new global::System.Data.Objects.ObjectParameter("MobileNumber", mobileNumber);
     }
     else
     {
         mobileNumberParameter = new global::System.Data.Objects.ObjectParameter("MobileNumber", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter landlineNumberParameter;
     if ((landlineNumber != null))
     {
         landlineNumberParameter = new global::System.Data.Objects.ObjectParameter("LandlineNumber", landlineNumber);
     }
     else
     {
         landlineNumberParameter = new global::System.Data.Objects.ObjectParameter("LandlineNumber", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter sMSFlagParameter;
     if (sMSFlag.HasValue)
     {
         sMSFlagParameter = new global::System.Data.Objects.ObjectParameter("SMSFlag", sMSFlag);
     }
     else
     {
         sMSFlagParameter = new global::System.Data.Objects.ObjectParameter("SMSFlag", typeof(bool));
     }
     global::System.Data.Objects.ObjectParameter registeredOrgAddressParameter;
     if ((registeredOrgAddress != null))
     {
         registeredOrgAddressParameter = new global::System.Data.Objects.ObjectParameter("RegisteredOrgAddress", registeredOrgAddress);
     }
     else
     {
         registeredOrgAddressParameter = new global::System.Data.Objects.ObjectParameter("RegisteredOrgAddress", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter deleteFlagParameter;
     if (deleteFlag.HasValue)
     {
         deleteFlagParameter = new global::System.Data.Objects.ObjectParameter("DeleteFlag", deleteFlag);
     }
     else
     {
         deleteFlagParameter = new global::System.Data.Objects.ObjectParameter("DeleteFlag", typeof(bool));
     }
     global::System.Data.Objects.ObjectParameter secureParameter;
     if ((secure != null))
     {
         secureParameter = new global::System.Data.Objects.ObjectParameter("Secure", secure);
     }
     else
     {
         secureParameter = new global::System.Data.Objects.ObjectParameter("Secure", typeof(string));
     }
     return base.ExecuteFunction<tblUser>("CreateUser", userTypeIDParameter, fullNameParameter, emailIDParameter, cityIDParameter, areaIDParameter, mobileNumberParameter, landlineNumberParameter, sMSFlagParameter, registeredOrgAddressParameter, deleteFlagParameter, secureParameter);
 }
예제 #8
0
 /// <summary>
 /// There are no comments for GlobalPricingModel.GetFeatures in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<Feature> GetFeatures(string userLoginName)
 {
     global::System.Data.Objects.ObjectParameter userLoginNameParameter;
     if ((userLoginName != null))
     {
         userLoginNameParameter = new global::System.Data.Objects.ObjectParameter("UserLoginName", userLoginName);
     }
     else
     {
         userLoginNameParameter = new global::System.Data.Objects.ObjectParameter("UserLoginName", typeof(string));
     }
     return base.ExecuteFunction<Feature>("GetFeatures", userLoginNameParameter);
 }
예제 #9
0
 public global::System.Data.Objects.ObjectResult<Event> SelectSimilarEvents(string searchWord, global::System.Nullable<int> eventId)
 {
     global::System.Data.Objects.ObjectParameter searchWordParameter;
     if ((searchWord != null))
     {
         searchWordParameter = new global::System.Data.Objects.ObjectParameter("SearchWord", searchWord);
     }
     else
     {
         searchWordParameter = new global::System.Data.Objects.ObjectParameter("SearchWord", typeof(string));
     }
     global::System.Data.Objects.ObjectParameter eventIdParameter;
     if (eventId.HasValue)
     {
         eventIdParameter = new global::System.Data.Objects.ObjectParameter("EventId", eventId);
     }
     else
     {
         eventIdParameter = new global::System.Data.Objects.ObjectParameter("EventId", typeof(int));
     }
     return base.ExecuteFunction<Event>("SelectSimilarEvents", searchWordParameter, eventIdParameter);
 }
예제 #10
0
 public global::System.Data.Objects.ObjectResult<Event> SelectOtherEvents(global::System.Nullable<int> eventId)
 {
     global::System.Data.Objects.ObjectParameter eventIdParameter;
     if (eventId.HasValue)
     {
         eventIdParameter = new global::System.Data.Objects.ObjectParameter("EventId", eventId);
     }
     else
     {
         eventIdParameter = new global::System.Data.Objects.ObjectParameter("EventId", typeof(int));
     }
     return base.ExecuteFunction<Event>("SelectOtherEvents", eventIdParameter);
 }
예제 #11
0
 /// <summary>
 /// There are no comments for avenuedbModel.Search in the schema.
 /// </summary>
 public global::System.Data.Objects.ObjectResult<Content> Search(string searchString)
 {
     global::System.Data.Objects.ObjectParameter searchStringParameter;
     if ((searchString != null))
     {
         searchStringParameter = new global::System.Data.Objects.ObjectParameter("searchString", searchString);
     }
     else
     {
         searchStringParameter = new global::System.Data.Objects.ObjectParameter("searchString", typeof(string));
     }
     return base.ExecuteFunction<Content>("Search", searchStringParameter);
 }