public static Comn_Upojela GetComn_UpojelaByID(int id)
{
Comn_Upojela comn_Upojela = new Comn_Upojela();
SqlComn_UpojelaProvider sqlComn_UpojelaProvider = new SqlComn_UpojelaProvider();
comn_Upojela = sqlComn_UpojelaProvider.GetComn_UpojelaByID(id);
return(comn_Upojela);
}
public int InsertComn_Upojela(Comn_Upojela comn_Upojela)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_Upojela", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_UpojelaID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@UpojelaID", SqlDbType.Int).Value = comn_Upojela.UpojelaID;
cmd.Parameters.Add("@UpojelaName", SqlDbType.NVarChar).Value = comn_Upojela.UpojelaName;
cmd.Parameters.Add("@DistrictName", SqlDbType.NVarChar).Value = comn_Upojela.DistrictName;
cmd.Parameters.Add("@DistrictID", SqlDbType.Int).Value = comn_Upojela.DistrictID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_UpojelaID"].Value);
}
}
public Comn_Upojela GetComn_UpojelaFromReader(IDataReader reader)
{
try
{
Comn_Upojela comn_Upojela = new Comn_Upojela
(
(int)reader["Comn_UpojelaID"],
(int)reader["UpojelaID"],
reader["UpojelaName"].ToString(),
reader["DistrictName"].ToString(),
(int)reader["DistrictID"]
);
return(comn_Upojela);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_Upojela(Comn_Upojela comn_Upojela)
{
SqlComn_UpojelaProvider sqlComn_UpojelaProvider = new SqlComn_UpojelaProvider();
return(sqlComn_UpojelaProvider.UpdateComn_Upojela(comn_Upojela));
}
public static int InsertComn_Upojela(Comn_Upojela comn_Upojela)
{
SqlComn_UpojelaProvider sqlComn_UpojelaProvider = new SqlComn_UpojelaProvider();
return(sqlComn_UpojelaProvider.InsertComn_Upojela(comn_Upojela));
}
