Пример #1
0
 public virtual string InsertDeleteFollowings(string UserID, string FollowingID)
 {
     SqlParameter[] param =
     {
         new SqlParameter("@UserID",      UserID),
         new SqlParameter("@FollowingID", FollowingID)
     };
     return(FCommon.CheckString(SqlHelper.ExecuteScalar(FCommon.ConStr, CommandType.StoredProcedure, "spInsertDeleteFollowings", param)));
 }
Пример #2
0
 public virtual string InsertUpdateUser(BALUsers BAL)
 {
     SqlParameter[] param =
     {
         new SqlParameter("@ID",               BAL.ID),
         new SqlParameter("@FirstName",        BAL.FirstName),
         new SqlParameter("@LastName",         BAL.LastName),
         new SqlParameter("@UserName",         BAL.UserName),
         new SqlParameter("@Email",            BAL.Email),
         new SqlParameter("@Pass",             BAL.Pass),
         new SqlParameter("@ImgUrl",           "Sample.png"),
         new SqlParameter("@IsEmailConfirmed", BAL.IsEmailConfirmed),
         new SqlParameter("@IsActive",         BAL.IsActive),
     };
     return(FCommon.CheckString(SqlHelper.ExecuteScalar(FCommon.ConStr, CommandType.StoredProcedure, "spInsertUpdateUsers", param)));
 }