public void DeleteBuilding(int buildingId)
{
string script = ReadSQLScript("DeleteBuilding.sql");
var parameters = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@BuildingId", buildingId)
};
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script, parameters);
}
public void DeleteBuildingFiles(List <Guid> fileIds)
{
string script = "update BuildingDocument set IsActive = 0 where Id = @Id";
foreach (Guid id in fileIds)
{
var parameters = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@Id", id),
};
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script, parameters);
}
}
public byte[] SaveBuildingImage(int buildingId, byte[] image)
{
string script = ReadSQLScript("SaveBuildingImage.sql");
var parameters = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@BuildingId", buildingId),
new System.Data.SqlClient.SqlParameter("@ImageData", image)
};
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script, parameters);
return(image);
}
public void CreateUserRecord(string emailAddress, string password, string accountNumber)
{
password = Cipher.Encrypt(password);
string script = ReadSQLScript("CreateUserRecord.sql");
var parameters = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@EmailAddress", emailAddress),
new System.Data.SqlClient.SqlParameter("@PasswordHash", password),
new System.Data.SqlClient.SqlParameter("@AccountNumber", accountNumber),
};
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script, parameters);
}
public void UpdatePrimaryEmail(int buildingId, string accountNumber, string oldEmail, string newEmail)
{
if (!String.IsNullOrWhiteSpace(oldEmail) && !string.IsNullOrWhiteSpace(newEmail))
{
string script = ReadSQLScript("UpdatePrimaryEmail.sql");
var parameters = new List <System.Data.SqlClient.SqlParameter>()
{
new System.Data.SqlClient.SqlParameter("@BuildingId", buildingId),
new System.Data.SqlClient.SqlParameter("@AccountNumber", accountNumber),
new System.Data.SqlClient.SqlParameter("@OldEmail", oldEmail),
new System.Data.SqlClient.SqlParameter("@NewEmail", newEmail),
};
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script, parameters);
}
}
/*Update all building records and client records*/
public void SyncBuildings()
{
string script = ReadSQLScript("SyncBuildingsAndUnits.sql");
SQLUtilities.ExecuteSqlCommand(_ClientProtalConnection, script);
}
