public virtual Distributor UpdateDistributor(Distributor entity)
{
if (entity.IsTransient())
{
return(entity);
}
Distributor other = GetDistributor(entity.DistributorId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update Distributor set [DistributorGUID]=@DistributorGUID
, [Name]=@Name
, [SEName]=@SEName
, [SEKeywords]=@SEKeywords
, [SEDescription]=@SEDescription
, [SETitle]=@SETitle
, [SENoScript]=@SENoScript
, [SEAltText]=@SEAltText
, [Address1]=@Address1
, [Address2]=@Address2
, [Suite]=@Suite
, [City]=@City
, [State]=@State
, [ZipCode]=@ZipCode
, [Country]=@Country
, [Phone]=@Phone
, [FAX]=@FAX
, [URL]=@URL
, [Email]=@Email
, [Summary]=@Summary
, [Description]=@Description
, [Notes]=@Notes
, [QuantityDiscountID]=@QuantityDiscountID
, [SortByLooks]=@SortByLooks
, [XmlPackage]=@XmlPackage
, [ColWidth]=@ColWidth
, [DisplayOrder]=@DisplayOrder
, [ExtensionData]=@ExtensionData
, [ContentsBGColor]=@ContentsBGColor
, [PageBGColor]=@PageBGColor
, [GraphicsColor]=@GraphicsColor
, [NotificationXmlPackage]=@NotificationXmlPackage
, [ImageFilenameOverride]=@ImageFilenameOverride
, [ParentDistributorID]=@ParentDistributorID
, [Published]=@Published
, [Wholesale]=@Wholesale
, [IsImport]=@IsImport
, [Deleted]=@Deleted
, [CreatedOn]=@CreatedOn
, [PageSize]=@PageSize
, [TaxClassID]=@TaxClassID
, [SkinID]=@SkinID
, [TemplateName]=@TemplateName
where DistributorID=@DistributorID" ;
SqlParameter[] parameterArray = new SqlParameter[] {
new SqlParameter("@DistributorID", entity.DistributorId)
, new SqlParameter("@DistributorGUID", entity.DistributorGuid)
, new SqlParameter("@Name", entity.Name)
, new SqlParameter("@SEName", entity.SeName ?? (object)DBNull.Value)
, new SqlParameter("@SEKeywords", entity.SeKeywords ?? (object)DBNull.Value)
, new SqlParameter("@SEDescription", entity.SeDescription ?? (object)DBNull.Value)
, new SqlParameter("@SETitle", entity.SeTitle ?? (object)DBNull.Value)
, new SqlParameter("@SENoScript", entity.SeNoScript ?? (object)DBNull.Value)
, new SqlParameter("@SEAltText", entity.SeAltText ?? (object)DBNull.Value)
, new SqlParameter("@Address1", entity.Address1 ?? (object)DBNull.Value)
, new SqlParameter("@Address2", entity.Address2 ?? (object)DBNull.Value)
, new SqlParameter("@Suite", entity.Suite ?? (object)DBNull.Value)
, new SqlParameter("@City", entity.City ?? (object)DBNull.Value)
, new SqlParameter("@State", entity.State ?? (object)DBNull.Value)
, new SqlParameter("@ZipCode", entity.ZipCode ?? (object)DBNull.Value)
, new SqlParameter("@Country", entity.Country ?? (object)DBNull.Value)
, new SqlParameter("@Phone", entity.Phone ?? (object)DBNull.Value)
, new SqlParameter("@FAX", entity.Fax ?? (object)DBNull.Value)
, new SqlParameter("@URL", entity.Url ?? (object)DBNull.Value)
, new SqlParameter("@Email", entity.Email ?? (object)DBNull.Value)
, new SqlParameter("@Summary", entity.Summary ?? (object)DBNull.Value)
, new SqlParameter("@Description", entity.Description ?? (object)DBNull.Value)
, new SqlParameter("@Notes", entity.Notes ?? (object)DBNull.Value)
, new SqlParameter("@QuantityDiscountID", entity.QuantityDiscountId ?? (object)DBNull.Value)
, new SqlParameter("@SortByLooks", entity.SortByLooks)
, new SqlParameter("@XmlPackage", entity.XmlPackage ?? (object)DBNull.Value)
, new SqlParameter("@ColWidth", entity.ColWidth)
, new SqlParameter("@DisplayOrder", entity.DisplayOrder)
, new SqlParameter("@ExtensionData", entity.ExtensionData ?? (object)DBNull.Value)
, new SqlParameter("@ContentsBGColor", entity.ContentsBgColor ?? (object)DBNull.Value)
, new SqlParameter("@PageBGColor", entity.PageBgColor ?? (object)DBNull.Value)
, new SqlParameter("@GraphicsColor", entity.GraphicsColor ?? (object)DBNull.Value)
, new SqlParameter("@NotificationXmlPackage", entity.NotificationXmlPackage ?? (object)DBNull.Value)
, new SqlParameter("@ImageFilenameOverride", entity.ImageFilenameOverride ?? (object)DBNull.Value)
, new SqlParameter("@ParentDistributorID", entity.ParentDistributorId)
, new SqlParameter("@Published", entity.Published)
, new SqlParameter("@Wholesale", entity.Wholesale)
, new SqlParameter("@IsImport", entity.IsImport)
, new SqlParameter("@Deleted", entity.Deleted)
, new SqlParameter("@CreatedOn", entity.CreatedOn)
, new SqlParameter("@PageSize", entity.PageSize)
, new SqlParameter("@TaxClassID", entity.TaxClassId)
, new SqlParameter("@SkinID", entity.SkinId)
, new SqlParameter("@TemplateName", entity.TemplateName)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetDistributor(entity.DistributorId));
}