public static Comn_Gender GetComn_GenderByID(int id)
{
Comn_Gender comn_Gender = new Comn_Gender();
SqlComn_GenderProvider sqlComn_GenderProvider = new SqlComn_GenderProvider();
comn_Gender = sqlComn_GenderProvider.GetComn_GenderByID(id);
return(comn_Gender);
}
public int InsertComn_Gender(Comn_Gender comn_Gender)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_Gender", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_GenderID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@Comn_GenderName", SqlDbType.NVarChar).Value = comn_Gender.Comn_GenderName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_GenderID"].Value);
}
}
public bool UpdateComn_Gender(Comn_Gender comn_Gender)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_UpdateComn_Gender", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_GenderID", SqlDbType.Int).Value = comn_Gender.Comn_GenderID;
cmd.Parameters.Add("@Comn_GenderName", SqlDbType.NVarChar).Value = comn_Gender.Comn_GenderName;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public Comn_Gender GetComn_GenderFromReader(IDataReader reader)
{
try
{
Comn_Gender comn_Gender = new Comn_Gender
(
(int)reader["Comn_GenderID"],
reader["Comn_GenderName"].ToString()
);
return(comn_Gender);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_Gender(Comn_Gender comn_Gender)
{
SqlComn_GenderProvider sqlComn_GenderProvider = new SqlComn_GenderProvider();
return(sqlComn_GenderProvider.UpdateComn_Gender(comn_Gender));
}
public static int InsertComn_Gender(Comn_Gender comn_Gender)
{
SqlComn_GenderProvider sqlComn_GenderProvider = new SqlComn_GenderProvider();
return(sqlComn_GenderProvider.InsertComn_Gender(comn_Gender));
}
