Пример #1
0
 //view details
 public List<Proc_ViewAccountDetails_Result> GetUserDetails(String memberId)
 {
     log.Warn("this is test log memberId: " + memberId);
     //log.Error("exception message", exception);
     //log.Debug("debug message",obj);
     LOYALTYNMEntities dataContext = new LOYALTYNMEntities();
     return dataContext.Proc_ViewAccountDetails(memberId).ToList();
 }
Пример #2
0
 // GetUserDetails ByEmailID       
 public List<Proc_GetWebAccountByEmailId_Result> GetUserDetailsByEmailId(String useremailid)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_GetWebAccountByEmailId(useremailid).ToList();
 }
Пример #3
0
  // getTopmemberid       
 public List<Proc_GetTopWebId_Result1> GetMaxMemberId()
  {
       LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
       return dataContext1.Proc_GetTopWebId().ToList();
  }
Пример #4
0
 //update details
 public int UpdateUserDetails(String membershipid,String salutation,String firstName, String lastName, String address, String addressTwo, String city, String country, String mobileNo, String email, DateTime dateOfBirth, DateTime anniversaryDate, String maritalStatus,String designation, String phoneNo)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     int cnfrm = dataContext1.Proc_UpdateAccountDetails(membershipid, salutation, firstName, lastName, address, addressTwo, city, country, mobileNo, email, dateOfBirth, anniversaryDate, maritalStatus, designation, phoneNo);
     return cnfrm;
 }
Пример #5
0
 //Forgot Password 
 public List<Proc_ForgetPassword_Result> ForgotPassword(String Membershipid,String emailid)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_ForgetPassword(Membershipid, emailid).ToList();
    
 }       
Пример #6
0
 //Update Password 
 public int ChangePassword(String Membershipid, String oldpwd, String newpwd)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     int cnfrm = dataContext1.Proc_UpdatePassword(Membershipid, oldpwd, newpwd);
     return cnfrm;
 }
Пример #7
0
 //insert top up by memberid    
 public List<Proc_CardTransaction_Result> InsertTopUpDetails(String membershipid,Decimal paidAmount,DateTime paiddate,String PaidReceiptNo, int PaidType)
 {
      LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
      return dataContext1.Proc_CardTransaction(membershipid, paidAmount, paiddate, PaidReceiptNo, PaidType).ToList();
     
 }
Пример #8
0
 //update details
 public int UpdatePaymentDetails(String membershipid, int PayStatus, int Readytocreate, decimal paidamt, String receiptno)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     int cnfrm = dataContext1.Proc_UpdateAccountPaymentDetails(membershipid, PayStatus, Readytocreate, paidamt, receiptno);
     return cnfrm;
 }
Пример #9
0
       public bool PasswordExistsCheck(String memberid, DateTime doB)
       {
           try
           {
               LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();

               var query = (from c in dataContext1.Great_Indian_Nautanki_Company_Contact
                            where c.No_ == memberid && c.DOB == doB
                            select c.Web_Password).First();
               if (query == null || string.IsNullOrEmpty(query))
                  return false;

               return true;
           }
           catch (Exception ex)
           {
               return false;
           }          
       }
Пример #10
0
 public int FirstTimeLogin(String memberid, DateTime doB)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     var query = (from c in dataContext1.Great_Indian_Nautanki_Company_Contact
       where c.No_ == memberid && c.DOB==doB
       select c.No_).Count();
     return query;
 }
Пример #11
0
 public int MobilenoExist(String mobile)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     var query = (from c in dataContext1.Great_Indian_Nautanki_Company_Temp_Web_Booking
                  where c.Mobile_Phone_No_ == mobile
                  select c.No_).Count();
     return query;
 }
Пример #12
0
 public int EmailExists(String email)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     var query = (from c in dataContext1.Great_Indian_Nautanki_Company_Temp_Web_Booking
                  where c.E_Mail == email
                  select c.No_).Count();
     return query;
 }
Пример #13
0
 //get  temp web details by temp memberid    
 public List<Proc_GetWebAccountByTempWebId_Result> GetTempUserDetailsByWebId(String tempwebid)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_GetWebAccountByTempWebId(tempwebid).ToList();
 }
Пример #14
0
 //update top up details      
 public int UpdateTopUpStatus(String Transactionid, int success, int transType)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     int cnfrm = dataContext1.Proc_PaymentSuccessfullUpdate(Transactionid, success, transType);
     return cnfrm;
 }
Пример #15
0
       // Get all cards Details

       public List<Proc_AllTierDetails_Result> GetAllCardsDetails()
       {
           LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
           return dataContext1.Proc_AllTierDetails().ToList();
       }
Пример #16
0
 public List<Proc_RegisterUsers_Result> registeruserwithoutpayment(String membershipid, String salutation, String firstName, String lastName, String address, String addressTwo, String city, String country, String phoneNo, String mobileNo, String email, DateTime dateOfBirth, DateTime anniversaryDate, String maritalStatus, String gender, Decimal paymentAmount, DateTime paymentDate, String cardNo, String bankName, String userName, String password, String designation, bool boxOffiec, bool coupon)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_RegisterUsers(membershipid, salutation, firstName, lastName, address, addressTwo, city, country, phoneNo, mobileNo, email, dateOfBirth, anniversaryDate, maritalStatus, gender, paymentAmount, paymentDate, cardNo, bankName, userName, password, designation, boxOffiec, coupon).ToList();
     
 }
Пример #17
0
 // Get cards Details by type     
 public List<Proc_TierDetails_Result> GetCardsDetailsbyType(String CardType)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_TierDetails(CardType).ToList();
 }
Пример #18
0
 //Get Login details
 public List<Proc_Login_Result> GetUserLogin(String Membershipid, String pwd)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_Login(Membershipid, pwd).ToList();
 }
Пример #19
0
 // Get point status by memberid    
 public List<Proc_GetMemberBalance_Result> GetCardsBalanceByMemberId(String membershipid)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_GetMemberBalance(membershipid).ToList();
 }
Пример #20
0
 // Get cards Balance by memberid    
 public List<Proc_PointStatment_Result> GetPointStatusByMemberId(String membershipid)
 {
     LOYALTYNMEntities dataContext1 = new LOYALTYNMEntities();
     return dataContext1.Proc_PointStatment(membershipid).ToList();
 }