private bool RecordExistsCheck(
SqlCommand cmd,
IAccountModel model,
TypeOfExistenceCheck typeOfExistenceCheck,
RequestType requestType
)
{
Int32 count0fRecordsFound = 0;
bool recordExistsCheckPassed = true;
DataAccessStatus dataAccessStatus = new DataAccessStatus();
SqlCommand cmdCheck = new SqlCommand(null, cmd.Connection);
cmdCheck.Prepare();
if ((requestType == RequestType.Add) || (requestType == RequestType.ConfirmAdd))
{
cmdCheck.CommandText = "SELECT count(*) FROM Accounts where Username = @User";
cmdCheck.Parameters.AddWithValue("@User", model.Username);
}
else if ((requestType == RequestType.Update) || (requestType == RequestType.Delete) || (requestType == RequestType.ConfirmDelete))
{
cmdCheck.CommandText = "SELECT count(*) FROM Accounts WHERE ID = @ID";
cmdCheck.Parameters.AddWithValue("@ID", model.ID);
}
try
{
count0fRecordsFound = Convert.ToInt32(cmdCheck.ExecuteScalar());
}
catch (SqlException e)
{
string msg = e.Message;
throw e;
}
if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesNotExistInDB) && (count0fRecordsFound > 0))
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
else if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesExistInDB) && (count0fRecordsFound == 0))
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
return(recordExistsCheckPassed);
}
private bool RecordExistsCheck(SqlCommand cmd, IRoleModel roleModel, TypeOfExistenceCheck typeOfExistenceCheck,
RequestType requestType)
{
Int32 count0fRecordsFound = 0;
bool recordExistsCheckPassed = true;
DataAccessStatus dataAccessStatus = new DataAccessStatus();
SqlCommand cmdCheck = new SqlCommand(null, cmd.Connection);
cmdCheck.Prepare();
if ((requestType == RequestType.Add) || (requestType == RequestType.ConfirmAdd))
{
cmdCheck.CommandText = "SELECT count(*) FROM [Roles] where [Name] = @Name";
cmdCheck.Parameters.Add(new SqlParameter("@Name", System.Data.SqlDbType.VarChar, 20)).Value = roleModel.Name;
}
else if ((requestType == RequestType.Update) || (requestType == RequestType.Delete) || (requestType == RequestType.ConfirmDelete))
{
cmdCheck.CommandText = "SELECT count(*) FROM [Roles] WHERE [ID] = @ID";
cmdCheck.Parameters.Add(new SqlParameter("@ID", roleModel.ID));
}
try
{
count0fRecordsFound = Convert.ToInt32(cmdCheck.ExecuteScalar());
}
catch (SqlException e)
{
string msg = e.Message;
throw e;
}
if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesNotExistInDB) && (count0fRecordsFound > 0))
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
else if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesExistInDB) && (count0fRecordsFound == 0))
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
return(recordExistsCheckPassed);
}
private void RecordExistsCheck(TDomainModel model, TypeOfExistenceCheck typeOfExistenceCheck,
RequestType requestType, bool checkAfterInsert = false,
bool checkExist = false)
{
bool exists = false;
try
{
switch (requestType)
{
//case RequestType.Insert:
case RequestType.ConfirmInsert:
exists = checkAfterInsert;
break;
case RequestType.Update:
case RequestType.Delete:
case RequestType.ConfirmDelete:
case RequestType.GetById:
exists = checkExist;
break;
}
}
catch (SqlException ex)
{
var dataAccessStatus = new DataAccessStatus();
dataAccessStatus = SetDataAccessValues(ex, ErrorMessageType.Delete);
throw new DataAccessException(message: ex.Message, innerException: ex.InnerException,
dataAccessStatus: dataAccessStatus);
}
if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesExistInDB) && !exists)
{
throw new DataAccessException(new DataAccessStatus());
}
else if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesNotExistInDB) && exists)
{
throw new DataAccessException(new DataAccessStatus());
}
}
private bool RecordExistsCheck(IBarangModel barangModel, TypeOfExistenceCheck typeOfExistenceCheck, RequestType requestType)
{
bool exists = false;
bool recordExistsCheckPassed = true;
DataAccessStatus dataAccessStatus = new DataAccessStatus();
try
{
if (requestType == RequestType.Add || requestType == RequestType.ConfirmAdd)
{
exists = _context.Conn.ExecuteScalar <bool>("SELECT COUNT(1) from barang where nama=@nama", new { barangModel.nama });
}
else if (requestType == RequestType.Update || requestType == RequestType.ConfirmDelete || requestType == RequestType.Delete)
{
exists = _context.Conn.ExecuteScalar <bool>("SELECT COUNT(1) from barang where id=@id", new { barangModel.id });
}
}
catch (SQLiteException ex)
{
throw ex;
}
if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesExistInDB) && !exists)
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
else if ((typeOfExistenceCheck == TypeOfExistenceCheck.DoesNotExistInDB) && exists)
{
dataAccessStatus.Status = "Error";
recordExistsCheckPassed = false;
throw new DataAccessException(dataAccessStatus);
}
return(recordExistsCheckPassed);
}
