public static Common.Models.Contacts.Contact Edit(
Common.Models.Contacts.Contact model,
Common.Models.Account.Users modifier,
IDbConnection conn = null,
bool closeConnection = true)
{
model.ModifiedBy = modifier;
model.Modified = DateTime.UtcNow;
DBOs.Contacts.Contact dbo = Mapper.Map <DBOs.Contacts.Contact>(model);
conn = DataHelper.OpenIfNeeded(conn);
conn.Execute("UPDATE \"contact\" SET \"utc_modified\"=@UtcModified, \"modified_by_user_pid\"=@ModifiedByUserPId, " +
"\"referred_by_name\"=@ReferredByName, \"gender\"=@Gender, \"business_home_page\"=@BusinessHomePage, " +
"\"personal_home_page\"=@PersonalHomePage, \"instant_messaging_address\"=@InstantMessagingAddress, " +
"\"language\"=@Language, \"spouse_name\"=@SpouseName, \"profession\"=@Profession, \"assistant_name\"=@AssistantName, " +
"\"manager_name\"=@ManagerName, \"office_location\"=@OfficeLocation, " +
"\"department_name\"=@DepartmentName, \"company_name\"=@CompanyName, \"bar_number\"=@BarNumber, \"title\"=@Title, \"wedding\"=@Wedding, " +
"\"birthday\"=@Birthday, \"telephone10_telephone_number\"=@Telephone10TelephoneNumber, \"telephone10_display_name\"=@Telephone10DisplayName, " +
"\"telephone9_telephone_number\"=@Telephone9TelephoneNumber, \"telephone9_display_name\"=@Telephone9DisplayName, \"telephone8_telephone_number\"=@Telephone8TelephoneNumber, " +
"\"telephone8_display_name\"=@Telephone8DisplayName, \"telephone7_telephone_number\"=@Telephone7TelephoneNumber, \"telephone7_display_name\"=@Telephone7DisplayName, " +
"\"telephone6_telephone_number\"=@Telephone6TelephoneNumber, \"telephone6_display_name\"=@Telephone6DisplayName, \"telephone5_telephone_number\"=@Telephone5TelephoneNumber, " +
"\"telephone5_display_name\"=@Telephone5DisplayName, \"telephone4_telephone_number\"=@Telephone4TelephoneNumber, \"telephone4_display_name\"=@Telephone4DisplayName, " +
"\"telephone3_telephone_number\"=@Telephone3TelephoneNumber, \"telephone3_display_name\"=@Telephone3DisplayName, \"telephone2_telephone_number\"=@Telephone2TelephoneNumber, " +
"\"telephone2_display_name\"=@Telephone2DisplayName, \"telephone1_telephone_number\"=@Telephone1TelephoneNumber, \"telephone1_display_name\"=@Telephone1DisplayName, " +
"\"address3_address_post_office_box\"=@Address3AddressPostOfficeBox, \"address3_address_country_code\"=@Address3AddressCountryCode, \"address3_address_country\"=@Address3AddressCountry, " +
"\"address3_address_postal_code\"=@Address3AddressPostalCode, \"address3_address_state_or_province\"=@Address3AddressStateOrProvince, \"address3_address_city\"=@Address3AddressCity, \"address3_address_line2\"=@Address3AddressLine2, " +
"\"address3_address_street\"=@Address3AddressStreet, \"address3_display_name\"=@Address3DisplayName, \"address2_address_post_office_box\"=@Address2AddressPostOfficeBox, " +
"\"address2_address_country_code\"=@Address2AddressCountryCode, \"address2_address_country\"=@Address2AddressCountry, \"address2_address_postal_code\"=@Address2AddressPostalCode, " +
"\"address2_address_state_or_province\"=@Address2AddressStateOrProvince, \"address2_address_city\"=@Address2AddressCity, \"address2_address_line2\"=@Address2AddressLine2, \"address2_address_street\"=@Address2AddressStreet, " +
"\"address2_display_name\"=@Address2DisplayName, \"address1_address_post_office_box\"=@Address1AddressPostOfficeBox, \"address1_address_country_code\"=@Address1AddressCountryCode, " +
"\"address1_address_country\"=@Address1AddressCountry, \"address1_address_postal_code\"=@Address1AddressPostalCode, \"address1_address_state_or_province\"=@Address1AddressStateOrProvince, " +
"\"address1_address_city\"=@Address1AddressCity, \"address1_address_line2\"=@Address1AddressLine2, \"address1_address_street\"=@Address1AddressStreet, \"address1_display_name\"=@Address1DisplayName, " +
"\"fax3_fax_number\"=@Fax3FaxNumber, \"fax3_display_name\"=@Fax3DisplayName, \"fax2_fax_number\"=@Fax2FaxNumber, " +
"\"fax2_display_name\"=@Fax2DisplayName, \"fax1_fax_number\"=@Fax1FaxNumber, \"fax1_display_name\"=@Fax1DisplayName, " +
"\"email3_email_address\"=@Email3EmailAddress, \"email3_display_name\"=@Email3DisplayName, \"email2_email_address\"=@Email2EmailAddress, " +
"\"email2_display_name\"=@Email2DisplayName, \"email1_email_address\"=@Email1EmailAddress, \"email1_display_name\"=@Email1DisplayName, " +
"\"display_name\"=@DisplayName, \"initials\"=@Initials, \"given_name\"=@GivenName, \"middle_name\"=@MiddleName, \"surname\"=@Surname, " +
"\"display_name_prefix\"=@DisplayNamePrefix, \"generation\"=@Generation, \"nickname\"=@Nickname, \"is_organization\"=@IsOrganization, \"is_our_employee\"=@IsOurEmployee, " +
"\"billing_rate_id\"=@BillingRateId " +
"WHERE \"id\"=@Id", dbo);
DataHelper.Close(conn, closeConnection);
return(model);
}
public static Common.Models.Contacts.Contact Create(Common.Models.Contacts.Contact model,
Common.Models.Account.Users creator)
{
model.CreatedBy = model.ModifiedBy = creator;
model.Created = model.Modified = DateTime.UtcNow;
DBOs.Contacts.Contact dbo = Mapper.Map <DBOs.Contacts.Contact>(model);
using (IDbConnection conn = Database.Instance.GetConnection())
{
model.Id = dbo.Id = conn.Execute("INSERT INTO \"contact\" (" +
"\"referred_by_name\", \"gender\", \"business_home_page\", \"personal_home_page\", " +
"\"instant_messaging_address\", \"language\", \"spouse_name\", " +
"\"profession\", \"assistant_name\", \"manager_name\", \"office_location\", " +
"\"department_name\", \"company_name\", \"title\", \"wedding\", " +
"\"birthday\", \"telephone10_telephone_number\", \"telephone10_display_name\", " +
"\"telephone9_telephone_number\", \"telephone9_display_name\", \"telephone8_telephone_number\", " +
"\"telephone8_display_name\", \"telephone7_telephone_number\", \"telephone7_display_name\", " +
"\"telephone6_telephone_number\", \"telephone6_display_name\", \"telephone5_telephone_number\", " +
"\"telephone5_display_name\", \"telephone4_telephone_number\", \"telephone4_display_name\", " +
"\"telephone3_telephone_number\", \"telephone3_display_name\", \"telephone2_telephone_number\", " +
"\"telephone2_display_name\", \"telephone1_telephone_number\", \"telephone1_display_name\", " +
"\"address3_address_post_office_box\", \"address3_address_country_code\", \"address3_address_country\", " +
"\"address3_address_postal_code\", \"address3_address_state_or_province\", \"address3_address_city\", " +
"\"address3_address_street\", \"address3_display_name\", \"address2_address_post_office_box\", " +
"\"address2_address_country_code\", \"address2_address_country\", \"address2_address_postal_code\", " +
"\"address2_address_state_or_province\", \"address2_address_city\", \"address2_address_street\", " +
"\"address2_display_name\", \"address1_address_post_office_box\", \"address1_address_country_code\", " +
"\"address1_address_country\", \"address1_address_postal_code\", \"address1_address_state_or_province\", " +
"\"address1_address_city\", \"address1_address_street\", \"address1_display_name\", " +
"\"fax3_fax_number\", \"fax3_display_name\", \"fax2_fax_number\", " +
"\"fax2_display_name\", \"fax1_fax_number\", \"fax1_display_name\", " +
"\"email3_email_address\", \"email3_display_name\", \"email2_email_address\", " +
"\"email2_display_name\", \"email1_email_address\", \"email1_display_name\", " +
"\"display_name\", \"initials\", \"given_name\", \"middle_name\", \"surname\", " +
"\"display_name_prefix\", \"generation\", \"nickname\", \"is_organization\", \"is_our_employee\", " +
"\"billing_rate_id\", " +
"\"utc_created\", \"utc_modified\", \"created_by_user_pid\", \"modified_by_user_pid\") VALUES (" +
"@ReferredByName, @Gender, @BusinessHomePage, " +
"@PersonalHomePage, @InstantMessagingAddress, @Language, @SpouseName, @Profession, " +
"@AssistantName, @ManagerName, @OfficeLocation, @DepartmentName, @CompanyName, " +
"@Title, @Wedding, @Birthday, @Telephone10TelephoneNumber, @Telephone10DisplayName, " +
"@Telephone9TelephoneNumber, @Telephone9DisplayName, @Telephone8TelephoneNumber, " +
"@Telephone8DisplayName, @Telephone7TelephoneNumber, @Telephone7DisplayName, " +
"@Telephone6TelephoneNumber, @Telephone6DisplayName, @Telephone5TelephoneNumber, " +
"@Telephone5DisplayName, @Telephone4TelephoneNumber, @Telephone4DisplayName, " +
"@Telephone3TelephoneNumber, @Telephone3DisplayName, @Telephone2TelephoneNumber, " +
"@Telephone2DisplayName, @Telephone1TelephoneNumber, @Telephone1DisplayName, " +
"@Address3AddressPostOfficeBox, @Address3AddressCountryCode, @Address3AddressCountry, " +
"@Address3AddressPostalCode, @Address3AddressStateOrProvince, @Address3AddressCity, " +
"@Address3AddressStreet, @Address3DisplayName, @Address2AddressPostOfficeBox, " +
"@Address2AddressCountryCode, @Address2AddressCountry, @Address2AddressPostalCode, " +
"@Address2AddressStateOrProvince, @Address2AddressCity, @Address2AddressStreet, " +
"@Address2DisplayName, @Address1AddressPostOfficeBox, @Address1AddressCountryCode, " +
"@Address1AddressCountry, @Address1AddressPostalCode, @Address1AddressStateOrProvince, " +
"@Address1AddressCity, @Address1AddressStreet, @Address1DisplayName, " +
"@Fax3FaxNumber, @Fax3DisplayName, @Fax2FaxNumber, @Fax2DisplayName, @Fax1FaxNumber, " +
"@Fax1DisplayName, @Email3EmailAddress, @Email3DisplayName, @Email2EmailAddress, @Email2DisplayName, " +
"@Email1EmailAddress, @Email1DisplayName, @DisplayName, @Initials, @GivenName, " +
"@MiddleName, @Surname, @DisplayNamePrefix, @Generation, @Nickname, @IsOrganization, @IsOurEmployee, " +
"@BillingRateId, " +
"@UtcCreated, @UtcModified, @CreatedByUserPId, @ModifiedByUserPId)", dbo);
model.Id = conn.Query <DBOs.Contacts.Contact>("SELECT currval(pg_get_serial_sequence('contact', 'id')) AS \"id\"").Single().Id;
}
return(model);
}
