public static bool IsMatch(GuidQueueType t,string email, string guid) { return IsMatch(t, email, guid, false); }
public static bool IsMatch(GuidQueueType t, string email, string guid, bool delete) { /* GuidQueueCheck @type smallint, @email varchar(50), @guid char(32), @delete bit=0 */ int ret = Database.ExecuteNonQuery(CommandType.StoredProcedure, "GuidQueueCheck", new SqlParameter[] { Database.MakeReturnValueParam("@returnValue"), Database.MakeInParam("@type",SqlDbType.SmallInt,(short)t), Database.MakeInParam("@email",SqlDbType.VarChar,50,email), Database.MakeInParam("@guid",SqlDbType.Char,32,guid), Database.MakeInParam("@delete",SqlDbType.Bit,delete) }); return ret > 0; }
public static string Create(GuidQueueType t, string mail) { GuidQueue gq= new GuidQueue(); gq.type = t; gq.email = mail; gq.Save(); return gq.guid; }