public static void UpdateProfileRF(ProfileRF profileRF, string Status = null) { try { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("UPDATE RF_PROFILE SET " + "name = @NAME, " + "CLASS = @CLASS, " + "GENDER = @GENDER, " + "DOB = @DOB, " + "EMAIL = @EMAIL, " + "ADDRESS = @ADDRESS, " + "PHONE = @PHONE, " + "ADNO = @ADNO, " + "DISU = @DISU, " + ((Status == null) ? "" : "LOCK_DATE = @LOCK_DATE, ") + ((Status == null) ? "" : "STATUS = @STATUS, ") + "DATE_TO_LOCK = @DATE_TO_LOCK, " + "CHECK_DATE_TO_LOCK = @CHECK_DATE_TO_LOCK, " + "IMAGE = @IMAGE " + "WHERE PIN_NO = @PIN_NO", profileRF); } } catch (Exception ex) { logFile.Error(ex.Message); Constant.mainWindowPointer.WriteLog(ex.Message); } }
public static void RemoveProfileRF(ProfileRF profileRF) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("DELETE FROM RF_TIMECHECK WHERE PIN_NO=@PIN_NO", profileRF); cnn.Execute("DELETE FROM RF_PROFILE WHERE PIN_NO=@PIN_NO", profileRF); } }
public static void SaveProfileRF(ProfileRF accountRFCard) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("INSERT INTO RF_PROFILE (PIN_NO,NAME,CLASS,GENDER,DOB,EMAIL,ADDRESS,PHONE,ADNO,DISU,STATUS,LOCK_DATE,IMAGE,DATE_TO_LOCK,CHECK_DATE_TO_LOCK) " + "VALUES (@PIN_NO,@NAME,@CLASS,@GENDER,@DOB,@EMAIL,@ADDRESS,@PHONE,@ADNO,@DISU,@STATUS,@LOCK_DATE,@IMAGE,@DATE_TO_LOCK,@CHECK_DATE_TO_LOCK)", accountRFCard); } }
public static void SaveProfileRF(ProfileRF accountRFCard) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("INSERT INTO RF_PROFILE (SERIAL_ID,NAME,CLASS,GENDER,BIRTHDAY,STUDENT,EMAIL,ADDRESS,PHONE) " + "VALUES (@SERIAL_ID,@NAME,@CLASS,@GENDER,@BIRTHDAY,@STUDENT,@EMAIL,@ADDRESS,@PHONE)", accountRFCard); } }
public static void UpdateProfileRF(ProfileRF profileRF) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("UPDATE RF_PROFILE SET " + "name = @NAME, " + "CLASS = @CLASS, " + "GENDER = @GENDER, " + "BIRTHDAY = @BIRTHDAY, " + "STUDENT = @STUDENT, " + "EMAIL = @EMAIL, " + "ADDRESS = @ADDRESS, " + "PHONE = @PHONE " + "WHERE SERIAL_ID = @SERIAL_ID", profileRF); } }