protected void saveNationalityButton_Click(object sender, EventArgs e)
{
NationalityModel nationalityModel = new NationalityModel();
nationalityModel.Name = nationalityNameTextBox.Text;
if (nationalityNameTextBox.Text=="")
{
failStatusLabel.InnerText = "Please enter the nationality";
}
else
{
if (addNationalityBll.IsNationalityExist(nationalityModel))
{
successStatusLabel.InnerText = "";
failStatusLabel.InnerText = "Nationality already exist";
}
else
{
if (addNationalityBll.SaveNationality(nationalityModel) > 0)
{
failStatusLabel.InnerText = "";
successStatusLabel.InnerText = "Nationality saved";
GetAllNationality();
}
else
{
successStatusLabel.InnerText = "";
failStatusLabel.InnerText = "Nationality not saved";
}
}
}
}
public int SaveNationality(NationalityModel nationalityModel)
{
string query = String.Format("Insert into tblNationality values(@name)");
SqlParameter nameParameter = new SqlParameter("@name", nationalityModel.Name);
sqlCommand.Parameters.Add(nameParameter);
sqlCommand.CommandText = query;
sqlConnection.Open();
int rowsAffected = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
return rowsAffected;
}
public bool IsNationalityExist(NationalityModel nationalityModel)
{
bool isNationalityExist = false;
string query = String.Format("Select * from tblNationality where nationality=@nationality");
SqlParameter nameParameter = new SqlParameter("@nationality", nationalityModel.Name);
sqlCommand.Parameters.Add(nameParameter);
sqlCommand.CommandText = query;
sqlConnection.Open();
SqlDataReader rdr = sqlCommand.ExecuteReader();
while (rdr.Read())
{
isNationalityExist = true;
}
sqlConnection.Close();
return isNationalityExist;
}
public List<NationalityModel> GetAllNationality()
{
int serialNumber = 1;
List<NationalityModel> nationalityModels = new List<NationalityModel>();
string query = String.Format("Select * from tblNationality");
sqlCommand.CommandText = query;
sqlConnection.Open();
SqlDataReader rdr = sqlCommand.ExecuteReader();
while (rdr.Read())
{
NationalityModel nationalityModel = new NationalityModel();
nationalityModel.ID = serialNumber;
nationalityModel.Name = rdr[1].ToString();
nationalityModels.Add(nationalityModel);
serialNumber++;
}
sqlConnection.Close();
return nationalityModels;
}
public int SaveNationality(NationalityModel nationalityModel)
{
return addNationalityDal.SaveNationality(nationalityModel);
}
public bool IsNationalityExist(NationalityModel nationalityModel)
{
return addNationalityDal.IsNationalityExist(nationalityModel);
}
