/// <summary> /// Adds the specified site columns. /// </summary> /// <param name="siteColumns">The site columns.</param> /// <returns></returns> public tbl_SiteColumns Add(tbl_SiteColumns siteColumns) { if (siteColumns.ID == Guid.Empty) { siteColumns.ID = Guid.NewGuid(); } _dataContext.tbl_SiteColumns.AddObject(siteColumns); _dataContext.SaveChanges(); return(siteColumns); }
/// <summary> /// Updates the specified site column. /// </summary> /// <param name="siteColumn">The site column.</param> public void Update(tbl_SiteColumns siteColumn) { var updateSiteColumn = SelectById(siteColumn.SiteID, siteColumn.ID); updateSiteColumn.SiteID = siteColumn.SiteID; updateSiteColumn.SiteActivityRuleID = siteColumn.SiteActivityRuleID; updateSiteColumn.Name = siteColumn.Name; updateSiteColumn.CategoryID = siteColumn.CategoryID; updateSiteColumn.TypeID = siteColumn.TypeID; updateSiteColumn.Code = siteColumn.Code; _dataContext.SaveChanges(); }
/// <summary> /// Adds the column. /// </summary> /// <param name="name">The name.</param> /// <param name="categoryId">The category id.</param> /// <param name="typeId">The type id.</param> /// <param name="code">The code.</param> /// <param name="siteActivityRuleId">The site activity rule id.</param> /// <returns></returns> public tbl_SiteColumns AddColumn(string name, Guid categoryId, int typeId, string code, Guid?siteActivityRuleId = null) { var siteColumn = new tbl_SiteColumns { ID = Guid.NewGuid(), SiteID = _siteId, Name = name, CategoryID = categoryId, Code = code }; if (siteActivityRuleId.HasValue) { siteColumn.SiteActivityRuleID = siteActivityRuleId; } _dataContext.tbl_SiteColumns.AddObject(siteColumn); _dataContext.SaveChanges(); return(siteColumn); }
/// <summary> /// Handles the Click event of the btnSave control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnSave_Click(object sender, EventArgs e) { var siteColumns = new tbl_SiteColumns(); var checkCode = DataManager.SiteColumns.SelectByCode(SiteId, txtCode.Text); if (_siteColumnId != Guid.Empty) { siteColumns = DataManager.SiteColumns.SelectById(SiteId, _siteColumnId); if (checkCode != null && checkCode.ID == _siteColumnId) { checkCode = null; } } ErrorMessage.Text = ""; if (checkCode == null) { siteColumns.SiteID = SiteId; siteColumns.CategoryID = Guid.Parse(ddlCategoryID.SelectedValue); siteColumns.TypeID = int.Parse(ddTypeID.SelectedValue); siteColumns.Name = txtName.Text; siteColumns.Code = txtCode.Text; if (_siteColumnId != Guid.Empty) { DataManager.SiteColumns.Update(siteColumns); } else { siteColumns = DataManager.SiteColumns.Add(siteColumns); _siteColumnId = siteColumns.ID; } if ((ColumnType)siteColumns.TypeID != ColumnType.Enum) { var siteColumnValues = DataManager.SiteColumnValues.SelectAll(_siteColumnId); foreach (var item in siteColumnValues) { try { DataManager.SiteColumnValues.Delete(item); } catch { } } } else { var siteColumnValues = new List <tbl_SiteColumnValues>(); if (ViewState["SiteColumnValues"] != null) { var siteColumnValuesOld = DataManager.SiteColumnValues.SelectAll(_siteColumnId); siteColumnValues = (List <tbl_SiteColumnValues>)ViewState["SiteColumnValues"]; foreach (var siteColumnValue in siteColumnValues) { siteColumnValue.SiteColumnID = _siteColumnId; var removeItemsiteColumnValue = siteColumnValuesOld.SingleOrDefault(a => a.ID == siteColumnValue.ID); if (removeItemsiteColumnValue != null) { DataManager.SiteColumnValues.Update(siteColumnValue); siteColumnValuesOld.Remove(removeItemsiteColumnValue); } else { DataManager.SiteColumnValues.Add(siteColumnValue); } } if (siteColumnValuesOld != null && siteColumnValuesOld.Count > 0) { foreach (var item in siteColumnValuesOld) { try { DataManager.SiteColumnValues.Delete(item); } catch { } } } } } Response.Redirect(UrlsData.AP_SiteColumns()); } else { ErrorMessage.Text = "Реквизит с таким кодом уже существует.<br /><br />"; } }