public static Comn_Nationality GetComn_NationalityByID(int id)
{
Comn_Nationality comn_Nationality = new Comn_Nationality();
SqlComn_NationalityProvider sqlComn_NationalityProvider = new SqlComn_NationalityProvider();
comn_Nationality = sqlComn_NationalityProvider.GetComn_NationalityByID(id);
return(comn_Nationality);
}
public int InsertComn_Nationality(Comn_Nationality comn_Nationality)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_Nationality", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_NationalityID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Comn_NationalityName", SqlDbType.NVarChar).Value = comn_Nationality.Comn_NationalityName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_NationalityID"].Value);
}
}
public bool UpdateComn_Nationality(Comn_Nationality comn_Nationality)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateComn_Nationality", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_NationalityID", SqlDbType.Int).Value = comn_Nationality.Comn_NationalityID;
cmd.Parameters.Add("@Comn_NationalityName", SqlDbType.NVarChar).Value = comn_Nationality.Comn_NationalityName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Comn_Nationality GetComn_NationalityFromReader(IDataReader reader)
{
try
{
Comn_Nationality comn_Nationality = new Comn_Nationality
(
(int)reader["Comn_NationalityID"],
reader["Comn_NationalityName"].ToString()
);
return(comn_Nationality);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_Nationality(Comn_Nationality comn_Nationality)
{
SqlComn_NationalityProvider sqlComn_NationalityProvider = new SqlComn_NationalityProvider();
return(sqlComn_NationalityProvider.UpdateComn_Nationality(comn_Nationality));
}
public static int InsertComn_Nationality(Comn_Nationality comn_Nationality)
{
SqlComn_NationalityProvider sqlComn_NationalityProvider = new SqlComn_NationalityProvider();
return(sqlComn_NationalityProvider.InsertComn_Nationality(comn_Nationality));
}
