public ExtraValue(OrgMemberExtra v, ExtraValueModel model)
{
Type = v.Type;
Field = v.Field;
StrValue = v.StrValue;
DateValue = v.DateValue;
Data = v.Data;
IntValue = v.IntValue;
BitValue = v.BitValue;
Id = v.OrganizationId;
Id2 = v.PeopleId;
Model = model;
}
public static OrgMemberExtra GetExtraValue(CMSDataContext db, int oid, int pid, string field)
{
//field = field.Replace('/', '-');
var q = from v in db.OrgMemberExtras
where v.Field == field
where v.OrganizationId == oid
where v.PeopleId == pid
select v;
var ev = q.SingleOrDefault();
if (ev == null)
{
ev = new OrgMemberExtra()
{
OrganizationId = oid,
PeopleId = pid,
Field = field,
TransactionTime = DateTime.Now
};
db.OrgMemberExtras.InsertOnSubmit(ev);
}
return ev;
}
public OrgMemberExtra GetExtraValue(string field)
{
var ev = OrgMemberExtras.AsEnumerable().FirstOrDefault(ee => ee.Field.Equal(field));
if (ev == null)
{
ev = new OrgMemberExtra()
{
OrganizationId = OrganizationId,
PeopleId = PeopleId,
Field = field,
};
OrgMemberExtras.Add(ev);
}
return ev;
}
public void AddEditExtra(CMSDataContext db, string field, string value, bool multiline = false)
{
var omev = db.OrgMemberExtras.SingleOrDefault(oe => oe.OrganizationId == OrganizationId && oe.PeopleId == PeopleId && oe.Field == field);
if (omev == null)
{
omev = new OrgMemberExtra()
{
OrganizationId = OrganizationId,
PeopleId = PeopleId,
Field = field,
};
db.OrgMemberExtras.InsertOnSubmit(omev);
}
omev.Data = value;
omev.DataType = multiline ? "text" : null;
}
private void detach_OrgMemberExtras(OrgMemberExtra entity)
{
this.SendPropertyChanging();
entity.Person = null;
}
private void attach_OrgMemberExtras(OrgMemberExtra entity)
{
this.SendPropertyChanging();
entity.Organization = this;
}
