public bool Delete(NationalityDTO oNationalityData)
{
string sProcName;
DatabaseManager oDB;
try
{
oDB = new DatabaseManager();
sProcName = "up_Del_NationalityMaster";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@iNationalityId", DbType.Int32, oNationalityData.NationalityId);
oDB.ExecuteNonQuery(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
oNationalityData = null;
GF.LogError("clsNationalityMaster.Delete", exp.Message);
return(false);
}
finally
{
oDB = null;
}
return(true);
}
public async Task <OutputResponse> Update(NationalityDTO nationality)
{
var nationalityToUpdate = await _context.Nationalities.FirstOrDefaultAsync(
x => x.NationalityCode.Equals(nationality.NationalityCode));
if (nationalityToUpdate == null)
{
return(new OutputResponse
{
IsErrorOccured = true,
Message = "Nationality specified does not exist, update cancelled"
});
}
//update details
nationalityToUpdate.NationalityName = nationality.NationalityName;
nationalityToUpdate.RowAction = "U";
nationalityToUpdate.ModifiedBy = nationality.CreatedBy;
nationalityToUpdate.DateModified = DateTime.UtcNow.AddHours(2);
await _context.SaveChangesAsync();
return(new OutputResponse
{
IsErrorOccured = false,
Message = MessageHelper.UpdateSuccess
});
}
private void Save()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Add))
{
return;
}
bool bActionCompleted = false;
NationalityDTO oNationalityData = new NationalityDTO();
oNationalityData.Nationality = txtNationality.Text.ToString();
NationalityMaster oNationalityMaster = new NationalityMaster();
bActionCompleted = oNationalityMaster.Insert(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been inserted successfully");
txtNationality.Text = "";
lblStatus.Text = "Saved";
}
else
{
lblStatus.Text = "Error Occured while insertion: Please refer to the error log.";
}
oNationalityData = null;
oNationalityMaster = null;
}
public void Create(NationalityDTO nationality)
{
Nationality regNationality = _mapper.Map <Nationality>(nationality);
unitOfWork.NationalityRepository.InsertOnSubmit(regNationality);
unitOfWork.Commit();
}
private void Delete()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Delete))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
NationalityDTO oNationalityData = new NationalityDTO();
oNationalityData.NationalityId = Id;
NationalityMaster oNationalityMaster = new NationalityMaster();
/*
* ADDED BY VIJAY
* CHECK IF THE NATIONALITY WHICH IS TO BE DELETED HAS ANY ASSOCIATED RECORDS...IF YES, MOVE OUT OF THE FUNCTION ELSE PROCEED
* IF THE OUTPUT OF sMessage IS "", THEN RECORD CAN BE DELETED, ELSE NOT
*
*/
string sMessage = "";
GF.HasRecords(Convert.ToString(Id), "nationality", out sMessage);
if (sMessage != "")
{
base.DisplayAlert(sMessage);
btnDelete.Enabled = true;
}
else
{
bActionCompleted = oNationalityMaster.Delete(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been deleted successfully");
txtNationality.Text = "";
//lblStatus.Text = "Deleted";
RefreshGrid();
}
else
{
base.DisplayAlert("Error Occured while deletion: Please refer to the error log.");
}
}
oNationalityData = null;
oNationalityMaster = null;
}
public async Task <IActionResult> Update([FromBody] NationalityDTO nationality)
{
var outputHandler = await _service.Update(nationality);
if (outputHandler.IsErrorOccured)
{
return(BadRequest(outputHandler.Message));
}
return(Ok(outputHandler.Message));
}
private NationalityDTO LoadEntityData(Nationality entity)
{
var myDto = new NationalityDTO()
{
Id = entity.Id,
Name = entity.Name
};
return(myDto);
}
public string PutNationality(NationalityDTO natDTO)
{
if (!service.Update(natDTO))
{
return("Nationality was not updated!");
}
else
{
return("Nationality was updated successfully.");
}
}
public string PostNationality(NationalityDTO natDTO)
{
if (!service.Save(natDTO))
{
return("Nationality was not inserted!");
}
else
{
return("Nationality was inserted successfully.");
}
}
private async Task <NationalityDTO> GetNationality(string nationalityCode)
{
string url = $"{CoreApiUrl}Nationalities/GetByCode?nationalityCode={nationalityCode}";
var Nationality = new NationalityDTO();
var accessToken = await HttpContext.GetTokenAsync("access_token");
var response = await HttpRequestFactory.Get(accessToken, url);
if (response.StatusCode == HttpStatusCode.OK)
{
Nationality = response.ContentAsType <NationalityDTO>();
}
else
{
ModelState.AddModelError("", HttpResponseHandler.Process(response));
}
return(Nationality);
}
private NationalityDTO[] PopulateDataObject(string Query)
{
NationalityDTO[] oNationalityData;
DataSet ds;
oNationalityData = null;
ds = GetDataFromDB(Query);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
oNationalityData = new NationalityDTO[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oNationalityData[i] = new NationalityDTO();
oNationalityData[i].NationalityId = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
oNationalityData[i].Nationality = Convert.ToString(ds.Tables[0].Rows[i][1]);
}
}
return(oNationalityData);
}
public void Insert(NationalityDTO oNationality)
{
string sql = "";
try
{
string[] parameters = new string[0];
string[] parametersValues = new string[0];
parameters[0] = "@nationality";
parametersValues[0] = oNationality.nationality;
//sql = "INSERT INTO Nationality (nationality) values (@nationality)";
sql = "spNationality_INS";
AcessoDB.CRUD(sql, parameters, parametersValues);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Edit([Bind] NationalityDTO nationality)
{
string url = $"{CoreApiUrl}Nationalities/Update";
var accessToken = await HttpContext.GetTokenAsync("access_token");
var response = await HttpRequestFactory.Put(accessToken, url, nationality);
if (response.StatusCode == HttpStatusCode.OK)
{
AppContextHelper.SetToastMessage("Nationality has been successfully updated", MessageType.Success, 1, Response);
return(RedirectToAction(nameof(Index)));
}
else
{
AppContextHelper.SetToastMessage("Failed to update nationality", MessageType.Danger, 1, Response);
ModelState.AddModelError("", HttpResponseHandler.Process(response));
}
return(View(nationality));
}
public async Task <IActionResult> VerifyDelete(string nationalityCode)
{
string url = $"{CoreApiUrl}Nationalities/Delete?nationalityCode={nationalityCode}";
var Nationality = new NationalityDTO();
var accessToken = await HttpContext.GetTokenAsync("access_token");
var response = await HttpRequestFactory.Delete(accessToken, url);
if (response.StatusCode == HttpStatusCode.OK)
{
AppContextHelper.SetToastMessage("Nationality has been successfully deleted", MessageType.Success, 1, Response);
return(RedirectToAction(nameof(Index)));
}
else
{
AppContextHelper.SetToastMessage("Failed to delete nationality", MessageType.Danger, 1, Response);
ModelState.AddModelError("", HttpResponseHandler.Process(response));
}
return(View(await GetNationality(nationalityCode)));
}
private void Update()
{
if (!base.ValidateIfCommandAllowed(Request.Url.AbsoluteUri, ENums.PageCommand.Update))
{
return;
}
if (ValidateValues() == false)
{
return;
}
bool bActionCompleted = false;
int Id = 0;
int.TryParse(hfId.Value, out Id);
if (Id == 0)
{
lblStatus.Text = "Please click on edit button again.";
return;
}
NationalityDTO oNationalityData = new NationalityDTO();
oNationalityData.NationalityId = Id;
oNationalityData.Nationality = txtNationality.Text.ToString();
NationalityMaster oNationalityMaster = new NationalityMaster();
bActionCompleted = oNationalityMaster.Update(oNationalityData);
if (bActionCompleted == true)
{
base.DisplayAlert("The record has been updated successfully");
txtNationality.Text = "";
lblStatus.Text = "Updated";
}
else
{
lblStatus.Text = "Error Occured while updation: Please refer to the error log.";
}
oNationalityData = null;
oNationalityMaster = null;
}
public bool Update(NationalityDTO item)
{
Nationality nationality = new Nationality
{
Id = item.Id,
Name = item.Name
};
try
{
using (UnitOfWork uof = new UnitOfWork())
{
uof.NationalitiesRepo.Update(nationality);
uof.Save();
}
return(true);
}
catch
{
return(false);
}
}
public void Update(NationalityDTO oNationality)
{
string sql = "";
try
{
string[] parameters = new string[2];
string[] parametersValues = new string[2];
parameters[0] = "@ID";
parameters[1] = "@nationality";
parametersValues[0] = oNationality.id.ToString();
parametersValues[1] = oNationality.nationality;
sql = "UPDATE Nationality SET nationality = @nationality where ID = @ID ";
//sql = "spNationality_INS";
AcessoDB.CRUD(sql, parameters, parametersValues, false);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <OutputResponse> Add(NationalityDTO nationality)
{
var isFound = await _context.Nationalities.AnyAsync(x => x.NationalityName.ToLower() == nationality.NationalityName.ToLower());
if (isFound)
{
return(new OutputResponse
{
IsErrorOccured = true,
Message = "Nationality name already exist, duplicates not allowed"
});
}
isFound = await _context.Nationalities.AnyAsync(x => x.NationalityCode.ToLower() == nationality.NationalityCode.ToLower());
if (isFound)
{
return(new OutputResponse
{
IsErrorOccured = true,
Message = "Nationality code already exist, duplicates not allowed"
});
}
var mappedNationality = new AutoMapperHelper <NationalityDTO, Nationalities>().MapToObject(nationality);
mappedNationality.RowAction = "I";
mappedNationality.DateCreated = DateTime.UtcNow.AddHours(2);
await _context.Nationalities.AddAsync(mappedNationality);
await _context.SaveChangesAsync();
return(new OutputResponse
{
IsErrorOccured = false,
Message = MessageHelper.AddNewSuccess
});
}
