public static void SetDataDescription(int userID, DateTime date, string desc)
{
CompareCondition <DateTime> cond = new CompareCondition <DateTime>(
DataObject.Schema.Date, new ValueCondition <DateTime>(date), COMPARE_KIND.EQUAL);
var user = ServerModel.DB.Load <TblUsers>(userID);
var notesIds = ServerModel.DB.LookupIds <TblUserNotes>(user, cond);
var notes = ServerModel.DB.Load <TblUserNotes>(notesIds);
if (notes.Count == 0)
{
TblUserNotes note = new TblUserNotes()
{
Date = date,
Description = desc,
SysState = 0,
UserRef = userID
}
;
ServerModel.DB.Insert(note);
}
else
{
TblUserNotes note = notes[0];
note.Description = desc;
ServerModel.DB.Update(note);
}
}
public static void SetDataDescription(int userID, DateTime date, string desc)
{
CompareCondition<DateTime> cond = new CompareCondition<DateTime>(
DataObject.Schema.Date, new ValueCondition<DateTime>(date), COMPARE_KIND.EQUAL);
var user = ServerModel.DB.Load<TblUsers>(userID);
var notesIds = ServerModel.DB.LookupIds<TblUserNotes>(user, cond);
var notes = ServerModel.DB.Load<TblUserNotes>(notesIds);
if (notes.Count == 0)
{
TblUserNotes note = new TblUserNotes()
{
Date = date,
Description = desc,
SysState = 0,
UserRef = userID
}
;
ServerModel.DB.Insert(note);
}
else
{
TblUserNotes note = notes[0];
note.Description = desc;
ServerModel.DB.Update(note);
}
}