public ResultInfo.Result Add(string title)
{
Alert alrt = new Alert();
try
{
alrt.Title = title;
alrt.Message = "Alert from [Thing], reported [EndpointType]: [Value] [Measurement] @[TimeStamp]";
alrt.IsActive = false;
alrt.Sunday = false;
alrt.Monday = false;
alrt.Tuesday = false;
alrt.Wednesday = false;
alrt.Thursday = false;
alrt.Friday = false;
alrt.Saturday = false;
alrt.StartTime = new TimeSpan(0, 0, 0);
alrt.EndTime = new TimeSpan(23, 59, 59);
db.Alerts.Add(alrt);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", alrt.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public ResultInfo.Result Add(string title, long typeID, long deviceID, long thingID, bool isNumericOnly, float?minValue, float?maxValue, float?lowRange, float?highRange)
{
Endpoint end = new Endpoint();
try
{
end.GUID = Guid.NewGuid();
end.KeyPass = Guid.NewGuid();
end.PinCode = "0000";
end.Title = title;
end.DeviceID = deviceID;
end.TypeID = typeID;
end.ThingID = thingID;
end.IsNumericOnly = isNumericOnly;
end.MinValue = minValue;
end.MaxValue = maxValue;
end.LowRange = lowRange;
end.HighRange = highRange;
end.ObjectStatusID = 1;
db.Endpoints.Add(end);
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", end.ID));
}
catch
{
return(ResultInfo.GetResultByID(1));
}
}
public ResultInfo.Result Add(string title, string description, string createdBy)
{
App app = new App();
//Validate UserID
List <AspNetUser> usrs = db.AspNetUsers.Where(u => u.Id == createdBy).ToList();
if (usrs.Count != 1)
{
return(Result.GenerateFailedResult());
}
//Save new app in database
try
{
app.GUID = Guid.NewGuid();
app.Key = Guid.NewGuid();
app.Title = title;
app.Description = description;
app.CreatedByID = createdBy;
app.DevelopedByName = usrs[0].FullName;
app.CreateDate = DateTime.Now;
app.StatusID = 1;
app.IsStoreApp = false;
app.Version = 1;
db.Apps.Add(app);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", app.ID.ToString()));
}
catch (Exception ex)
{
return(Result.GenerateFailedResult("Error", ex.Message));
}
}
/// <summary>
/// Create new Thing Extension Property.
/// </summary>
/// <param name="title">Property Title.</param>
/// <param name="code">Property Code, should not includes empty spaces.</param>
/// <param name="thingCategoryID">Thing Category ID that will attach the property to.</param>
/// <param name="dataTypeID">Property Data Type ID</param>
/// <param name="isList">Set if the property support list or single value.</param>
/// <param name="createdBy">Created by User account.</param>
/// <returns>Result status info.</returns>
public ResultInfo.Result Add(string title, string code, long thingCategoryID, int dataTypeID, bool isList, string createdBy)
{
ThingExtension ext = new ThingExtension();
//Validate data before insert int odatabase
if (code.Contains(" "))
{
return(Result.GenerateFailedResult("Code field should not includes empty spaces"));
}
List <ThingExtension> exts = db.ThingExtensions.Where(u =>
u.Title == title ||
u.Code == code
).ToList();
if (exts.Count != 0)
{
return(Result.GenerateFailedResult("Record not found"));
}
//Save new ThingExtension to database
try
{
ext.Title = title;
ext.Code = code;
ext.ThingCategoryID = thingCategoryID;
ext.DataTypeID = dataTypeID;
ext.IsList = isList;
db.ThingExtensions.Add(ext);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", ext.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public static void SetDevelopmentMode(bool activation)
{
DynSetting dset = db.DynSettings.First();
dset.DevelopmentMode = activation;
db.SaveChanges();
}
public ActionResult Create([Bind(Include = "ID,Title")] LocationViewType locationViewType)
{
if (ModelState.IsValid)
{
db.LocationViewTypes.Add(locationViewType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(locationViewType));
}
public ResultInfo.Result SetMailIsSent(long id)
{
try
{
UserNotification noti = db.UserNotifications.Find(id);
noti.IsEmailSent = true;
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", noti.ID));
}
catch
{
return(ResultInfo.GetResultByID(1));
}
}
public void AddSuccess(long appID, Guid token, long methodID, string notes)
{
Result result = Result.GenerateFailedResult();
APIUtilisation ut = new APIUtilisation();
ut.AppID = appID;
ut.MethodID = methodID;
ut.StatusID = 0;
ut.TimeStampUTC = DateTime.UtcNow;
ut.Token = token;
ut.Notes = notes;
db.APIUtilisations.Add(ut);
db.SaveChanges();
}
public ResultInfo.Result Edit(string id, string userName, string fullName)
{
try
{
AspNetUser usr = db.AspNetUsers.Find(id);
usr.FullName = fullName;
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", long.Parse(usr.Id)));
}
catch (Exception ex)
{
return(ResultInfo.GenerateErrorResult(ex.Message));
}
}
public ResultInfo.Result Add(string Title)
{
try
{
MediaFile cat = new MediaFile();
cat.Title = Title;
db.MediaFiles.Add(cat);
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", cat.ID));
}
catch
{
return(ResultInfo.GetResultByID(1));
}
}
public ResultInfo.Result Add(string Title, long IconID)
{
try
{
ThingCategory cat = new ThingCategory();
cat.Title = Title;
cat.IconID = IconID;
db.ThingCategorys.Add(cat);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", cat.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public ResultInfo.Result Add(string Title)
{
try
{
MediaFile cat = new MediaFile();
cat.Title = Title;
cat.GUID = Guid.NewGuid();
db.MediaFiles.Add(cat);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", cat.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public static void SetSystemLogger(bool activation)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.EnableSystemLogger = activation;
db.SaveChanges();
}
public static void SetDefaultRecordsPerChild(int recordsCount)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.DefaultRecordsPerChild = recordsCount;
db.SaveChanges();
}
public ResultInfo.Result SetGridRowsCount(int masterGridRowsCount, int childGridRowsCount)
{
List <DynSetting> cons = db.DynSettings.Where(l => l.ID == 1).ToList();
if (cons.Count == 1)
{
cons[0].DefaultRecordsPerMaster = masterGridRowsCount;
cons[0].DefaultRecordsPerChild = childGridRowsCount;
db.SaveChanges();
Core.Config.Refresh();
}
else
{
return(ResultInfo.GetResultByID(1));
}
return(ResultInfo.GenerateOKResult("Saved"));
}
public static void SetPlatformKey(Guid newKey)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.PlatformKey = newKey;
db.SaveChanges();
}
public static void SetApp_TimeZone(int timeZone)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.App_TimeZone = timeZone;
db.SaveChanges();
}
public static void SetPublicSignUP(bool activation)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.PublicSignUP = activation;
db.SaveChanges();
}
public static void SetLastCentralSync()
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.LastCentralSync = DateTime.UtcNow;
db.SaveChanges();
}
public static void SetGogoleAnalytics(string googleAnalytics)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.GoogleAnalytics = googleAnalytics;
db.SaveChanges();
}
public static void SetKeyMap(string mapKey)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.MapKey = mapKey;
db.SaveChanges();
}
public static void SetPlatformTitle(string title)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.PlatformTitle = title;
db.SaveChanges();
}
public ResultInfo.Result Add(string Title, string measurment, long TypeCategoryID, long IconID)
{
try
{
EndPointType epType = new EndPointType();
epType.Title = Title;
epType.measurement = measurment;
epType.TypeCategoryID = TypeCategoryID;
epType.IconID = IconID;
db.EndPointTypes.Add(epType);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", epType.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public ResultInfo.Result Add(long deviceID, string value, deviceIOType ioType, DateTime executionTime)
{
try
{
DeviceIO endIO = new DeviceIO();
endIO.DeviceID = deviceID;
endIO.Valu = value;
endIO.IOTypeID = long.Parse(ioType.GetHashCode().ToString());
endIO.TimeStamp = DateTime.Now;
endIO.ExecTimeStamp = executionTime;
db.DeviceIOs.Add(endIO);
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", endIO.ID));
}
catch
{
return(ResultInfo.GetResultByID(1));
}
}
public ResultInfo.Result Add(string title, long EndPointID, string description, string commandCode, string ownerID)
{
try
{
EndPointCommand cmd = new EndPointCommand();
cmd.Title = title;
cmd.EndPointID = EndPointID;
cmd.Description = description;
cmd.CommandCode = commandCode;
cmd.OwnerID = ownerID;
db.EndPointCommands.Add(cmd);
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", cmd.ID));
}
catch
{
return(ResultInfo.GetResultByID(1));
}
}
public ResultInfo.Result Add(string title, long deviceID, string description, string commandCode, string ownerID)
{
try
{
DeviceCommand cmd = new DeviceCommand();
cmd.Title = title;
cmd.DeviceID = deviceID;
cmd.Description = description;
cmd.CommandCode = commandCode;
cmd.OwnerID = ownerID;
db.DeviceCommands.Add(cmd);
db.SaveChanges();
return(Result.GenerateOKResult("Saved", cmd.ID.ToString()));
}
catch
{
return(Result.GenerateFailedResult());
}
}
public static void SetMailsConfig(Mails.MailsConfig mailConfig)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.SMTPAddress = mailConfig.Host;
dset.SMTPPort = mailConfig.Port;
dset.NotifcationMail = mailConfig.Sender;
db.SaveChanges();
}
public ResultInfo.Result Add(string title, long categoryID, int utc_Diff, string userID)
{
Thing thing = new Thing();
try
{
thing.CategoryID = categoryID;
thing.Title = title;
thing.UTC_Diff = utc_Diff;
thing.CreateByUser = userID;
thing.CreateTimeStamp = DateTime.UtcNow.AddHours(Config.App_TimeZone);
thing.ObjectStatusID = 1;
db.Things.Add(thing);
db.SaveChanges();
}
catch (Exception ex)
{
return(Result.GenerateFailedResult(ex.InnerException.ToString()));
}
return(Result.GenerateOKResult("Saved", thing.ID.ToString()));
}
public static void Setup(string title, bool publicAccess, bool publicSignUp, int appLocalTime, bool developmentMode)
{
DynThingsEntities db = new DynThingsEntities();
DynSetting dset = db.DynSettings.First();
dset.PlatformTitle = title;
dset.PublicAccess = publicAccess;
dset.PublicSignUP = PublicSignUP;
dset.App_TimeZone = appLocalTime;
dset.DevelopmentMode = developmentMode;
db.SaveChanges();
}
public ResultInfo.Result Add(string title, string code, Guid guid, Guid iconGuid, long appID, string userID)
{
AppThingCategory appThingCategory = new AppThingCategory();
//Save new app in database
try
{
appThingCategory.AppID = appID;
appThingCategory.Title = title;
appThingCategory.Code = code;
appThingCategory.GUID = guid;
appThingCategory.IconGUID = iconGuid;
db.AppThingCategorys.Add(appThingCategory);
db.SaveChanges();
return(ResultInfo.GenerateOKResult("Saved", appThingCategory.ID));
}
catch (Exception ex)
{
return(ResultInfo.GenerateErrorResult("Error", ex.Message));
}
}
