public static ReturnStatusModel updatetsNumberRange(tsNumberRangeModel tsNumberRangeModel)
{
ReturnStatusModel returnStatusModel = new ReturnStatusModel();
string CommandText = "SELECT * " +
"FROM tsNumber_Range_Model";
sqlConnection.Open();
sqlCommand = sqlConnection.CreateCommand();
using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection))
{
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
tsNumberRangeModel.login_id = (rdr["login_id"].ToString());
}
}
}
returnStatusModel.status = true;
returnStatusModel.error_message = Messages.m_update_success;
sqlConnection.Close();
return(returnStatusModel);
#endregion
}
public static void CreateLoginTransaction(LoginMessage loginMessage)
{
tsNumberRangeModel newNumberRange = new tsNumberRangeModel()
{
login_id = (Int32.Parse(DatabaseConnection.querytsNumberRange().login_id) + 1).ToString()
};
tsLoginDetailModel tsLoginDetailModel = new tsLoginDetailModel()
{
login_id = newNumberRange.login_id,
login_account_id = loginMessage.zAccountDetailModel.account_id,
login_username = loginMessage.zAccountDetailModel.account_username,
login_time = DateTime.Now.ToString("HHmm"),
login_date = DateTime.Now.Date.ToString("ddMMyyyy"),
login_ip = GlobalFunctions.GetIPAddress(),
login_token = "null",
login_status = loginMessage.returnStatusModel.status.ToString()
};
DatabaseConnection.inserttsLoginDetail(tsLoginDetailModel);
returnStatusModel = DatabaseConnection.updatetsNumberRange(newNumberRange);
if (GlobalFunctions.isNotError(returnStatusModel.status))
{
GlobalFunctions.ShowDebug("COMPLETED");
}
}
public static tsNumberRangeModel querytsNumberRange()
{
tsNumberRangeModel tsNumberRangeModel = new tsNumberRangeModel();
string CommandText = "SELECT * " +
"FROM tsNumber_Range_Model";
sqlConnection.Open();
sqlCommand = sqlConnection.CreateCommand();
using (SQLiteCommand cmd = new SQLiteCommand(CommandText, DatabaseConnection.sqlConnection))
{
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
tsNumberRangeModel.login_id = (rdr["login_id"].ToString());
}
}
}
sqlConnection.Close();
return(tsNumberRangeModel);
}
