public bool UpdateParkletApplication(COMMUNITY_PARKLET_APPLICATION cpa, int refNumber)
{
try
{
using (SqlConnection conn = new SqlConnection(dbConnection))
{
var sql =
$"UPDATE {sqlTableCPA} SET [NAME] = '{cpa.NAME}', [EMAIL] = '{cpa.EMAIL}', [PHONE] = '{cpa.PHONE}',[NOTES] = '{cpa.NOTES}',[STATUS] = '{cpa.STATUS}', [PARKLET_24HR_CONTACT] = '{cpa.PARKLET_24HR_CONTACT}', [PARKLET_TIME_FRAME] = '{cpa.PARKLET_TIME_FRAME}' WHERE REF_NUMBER = '{refNumber}'";
conn.Execute(sql);
}
}
catch (Exception ex)
{
Console.WriteLine(@"ERROR: " + ex.Message);
return(false);
}
return(true);
}
public CPDashboardModel(COMMUNITY_PARKLET_APPLICATION lApplications)
{
lParkletApplicationDtos = new List <ParkletApplicationDTO>();
if (lApplications != null)
{
ParkletApplicationDTO applicationDTO = new ParkletApplicationDTO
{
RefNumber = lApplications.REF_NUMBER,
Name = lApplications.NAME,
Parklet24hrContact = lApplications.PARKLET_24HR_CONTACT,
ParkletDescription = lApplications.PARKLET_DESCRIPTION,
ParkletMaintenance = lApplications.PARKLET_MAINTENANCE,
ParkletTimeFrame = lApplications.PARKLET_TIME_FRAME,
ParkletTitle = lApplications.PARKLET_TITLE,
Phone = lApplications.PHONE,
Notes = lApplications.NOTES,
Status = lApplications.STATUS,
};
string type = lApplications.TYPE_DISPLAY + "\n" + lApplications.TYPE_EDUCATIONAL + "\n" +
lApplications.TYPE_FITNESS + "\n" + lApplications.TYPE_GARDEN + "\n" +
lApplications.OTHER + "\n" + lApplications.TYPE_PLAY_AREA + "\n" +
lApplications.TYPE_REST_AREA;
applicationDTO.Type = type;
string address = lApplications.C_POSTCODE_SEARCH__ADDRESS_NAME + "\n" + lApplications.C_POSTCODE_SEARCH__LINE1 + "\n" +
lApplications.C_POSTCODE_SEARCH__LINE2 + "\n" + lApplications.C_POSTCODE_SEARCH__LINE3 + "\n" +
lApplications.C_POSTCODE_SEARCH__POSTCODE;
applicationDTO.Address = address;
string parkletAddress = lApplications.PARKLET__ADDRESS_NAME + "\n" + lApplications.PARKLET__LINE1 + "\n" + lApplications.PARKLET__LINE2 + "\n" +
lApplications.PARKLET__LINE3 + "\n" + lApplications.PARKLET__POSTCODE;
applicationDTO.ParkletAddress = parkletAddress;
lParkletApplicationDtos.Add(applicationDTO);
}
}
