public static Comn_District GetComn_DistrictByID(int id)
{
Comn_District comn_District = new Comn_District();
SqlComn_DistrictProvider sqlComn_DistrictProvider = new SqlComn_DistrictProvider();
comn_District = sqlComn_DistrictProvider.GetComn_DistrictByID(id);
return(comn_District);
}
public int InsertComn_District(Comn_District comn_District)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("IEB_InsertComn_District", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Comn_DistrictID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@DistrictID", SqlDbType.Int).Value = comn_District.DistrictID;
cmd.Parameters.Add("@DistrictName", SqlDbType.NVarChar).Value = comn_District.DistrictName;
cmd.Parameters.Add("@BanglaName", SqlDbType.NVarChar).Value = comn_District.BanglaName;
cmd.Parameters.Add("@Devision", SqlDbType.NVarChar).Value = comn_District.Devision;
connection.Open();
int result = cmd.ExecuteNonQuery();
return((int)cmd.Parameters["@Comn_DistrictID"].Value);
}
}
public Comn_District GetComn_DistrictFromReader(IDataReader reader)
{
try
{
Comn_District comn_District = new Comn_District
(
(int)reader["Comn_DistrictID"],
(int)reader["DistrictID"],
reader["DistrictName"].ToString(),
reader["BanglaName"].ToString(),
reader["Devision"].ToString()
);
return(comn_District);
}
catch (Exception ex)
{
return(null);
}
}
public static bool UpdateComn_District(Comn_District comn_District)
{
SqlComn_DistrictProvider sqlComn_DistrictProvider = new SqlComn_DistrictProvider();
return(sqlComn_DistrictProvider.UpdateComn_District(comn_District));
}
public static int InsertComn_District(Comn_District comn_District)
{
SqlComn_DistrictProvider sqlComn_DistrictProvider = new SqlComn_DistrictProvider();
return(sqlComn_DistrictProvider.InsertComn_District(comn_District));
}
