public ServiceResult InsertGlobalLookupData(Global_Lookup_Data pData)
{
try
{
using (var db = new AgnosDBContext())
{
db.Global_Lookup_Data.Add(pData);
db.SaveChanges();
db.Entry(pData).GetDatabaseValues();
return(new ServiceResult()
{
Code = ReturnCode.SUCCESS,
Msg = Success.GetMessage(ReturnCode.SUCCESS_INSERT),
Field = Resource.Global_Lookup
});
}
}
catch (Exception ex)
{
return(new ServiceResult()
{
Code = ReturnCode.ERROR_INSERT,
Msg = Error.GetMessage(ReturnCode.ERROR_INSERT),
Field = Resource.Global_Lookup,
Exception = ex
});
}
}
public ServiceResult UpdateGlobalLookupData(Global_Lookup_Data pData)
{
try
{
using (var db = new AgnosDBContext())
{
var current = db.Global_Lookup_Data.Where(w => w.Lookup_Data_ID == pData.Lookup_Data_ID).FirstOrDefault();
if (current != null)
{
db.Entry(current).CurrentValues.SetValues(pData);
db.SaveChanges();
}
return(new ServiceResult()
{
Code = ReturnCode.SUCCESS,
Msg = Success.GetMessage(ReturnCode.SUCCESS_UPDATE),
Field = Resource.Global_Lookup
});
}
}
catch (Exception ex)
{
return(new ServiceResult()
{
Code = ReturnCode.ERROR_UPDATE,
Msg = Error.GetMessage(ReturnCode.ERROR_UPDATE),
Field = Resource.Global_Lookup,
Exception = ex
});
}
}
public ActionResult GlobalLookup(GlobalLookupViewModel model)
{
var gService = new GlobalLookupService();
if (ModelState.IsValid)
{
var gdata = new Global_Lookup_Data();
if (model.operation == Operation.U || model.operation == Operation.D)
{
var cri = new GlobalLookupCriteria();
cri.Lookup_Data_ID = model.Lookup_Data_ID;
var result = gService.GetGlobalLookupData(cri);
if (result.Code == ReturnCode.SUCCESS)
{
var gdatas = result.Object as List <Global_Lookup_Data>;
if (gdatas != null && gdatas.Count() == 1)
{
gdata = gdatas.FirstOrDefault();
}
}
}
if (model.operation != Operation.D)
{
gdata.Def_ID = model.Def_ID.Value;
gdata.Data_Code = model.Data_Code;
gdata.Name = model.Name;
}
if (model.operation == Operation.C)
{
gdata.Record_Status = Record_Status.Active;
model.result = gService.InsertGlobalLookupData(gdata);
}
else if (model.operation == Operation.U)
{
model.result = gService.UpdateGlobalLookupData(gdata);
}
else if (model.operation == Operation.D)
{
gdata.Record_Status = Record_Status.Delete;
model.result = gService.UpdateGlobalLookupData(gdata);
if (model.result.Code == ReturnCode.SUCCESS)
{
model.result = new ServiceResult()
{
Code = ReturnCode.SUCCESS, Msg = Success.GetMessage(ReturnCode.SUCCESS_DELETE), Field = Resource.Global_Lookup
}
}
;
else
{
model.result = new ServiceResult()
{
Code = ReturnCode.ERROR_DELETE, Msg = Error.GetMessage(ReturnCode.ERROR_DELETE), Field = Resource.Global_Lookup
}
};
var route = new RouteValueDictionary(model.result);
route.Add("search_Def_ID", gdata.Def_ID);
return(RedirectToAction("GlobalLookup", route));
}
if (model.result.Code == ReturnCode.SUCCESS)
{
var route = new RouteValueDictionary(model.result);
route.Add("search_Def_ID", model.Def_ID);
return(RedirectToAction("GlobalLookup", route));
}
}
var cService = new ComboService();
model.cGlobalDefList = cService.LstLookupDef();
if (model.cGlobalDefList.Count > 0 && !model.search_Def_ID.HasValue)
{
model.search_Def_ID = NumUtil.ParseInteger(model.cGlobalDefList[0].Value);
}
if (model.search_Def_ID.HasValue)
{
var cri = new GlobalLookupCriteria();
var result = gService.GetGlobalLookupData(cri);
if (result.Code == ReturnCode.SUCCESS)
{
model.GlobalDataList = result.Object as List <Global_Lookup_Data>;
}
}
return(View(model));
}
}
