public static Company Update(Company company) { if (company.BrandListLoaded) { JoinableList jList = new JoinableList(); company.BrandList.ForEach(b => jList.Add(b.Name)); company.Brands = jList.ToString(); } CompanyMapper.Instance.Update(company); if (company.BrandListLoaded) { CompanyBrandMapper.Instance.DeleteBrands(company.CompanyId); foreach (Brand brand in company.BrandList) { CompanyBrand cb = CompanyBrand.New(); cb.CompanyId = company.CompanyId.GetValueOrDefault(); cb.BrandId = brand.BrandId.GetValueOrDefault(); CompanyBrand.Update(cb); } } return(company); }
protected override object ReadRow(IRowReader reader) { CompanyBrand companyBrand = CompanyBrand.New(); // Table Fields companyBrand.CompanyBrandId = reader.GetInt32("CompanyBrandId"); companyBrand.CompanyId = reader.GetInt32("CompanyId"); companyBrand.BrandId = reader.GetInt32("BrandId"); companyBrand.IsDirty = false; companyBrand.ChangedProperties.Clear(); return(companyBrand); }
public virtual CompanyBrand Update(CompanyBrand companyBrand) { if (!companyBrand.IsDirty || companyBrand.IsNull) { // Nothing to do - no point hammering the database unnecessarily return(companyBrand); } IDbCommand command = CreateCommand(); if (companyBrand.IsNew) { // Adding command.CommandText = "INSERT INTO [CompanyBrand] ([CompanyId], [BrandId]) VALUES (@companyId, @brandId) ; SELECT @@identity AS NewId;"; } else { // Updating command.CommandText = "UPDATE [CompanyBrand] SET [CompanyId] = @companyId, [BrandId] = @brandId WHERE CompanyBrandId = @companyBrandId"; } command.Parameters.Add(CreateParameter("@companyId", companyBrand.CompanyId)); command.Parameters.Add(CreateParameter("@brandId", companyBrand.BrandId)); if (companyBrand.IsNew) { companyBrand.CompanyBrandId = Convert.ToInt32(ExecScalar(command)); } else { command.Parameters.Add(CreateParameter("@companyBrandId", companyBrand.CompanyBrandId)); ExecuteCommand(command); } companyBrand.IsDirty = false; companyBrand.ChangedProperties.Clear(); return(companyBrand); }
public static CompanyBrand FindOne(CompanyBrandFinder finder) { CompanyBrand CompanyBrand = CompanyBrandMapper.Instance.FindOne(finder); return(CompanyBrand ?? Empty); }
public static CompanyBrand Update(CompanyBrand companyBrand) { return(CompanyBrandMapper.Instance.Update(companyBrand)); }
public static CompanyBrand Get(Nullable <Int32> CompanyBrandId) { CompanyBrand CompanyBrand = CompanyBrandMapper.Instance.Get(CompanyBrandId); return(CompanyBrand ?? Empty); }