public DocType GetDocType(string typename, bool typeadd = false)
{
DocType dtype = null;
using (SystemMapEntities db = new SystemMapEntities())
{
dtype = db.doc_type
.Where(dt => dt.typename == typename)
.Select(dt => new DocType
{
typeId = dt.doctypeid,
name = dt.typename,
description = dt.descr,
iconUrl = dt.iconurl
})
.SingleOrDefault();
if (dtype == null && typeadd && !String.IsNullOrEmpty(typename) && !String.IsNullOrWhiteSpace(typename))
{
doc_type natype = new doc_type {
typename = typename
};
db.doc_type.Add(natype);
db.SaveChanges();
dtype = new DocType {
typeId = natype.doctypeid, name = typename
};
}
}
return(dtype);
}
public void UpdateDocType(DocType udata)
{
using (SystemMapEntities db = new SystemMapEntities())
{
doc_type utype = db.doc_type
.Where(dt => dt.doctypeid == udata.typeId)
.SingleOrDefault();
if (utype != null)
{
utype.typename = udata.name;
utype.descr = udata.description;
utype.iconurl = udata.iconUrl;
db.SaveChanges();
}
}
}
public DocType AddDocType(DocType dtype)
{
DocType typeval = null;
using (SystemMapEntities db = new SystemMapEntities())
{
//check that we don't already have this name
int ecount = db.doc_type.Where(n => n.typename == dtype.name).Count();
if (ecount == 0)
{
//Go ahead and add it
doc_type addtype = new doc_type {
typename = dtype.name, descr = dtype.description, iconurl = dtype.iconUrl
};
db.doc_type.Add(addtype);
db.SaveChanges();
typeval = new DocType {
typeId = addtype.doctypeid, name = addtype.typename, description = addtype.descr, iconUrl = addtype.iconurl
};
}
else
{
typeval = db.doc_type
.Where(n => n.typename == dtype.name)
.Select(n => new DocType
{
typeId = n.doctypeid,
name = n.typename,
description = n.descr,
iconUrl = n.iconurl
})
.FirstOrDefault();
}
}
return(typeval);
}
