public List<Supplier> ListSuppliers() { List<Supplier> listSupplier = 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 s.supplier_id, s.category_id, s.supplier_name, s.address, s.phone, s.fax, s.email, s.contact_person, c.category_name, s.deleted, s.TypeOfPaymentId, s.TermOfPayment FROM [Supplier] s JOIN [CATEGORY] c " + "ON (s.deleted is null OR s.deleted = '0') AND (c.deleted is null OR c.deleted = '0') AND s.category_id = c.category_id", con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Supplier supplier = new Supplier(); supplier.Id = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); supplier.CategoryId = Utility.Utility.ConvertToUUID(reader.GetValue(1).ToString()); supplier.SupplierName = (Utility.Utility.IsDBNull(reader.GetValue(2))) ? null : reader.GetString(2); supplier.Address = (Utility.Utility.IsDBNull(reader.GetValue(3))) ? null : reader.GetString(3); supplier.Phone = (Utility.Utility.IsDBNull(reader.GetValue(4))) ? null : reader.GetString(4); supplier.Fax = (Utility.Utility.IsDBNull(reader.GetValue(5))) ? null : reader.GetString(5); supplier.Email = (Utility.Utility.IsDBNull(reader.GetValue(6))) ? null : reader.GetString(6); supplier.ContactPerson = (Utility.Utility.IsDBNull(reader.GetValue(7))) ? null : reader.GetString(7); supplier.CategoryName = (Utility.Utility.IsDBNull(reader.GetValue(8))) ? null : reader.GetString(8); if(! (Utility.Utility.IsDBNull(reader.GetValue(10)))) supplier.TypeOfPayment = Utility.Utility.ConvertToUUID(reader.GetValue(10).ToString()); supplier.TermOfPayment = (Utility.Utility.IsDBNull(reader.GetValue(11))) ? null : reader.GetString(11); if (listSupplier == null) listSupplier = new List<Supplier>(); listSupplier.Add(supplier); supplier = null; } } } } catch (Exception e) { Logging.Error("SqlSupplierRepository.cs - ListSuppliers() " + e.Message); } return listSupplier; }
public List<Supplier> GetSupplier(Guid ID) { List<Supplier> listSupplier = 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 supplier_id, supplier_name FROM SUPPLIER " + "WHERE (deleted is null OR deleted = '0') AND category_id like '" + ID + "' ORDER BY supplier_name ASC" , con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Supplier supplier = new Supplier(); supplier.Id = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); supplier.SupplierName = reader.GetString(1); if (listSupplier == null) listSupplier = new List<Supplier>(); listSupplier.Add(supplier); supplier = null; } } } } catch (Exception e) { Logging.Error("SqlPriceListRepository.cs - GetSupplier() " + e.Message); } return listSupplier; }
public SupplierEdit(VisitaJayaPerkasa.Entities.Supplier supplier) { InitializeComponent(); sqlCategoryRepository = new SqlCategoryRepository(); sqlPaymentRepository = new SqlPaymentRepository(); sqlCityRepository = new SqlCityRepository(); List<Category> listCategory = sqlCategoryRepository.GetCategories(); List<Payment> listPayment = sqlPaymentRepository.GetListPayment(); List<Entities.City> listCity = sqlCityRepository.GetCity(); cboCategory.DataSource = listCategory; cboCategory.DisplayMember = "CategoryName"; cboCategory.ValueMember = "ID"; cbTypeOfPayment.DataSource = listPayment; cbTypeOfPayment.DisplayMember = "Name"; cbTypeOfPayment.ValueMember = "ID"; cboDestination.DataSource = listCity; cboDestination.DisplayMember = "CityName"; cboDestination.ValueMember = "ID"; cboDestination.SelectedIndex = -1; cboDestination.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; this.supplier = supplier; this.isSaveMasterSupplierDetail = false; sqlCityRepository = null; sqlPaymentRepository = null; if (supplier == null) { if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); wantToCreateVessel = true; listSupplierDetail = new List<Entities.SupplierDetail>(); cboCategory.SelectedIndex = -1; cboCategory.Text = "-- Choose --"; cbTypeOfPayment.SelectedIndex = -1; cbTypeOfPayment.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; } else { wantToCreateVessel = false; etSupplierName.Text = supplier.SupplierName; cboCategory.SelectedItem = supplier.CategoryName; if (supplier.TypeOfPayment == null) { cbTypeOfPayment.SelectedIndex = -1; cbTypeOfPayment.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; } else cbTypeOfPayment.SelectedValue = supplier.TypeOfPayment; etTermOfPayment.Text = supplier.TermOfPayment; etAddress.Text = supplier.Address; etEmail.Text = supplier.Email; etPhone.Text = supplier.Phone; etFax.Text = supplier.Fax; etContactPerson.Text = supplier.ContactPerson; SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository(); listSupplierDetail = sqlSupplierRepository.ListSupplierDetail(supplier.Id); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (listSupplierDetail != null) supplierDetailGridView.DataSource = listSupplierDetail; else listSupplierDetail = new List<VisitaJayaPerkasa.Entities.SupplierDetail>(); if (supplier.CategoryName.Equals("Trucking")) { List<string> listTemp = sqlSupplierRepository.ListTruckingNumber(supplier.Id); if(listTemp != null) for (int i = 0; i < listTemp.Count; i++) gvTrucking.Rows.Add(listTemp.ElementAt(i)); listTemp = null; } else if (supplier.CategoryName.Equals("Dooring Agent")) { List<Entities.City> listTemp = sqlSupplierRepository.ListCitySupplier(supplier.Id); groupBoxDestination.Visible = true; if (listTemp != null) for (int i = 0; i < listTemp.Count; i++) { gvDestination.Rows.AddNew(); GridViewDataRowInfo gridViewRow = gvDestination.Rows[i]; gridViewRow.Cells["ID"].Value = listTemp.ElementAt(i).ID.ToString(); gridViewRow.Cells["CityName"].Value = listTemp.ElementAt(i).CityName; } listTemp = null; } sqlSupplierRepository = null; } }
public List<Supplier> GetListSupplierForRecipient() { List<Supplier> listSupplier = 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 s.supplier_id, s.supplier_name FROM [Supplier] s WHERE (s.deleted is null OR s.deleted = '0') ", con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Supplier supplier = new Supplier(); supplier.Id = Utility.Utility.ConvertToUUID(reader.GetValue(0).ToString()); supplier.SupplierName = (Utility.Utility.IsDBNull(reader.GetValue(1))) ? null : reader.GetString(1); if (listSupplier == null) listSupplier = new List<Supplier>(); listSupplier.Add(supplier); supplier = null; } } } } catch (Exception e) { Logging.Error("SqlSupplierRepository.cs - GetListSupplierForRecipient() " + e.Message); } return listSupplier; }