public static void NewExtra(int id, string field, string type, string value)
{
//field = field.Replace('/', '-');
var v = new PeopleExtra {
PeopleId = id, Field = field
};
DbUtil.Db.PeopleExtras.InsertOnSubmit(v);
switch (type)
{
case "string":
v.StrValue = value;
break;
case "text":
v.Data = value;
break;
case "date":
DateTime dt;
DateTime.TryParse(value, out dt);
v.DateValue = dt;
break;
case "int":
v.IntValue = value.ToInt();
break;
}
DbUtil.Db.SubmitChanges();
}
public ActionResult Update(PeopleExtra ev)
{
var m = DbUtil.Db.PeopleExtras.Single(vv => vv.Field == ev.Field && vv.PeopleId == ev.PeopleId);
m.Data = ev.Data;
DbUtil.Db.SubmitChanges();
DbUtil.LogActivity("Updated Attributes", peopleid: m.PeopleId);
return(Redirect($"/Person/Attributes/{ev.Field}/{ev.PeopleId}"));
}
public string ResolvePayerKey(int PeopleId)
{
PeopleExtra pe = _db.PeopleExtras.Where(c => c.PeopleId == PeopleId && c.Field == "PushPayKey").FirstOrDefault();
if (pe == null)
{
return(null);
}
return(pe.StrValue);
}
public string AddEditExtraValue(int peopleid, string field, string value, string type = "data")
{
try
{
var q = from v in Db.PeopleExtras
where v.Field == field
where v.PeopleId == peopleid
select v;
var ev = q.SingleOrDefault();
if (ev == null)
{
ev = new PeopleExtra
{
PeopleId = peopleid,
Field = field,
TransactionTime = DateTime.Now
};
Db.PeopleExtras.InsertOnSubmit(ev);
}
else
{
// prepare for new data type
ev.Data = null;
ev.IntValue = null;
ev.DateValue = null;
ev.StrValue = null;
}
switch (type)
{
case "code":
ev.StrValue = value;
break;
case "data":
ev.Data = value;
break;
case "date":
ev.DateValue = value.ToDate();
break;
case "int":
ev.IntValue = value.ToInt2();
break;
}
Db.SubmitChanges();
return("ok");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public ExtraValue(PeopleExtra 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.PeopleId;
Model = model;
}
public AttributesModel(CMSDataContext db, string field, int pid)
{
this.db = db;
var i = (from ev in db.PeopleExtras
where ev.PeopleId == pid
where ev.Field == field
select new
{
ev,
ev.Person.Name
}).Single();
Name = i.Name;
ev = i.ev;
}
private static PeopleExtra GetExtraValue(int id, string field)
{
var q = from v in DbUtil.Db.PeopleExtras
where v.Field == field
where v.PeopleId == id
select v;
var ev = q.SingleOrDefault();
if (ev == null)
{
ev = new PeopleExtra
{
PeopleId = id,
Field = field,
TransactionTime = DateTime.Now
};
DbUtil.Db.PeopleExtras.InsertOnSubmit(ev);
}
return(ev);
}
internal static Field AddField(Field f, PeopleExtra v)
{
if (f == null)
{
f = new Field
{
name = v.Field,
nonstandard = true,
peopleid = v.PeopleId,
extravalue = v,
};
f.type = v.StrValue.HasValue() ? "Code"
: v.Data.HasValue() ? "Data"
: v.DateValue.HasValue ? "Date"
: v.IntValue.HasValue ? "Int"
: v.BitValue.HasValue ? "Bit"
: "Code";
}
f.extravalue = v;
return(f);
}
public ActionResult NewExtraValue(int id, string field, string type, string value)
{
var v = new PeopleExtra {
PeopleId = id, Field = field
};
DbUtil.Db.PeopleExtras.InsertOnSubmit(v);
switch (type)
{
case "string":
v.StrValue = value;
break;
case "text":
v.Data = value;
break;
case "date":
var dt = DateTime.MinValue;
DateTime.TryParse(value, out dt);
v.DateValue = dt;
break;
case "int":
v.IntValue = value.ToInt();
break;
}
try
{
DbUtil.Db.SubmitChanges();
}
catch (Exception ex)
{
return(Content("error: " + ex.Message));
}
return(Content("ok"));
}
public string AddEditExtraValue(int peopleid, string field, string value, string type = "data")
{
try
{
var q = from v in Db.PeopleExtras
where v.Field == field
where v.PeopleId == peopleid
select v;
var ev = q.SingleOrDefault();
if (ev == null)
{
ev = new PeopleExtra
{
PeopleId = peopleid,
Field = field,
TransactionTime = DateTime.Now
};
Db.PeopleExtras.InsertOnSubmit(ev);
}
else
{
// prepare for new data type
ev.Data = null;
ev.IntValue = null;
ev.DateValue = null;
ev.StrValue = null;
}
switch (type)
{
case "code":
ev.StrValue = value;
break;
case "data":
ev.Data = value;
break;
case "date":
ev.DateValue = value.ToDate();
break;
case "int":
ev.IntValue = value.ToInt2();
break;
}
Db.SubmitChanges();
return "ok";
}
catch (Exception ex)
{
return ex.Message;
}
}
