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