/// <summary>
 /// This method is used to register a new user in the database.
 /// </summary>
 /// <param name="UserId"></param>
 /// <param name="Password"></param>
 /// <param name="EmailId"></param>
 /// <returns></returns>
 public static string CreateUser(string UserId, string Password, string EmailId)
 {
     UserSignUp us = new UserSignUp();
     us.UserId = UserId;
     us.Password = Password;
     us.EmailId = EmailId;
     return DataProvider.Registration(us);
 }
 /// <summary>
 /// This method is used to register a new user in the database.
 /// </summary>
 /// <param name="usersignup"></param>
 /// <returns></returns>
 public static string Registration(UserSignUp usersignup)
 {
     try
     {
         Database db = EnterpriseLibraryContainer.Current.GetInstance<Database>("LetsShopConnString");
         DbCommand CmdObj = db.GetStoredProcCommand("SignUp");
         db.AddInParameter(CmdObj, "@UserId", DbType.String, usersignup.UserId);
         db.AddInParameter(CmdObj, "@Password", DbType.String, usersignup.Password);
         db.AddInParameter(CmdObj, "@EmailId", DbType.String, usersignup.EmailId);
         db.AddOutParameter(CmdObj, "@strMessage", DbType.String, 255);
         db.ExecuteNonQuery(CmdObj);
         return db.GetParameterValue(CmdObj, "@strMessage").ToString();
     }
     catch (Exception ex)
     {
         bool rethrow = ExceptionPolicy.HandleException(ex, "Database Policy");
         if (rethrow) throw;
         string result = " Error in Registration.";
         return result;
     }
 }