public virtual ProductCustomerLevel UpdateProductCustomerLevel(ProductCustomerLevel entity) { if (entity.IsTransient()) { return(entity); } ProductCustomerLevel other = GetProductCustomerLevel(entity.ProductId); if (entity.Equals(other)) { return(entity); } string sql = @"Update ProductCustomerLevel set [CustomerLevelID]=@CustomerLevelID , [DisplayOrder]=@DisplayOrder , [CreatedOn]=@CreatedOn where ProductID=@ProductID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ProductID", entity.ProductId) , new SqlParameter("@CustomerLevelID", entity.CustomerLevelId) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetProductCustomerLevel(entity.ProductId)); }