protected override string GetQuery(BaseProcessingModel model) { var contact = (ContactProcessingModel)model; return(string.Format (@" do $$ begin if (select 1 from ""Contact"" where ""Id""='{2}') then UPDATE ""public"".""Contact"" SET ""Name"" = '{0}', ""Phone"" = '{1}', ""BrandId"" = '{3}' WHERE ""Id"" = '{2}'; ELSE INSERT INTO ""public"".""Contact"" (""Name"", ""Phone"", ""Id"", ""BrandId"") VALUES ('{0}', '{1}', '{2}', '{3}'); END IF; END $$ ", (contact.Name ?? "").Replace("'", "''"), (contact.Phone ?? "").Replace("'", "''"), contact.Id.ToString(), _defaultBrandId)); }
protected abstract string GetQuery(BaseProcessingModel model);
protected override string GetQuery(BaseProcessingModel model) { var contact = (ContactProcessingModel)model; return(string.Format (@" do $$ begin if (select 1 from ""Contact"" where ""Id""='{2}') then UPDATE ""public"".""Contact"" SET ""Name_FirstName"" = '{0}', ""Phone"" = '{1}', ""BrandId"" = '{3}', ""Name_Surname"" = '{4}', ""Name_MiddleName"" = '{5}', ""Email"" = '{6}', ""Gender"" = {7}, ""Address_Country"" = '{8}', ""Address_City"" = '{9}', ""Address_Address"" = '{10}', ""Birthday"" = {11}, ""RegistrationPlaceId"" = (SELECT ""Id"" FROM ""public"".""Shop"" WHERE ""Code"" = '{12}'), ""RegistrationDate"" = {13}, ""PhoneConfirmed"" = {14}, ""Code"" = '{15}' WHERE ""Id"" = '{2}'; ELSE INSERT INTO ""public"".""Contact"" ( ""Name_FirstName"", ""Phone"", ""Id"", ""BrandId"", ""Name_Surname"", ""Name_MiddleName"", ""Email"", ""Gender"", ""Address_Country"", ""Address_City"", ""Address_Address"", ""Birthday"", ""RegistrationPlaceId"", ""RegistrationDate"", ""PhoneConfirmed"", ""Code"" ) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', {7}, '{8}', '{9}', '{10}', {11}, (SELECT ""Id"" FROM ""public"".""Shop"" WHERE ""Code"" = '{12}'), {13}, {14}, '{15}'); END IF; END $$ ", (contact.FirstName ?? String.Empty).Replace("'", "''"), (contact.Phone ?? String.Empty).Replace("'", "''"), contact.Id.ToString(), _defaultBrandId, (contact.Surname ?? String.Empty).Replace("'", "''"), (contact.MiddleName ?? String.Empty).Replace("'", "''"), (contact.Email ?? String.Empty).Replace("'", "''"), contact.IsGenderNull ? "null" : (contact.Gender == "1" ? "0" : "1"), (contact.Country ?? String.Empty).Replace("'", "''"), (contact.City ?? String.Empty).Replace("'", "''"), (contact.Address ?? String.Empty).Replace("'", "''"), String.IsNullOrEmpty(contact.Birthday) ? "null" : String.Format("'{0}'", contact.Birthday.Replace("'", "''")), (contact.ShopCode ?? String.Empty).Replace("'", "''"), String.IsNullOrEmpty(contact.RegistrationDate) ? "null" : String.Format("'{0}'", contact.RegistrationDate.Replace("'", "''")), "false", contact.Code )); }