public void Save()
{
var dc = new RobotBehaviorsDataContext(SqlConnectionString);
if (this.Id == 0)
{
var robotBehaviorKeyphrase = new RobotBehaviorKeyphrase();
robotBehaviorKeyphrase.SynAppsId = this.SynAppsId;
robotBehaviorKeyphrase.SynAppsDeviceId = this.SynAppsDeviceId;
robotBehaviorKeyphrase.Keyphrase = this.Keyphrase;
robotBehaviorKeyphrase.KeyphraseReply = this.KeyphraseReply;
robotBehaviorKeyphrase.Status = this.Status;
robotBehaviorKeyphrase.IsSynAppsLinked = this.IsSynAppsLinked;
robotBehaviorKeyphrase.IsDeleted = this.IsDeleted;
robotBehaviorKeyphrase.CreatedAt = DateTime.Now;
dc.RobotBehaviorKeyphrases.InsertOnSubmit(robotBehaviorKeyphrase);
dc.SubmitChanges();
this.Id = robotBehaviorKeyphrase.Id;
this.CreatedAt = robotBehaviorKeyphrase.CreatedAt;
}
else
{
var records =
from n in dc.RobotBehaviorKeyphrases
where n.Id == this.Id
select n;
foreach (var r in records)
{
r.SynAppsId = this.SynAppsId;
r.SynAppsDeviceId = this.SynAppsDeviceId;
r.Keyphrase = this.Keyphrase;
r.KeyphraseReply = this.KeyphraseReply;
r.Status = this.Status;
r.IsSynAppsLinked = this.IsSynAppsLinked;
r.IsDeleted = this.IsDeleted;
r.UpdatedAt = DateTime.Now;
}
dc.SubmitChanges();
}
}
public void Save()
{
var dc = new RobotBehaviorsDataContext(SqlConnectionString);
if (this.Id == 0)
{
var robotBehaviorTalkLog = new RobotBehaviorTalkLog();
robotBehaviorTalkLog.DeviceId = this.DeviceId;
robotBehaviorTalkLog.PersonId = this.PersonId;
robotBehaviorTalkLog.RobotTalk = this.RobotTalk;
robotBehaviorTalkLog.PersonTalk = this.PersonTalk;
robotBehaviorTalkLog.PersonTalkKeyphrase = this.PersonTalkKeyphrase;
robotBehaviorTalkLog.Status = this.Status;
robotBehaviorTalkLog.IsDeleted = this.IsDeleted;
robotBehaviorTalkLog.CreatedAt = DateTime.Now;
dc.RobotBehaviorTalkLogs.InsertOnSubmit(robotBehaviorTalkLog);
dc.SubmitChanges();
this.Id = robotBehaviorTalkLog.Id;
this.CreatedAt = robotBehaviorTalkLog.CreatedAt;
}
else
{
var records =
from n in dc.RobotBehaviorTalkLogs
where n.Id == this.Id
select n;
foreach (var r in records)
{
r.PersonId = this.PersonId;
r.RobotTalk = this.RobotTalk;
r.PersonTalk = this.PersonTalk;
r.PersonTalkKeyphrase = this.PersonTalkKeyphrase;
r.Status = this.Status;
r.IsDeleted = this.IsDeleted;
r.UpdatedAt = DateTime.Now;
}
dc.SubmitChanges();
}
}
public void Save()
{
var dc = new RobotBehaviorsDataContext(SqlConnectionString);
if (this.Id == 0)
{
var robotBehaviorToPerson = new RobotBehaviorToPerson();
robotBehaviorToPerson.DeviceId = this.DeviceId;
robotBehaviorToPerson.PersonId = this.PersonId;
robotBehaviorToPerson.RobotBehaviorId = this.RobotBehaviorId;
robotBehaviorToPerson.Status = this.Status;
robotBehaviorToPerson.Weather = this.Weather;
robotBehaviorToPerson.IsDeleted = this.IsDeleted;
robotBehaviorToPerson.CreatedAt = DateTime.Now;
dc.RobotBehaviorToPersons.InsertOnSubmit(robotBehaviorToPerson);
dc.SubmitChanges();
this.Id = robotBehaviorToPerson.Id;
this.CreatedAt = robotBehaviorToPerson.CreatedAt;
}
else
{
var records =
from n in dc.RobotBehaviorToPersons
where n.Id == this.Id
select n;
foreach (var r in records)
{
r.PersonId = this.PersonId;
r.RobotBehaviorId = this.RobotBehaviorId;
r.Status = this.Status;
r.Weather = this.Weather;
r.IsDeleted = this.IsDeleted;
r.UpdatedAt = DateTime.Now;
}
dc.SubmitChanges();
}
}
public static void Refresh(string _synappsDeviceId, List <RobotBehaviorModel> list)
{
var dc = new RobotBehaviorsDataContext(SqlConnectionString);
var synAppsIds = (from l in list select l.SynAppsId).ToList <int>();
var forDelete =
from n in dc.RobotBehaviors
where n.SynAppsDeviceId == _synappsDeviceId
where n.IsSynAppsLinked == true
where !synAppsIds.Contains(n.SynAppsId)
select n;
Delete(forDelete);
var newBehaviors = new List <RobotBehavior>();
foreach (var l in list)
{
var behaviors =
from n in dc.RobotBehaviors
where n.SynAppsDeviceId == _synappsDeviceId
where n.IsSynAppsLinked == true
where n.SynAppsId == l.SynAppsId
select n;
if (behaviors.Count() > 0)
{
behaviors.First <RobotBehavior>().IsDeleted = false;
behaviors.First <RobotBehavior>().Status = l.Status;
behaviors.First <RobotBehavior>().ActionType = l.ActionType;
behaviors.First <RobotBehavior>().ActionBody = l.ActionBody;
behaviors.First <RobotBehavior>().UpdatedAt = DateTime.Now;
}
else
{
newBehaviors.Add(new RobotBehavior
{
SynAppsId = l.SynAppsId,
SynAppsDeviceId = l.SynAppsDeviceId,
Status = l.Status,
ActionType = l.ActionType,
ActionBody = l.ActionBody,
IsSynAppsLinked = l.IsSynAppsLinked,
IsDeleted = l.IsDeleted,
CreatedAt = DateTime.Now
});
}
}
dc.RobotBehaviors.InsertAllOnSubmit(newBehaviors);
dc.SubmitChanges();
}
public static void Refresh(string _synappsDeviceId, List <RobotBehaviorKeyphraseModel> list)
{
var dc = new RobotBehaviorsDataContext(SqlConnectionString);
var synAppsIds = (from l in list select l.SynAppsId).ToList <int>();
var forDelete =
from n in dc.RobotBehaviorKeyphrases
where n.SynAppsDeviceId == _synappsDeviceId
where n.IsSynAppsLinked == true
where !synAppsIds.Contains(n.SynAppsId)
select n;
Delete(forDelete);
var newKeyphrases = new List <RobotBehaviorKeyphrase>();
foreach (var l in list)
{
var keyphrases =
from n in dc.RobotBehaviorKeyphrases
where n.SynAppsDeviceId == _synappsDeviceId
where n.IsSynAppsLinked == true
where n.SynAppsId == l.SynAppsId
select n;
if (keyphrases.Count() > 0)
{
keyphrases.First <RobotBehaviorKeyphrase>().Keyphrase = l.Keyphrase;
keyphrases.First <RobotBehaviorKeyphrase>().KeyphraseReply = l.KeyphraseReply;
keyphrases.First <RobotBehaviorKeyphrase>().Status = l.Status;
keyphrases.First <RobotBehaviorKeyphrase>().UpdatedAt = DateTime.Now;
}
else
{
newKeyphrases.Add(new RobotBehaviorKeyphrase
{
SynAppsId = l.SynAppsId,
SynAppsDeviceId = l.SynAppsDeviceId,
Keyphrase = l.Keyphrase,
KeyphraseReply = l.KeyphraseReply,
Status = l.Status,
IsSynAppsLinked = l.IsSynAppsLinked,
IsDeleted = l.IsDeleted,
CreatedAt = DateTime.Now
});
}
}
dc.RobotBehaviorKeyphrases.InsertAllOnSubmit(newKeyphrases);
dc.SubmitChanges();
}