public IActionResult EditListOfValue(ListOfValueDTO value)
{
try
{
string result = IListOfValue.EditListOfValue(value);
return(Ok(result));
} catch (Exception e) { return(Ok(e.InnerException.Message)); }
}
public string DeleteListOfValue(ListOfValueDTO value)
{
RegisterManange.API.Models.ListOfValue ListOfValue = new RegisterManange.API.Models.ListOfValue();
ListOfValue = Context.ListOfValue.Where(x => x.GroupCode == value.GroupCode && x.SeqNo == value.SeqNo).FirstOrDefault();
Context.ListOfValue.Remove(ListOfValue);
Context.SaveChanges();
return("success");
}
public IActionResult DeleteListOfValue(string groupCode, int seqNo)
{
try
{
ListOfValueDTO value = new ListOfValueDTO
{
GroupCode = groupCode,
SeqNo = seqNo
};
string result = IListOfValue.DeleteListOfValue(value);
return(Ok(result));
} catch (Exception e) { return(Ok(e.InnerException.Message)); }
}
public string EditListOfValue(ListOfValueDTO value)
{
RegisterManange.API.Models.ListOfValue ListOfValue = new RegisterManange.API.Models.ListOfValue();
ListOfValue = Context.ListOfValue.Where(x => x.GroupCode == value.GroupCode && x.SeqNo == value.SeqNo).FirstOrDefault();
ListOfValue.Value = value.Value;
ListOfValue.Description = value.Description;
ListOfValue.UpdBy = value.UpdBy;
ListOfValue.UpdDate = DateTime.Now;
ListOfValue.Active = value.Active;
Context.ListOfValue.Update(ListOfValue);
Context.SaveChanges();
return("success");
}
public string AddListOfValue(ListOfValueDTO value)
{
RegisterManange.API.Models.ListOfValue ListOfValue = new RegisterManange.API.Models.ListOfValue();
ListOfValue.GroupCode = value.GroupCode;
ListOfValue.SeqNo = value.SeqNo.GetValueOrDefault();
ListOfValue.Value = value.Value;
ListOfValue.Description = value.Description;
ListOfValue.CrBy = value.CrBy;
ListOfValue.CrDate = DateTime.Now;
ListOfValue.UpdBy = value.CrBy;
ListOfValue.UpdDate = DateTime.Now;
ListOfValue.Active = value.Active;
Context.ListOfValue.Add(ListOfValue);
Context.SaveChanges();
return("success");
}
public IActionResult GetDataListOfValue([FromQuery(Name = "groupCode")] string groupCode,
[FromQuery(Name = "seqNo")] int?seqNo,
[FromQuery(Name = "value")] string value,
[FromQuery(Name = "description")] string desc,
[FromQuery(Name = "active")] string active)
{
try
{
ListOfValueDTO dto = new ListOfValueDTO
{
GroupCode = groupCode,
SeqNo = seqNo,
Value = value,
Description = desc,
Active = active
};
return(Ok(IListOfValue.GetDataListOfValue(dto)));
} catch (Exception e) { throw e; }
}
public List <ListOfValueDTO> GetDataListOfValue(ListOfValueDTO value)
{
List <ListOfValueDTO> values = (from Values in Context.ListOfValue
where (value.GroupCode == null || Values.GroupCode == value.GroupCode) &&
(value.SeqNo == null || Values.SeqNo == value.SeqNo) &&
(value.Value == null || Values.Value == value.Value) &&
(value.Description == null || Values.Description.Contains(value.Description))
select new ListOfValueDTO
{
GroupCode = Values.GroupCode,
SeqNo = Values.SeqNo,
Value = Values.Value,
Description = Values.Description,
CrBy = Values.CrBy,
CrDate = Values.CrDate,
UpdBy = Values.UpdBy,
UpdDate = Values.UpdDate,
Active = Values.Active
}).ToList();
return(values);
}
