示例#1
0
        public UserModel UserData(object UserID)
        {
            List <SqlParameter>  ProcParam = new List <SqlParameter>();
            EducationDataContext sqldb     = new EducationDataContext();

            ProcParam.Add(new SqlParameter("UserID", UserID.handleDBNull()));
            return(new EducationDataContext().Database.SqlQuery <UserModel>("GetUserData".getSql(ProcParam), ProcParam.Cast <object>().ToArray()).FirstOrDefault());
        }
示例#2
0
        //public string UploadDB()
        //{
        //    SqlConnection con = new SqlConnection();
        //    return null;
        //}

        public void LogOut(object UserID = null, string Email = null, string pass = null)
        {
            EducationDataContext sqldb     = new EducationDataContext();
            List <SqlParameter>  ProcParam = new List <SqlParameter>();

            ProcParam.Add(new SqlParameter("UserID", UserID.handleDBNull()));
            ProcParam.Add(new SqlParameter("Email", Email.handleDBNull()));
            ProcParam.Add(new SqlParameter("pass", pass.handleDBNull()));
            new EducationDataContext().Database.ExecuteSqlCommand("EXEC LogOutUser @UserID,@Email,@pass", ProcParam.ToArray());
        }
示例#3
0
        public Boolean GetUserName(string lsUserName)
        {
            EducationDataContext sqldb     = new EducationDataContext();
            List <SqlParameter>  ProcParam = new List <SqlParameter>();

            ProcParam.Add(new SqlParameter("UserName", lsUserName.handleDBNull()));

            var u = new EducationDataContext().Database.SqlQuery <string>("EXEC GetUserNameForValidation @UserName", ProcParam.ToArray()).FirstOrDefault();

            if (u == null)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#4
0
        public Boolean GetEmail(string lsEmailID)
        {
            EducationDataContext sqldb     = new EducationDataContext();
            List <SqlParameter>  ProcParam = new List <SqlParameter>();

            ProcParam.Add(new SqlParameter("EmailID", lsEmailID.handleDBNull()));

            var e = new EducationDataContext().Database.SqlQuery <string>("EXEC GetEmailForValidation @EmailID", ProcParam.ToArray()).FirstOrDefault();

            if (e == null)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
示例#5
0
        public string EditProfile(UserModel loEdit)
        {
            EducationDataContext sqldb     = new EducationDataContext();
            List <SqlParameter>  ProcParam = new List <SqlParameter>();
            //string FileName;
            //if (loEdit.ProfileImg==null)
            //{
            //    FileName = System.Configuration.ConfigurationManager.AppSettings["Default_Profile"];
            //}
            //else
            //{
            //    FileName = loEdit.ProfileImg.FileName;
            //}

            string FileName = loEdit.ProfImg;

            if (loEdit.ProfileImg != null)
            {
                FileName = loEdit.FName + " " + loEdit.LName + loEdit.UserID + Path.GetExtension(loEdit.ProfileImg.FileName);
            }
            else
            {
                FileName = System.Configuration.ConfigurationManager.AppSettings["Default_Profile"];
            }

            ProcParam.Add(new SqlParameter("UserID", loEdit.UserID.handleDBNull()));
            ProcParam.Add(new SqlParameter("FName", loEdit.FName.handleDBNull()));
            ProcParam.Add(new SqlParameter("LName", loEdit.LName.handleDBNull()));
            ProcParam.Add(new SqlParameter("MobileNo", loEdit.MobileNo.handleDBNull()));
            ProcParam.Add(new SqlParameter("Email", loEdit.Email.handleDBNull()));
            ProcParam.Add(new SqlParameter("DoB", loEdit.DoB.handleDBNull()));
            ProcParam.Add(new SqlParameter("City", loEdit.City.handleDBNull()));
            ProcParam.Add(new SqlParameter("profileImg", FileName.handleDBNull()));
            ProcParam.Add(new SqlParameter("UPassword", loEdit.UPassword.handleDBNull()));

            if (Convert.ToBoolean(sqldb.Database.ExecuteSqlCommand("exec UpdateProfile @UserID,@FName,@LName,@MobileNo,@Email,@DoB,@City,@profileImg,@UPassword", ProcParam.ToArray())))
            {
                return("Successfully Registered");
            }
            else
            {
                return("Error Occured While Registering");
            }
        }
示例#6
0
        public Boolean GetMobile(string lsMobile)
        {
            EducationDataContext sqldb     = new EducationDataContext();
            List <SqlParameter>  ProcParam = new List <SqlParameter>();


            ProcParam.Add(new SqlParameter("Mobile", lsMobile.handleDBNull()));

            var e = new EducationDataContext().Database.SqlQuery <Decimal>("GetMobileForValidation".getSql(ProcParam), ProcParam.Cast <object>().ToArray()).FirstOrDefault();

            if (e < 1)
            {
                return(false);
            }
            else
            {
                return(true);
            }
        }
示例#7
0
        public string UserInsert(UserModel loRegistration)
        {
            List <SqlParameter>  ProcParam = new List <SqlParameter>();
            EducationDataContext sqldb     = new EducationDataContext();

            ProcParam.Add(new SqlParameter("FName", loRegistration.FName.handleDBNull()));
            ProcParam.Add(new SqlParameter("LName", loRegistration.LName.handleDBNull()));
            ProcParam.Add(new SqlParameter("MobileNo", loRegistration.MobileNo.handleDBNull()));
            ProcParam.Add(new SqlParameter("Email", loRegistration.Email.handleDBNull()));
            ProcParam.Add(new SqlParameter("Gender", loRegistration.Gender.handleDBNull()));

            ProcParam.Add(new SqlParameter("UserType", "user"));
            ProcParam.Add(new SqlParameter("ProfImg", System.Configuration.ConfigurationManager.AppSettings["Default_Profile"].handleDBNull()));
            ProcParam.Add(new SqlParameter("RegDate", DateTime.Now.Date.ToString()));
            ProcParam.Add(new SqlParameter("ISActive", "InActive"));

            ProcParam.Add(new SqlParameter("UPassword", loRegistration.UPassword.handleDBNull()));
            ProcParam.Add(new SqlParameter("SecQue", "security question"));

            //ProcParam.Add(new SqlParameter("SecQue", loRegistration.SecQue));
            ProcParam.Add(new SqlParameter("SecAns", loRegistration.SecAns.handleDBNull()));

            ProcParam.Add(new SqlParameter("LearnedTime", 1));

            //procparam.add(new SqlParameter("dob", loRegistration.dob));
            //procparam.add(new SqlParameter("cityid", loRegistration.cityid));

            //if (Convert.ToBoolean(ins.Database.SqlQuery<Reg>("Rginsert".getSql(ProcParam.ToList()))))
            // if (Convert.ToBoolean(ins.Database.ExecuteSqlCommand("Rginsert".getSql(ProcParam.ToList()))))
            if (Convert.ToBoolean(sqldb.Database.ExecuteSqlCommand("exec Registration @FName,@LName,@MobileNo,@Email,@Gender,@UserType,@ProfImg,@RegDate,@ISActive,@UPassword,@SecQue,@SecAns,@LearnedTime", ProcParam.ToArray())))
            {
                return("Successfully Registered");
            }
            else
            {
                return("Error Occured While Registering");
            }
        }