Example #1
0
        public bool InsertRecord_UserProfile(tblUserProfile rec)
        {
            try
            {
                MentorJEntities context     = new MentorJEntities();
                tblUserProfile  existingRec = ReadRecord_UserProfile(rec.UserID);

                if (existingRec == null)
                {
                    //generate profile URL;
                    //if (isUserNameTaken(rec) == true)  //if check fails, then username already taken.
                    //{
                    //    return false;
                    //}
                    //if (isEmailTaken(rec) == true)  //if check fails, then username already taken.
                    //{
                    //    return false;
                    //}
                    rec.Modified = DateTime.Now;
                    context.tblUserProfiles.Add(rec);
                    context.SaveChangesAsync();

                    return(true);
                }
                return(false);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Example #2
0
        public static string insertUpdateData(tblUserProfile data, string path)
        {
            try
            {
                var db = new SQLiteAsyncConnection(path);
                if (db.InsertAsync(data).ToString() == 0.ToString())
                {
                    db.UpdateAsync(data);
                }

                return("Single data file inserted or updated");
            }
            catch (SQLiteException ex)
            {
                return(ex.Message);
            }
        }
Example #3
0
 public static bool deleteRecord(tblUserProfile data, string path)
 {
     try
     {
         var  db     = new SQLiteAsyncConnection(path);
         long userid = data.UserID;
         var  query  = db.GetAsync <tblUserProfile>(t => t.UserID == userid).Result;
         if (query != null)
         {
             return(db.DeleteAsync(query).IsCompleted);
         }
         return(false);
     }
     catch (SQLiteException ex)
     {
         throw ex;
     }
 }
Example #4
0
 public bool DeleteRecord_UserProfile(long ID)
 {
     try
     {
         MentorJEntities context     = new MentorJEntities();
         tblUserProfile  existingRec = ReadRecord_UserProfile(ID);
         if (existingRec != null) //there is a record
         {
             context.tblUserProfiles.Remove(existingRec);
             context.SaveChangesAsync();
             return(true);
         }
         return(false);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #5
0
 public bool UpdateRecord_UserProfile(tblUserProfile rec)
 {
     try
     {
         MentorJEntities context     = new MentorJEntities();
         tblUserProfile  existingRec = ReadRecord_UserProfile(rec.UserID);
         if (existingRec != null)
         {
             rec.Modified = DateTime.Now;
             Serializer.Clone <tblUserProfile>(rec, existingRec);
             context.SaveChangesAsync();
             return(true);
         }
         return(false);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #6
0
 public bool AddUpdateRecord_UserProfile(tblUserProfile rec)
 {
     try
     {
         MentorJEntities context     = new MentorJEntities();
         tblUserProfile  existingRec = ReadRecord_UserProfile(rec.UserID);
         if (existingRec == null) //new record
         {
             return(InsertRecord_UserProfile(rec));
         }
         else //found existing, update
         {
             return(UpdateRecord_UserProfile(rec));
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #7
0
 public static tblUserProfile getRecord(tblUserProfile data, string path)
 {
     try
     {
         var  db     = new SQLiteAsyncConnection(path);
         long userid = data.UserID;
         // for a non-parameterless query
         var query = db.GetAsync <tblUserProfile>(t => t.UserID == userid).Result;
         //var query = table.Where(x => (x.UserID == userid)); //Linq Query
         if (query != null)
         {
             return(query);
         }
         return(null);
     }
     catch (SQLiteException ex)
     {
         throw ex;
     }
     //Get�specific�student��
 }