public CustomerEdit(VisitaJayaPerkasa.Entities.Customer customer)
        {
            InitializeComponent();
            this.customer = customer;

            if (customer == null)
            {
                wantToCreateVessel = true;
                listCustomerDetail = new List<Entities.CustomerDetail>();
            }
            else
            {
                wantToCreateVessel = false;
                etCustomerName.Text = customer.CustomerName;
                etOffice.Text = customer.Office;
                etAddress.Text = customer.Address;
                etEmail.Text = customer.Email;
                etPhone.Text = customer.Phone;
                etFax.Text = customer.Fax;
                etContactPerson.Text = customer.ContactPerson;
                chkStatusPPN.Checked = Convert.ToBoolean(customer.StatusPPN);

                SqlCustomerRepository sqlCustomerRepository = new SqlCustomerRepository();
                listCustomerDetail = sqlCustomerRepository.ListCustomerDetail(customer.ID);

                if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                else if (listCustomerDetail != null)
                    CustomerDetailGridView.DataSource = listCustomerDetail;
                else
                    listCustomerDetail = new List<VisitaJayaPerkasa.Entities.CustomerDetail>();

                sqlCustomerRepository = null;
            }
        }
        public TypeContView(VisitaJayaPerkasa.Entities.TypeCont typeCont)
        {
            InitializeComponent();

            lblTypeCode.Text = Utility.Utility.DisplayNullValues(typeCont.TypeCode);
            lblTypeName.Text = Utility.Utility.DisplayNullValues(typeCont.TypeName);
        }
Example #3
0
        public CityView(VisitaJayaPerkasa.Entities.City city)
        {
            InitializeComponent();

            lblCityCode.Text = Utility.Utility.DisplayNullValues(city.CityCode);
            lblCityName.Text = Utility.Utility.DisplayNullValues(city.CityName);
            lblDays.Text = Utility.Utility.DisplayNullValues(city.Days.ToString());
        }
        public RecipientView(VisitaJayaPerkasa.Entities.Recipient recipient)
        {
            InitializeComponent();

            lblRecipientName.Text = recipient.Name;
            lblAddress.Text = recipient.Address;
            lblPhone1.Text = recipient.Phone1;
            lblPhone2.Text = recipient.Phone2;
            lblPhone3.Text = recipient.Phone3;
        }
        public TypeContEdit(VisitaJayaPerkasa.Entities.TypeCont typeCont)
        {
            InitializeComponent();
            this.typeCont = typeCont;

            if (typeCont == null)
                wantToCreateVessel = true;
            else {
                wantToCreateVessel = false;
                etTypeCode.Text = typeCont.TypeCode;
                etTypeName.Text = typeCont.TypeName;
            }
        }
        public PelayaranView(VisitaJayaPerkasa.Entities.Pelayaran pelayaran)
        {
            InitializeComponent();
            sqlPelayaranRepository = new SqlPelayaranRepository();
            listPelayaranDetail = sqlPelayaranRepository.ListPelayaranDetail(pelayaran.ID);

            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            else if (listPelayaranDetail != null)
                PelayaranDetailGridView.DataSource = listPelayaranDetail;


            lblPelayaranName.Text = pelayaran.supplierName;
        }
        public CustomerTransView(VisitaJayaPerkasa.Entities.CustomerTrans customerTrans)
        {
            InitializeComponent();
            sqlCustomerTransRepository = new SqlCustomerTransRepository();
            listCustomerTransDetail = sqlCustomerTransRepository.ListCustomerTransDetail(customerTrans.CustomerTransID);

            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            else if (listCustomerTransDetail != null)
                CustomerTransDetailGridView.DataSource = listCustomerTransDetail;


            lblCustomerName.Text = customerTrans.CustomerName;
            lblDate.Text = Utility.Utility.GetDateOnly(Utility.Utility.ChangeDateMMDD(customerTrans.TransDate.ToString()));
        }
Example #8
0
        public CityEdit(VisitaJayaPerkasa.Entities.City city)
        {
            InitializeComponent();
            this.city = city;

            if (city == null)
            {
                wantToCreateCity = true;
            }
            else
            {
                wantToCreateCity = false;
                etCityCode.Text = city.CityCode;
                etCityName.Text = city.CityName;
                etDays.Text = city.Days.ToString();
            }
        }
        public ScheduleView(VisitaJayaPerkasa.Entities.Schedule tempSchedule)
        {
            InitializeComponent();
            
            lblTujuan.Text = tempSchedule.berangkatTujuan;
            lblKapal.Text = tempSchedule.namaKapal;
            lblVOY.Text = tempSchedule.voy;
            lblKeterangan.Text = tempSchedule.keterangan;

            lblETD.Text =  Utility.Utility.ConvertDateToString(tempSchedule.etd);
            if (tempSchedule.unLoading != null)
                lblUnLoading.Text = Utility.Utility.ConvertDateToString(tempSchedule.unLoading.Value);

            lblRB20.Text = tempSchedule.ro_begin_20.ToString();
            lblRB40.Text = tempSchedule.ro_begin_40.ToString();
            lblRE20.Text = tempSchedule.ro_end_20.ToString();
            lblRE40.Text = tempSchedule.ro_end_40.ToString();
        }
Example #10
0
        public CustomerView(VisitaJayaPerkasa.Entities.Customer customer)
        {
            InitializeComponent();
            sqlCustomerRepository = new SqlCustomerRepository();
            listCustomerDetail = sqlCustomerRepository.ListCustomerDetail(customer.ID);

            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            else if (listCustomerDetail != null)
                CustomerDetailGridView.DataSource = listCustomerDetail;


            lblCustomerName.Text = customer.CustomerName;
            lblOffice.Text = customer.Office;
            lblAddres.Text = customer.Address;
            lblEmail.Text = customer.Email;
            lblPhone.Text = customer.Phone;
            lblFax.Text = customer.Fax;
            lblContactPerson.Text = customer.ContactPerson;
        }
        public PelayaranEdit(VisitaJayaPerkasa.Entities.Pelayaran pelayaran, UserControl ucSupplier)
        {
            InitializeComponent();
            this.ucSupplier = ucSupplier;
            this.pelayaran = pelayaran;
            List<VisitaJayaPerkasa.Entities.Supplier> listSupplier;
            SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository();
            listSupplier = sqlSupplierRepository.ListSuppliers();
            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);


            cbSupplier.DataSource = listSupplier;
            cbSupplier.DisplayMember = "SupplierName";
            cbSupplier.ValueMember = "Id";

            if (pelayaran == null)
            {
                wantToCreateVessel = true;
                listPelayaranDetail = new List<Entities.PelayaranDetail>();

                cbSupplier.SelectedValue = ((SupplierEdit)ucSupplier).newGuid;
            }
            else
            {
                wantToCreateVessel = false;
                cbSupplier.SelectedValue = pelayaran.supplierID;

                SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository();
                listPelayaranDetail = sqlPelayaranRepository.ListPelayaranDetail(pelayaran.ID);

                if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                else if (listPelayaranDetail != null)
                    PelayaranDetailGridView.DataSource = listPelayaranDetail;
                else
                    listPelayaranDetail = new List<VisitaJayaPerkasa.Entities.PelayaranDetail>();

                sqlPelayaranRepository = null;
            }
        }
Example #12
0
        public ScheduleEdit(VisitaJayaPerkasa.Entities.Schedule schedule)
        {
            InitializeComponent();
            sqlCityRepository = new SqlCityRepository();
            sqlPelayaranRepository = new SqlPelayaranRepository();
            this.schedule = schedule;

            List<VisitaJayaPerkasa.Entities.City> listCity = sqlCityRepository.GetCity();
            List<VisitaJayaPerkasa.Entities.PelayaranDetail> listPelayaran = sqlPelayaranRepository.GetVessels();
            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);

            cboTujuan.DataSource = listCity;
            cboTujuan.DisplayMember = "CityName";
            cboTujuan.ValueMember = "ID";

            cboKapal.DataSource = listPelayaran;
            cboKapal.DisplayMember = "VesselName";
            cboKapal.ValueMember = "VesselCodeAndPelayaranID";

            if (schedule == null)
            {
                wantToCreateVessel = true;

                cboTujuan.SelectedIndex = -1;
                cboTujuan.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText;
                cboKapal.SelectedIndex = -1;
                cboKapal.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText;

                lblETA.Visible = false;
                lblTA.Visible = false;
                lblTD.Visible = false;
                lblUnloading.Visible = false;
                pickerETA.Visible = false;
                pickerTA.Visible = false;
                pickerTD.Visible = false;
                pickerUnLoading.Visible = false;

                pickerETD.Value = DateTime.Now;
                pickerUnLoading.Value = DateTime.Now;
                pickerTglClosing.Value = DateTime.Now;
            }
            else {
                wantToCreateVessel = false;
                 
                DialogResult dResult = MessageBox.Show(this, "Are you sure want to edit TD, TA and etc ? ", "Confirmation", MessageBoxButtons.YesNo);
                if (dResult == DialogResult.Yes)
                    wantToEditTdETC = true;
                else
                    wantToEditTdETC = false;


                cboTujuan.SelectedItem = schedule.berangkatTujuan;
                cboKapal.SelectedItem = schedule.namaKapal;

                etVOY.Text = schedule.voy;

                pickerETD.Value = schedule.etd;
                pickerUnLoading.Value = schedule.unLoading.GetValueOrDefault(DateTime.Now);
                pickerTglClosing.Value = schedule.tglclosing;

                etRObegin20.Text = schedule.ro_begin_20.ToString();
                etRObegin40.Text = schedule.ro_begin_40.ToString();
                etKet.Text = schedule.keterangan;

                lblETA.Visible = true;
                lblTA.Visible = true;
                lblTD.Visible = true;
                pickerETA.Visible = true;
                pickerTA.Visible = true;
                pickerTD.Visible = true;
                
                pickerETA.Value = DateTime.Now;
                pickerTA.Value = DateTime.Now;
                pickerTD.Value = DateTime.Now;


                if (wantToEditTdETC)
                {
                    cboTujuan.Enabled = false;
                    cboKapal.Enabled = false;
                    etVOY.Enabled = false;
                    pickerETD.Enabled = false;
                    pickerTglClosing.Enabled = false;
                    pickerUnLoading.Enabled = false;
                    etRObegin20.Enabled = false;
                    etRObegin40.Enabled = false;
                    etKet.Enabled = false;


                    VisitaJayaPerkasa.Entities.City tempCity = sqlCityRepository.GetCityByID(cboTujuan.SelectedValue.ToString());
                    if (tempCity.Deleted == 1)
                        MessageBox.Show(this, "ETA not same like city, because city has already be deleted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    else
                    {
                        pickerETA.Value = DateTime.Now.AddDays(tempCity.Days);
                        pickerTA.Value = DateTime.Now.AddDays(tempCity.Days);
                    }

                    tempCity = null;
                }
                else {
                    lblETA.Visible = false;
                    lblTA.Visible = false;
                    lblTD.Visible = false;

                    pickerETA.Visible = false;
                    pickerTA.Visible = false;
                    pickerTD.Visible = false;
                }
            }

            listCity = null;
            sqlCityRepository = null;
         }
Example #13
0
        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 CustomerTransEdit(VisitaJayaPerkasa.Entities.CustomerTrans customerTrans)
        {
            InitializeComponent();
            this.customerTrans = customerTrans;
            
            sqlCustomerRepository = new SqlCustomerRepository();
            sqlTypeContRepository = new SqlTypeContRepository();
            sqlCityRepository = new SqlCityRepository();
            sqlPelayaranRepository = new SqlPelayaranRepository();
            sqlConditionRepository = new SqlConditionRepository();
            sqlPriceListRepository = new SqlPriceListRepository();
            sqlWarehouseRepository = new SqlWareHouseRepository();
            sqlRecipientRepository = new SqlRecipientRepository();
            sqlScheduleRepository = new SqlScheduleRepository();
            sqlTruckingRepository = new SqlTruckingRepository();
            sqlJenisBarangRepository = new SqlJenisBarangRepository();

            List<VisitaJayaPerkasa.Entities.Customer> listCustomer = sqlCustomerRepository.ListCustomers();
            List<VisitaJayaPerkasa.Entities.TypeCont> listType = sqlTypeContRepository.GetTypeCont();
            List<VisitaJayaPerkasa.Entities.City> listOrigin = sqlCityRepository.GetCity();
            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
            {
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            List<VisitaJayaPerkasa.Entities.City> listDestination = sqlCityRepository.GetCity();
            List<VisitaJayaPerkasa.Entities.PelayaranDetail> listPelayaran = sqlPelayaranRepository.GetVessels();
            List<VisitaJayaPerkasa.Entities.Schedule> listSchedule = sqlScheduleRepository.ListSchedule();
            List<VisitaJayaPerkasa.Entities.Condition> listCondition = sqlConditionRepository.GetConditions();
            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
            {
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            List<VisitaJayaPerkasa.Entities.WareHouse> listWarehouse;
            List<VisitaJayaPerkasa.Entities.Recipient> listRecipient;
            if (customerTrans != null)
            {
                listWarehouse = (this.customerTrans == null) ? sqlWarehouseRepository.GetWareHouse() : sqlWarehouseRepository.GetWareHouseByCustomer(customerTrans.CustomerID);
                listRecipient = (this.customerTrans == null) ? sqlRecipientRepository.GetRecipient() : sqlRecipientRepository.GetRecipientByCustomer(customerTrans.CustomerID);
            }
            else
            {
                listWarehouse = new List<Entities.WareHouse>();
                listRecipient = new List<Entities.Recipient>();
            }
            List<VisitaJayaPerkasa.Entities.Trucking> listTrucking = new List<Entities.Trucking>();
            List<VisitaJayaPerkasa.Entities.JenisBarang> listJenisBarang = sqlJenisBarangRepository.ListJenisBarang();
            if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
            {
                MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            cboCustomer.DataSource = listCustomer;
            cboCustomer.DisplayMember = "CustomerName";
            cboCustomer.ValueMember = "ID";
            cboCustomer.SelectedIndex = -1;
            cboCustomer.Text = "-- Choose --";
            cboCustomer.Tag = "cboCustomer";
            
            cboType.DataSource = listType;
            cboType.DisplayMember = "TypeName";
            cboType.ValueMember = "ID";
            cboType.SelectedIndex = -1;
            cboType.Text = "-- Choose --";

            cboOrigin.DataSource = listOrigin;
            cboOrigin.DisplayMember = "CityName";
            cboOrigin.ValueMember = "ID";
            cboOrigin.SelectedIndex = -1;
            cboOrigin.Text = "-- Choose --";

            cboDestination.DataSource = listDestination;
            cboDestination.DisplayMember = "CityName";
            cboDestination.ValueMember = "ID";
            cboDestination.SelectedIndex = -1;
            cboDestination.Text = "-- Choose --";

            days = from p in listDestination 
                   select p.Days;

            cboPelayaranDetail.DataSource = listSchedule;
            cboPelayaranDetail.DisplayMember = "namaKapal";
            //cboPelayaranDetail.ValueMember = "ID";
            cboPelayaranDetail.SelectedIndex = -1;
            cboPelayaranDetail.Text = "-- Choose --";

            cboCondition.DataSource = listCondition;
            cboCondition.DisplayMember = "ConditionName";
            cboCondition.ValueMember = "ID";
            cboCondition.SelectedIndex = -1;
            cboCondition.Text = "-- Choose --";

            cboStuffingPlace.DataSource = listWarehouse;
            cboStuffingPlace.DisplayMember = "Address";
            cboStuffingPlace.ValueMember = "Id";
            cboStuffingPlace.SelectedIndex = -1;
            cboStuffingPlace.Text = "-- Choose --";

            cboRecipient.DataSource = listRecipient;
            cboRecipient.DisplayMember = "Name";
            cboRecipient.ValueMember = "ID";
            cboRecipient.SelectedIndex = -1;
            cboRecipient.Text = "-- Choose --";

            cboTrucking.DataSource = listTrucking;
            cboTrucking.DisplayMember = "TruckNo";
            cboTrucking.ValueMember = "ID";
            cboTrucking.SelectedIndex = -1;
            cboTrucking.Text = "-- Choose --";

            cboJenisBarang.DataSource = listJenisBarang;
            cboJenisBarang.DisplayMember = "Nama";
            cboJenisBarang.ValueMember = "Nama";
            cboJenisBarang.SelectedIndex = -1;
            cboJenisBarang.Text = "-- Type or Choose --";

            if (customerTrans == null)
            {
                wantToCreateVessel = true;
                listCustomerTransDetail = new List<Entities.CustomerTransDetail>();
            }
            else
            {
                wantToCreateVessel = false;
                cboCustomer.SelectedValue = customerTrans.CustomerID;
                cboCustomer.Enabled = false;

                SqlCustomerTransRepository sqlCustomerTransRepository = new SqlCustomerTransRepository();
                listCustomerTransDetail = sqlCustomerTransRepository.ListCustomerTransDetail(customerTrans.CustomerTransID);
                ID = customerTrans.CustomerTransID;

                if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
                    MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                else if (listCustomerTransDetail != null)
                    CustomerTransDetailGridView.DataSource = listCustomerTransDetail;
                else
                    listCustomerTransDetail = new List<VisitaJayaPerkasa.Entities.CustomerTransDetail>();

                sqlCustomerTransRepository = null;
            }



            cboCustomer.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged);
            cboType.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged);
            cboDestination.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged);
            cboCondition.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged);


            sqlCustomerRepository = null;
            sqlTypeContRepository = null;
            sqlCityRepository = null;
            sqlPelayaranRepository = null;
            sqlConditionRepository = null;

            if (wantToCreateVessel)
            {
                dtpTD.Visible = false;
                dtpETA.Visible = false;
                dtpTA.Visible = false;
                dtpUnloading.Visible = false;
            }
        }