public MenuMasterModel AddNewMenu(MenuMasterModel model)
{
//ResponseStatus respponse = new ResponseStatus();
MenuMasterModel data = new MenuMasterModel();
using (sjb_androidEntities context = new sjb_androidEntities())
{
var me = context.menumasters.Find(model.MenuId);
if (me != null)
{
me.MenuName = model.MenuName;
me.MenuPrice = model.MenuPrice;
me.StoreId = model.StoreId;
var result = context.SaveChanges();
if (result > 0)
{
data.MenuId = me.MenuId;
}
}
else
{
menumaster m = new menumaster();
m.MenuName = model.MenuName;
m.MenuPrice = model.MenuPrice;
m.StoreId = model.StoreId;
context.menumasters.Add(m);
var result = context.SaveChanges();
if (result > 0)
{
data.MenuId = m.MenuId;
}
}
}
return(data);
}
public MenuMasterModel GetMenuById(int id)
{
//ResponseStatus respponse = new ResponseStatus();
MenuMasterModel data = new MenuMasterModel();
using (sjb_androidEntities context = new sjb_androidEntities())
{
data = (from m in context.menumasters
join s in context.storemasters on m.StoreId equals s.StoreId into j1
from j2 in j1.DefaultIfEmpty()
orderby m.CreatedOn descending
where m.MenuId == id
select new MenuMasterModel()
{
MenuId = m.MenuId,
MenuName = m.MenuName,
MenuPrice = (decimal)m.MenuPrice,
StoreName = j2.StoreName
}).FirstOrDefault();
}
return(data);
}