/// <summary>
/// Update State Record
/// </summary>
/// <param name="obj"></param>
/// <param name="id"></param>
/// <returns></returns>
public async Task <string> UpdateLga(LgaDTO obj, int id)
{
string status = "";
try
{
//Check if record exist not as same id
var checkexist = await _context.BtState.AnyAsync(x => x.StateId != id && (x.Name == obj.name));
if (checkexist == false)
{
var state = await _context.BtState.FirstOrDefaultAsync(x => x.StateId == id);
state.Name = obj.name;
//state.CountryCode = obj.countrycode;
state.ModifiedBy = _authUser.Name;
state.LastModified = DateTime.Now;
if (await _context.SaveChangesAsync() > 0)
{
status = "1";
return(status);
}
else
{
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
status = string.Format(ResponseErrorMessageUtility.RecordExistBefore, obj.name);
return(status);
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
public async Task <string> CreateLga(LgaDTO obj)
{
string status = "";
try
{
//Check Country
var checkcountry = await _context.BtLga.AsNoTracking().FirstOrDefaultAsync(x => x.StateCode == obj.statecode);
if (checkcountry == null)
{
status = "The state code is not valid.";
return(status);
}
//Check Country
var checkstate = await _context.BtLga.AsNoTracking()
.FirstOrDefaultAsync(x => x.Name == obj.name && x.StateCode == checkcountry.StateCode);
if (checkstate != null)
{
status = string.Format(ResponseErrorMessageUtility.RecordExistBefore, obj.name);
return(status);
}
//Assign State Code
var getstate = await _context.BtLga.AsNoTracking()
.Where(x => x.StateCode == checkcountry.StateCode && !x.StateCode.Contains("N/A"))
.Select(x => int.Parse(x.StateCode)).ToListAsync();
var getLastID = (getstate.Count() > 0) ? getstate.Max() : 0;
BtLga newrecord = new BtLga
{
Name = obj.name,
LgaCode = Convert.ToString(getLastID + 1),
StateCode = checkcountry.StateCode,
CreatedBy = _authUser.Name,
CreatedDate = DateTime.Now,
IsActive = true,
LastModified = null,
ModifiedBy = null
};
_context.BtLga.Add(newrecord);
if (await _context.SaveChangesAsync() > 0)
{
status = "1";
return(status);
}
else
{
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}
catch (Exception ex)
{
_logger.LogError(ex.Message);
status = ResponseErrorMessageUtility.RecordNotSaved;
return(status);
}
}