public List <TagsClass> GetAllTags(int id)
{
int ShowRecords = 20;
int skip = id * ShowRecords;
var DesiMasala = "";
var AllRecords = obj.Tags.Count();
int max = (skip + ShowRecords);
if (max > AllRecords)
{
max = AllRecords;
}
DesiMasala = (skip + 1).ToString() + "-" + max.ToString() + "/" + AllRecords.ToString();
List <TagsClass> li = new List <TagsClass>();
var AllTags = obj.Tags.Skip(skip).Take(ShowRecords).Where(x => x.status != 0).ToList();
var count = AllTags.Count();
foreach (var details in AllTags)
{
TagsClass temp = new TagsClass();
temp.Id = details.Id;
temp.Description = details.Description;
temp.Count = count;
temp.NumberOfShowing = DesiMasala;
li.Add(temp);
}
return(li);
}
public int UpdateTags(TagsClass TC)
{
int check = 0;
try
{
Tag Tags = obj.Tags.First(x => x.Id.Equals(TC.Id));
Tags.Description = TC.Description;
Tags.status = 1;
obj.SubmitChanges();
check = Tags.Id;
}
catch (Exception e) { check = 0; }
return(check);
}
public int PostTags(TagsClass TC)
{
int check = 0;
try
{
Tag Tags = new Tag();
Tags.Description = TC.Description;
Tags.status = 1;
Tags.AddDate = DateTime.Now.ToShortDateString();
obj.Tags.InsertOnSubmit(Tags);
obj.SubmitChanges();
check = Tags.Id;
}
catch (Exception e) { check = 0; }
return(check);
}
public List <TagsClass> GetAllTagsById(int id)
{
List <TagsClass> li = new List <TagsClass>();
var AllTags = obj.Tags.Where(x => x.status != 0 && x.Id.Equals(id)).ToList();
var count = AllTags.Count();
foreach (var details in AllTags)
{
TagsClass temp = new TagsClass();
temp.Id = details.Id;
temp.Description = details.Description;
temp.Count = count;
li.Add(temp);
}
return(li);
}
public ActionResult Edit([Bind(Include = "tag_id,tag_name")] TagsClass tag)
{
ViewBag.isExist = "NO";
if (modelClass.isExist(tag))
{
ViewBag.isExist = "Same Tag Name is exist already.";
}
else
{
if (ModelState.IsValid)
{
modelClass.Edit(tag);
return(RedirectToAction("Index"));
}
}
return(View(tag));
}
// GET: Parents
public ActionResult Tags()
{
//if ((Object)Session["Login"] == null)
//{
// return RedirectToAction("Login", "Users");
//}
//ViewBag.isLogin = true;
if ((Object)Session["Login"] == null)
{
ViewBag.isLogin = false;
}
else
{
ViewBag.isLogin = true;
}
TagsClass tc = new TagsClass();
return(View(tc.ReadWithUsedNumber()));
}
// GET: cases
public ActionResult Index()
{
if ((Object)Session["as_role"] == null)
{
if ((Object)Session["Login"] == null)
{
return(RedirectToAction("Login", "Users"));
}
//else
//{
// return RedirectToAction("NoRole", "Users");
//}
}
TagsClass tc = new TagsClass();
ViewBag.Tags = tc.Read();
//ViewBag.Case_tags = case_tagClass.Read();
//case_tagClass.Read().Any(cus => cus.f_case_id == 1);
return(View(modelClass.Read()));
}
public IActionResult Add(NewRecipeVM obj)
{
int?uid = HttpContext.Session.GetInt32("UID");
int uid2 = uid.Value;
if (ModelState.IsValid)
{
//RecipeClass newRecipe = context.Recipes.Single(c => c.RecId == obj.RecId);
TagsClass t = new TagsClass
{
TagName = obj.TagName
};
context.Tags.Add(t);
context.SaveChanges();
RecipeClass r = new RecipeClass
{
RecName = obj.RecName,
TagsId = t.Id,
UserId = uid2
//Calories = obj.Calories
};
context.Recipes.Add(r);
context.SaveChanges();
InstructionsClass inst = new InstructionsClass
{
RecipeId = r.Id,
StepOrder = obj.StepOrder,
Instruct = obj.Instruct
};
context.Instructions.Add(inst);
context.SaveChanges();
IngredientsClass ing = new IngredientsClass
{
IngName = obj.IngName,
UM = obj.UM
//Id = ingQ.Id
};
context.Ingredients.Add(ing);
context.SaveChanges();
IngQuantClass ingQ = new IngQuantClass
{
RecipeClassId = r.Id,
IngredientsClassId = ing.Id,
Quantity = obj.Quantity
};
context.IngQuant.Add(ingQ);
context.SaveChanges();
ViewBag.message = "Recipe created";
return(Redirect("/Index"));
}
return(View(obj));
}
