private Global.Response DeleteRecord(string userId, string id, SQLiteConnection connection, string tbl)
{
Global.Response response = new Global.Response();
try {
string sql = null;
switch (tbl)
{
case "clients":
sql = string.Format(@"DELETE FROM clients WHERE clientId = '{0}';
DELETE FROM clientsdata WHERE clientId = '{0}'", id);
F.DeleteClientFolder(userId, id);
break;
case "menus":
sql = string.Format("DELETE FROM menues WHERE id = '{0}'", id);
F.DeleteJsonFile(userId, id, "menues", null);
break;
case "weeklymenus":
sql = string.Format("DELETE FROM weeklymenus WHERE id = '{0}'", id);
break;
case "recipes":
sql = string.Format("DELETE FROM recipes WHERE id = '{0}'", id);
F.DeleteJsonFile(userId, id, "recipes", null);
/******* Delete from My Foods if exists (Recipes as My Food) *******/
MyFoods mf = new MyFoods();
mf.Delete(userId, id);
F.DeleteRecipeFolder(userId, id);
/******* Delete from My Sharing Recipes if exists *******/
SharingRecipes SR = new SharingRecipes();
SR.DeleteSharedRecipe(id);
break;
case "foods":
sql = string.Format("DELETE FROM myfoods WHERE id = '{0}'", id);
break;
case "appointments":
sql = string.Format("DELETE FROM scheduler WHERE rowid = '{0}'", id);
break;
default:
break;
}
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.ExecuteNonQuery();
}
response.isSuccess = true;
response.msg = "deleted";
return(response);
} catch (Exception e) {
response.isSuccess = false;
response.msg = e.Message;
L.SendErrorLog(e, id, userId, "Archives", "DeleteRecord");
return(response);
}
}
public string SaveAsFood(string userId, NewRecipe recipe, string unit)
{
try {
NewRecipe x = JsonConvert.DeserializeObject <NewRecipe>(Save(userId, recipe));
Foods.NewFood food = TransformRecipeToFood(recipe);
food.id = x.id;
food.unit = unit;
MyFoods mf = new MyFoods();
mf.Save(userId, food);
return("saved");
} catch (Exception e) { return(e.Message); }
}
public string Delete(string userGroupId, string id, string userId, int adminType, string authorId)
{
var x = new Global.Response();
try {
if (string.IsNullOrEmpty(userGroupId) || string.IsNullOrEmpty(id))
{
x.isSuccess = false;
x.msg = "tryAgainMsg";
return(JsonConvert.SerializeObject(x, Formatting.None));
}
Global G = new Global();
if (!G.CheckUserPermission(userGroupId, userId, adminType, authorId))
{
x.isSuccess = false;
x.msg = "deleteRecipePermissionAlert";
return(JsonConvert.SerializeObject(x, Formatting.None));
}
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userGroupId, dataBase))) {
connection.Open();
string sql = @"BEGIN;
DELETE FROM recipes WHERE id = @Id;
COMMIT;";
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.Parameters.Add(new SQLiteParameter("Id", id));
command.ExecuteNonQuery();
}
}
Files F = new Files();
F.DeleteJsonFile(userGroupId, id, "recipes", null);
/******* Delete from My Foods if exists (Recipes as My Food) *******/
MyFoods mf = new MyFoods();
mf.Delete(userGroupId, id);
/*******************************************************************/
F.DeleteRecipeFolder(userGroupId, id);
/******* Delete from My Sharing Recipes if exists *******/
SharingRecipes SR = new SharingRecipes();
SR.DeleteSharedRecipe(id);
/*******************************************************************/
x.isSuccess = true;
x.msg = "deleted";
return(JsonConvert.SerializeObject(x, Formatting.None));
} catch (Exception e) {
x.isSuccess = false;
x.msg = e.Message;
L.SendErrorLog(e, id, null, "Recipes", "Delete");
return(JsonConvert.SerializeObject(x, Formatting.None));
}
}
public string SaveAsFood(string userId, NewRecipe recipe, string unit)
{
try {
NewRecipe x = JsonConvert.DeserializeObject <NewRecipe>(Save(userId, recipe));
Foods.NewFood food = TransformRecipeToFood(recipe);
food.id = x.id;
food.unit = unit;
MyFoods mf = new MyFoods();
mf.Save(userId, food);
return(JsonConvert.SerializeObject("saved", Formatting.None));
} catch (Exception e) {
L.SendErrorLog(e, recipe.id, null, "Recipes", "SaveAsFood");
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public string Delete(string userId, string id)
{
try {
SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase));
connection.Open();
string sql = "delete from recipes where id = @id";
SQLiteCommand command = new SQLiteCommand(sql, connection);
command.Parameters.Add(new SQLiteParameter("id", id));
command.ExecuteNonQuery();
connection.Close();
DeleteJson(userId, id);
/******* Delete from My Foods if exists (Recipes as My Food) *******/
MyFoods mf = new MyFoods();
mf.Delete(userId, id);
/*******************************************************************/
} catch (Exception e) { return(e.Message); }
return("OK");
}
