public static DTO.Reset Request(InputModels.ResetInfo model)
{
const string sql = "SELECT * FROM account.reset_account(@0::text, @1::text, @2::text);";
return
Factory.Get<DTO.Reset>(AppUsers.GetCatalog(), sql, model.Email, model.Browser, model.IpAddress)
.FirstOrDefault();
}
private void recursiveCreateAttributeModels(Attribute attribute, IDEAAttributeGroupModel parentGroupModel)
{
var fieldAttributeModel = new IDEAFieldAttributeModel(attribute.RawName, attribute.DisplayName, attribute.Index,
InputDataTypeConstants.FromDataType(attribute.DataType),
InputDataTypeConstants.FromDataType(attribute.DataType) == InputDataTypeConstants.NVARCHAR ? "enum" : "numeric", attribute.VisualizationHints);
fieldAttributeModel.OriginModel = this;
if (parentGroupModel != null)
{
parentGroupModel.InputModels.Add(fieldAttributeModel);
}
else
{
InputModels.Add(fieldAttributeModel);
}
}
private void recursiveCreateAttributeModels(AttributeGroup attributeGroup, IDEAAttributeGroupModel parentGroupModel)
{
var groupModel = new IDEAAttributeGroupModel(attributeGroup.Name, attributeGroup.Name);
groupModel.OriginModel = this;
if (parentGroupModel != null)
{
parentGroupModel.InputModels.Add(groupModel);
}
else
{
InputModels.Add(groupModel);
}
foreach (var childGroup in attributeGroup.AttributeGroups)
{
recursiveCreateAttributeModels(childGroup, groupModel);
}
foreach (var childAttribute in attributeGroup.Attributes)
{
recursiveCreateAttributeModels(childAttribute, groupModel);
}
}
public object add(InputModels.ProductInputModel p)
{
using (LangDataContext dc = new LangDataContext())
{
product prod = new product();
prod.text_title = new text();
prod.text_subtitle = new text();
prod.text_description = new text();
prod.text_text = new text();
foreach (InputModels.ProductInputModel.Product inProd in p.request)
{
texts_value titleval = new texts_value();
titleval.culture = inProd.lang;
titleval.value = inProd.data.Title;
titleval.text = prod.text_title;
titleval.seo_value = this._app.makeAlias(inProd.data.Title);
texts_value subtitleval = new texts_value();
subtitleval.culture = inProd.lang;
subtitleval.value = inProd.data.Subtitle;
subtitleval.text = prod.text_subtitle;
texts_value descval = new texts_value();
descval.culture = inProd.lang;
descval.value = inProd.data.Shortdesc;
descval.text = prod.text_description;
texts_value textval = new texts_value();
textval.culture = inProd.lang;
textval.value = inProd.data.Content;
textval.text = prod.text_text;
}
if (p.docGroups != null)
{
foreach (InputModels.DocGroupInputModel dg in p.docGroups)
{
if (dg.Id == null) continue;
docgroups_product dgp = new docgroups_product();
dgp.docgroup_id = (long)dg.Id;
dgp.product = prod;
}
}
foreach (long cat in p.Categories)
{
products_category pc = new products_category();
pc.product = prod;
pc.category_id = cat;
}
foreach (long conn in p.Connections)
{
products_connection prodConn = new products_connection();
prodConn.product = prod;
prodConn.product_id_2 = conn;
}
prod.image_id = p.mainImage;
dc.products.InsertOnSubmit(prod);
dc.SubmitChanges();
return new { Id = prod.id };
}
}
public object edit(InputModels.ProductInputModel p)
{
try
{
using (LangDataContext dc = new LangDataContext())
{
var prod = dc.products.Single(x => x.id == p.prodId);
foreach (string lang in Helpers.LangHelper.langs)
{
prod.text_title.texts_values.Single(x => x.culture == lang).value = p.request.Single(x => x.lang == lang).data.Title;
prod.text_subtitle.texts_values.Single(x => x.culture == lang).value = p.request.Single(x => x.lang == lang).data.Subtitle;
prod.text_description.texts_values.Single(x => x.culture == lang).value = p.request.Single(x => x.lang == lang).data.Shortdesc;
prod.text_text.texts_values.Single(x => x.culture == lang).value = p.request.Single(x => x.lang == lang).data.Content;
}
if (p.docGroups != null)
{
foreach (docgroups_product dgp in prod.docgroups_products.Where(x => p.docGroups.Where(u => u.Id == x.docgroup_id).Count() == 0))
{
prod.docgroups_products.Remove(dgp);
}
foreach (InputModels.DocGroupInputModel dg in p.docGroups)
{
if (dg.Id == null || prod.docgroups_products.Where(x => x.docgroup_id == dg.Id).Count() > 0) continue;
docgroups_product dgp = new docgroups_product();
dgp.docgroup_id = (long)dg.Id;
dgp.product = prod;
}
}
foreach (products_connection pdc in prod.products_connections.Where(x => !p.Connections.Contains(x.product_id)))
{
prod.products_connections.Remove(pdc);
}
foreach (long conn in p.Connections)
{
if (prod.products_connections.Select(x => x.product_id_2).Contains(conn)) continue;
products_connection prodConn = new products_connection();
prodConn.product = prod;
prodConn.product_id_2 = conn;
}
prod.image_id = p.mainImage;
dc.products.InsertOnSubmit(prod);
dc.SubmitChanges();
return new { result = true };
}
}
catch (Exception e)
{
return new { result = false, errMsg = e.Message };
}
}
