public IHttpActionResult CheckRecordExist(int id, string groupCode)
{
using (var ctx = new RestMgmtEntities())
{
if (id > 0)
{
int cnt = ctx.GroupMasters.Where(t => t.GroupCode == groupCode && t.Id != id).Count();
if (cnt > 0)
{
return(Ok("true"));
}
else
{
return(Ok("false"));
}
}
else
{
int cnt = ctx.GroupMasters.Where(t => t.GroupCode == groupCode).Count();
if (cnt > 0)
{
return(Ok("true"));
}
else
{
return(Ok("false"));
}
}
}
}
public IHttpActionResult Delete(int id)
{
using (var ctx = new RestMgmtEntities())
{
var res = ctx.GroupMasters.Where(t => t.Id == id).FirstOrDefault();
ctx.GroupMasters.Remove(res);
ctx.SaveChanges();
}
return(Ok());
}
public IEnumerable <ItemMasterModel> GetList()
{
using (var ctx = new RestMgmtEntities())
{
IEnumerable <ItemMasterModel> itemList = (from it in ctx.ItemMasters join gr in ctx.GroupMasters on it.GroupId equals gr.Id select new ItemMasterModel {
Id = it.Id, GroupName = gr.GroupName, ItemName = it.ItemName, Price = it.Price
}).ToList();
return(itemList);
}
}
public IEnumerable <GroupMasterModel> GetList()
{
using (var ctx = new RestMgmtEntities())
{
return(ctx.GroupMasters.ToList().Select(t => new GroupMasterModel()
{
Id = t.Id,
GroupCode = t.GroupCode,
GroupName = t.GroupName
}).ToList().OrderBy(t => t.GroupName));
}
}
public IHttpActionResult Insert(GroupMasterModel model)
{
using (var ctx = new RestMgmtEntities())
{
ctx.GroupMasters.Add(new GroupMaster()
{
GroupCode = model.GroupCode,
GroupName = model.GroupName,
CreatedUserId = model.CreatedUserId
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult Update(GroupMasterModel model, int id)
{
GroupMaster groupMaster = new GroupMaster();
using (var ctx = new RestMgmtEntities())
{
groupMaster = ctx.GroupMasters.Where(t => t.Id == id).FirstOrDefault();
groupMaster.GroupCode = model.GroupCode;
groupMaster.GroupName = model.GroupName;
groupMaster.UpdatedUserId = model.CreatedUserId;
groupMaster.UpdatedDate = DateTime.Now;
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult GetDetail(int id)
{
GroupMasterModel groupMaster = new GroupMasterModel();
using (var ctx = new RestMgmtEntities())
{
groupMaster = ctx.GroupMasters.Where(t => t.Id == id).Select(t => new GroupMasterModel()
{
Id = t.Id,
GroupCode = t.GroupCode,
GroupName = t.GroupName,
CreatedUserId = t.CreatedUserId ?? 0
}).FirstOrDefault();
}
return(Ok(groupMaster));
}
public IHttpActionResult GetDetail(int id)
{
using (var ctx = new RestMgmtEntities())
{
ItemMasterModel itemMasterModel = ctx.ItemMasters.Where(t => t.Id == id).Select(t => new ItemMasterModel {
Id = t.Id,
ItemName = t.ItemName,
GroupId = t.GroupId,
Price = t.Price
}).FirstOrDefault();
return(Ok(itemMasterModel));
}
}
public IHttpActionResult Insert(ItemMasterModel model)
{
using (var ctx = new RestMgmtEntities())
{
ctx.ItemMasters.Add(new ItemMaster()
{
ItemName = model.ItemName,
GroupId = model.GroupId,
Price = model.Price,
CreatedUserId = model.CreatedUserId,
CreatedDate = DateTime.Now
});
ctx.SaveChanges();
}
return(Ok());
}
public IHttpActionResult Update(int id, ItemMasterModel model)
{
using (var ctx = new RestMgmtEntities())
{
ItemMaster itemMaster = ctx.ItemMasters.Where(t => t.Id == id).FirstOrDefault();
if (itemMaster != null)
{
itemMaster.ItemName = model.ItemName;
itemMaster.GroupId = model.GroupId;
itemMaster.Price = model.Price;
itemMaster.UpdatedDate = DateTime.Now;
itemMaster.UpdateUserId = model.UpdateUserId;
ctx.SaveChanges();
}
}
return(Ok());
}
