/// <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 />";
}
}
