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); } }