public List<Pelayaran> GetPelayaran() { List<Pelayaran> listPelayaran = null; try { using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString)) { Constant.VisitaJayaPerkasaApplication.anyConnection = false; con.Open(); Constant.VisitaJayaPerkasaApplication.anyConnection = true; using (SqlCommand command = new SqlCommand( "SELECT pelayaran_id, pelayaran.supplier_id, supplier.supplier_name as name FROM [Pelayaran], [supplier] " + "WHERE (pelayaran.deleted is null OR pelayaran.deleted = '0') " + "and ([supplier].deleted is null OR [supplier].deleted = '0') " + "and [supplier].supplier_id = pelayaran.supplier_id " + "ORDER BY name ASC" , con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Pelayaran pelayaran = new Pelayaran(); pelayaran.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); pelayaran.supplierID = Utility.Utility.ConvertToUUID(reader.GetValue(1).ToString()); pelayaran.supplierName = reader.GetString(2); if (listPelayaran == null) listPelayaran = new List<Pelayaran>(); listPelayaran.Add(pelayaran); pelayaran = null; } } } } catch (Exception e) { Logging.Error("SqlPelayaranRepository.cs - GetPelayaran() " + e.Message); } return listPelayaran; }
public Pelayaran GetPelayaranBySupplierID(string supplierId) { Pelayaran pelayaran = null; try { using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString)) { Constant.VisitaJayaPerkasaApplication.anyConnection = false; con.Open(); Constant.VisitaJayaPerkasaApplication.anyConnection = true; using (SqlCommand command = new SqlCommand( "Select pelayaran_id, p.supplier_id, supplier_name From Pelayaran p, Supplier s " + "where p.supplier_id = s.supplier_id and (p.deleted is null or p.deleted = '0') and " + "p.supplier_id = '" + supplierId+ "'" , con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pelayaran = new Pelayaran(); pelayaran.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); pelayaran.supplierID = Utility.Utility.ConvertToUUID(reader.GetValue(1).ToString()); pelayaran.supplierName = reader.GetString(2); } } } } catch (Exception e) { Logging.Error("SqlPelayaranRepository.cs - GetPelayaranBySupplierID() " + e.Message); } return pelayaran; }
public Pelayaran CheckPelayaranForEdit(SqlParameter[] sqlParam) { Pelayaran pelayaran = null; try { using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString)) { Constant.VisitaJayaPerkasaApplication.anyConnection = false; con.Open(); Constant.VisitaJayaPerkasaApplication.anyConnection = true; using (SqlCommand command = new SqlCommand( "SELECT TOP 1 pelayaran_id, pelayaran.supplier_id, supplier.supplier_name FROM [Pelayaran], [supplier] " + "WHERE pelayaran.supplier_id = supplier.supplier_id and supplier.supplier_name = " + sqlParam[0].ParameterName, con)) { foreach (SqlParameter tempSqlParam in sqlParam) command.Parameters.Add(tempSqlParam); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { pelayaran = new Pelayaran(); pelayaran.ID = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); pelayaran.supplierID = Utility.Utility.ConvertToUUID(reader.GetValue(1).ToString()); pelayaran.supplierName = reader.GetString(2); } } } } catch (Exception e) { Logging.Error("SqlPelayaranRepository.cs - CheckPelayaranForEdit() " + e.Message); } return pelayaran; }