private MyMeals.NewMyMeals GetMyMeals(string userId, string clientId)
{
MyMeals.NewMyMeals x = new MyMeals.NewMyMeals();
x = JsonConvert.DeserializeObject <MyMeals.NewMyMeals>(GetJsonFile(userId, clientId));
if (x == null)
{
x = new MyMeals.NewMyMeals();
}
return(x);
}
private void SaveMyMeals(string userId, string clientId, MyMeals.NewMyMeals myMeals)
{
try {
if (myMeals.data != null)
{
string path = string.Format("~/App_Data/users/{0}/clients/{1}", userId, clientId);
string filepath = string.Format("{0}/myMeals.json", path);
CreateFolder(path);
WriteFile(filepath, JsonConvert.SerializeObject(myMeals, Formatting.None));
}
}
catch (Exception e) {}
}
public string Save(string userId, NewMenu x, Users.NewUser user, MyMeals.NewMyMeals myMeals)
{
db.CreateDataBase(userId, db.menues);
if (x.id == null && Check(userId, x) != false)
{
return("error");
}
else
{
try {
string sql = null;
if (x.id == null)
{
x.id = Convert.ToString(Guid.NewGuid());
sql = string.Format(@"BEGIN;
INSERT INTO menues (id, title, diet, date, note, userId, clientId, userGroupId, energy)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}');
COMMIT;", x.id, x.title, x.diet, x.date, x.note, user.userId, x.client.clientId, string.IsNullOrEmpty(x.userGroupId) ? userId : x.userGroupId, x.energy);
}
else
{
sql = string.Format(@"BEGIN;
UPDATE menues SET
title = '{1}', diet = '{2}', date = '{3}', note = '{4}', userId = '{5}', clientId = '{6}', userGroupId = '{7}', energy = '{8}'
WHERE id = '{0}';
COMMIT;", x.id, x.title, x.diet, x.date, x.note, user.userId, x.client.clientId, string.IsNullOrEmpty(x.userGroupId) ? userId : x.userGroupId, x.energy);
}
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase))) {
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.ExecuteNonQuery();
}
connection.Close();
}
SaveJsonToFile(userId, x.id, JsonConvert.SerializeObject(x.data, Formatting.None));
if (myMeals != null)
{
if (myMeals.data != null)
{
if (myMeals.data.meals.Count > 2)
{
SaveMyMealsJsonToFile(userId, x.id, JsonConvert.SerializeObject(myMeals, Formatting.None));
}
}
}
string json = JsonConvert.SerializeObject(x, Formatting.None);
return(json);
} catch (Exception e) { return(e.Message); }
}
}
private void SaveMyMeals(string userId, string clientId, MyMeals.NewMyMeals myMeals)
{
try {
if (string.IsNullOrWhiteSpace(userId) || string.IsNullOrWhiteSpace(clientId))
{
return;
}
string sql = string.Format(@"BEGIN;
UPDATE clients SET myMeals = '{1}' WHERE clientId = '{0}';
COMMIT;", clientId, JsonConvert.SerializeObject(myMeals, Formatting.None));
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase))) {
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.ExecuteNonQuery();
}
}
Files F = new Files();
F.DeleteClientJsonFile(userId, clientId, "myMeals");
} catch (Exception e) {
L.SendErrorLog(e, clientId, userId, "ClientsData", "SaveMyMeals");
}
}
public string Save(string userId, NewMenu x, Users.NewUser user, MyMeals.NewMyMeals myMeals)
{
SaveResponse r = new SaveResponse();
try {
//db.CreateDataBase(userId, db.menues);
db.AddColumn(userId, db.GetDataBasePath(userId, userDataBase), db.menues, MENU_DATA, "TEXT"); //new column in menues tbl.
db.AddColumn(userId, db.GetDataBasePath(userId, userDataBase), db.menues, MY_MEALS, "TEXT"); //new column in menues tbl.
if (string.IsNullOrWhiteSpace(x.id) && Check(userId, x) != false)
{
r.data = x;
r.msg = "there is already a menu with the same name";
r.isSuccess = false;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
Global G = new Global();
if (!G.CheckUserPermission(user, x.userId))
{
r.data = x;
r.msg = "you can only save menus that you have created yourself";
r.isSuccess = false;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
string myMealsData = null;
if (myMeals != null)
{
if (myMeals.data != null)
{
if (myMeals.data.meals.Count > 2)
{
myMealsData = JsonConvert.SerializeObject(myMeals, Formatting.None);
}
}
}
x.data.meals = CombineTitleDesc(x);
string sql = null;
if (string.IsNullOrEmpty(x.id))
{
x.id = Guid.NewGuid().ToString();
sql = @"BEGIN;
INSERT INTO menues (id, title, diet, date, note, userId, clientId, userGroupId, energy, menuData, myMeals)
VALUES (@Id, @Title, @Diet, @Date, @Note, @UserId, @ClientId, @UserGroupId, @Energy, @MenuData, @MyMealsData);
COMMIT;";
}
else
{
sql = @"BEGIN;
UPDATE menues SET
title = @Title, diet = @Diet, date = @Date, note = @Note, userId = @UserId, clientId = @ClientId, userGroupId = @UserGroupId, energy = @Energy, menuData = @MenuData, myMeals = @MyMealsData
WHERE id = @Id;
COMMIT;";
}
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, userDataBase))) {
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.Parameters.Add(new SQLiteParameter("Id", x.id));
command.Parameters.Add(new SQLiteParameter("Title", x.title));
command.Parameters.Add(new SQLiteParameter("Diet", x.diet));
command.Parameters.Add(new SQLiteParameter("Date", x.date));
command.Parameters.Add(new SQLiteParameter("Note", x.note));
command.Parameters.Add(new SQLiteParameter("UserId", user.userId));
command.Parameters.Add(new SQLiteParameter("ClientId", x.client.clientId));
command.Parameters.Add(new SQLiteParameter("UserGroupId", string.IsNullOrEmpty(x.userGroupId) ? userId : x.userGroupId));
command.Parameters.Add(new SQLiteParameter("Energy", x.energy));
command.Parameters.Add(new SQLiteParameter("MenuData", JsonConvert.SerializeObject(x.data, Formatting.None)));
command.Parameters.Add(new SQLiteParameter("MyMealsData", myMealsData));
command.ExecuteNonQuery();
}
}
Files F = new Files();
F.RemoveJsonFile(userId, x.id, "menues", MENU_DATA, db, userDataBase, null); //******* Remove json file if exists (old sistem).
F.RemoveJsonFile(userId, x.id, "menues", MY_MEALS, db, userDataBase, "mymeals"); //******* Remove myMeals json file if exists (old sistem).
r.data = x;
r.msg = "saved";
r.isSuccess = true;
return(JsonConvert.SerializeObject(r, Formatting.None));
} catch (Exception e) {
r.data = x;
r.msg = e.Message;
r.msg1 = "report a problem";
r.isSuccess = false;
L.SendErrorLog(e, x.id, userId, "Menues", "Save");
return(JsonConvert.SerializeObject(r, Formatting.None));
}
}
