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); }