public bool DeleteDepartment(DepartmentEntity entityObject)
{
string sqlStatement = "UPDATE Department SET Deleted=1 WHERE DepartmentId=@DepartmentId " + Environment.NewLine;
//execute
Connection.Execute(sqlStatement, new { DepartmentId = entityObject.DepartmentId }, Transaction);
return true;
}
public bool DeleteDepartment(DepartmentEntity entityObject)
{
//execute
using (var db = VinaGerman.Database.VinagermanDatabase.GetDatabaseInstance())
{
try
{
db.OpenConnection();
return db.Resolve<IDepartmentDB>().DeleteDepartment(entityObject);
}
finally
{
db.CloseConnection();
}
}
}
public DepartmentEntity AddOrUpdateDepartment(DepartmentEntity entityObject)
{
string sqlStatement = "";
//if insert
if (entityObject.DepartmentId > 0)
{
sqlStatement += "UPDATE Department SET " + Environment.NewLine +
"Phone=@Phone," + Environment.NewLine +
"Description=@Description," + Environment.NewLine +
"CompanyId=@CompanyId," + Environment.NewLine +
"Deleted=@Deleted" + Environment.NewLine +
"WHERE DepartmentId=@DepartmentId " + Environment.NewLine +
"SELECT @DepartmentId AS DepartmentId " + Environment.NewLine;
}
else
{
sqlStatement += "INSERT INTO Department( " + Environment.NewLine +
"Phone," + Environment.NewLine +
"Description," + Environment.NewLine +
"CompanyId," + Environment.NewLine +
"Deleted)" + Environment.NewLine +
"VALUES (" + Environment.NewLine +
"@Phone," + Environment.NewLine +
"@Description," + Environment.NewLine +
"@CompanyId," + Environment.NewLine +
"@Deleted)" + Environment.NewLine +
"SELECT SCOPE_IDENTITY() AS DepartmentId" + Environment.NewLine;
}
//execute
entityObject.DepartmentId = Connection.ExecuteScalar<int>(sqlStatement, new
{
DepartmentId = entityObject.DepartmentId,
Phone = entityObject.Phone,
Description = entityObject.Description,
CompanyId = entityObject.CompanyId,
Deleted = (entityObject.Deleted ? 1 : 0)
}, Transaction);
return entityObject;
}