예제 #1
0
        private static string CheckIfExists(SIMcard simcard, string ID, bool WithID)
        {
            DataAccessLayer dal   = new DataAccessLayer();
            string          error = "";
            string          addID = "";

            if (WithID)
            {
                dal.AddParameter("@ID", ID, System.Data.DbType.String);
                addID = " AND [ID] <> @ID";
            }

            dal.AddParameter("@SIMcardnr", simcard.SIMcardnr, System.Data.DbType.String);
            dal.AddParameter("@Phonenr", simcard.Phonenr, System.Data.DbType.String);
            error = dal.ExecuteScalar(@"
DECLARE @error varchar(50)
SET @error = ''

IF EXISTS (SELECT * FROM [SIMcard] WHERE [Deleted] = 0 AND UPPER([SIMcardnr]) = UPPER(@SIMcardnr)" + addID + @")
SET @error += '3'

IF EXISTS (SELECT * FROM [SIMcard] WHERE [Deleted] = 0 AND UPPER([Phonenr]) = UPPER(@Phonenr) AND [Phonenr] <> ''" + addID + @")
SET @error += '4'

SELECT @error
").ToString();
            dal.ClearParameters();

            return(error);
        }
예제 #2
0
 public static string CheckIfExists(SIMcard simcard, string ID)
 {
     return(CheckIfExists(simcard, ID, true));
 }
예제 #3
0
 /// <summary>
 /// SIMcard
 /// </summary>
 /// <param name="simcard">The SIMcard to check</param>
 /// <returns></returns>
 public static string CheckIfExists(SIMcard simcard)
 {
     return(CheckIfExists(simcard, "", false));
 }