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);
}
}
