public void LoadDataInBackground() { sqlPriceRepository = new SqlPriceListRepository(); listPrice = sqlPriceRepository.GetPriceListByCriteria(Utility.Utility.ConvertStringToDate("01/01/1990"), Utility.Utility.ConvertStringToDate("01/01/5555"), "", "", "", "", "", 1, ""); string searchValue = radTextBoxElementSearchWord.Text.ToLower().Trim(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (listPrice != null) { if (!string.IsNullOrEmpty(searchValue)) showListPrice = listPrice.Where(c => c.Item.ToLower().Contains(searchValue)).ToList<VisitaJayaPerkasa.Entities.PriceList>(); else showListPrice = listPrice; } else showListPrice = null; if (showListPrice != null) { totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(showListPrice.Count() / Convert.ToDecimal(pageSize)))); currentPage = 1; } else totalPage = 0; sqlPriceRepository = null; }
public AtkEdit(Entities.PriceList price) { InitializeComponent(); this.price = price; sqlPriceListRepository = new SqlPriceListRepository(); List<Entities.Category> listCategory = sqlPriceListRepository.GetTypeOfSupplier(1); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } categorySupplier = listCategory != null ? listCategory.FirstOrDefault() : null; if (categorySupplier != null) { listSupplier = sqlPriceListRepository.GetSupplier(categorySupplier.ID); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } cbSupplier.Enabled = true; cbSupplier.DataSource = listSupplier; cbSupplier.DisplayMember = "SupplierName"; cbSupplier.ValueMember = "Id"; cbSupplier.SelectedIndex = -1; cbSupplier.Text = "-- Choose --"; if (this.price == null) { pickerDate.Value = DateTime.Now; wantToCreateNew = true; } else { cbSupplier.SelectedValue = price.SupplierID; if (cbSupplier.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText) || cbSupplier.Text.Equals("")) radButtonElement1.Enabled = false; pickerDate.Value = price.DateFrom; etItem.Text = price.Item; etPrice.Text = price.PriceSupplier.ToString(); wantToCreateNew = false; } } listCategory = null; sqlPriceListRepository = null; }
private void radButtonElementRemove_Click(object sender, EventArgs e) { if (AtkGridView.SelectedRows.Count == 1) { sqlPriceRepository = new SqlPriceListRepository(); DialogResult dResult = MessageBox.Show(this, "Are you sure want delete this data ? ", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { GridViewRowInfo gridInfo = AtkGridView.SelectedRows.First(); string id = gridInfo.Cells[0].Value.ToString(); if (sqlPriceRepository.DeletePrice(Utility.Utility.ConvertToUUID(id))) { MessageBox.Show("Data Deleted !"); LoadData(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show("Cannot Delete Data !"); } sqlPriceRepository = null; } }
private void btnSaveGrid_Click(object sender, EventArgs e) { if (PriceListGridView.RowCount > 0) { List<VisitaJayaPerkasa.Entities.PriceList> tempPriceList = new List<VisitaJayaPerkasa.Entities.PriceList>(); if (cboTypeSupplier.Text.ToLower().Equals("shipping lines")) { for (int i = 0; i < PriceListGridView.RowCount; i++) { VisitaJayaPerkasa.Entities.PriceList objPriceList = new VisitaJayaPerkasa.Entities.PriceList(); string id = (PriceListGridView.Rows[i].Cells[0].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[0].Value.ToString(); objPriceList.ID = Utility.Utility.ConvertToUUID(id); id = (PriceListGridView.Rows[i].Cells[1].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[1].Value.ToString(); objPriceList.DateFrom = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateFrom.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date from in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[2].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[2].Value.ToString(); objPriceList.DateTo = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateTo.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date to in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[5].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[5].Value.ToString(); objPriceList.TypeID = Utility.Utility.ConvertToUUID(id); if (objPriceList.TypeID.ToString().Equals(Guid.Empty.ToString())) { MessageBox.Show(this, "Please fill type in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[6].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[6].Value.ToString(); objPriceList.ConditionID = Utility.Utility.ConvertToUUID(id); if (objPriceList.ConditionID.ToString().Equals(Guid.Empty)) { MessageBox.Show(this, "Please fill condition in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[9].Value.ToString().Equals("")) ? "-1" : PriceListGridView.Rows[i].Cells[9].Value.ToString(); objPriceList.PriceSupplier = Utility.Utility.ConvertStringToDecimal(id); if (objPriceList.PriceSupplier.ToString().Equals("-1")) { MessageBox.Show(this, "Please fill price supplier in line and check your price in line " + i, "Information"); return; } if (objPriceList.DateFrom.Date > objPriceList.DateTo.Date) { MessageBox.Show(this, "Please correct datefrom and dateto in line " + i, "Information"); return; } tempPriceList.Add(objPriceList); objPriceList = null; } for (int i = 0; i < tempPriceList.Count; i++) { for (int j = i+1; j < tempPriceList.Count; j++) { if ( ( tempPriceList.ElementAt(i).TypeID.ToString().Equals(tempPriceList.ElementAt(j).TypeID.ToString()) && tempPriceList.ElementAt(i).ConditionID.ToString().Equals(tempPriceList.ElementAt(j).ConditionID.ToString()) ) && ( ( tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateTo >= tempPriceList.ElementAt(j).DateFrom ) || ( tempPriceList.ElementAt(i).DateFrom >= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateTo ) ) ) { MessageBox.Show(this, "Please fix record - " + i + " and record -" + j + " have same record of date, type and condition. Please remove one", "Information"); return; } } } sqlPriceListRepository = new SqlPriceListRepository(); listPriceDeleteExistsData.Clear(); listIndexPriceDeleteExistsData.Clear(); List<int> indexDeleted = new List<int>(); for (int i = 0; i < tempPriceList.Count; i++) { Guid exists = Guid.Empty; exists = sqlPriceListRepository.GetPriceCustomerByShippingLines(tempPriceList.ElementAt(i).DateFrom, tempPriceList.ElementAt(i).DateTo, tempPriceList.ElementAt(i).TypeID.ToString(), tempPriceList.ElementAt(i).ConditionID.ToString(), cbSupplier.SelectedValue.ToString(), cbDestination.SelectedValue.ToString(), searchResultCustomer.ID.ToString()); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (! exists.ToString().Equals(Guid.Empty.ToString())) { DialogResult dResult = MessageBox.Show(this, "Record - " + i + " has already exist. \n If you don't want to override this data, so your data not will be save. \n Do you want to override ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes){ listPriceDeleteExistsData.Add(exists); listIndexPriceDeleteExistsData.Add(i); } else indexDeleted.Add(i); } } for (int i = indexDeleted.Count - 1; i >= 0; i--) tempPriceList.RemoveAt(indexDeleted.ElementAt(i)); for (int i = 0; i < listPriceDeleteExistsData.Count; i++) { for (int j = i+1; j < listPriceDeleteExistsData.Count; j++) { if (listPriceDeleteExistsData.ElementAt(i) == listPriceDeleteExistsData.ElementAt(j)) { MessageBox.Show(this, "Please fix record -" + listIndexPriceDeleteExistsData.ElementAt(i) + " and record -" + listIndexPriceDeleteExistsData.ElementAt(j) + " have same record of date, type and condition. Please remove one", "Information"); return; } } } sqlPriceListRepository = null; } else if (cboTypeSupplier.Text.ToLower().Equals("dooring agent")) { for (int i = 0; i < PriceListGridView.RowCount; i++) { VisitaJayaPerkasa.Entities.PriceList objPriceList = new VisitaJayaPerkasa.Entities.PriceList(); string id = (PriceListGridView.Rows[i].Cells[0].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[0].Value.ToString(); objPriceList.ID = Utility.Utility.ConvertToUUID(id); id = (PriceListGridView.Rows[i].Cells[1].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[1].Value.ToString(); objPriceList.DateFrom = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateFrom.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date from in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[2].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[2].Value.ToString(); objPriceList.DateTo = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateTo.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date to in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[5].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[5].Value.ToString(); objPriceList.TypeID = Utility.Utility.ConvertToUUID(id); if (objPriceList.TypeID.ToString().Equals(Guid.Empty.ToString())) { MessageBox.Show(this, "Please fill type in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[9].Value.ToString().Equals("")) ? "-1" : PriceListGridView.Rows[i].Cells[9].Value.ToString(); objPriceList.PriceSupplier = Utility.Utility.ConvertStringToDecimal(id); if (objPriceList.PriceSupplier.ToString().Equals("-1")) { MessageBox.Show(this, "Please fill price supplier in line and check your price in line " + i, "Information"); return; } if (objPriceList.DateFrom.Date > objPriceList.DateTo.Date) { MessageBox.Show(this, "Please correct datefrom and dateto in line " + i, "Information"); return; } tempPriceList.Add(objPriceList); objPriceList = null; } for (int i = 0; i < tempPriceList.Count; i++) { for (int j = i + 1; j < tempPriceList.Count; j++) { if ( ( tempPriceList.ElementAt(i).TypeID.ToString().Equals(tempPriceList.ElementAt(j).TypeID.ToString()) ) && ( ( tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateTo >= tempPriceList.ElementAt(j).DateFrom ) || ( tempPriceList.ElementAt(i).DateFrom >= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateTo ) ) ) { MessageBox.Show(this, "Please fix record - " + i + " and record -" + j + " have same record of date and type. Please remove one", "Information"); return; } } } sqlPriceListRepository = new SqlPriceListRepository(); listPriceDeleteExistsData.Clear(); listIndexPriceDeleteExistsData.Clear(); List<int> indexDeleted = new List<int>(); for (int i = 0; i < tempPriceList.Count; i++) { Guid exists = Guid.Empty; exists = sqlPriceListRepository.GetPriceCustomerByDooringAgent( tempPriceList.ElementAt(i).DateFrom, tempPriceList.ElementAt(i).DateTo, tempPriceList.ElementAt(i).TypeID.ToString(), cbSupplier.SelectedValue.ToString(), cbDestination.SelectedValue.ToString(), cboRecipient.SelectedValue.ToString()); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (!exists.ToString().Equals(Guid.Empty.ToString())) { DialogResult dResult = MessageBox.Show(this, "Record - " + i + " has already exist. \n If you don't want to override this data, so your data not will be save. \n Do you want to override ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes){ listPriceDeleteExistsData.Add(exists); listIndexPriceDeleteExistsData.Add(i); } else indexDeleted.Add(i); } } for (int i = indexDeleted.Count - 1; i >= 0; i--) tempPriceList.RemoveAt(indexDeleted.ElementAt(i)); for (int i = 0; i < listPriceDeleteExistsData.Count; i++) { for (int j = i + 1; j < listPriceDeleteExistsData.Count; j++) { if (listPriceDeleteExistsData.ElementAt(i) == listPriceDeleteExistsData.ElementAt(j)) { MessageBox.Show(this, "Please fix record -" + listIndexPriceDeleteExistsData.ElementAt(i) + " and record -" + listIndexPriceDeleteExistsData.ElementAt(j) + " have same record of date and type. Please remove one", "Information"); return; } } } sqlPriceListRepository = null; } else if (cboTypeSupplier.Text.ToLower().Equals("trucking")) { for (int i = 0; i < PriceListGridView.RowCount; i++) { VisitaJayaPerkasa.Entities.PriceList objPriceList = new VisitaJayaPerkasa.Entities.PriceList(); string id = (PriceListGridView.Rows[i].Cells[0].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[0].Value.ToString(); objPriceList.ID = Utility.Utility.ConvertToUUID(id); id = (PriceListGridView.Rows[i].Cells[1].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[1].Value.ToString(); objPriceList.DateFrom = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateFrom.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date from in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[2].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : PriceListGridView.Rows[i].Cells[2].Value.ToString(); objPriceList.DateTo = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateTo.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date to in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[5].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[5].Value.ToString(); objPriceList.TypeID = Utility.Utility.ConvertToUUID(id); if (objPriceList.TypeID.ToString().Equals(Guid.Empty.ToString())) { MessageBox.Show(this, "Please fill type in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[9].Value.ToString().Equals("")) ? "-1" : PriceListGridView.Rows[i].Cells[9].Value.ToString(); objPriceList.PriceSupplier = Utility.Utility.ConvertStringToDecimal(id); if (objPriceList.PriceSupplier.ToString().Equals("-1")) { MessageBox.Show(this, "Please fill price supplier in line and check your price in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[12].Value.ToString().Equals("")) ? "-1" : PriceListGridView.Rows[i].Cells[12].Value.ToString(); objPriceList.PriceCourier = Utility.Utility.ConvertStringToDecimal(id); if (objPriceList.PriceCourier.ToString().Equals("-1")) { MessageBox.Show(this, "Please fill price courier in line and check your price in line " + i, "Information"); return; } if (objPriceList.DateFrom.Date > objPriceList.DateTo.Date) { MessageBox.Show(this, "Please correct datefrom and dateto in line " + i, "Information"); return; } tempPriceList.Add(objPriceList); objPriceList = null; } for (int i = 0; i < tempPriceList.Count; i++) { for (int j = i + 1; j < tempPriceList.Count; j++) { if ( ( tempPriceList.ElementAt(i).TypeID.ToString().Equals(tempPriceList.ElementAt(j).TypeID.ToString()) ) && ( ( tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateTo >= tempPriceList.ElementAt(j).DateFrom ) || ( tempPriceList.ElementAt(i).DateFrom >= tempPriceList.ElementAt(j).DateFrom && tempPriceList.ElementAt(i).DateFrom <= tempPriceList.ElementAt(j).DateTo ) ) ) { MessageBox.Show(this, "Please fix record - " + i + " and record -" + j + " have same record of date and type. Please remove one", "Information"); return; } } } sqlPriceListRepository = new SqlPriceListRepository(); listPriceDeleteExistsData.Clear(); listIndexPriceDeleteExistsData.Clear(); List<int> indexDeleted = new List<int>(); for (int i = 0; i < tempPriceList.Count; i++) { Guid exists = Guid.Empty; exists = sqlPriceListRepository.GetPriceCustomerByTrucking(tempPriceList.ElementAt(i).DateFrom, tempPriceList.ElementAt(i).DateTo, tempPriceList.ElementAt(i).TypeID.ToString(), cbSupplier.SelectedValue.ToString(), searchResultCustomer.ID.ToString(), cboStuffingPlace.SelectedValue.ToString()); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (!exists.ToString().Equals(Guid.Empty.ToString())) { DialogResult dResult = MessageBox.Show(this, "Record - " + i + " has already exist. \n If you don't want to override this data, so your data not will be save. \n Do you want to override ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes){ listPriceDeleteExistsData.Add(exists); listIndexPriceDeleteExistsData.Add(i); } else indexDeleted.Add(i); } } for (int i = indexDeleted.Count - 1; i >= 0; i--) tempPriceList.RemoveAt(indexDeleted.ElementAt(i)); for (int i = 0; i < listPriceDeleteExistsData.Count; i++) { for (int j = i + 1; j < listPriceDeleteExistsData.Count; j++) { if (listPriceDeleteExistsData.ElementAt(i) == listPriceDeleteExistsData.ElementAt(j)) { MessageBox.Show(this, "Please fix record -" + listIndexPriceDeleteExistsData.ElementAt(i) + " and record -" + listIndexPriceDeleteExistsData.ElementAt(j) + " have same record of date and type. Please remove one", "Information"); return; } } } sqlPriceListRepository = null; } /* else if (cboTypeSupplier.Text.ToLower().Equals("general")) { for (int i = 0; i < PriceListGridView.RowCount; i++) { VisitaJayaPerkasa.Entities.PriceList objPriceList = new VisitaJayaPerkasa.Entities.PriceList(); string id = (PriceListGridView.Rows[i].Cells[0].Value.ToString().Equals("")) ? Guid.Empty.ToString() : PriceListGridView.Rows[i].Cells[0].Value.ToString(); objPriceList.ID = Utility.Utility.ConvertToUUID(id); id = (PriceListGridView.Rows[i].Cells[1].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : Utility.Utility.ChangeDateMMDD(PriceListGridView.Rows[i].Cells[1].Value.ToString()); objPriceList.DateFrom = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateFrom.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date from in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[2].Value.ToString().Equals("")) ? Utility.Utility.DefaultDateTime().ToString() : Utility.Utility.ChangeDateMMDD(PriceListGridView.Rows[i].Cells[2].Value.ToString()); objPriceList.DateFrom = Utility.Utility.ConvertStringToDate(id); if (objPriceList.DateFrom.ToString().Equals(Utility.Utility.DefaultDateTime().ToString())) { MessageBox.Show(this, "Please fill date to in line " + i, "Information"); return; } id = (PriceListGridView.Rows[i].Cells[8].Value.ToString().Equals("")) ? "-1" : PriceListGridView.Rows[i].Cells[8].Value.ToString(); objPriceList.PriceSupplier = Utility.Utility.ConvertStringToDecimal(id); if (objPriceList.PriceSupplier.ToString().Equals("-1")) { MessageBox.Show(this, "Please fill price supplier in line and check your price in line " + i, "Information"); return; } if (objPriceList.DateFrom.Date > objPriceList.DateTo.Date) { MessageBox.Show(this, "Please correct datefrom and dateto in line " + i, "Information"); return; } tempPriceList.Add(objPriceList); objPriceList = null; } for (int i = 0; i < tempPriceList.Count; i++) { for (int j = i + 1; j < tempPriceList.Count; j++) { if (PriceListGridView.Rows[i].Cells[1].Value.ToString().Equals(PriceListGridView.Rows[j].Cells[1].Value.ToString()) && PriceListGridView.Rows[i].Cells[2].Value.ToString().Equals(PriceListGridView.Rows[j].Cells[2].Value.ToString())) { MessageBox.Show(this, "Record -" + i + " and record -" + j + " have same record of date. Please remove one", "Information"); return; } } } } */ SqlParameter[] sqlParamDeletedPrice = null; SqlParameter[] sqlParamInsert = null; if (listPriceDeleteExistsData.Count > 0) { string[] key = new string[listPriceDeleteExistsData.Count]; object[] value = new object[listPriceDeleteExistsData.Count]; for (int j = 0; j < listPriceDeleteExistsData.Count; j++) { key[j] = "priceID"; value[j] = listPriceDeleteExistsData.ElementAt(j); } sqlParamDeletedPrice = SqlUtility.SetSqlParameter(key, value); } if (tempPriceList.Count > 0) { //14 is field who any in below for string[] key = new string[tempPriceList.Count * 14]; object[] value = new object[tempPriceList.Count * 14]; int nn = 0; for (int j = 0; j < tempPriceList.Count; j++) { key[nn] = "price_id"; value[nn++] = Guid.NewGuid(); key[nn] = "dateFrom"; value[nn++] = tempPriceList.ElementAt(j).DateFrom; key[nn] = "dateTo"; value[nn++] = tempPriceList.ElementAt(j).DateTo; key[nn] = "supplier_id"; if (cbSupplier.SelectedIndex >= 0) value[nn++] = listSupplier[cbSupplier.SelectedIndex].Id; else value[nn++] = Guid.Empty; key[nn] = "destination"; if (cbDestination.SelectedIndex >= 0) value[nn++] = listCity[cbDestination.SelectedIndex].ID; else value[nn++] = Guid.Empty; key[nn] = "type_cont_id"; value[nn++] = tempPriceList.ElementAt(j).TypeID; key[nn] = "condition_id"; value[nn++] = tempPriceList.ElementAt(j).ConditionID; key[nn] = "price_supplier"; value[nn++] = tempPriceList.ElementAt(j).PriceSupplier; key[nn] = "customer_id"; if (searchResultCustomer != null) value[nn++] = searchResultCustomer.ID; else value[nn++] = Guid.Empty; key[nn] = "price_customer"; value[nn++] = tempPriceList.ElementAt(j).PriceCustomer; key[nn] = "stuffing_id"; if (cboStuffingPlace.SelectedIndex >= 0) value[nn++] = listWarehouse[cboStuffingPlace.SelectedIndex].Id; else value[nn++] = Guid.Empty; key[nn] = "recipient_id"; if (cboRecipient.SelectedIndex >= 0) value[nn++] = listRecipient[cboRecipient.SelectedIndex].ID; else value[nn++] = Guid.Empty; key[nn] = "price_courier"; value[nn++] = tempPriceList.ElementAt(j).PriceCourier; key[nn] = "item"; value[nn++] = DBNull.Value; } sqlParamInsert = SqlUtility.SetSqlParameter(key, value); if (sqlPriceListRepository == null) sqlPriceListRepository = new SqlPriceListRepository(); if (sqlPriceListRepository.SavePriceList( (sqlParamDeletedPrice == null) ? null : sqlParamDeletedPrice, sqlParamInsert)) { MessageBox.Show(this, "Success saving !", "Information"); listPriceDeleteExistsData.Clear(); listIndexPriceDeleteExistsData.Clear(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { MessageBox.Show(this, "Failed save data !", "Information"); return; } } PriceListGridView.Rows.Clear(); PriceListGridView.Enabled = false; } }
public PriceList() { InitializeComponent(); sqlPriceListRepository = new SqlPriceListRepository(); sqlCityRepository = new SqlCityRepository(); sqlCustomerRepository = new SqlCustomerRepository(); sqlRecipientRepository = new SqlRecipientRepository(); sqlWareHouseRepository = new SqlWareHouseRepository(); listPriceDeleteExistsData = new List<Guid>(); listIndexPriceDeleteExistsData = new List<int>(); listTypeOfSupplier = sqlPriceListRepository.GetTypeOfSupplier(0); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboTypeSupplier.SelectedValueChanged -= new EventHandler(cboTypeSupplier_SelectedValueChanged); cboTypeSupplier.DataSource = listTypeOfSupplier; cboTypeSupplier.DisplayMember = "CategoryName"; cboTypeSupplier.ValueMember = "ID"; cboTypeSupplier.SelectedIndex = -1; cboTypeSupplier.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; cboTypeSupplier.SelectedValueChanged += new EventHandler(cboTypeSupplier_SelectedValueChanged); listCity = sqlCityRepository.GetCity(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cbDestination.DataSource = listCity; cbDestination.DisplayMember = "CityName"; cbDestination.ValueMember = "ID"; cbDestination.SelectedIndex = -1; cbDestination.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; listRecipient = sqlRecipientRepository.GetRecipient(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboRecipient.DataSource = listRecipient; cboRecipient.DisplayMember = "Name"; cboRecipient.ValueMember = "ID"; cboRecipient.SelectedIndex = -1; cboRecipient.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; listWarehouse = sqlWareHouseRepository.GetWareHouse(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboStuffingPlace.DataSource = listWarehouse; cboStuffingPlace.DisplayMember = "Address"; cboStuffingPlace.ValueMember = "Id"; cboStuffingPlace.SelectedIndex = -1; cboStuffingPlace.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; cbSupplier.Enabled = false; cboRecipient.Enabled = false; cbDislayAll.Visible = false; cbDislayAll.Enabled = false; sqlPriceListRepository = null; PriceListGridView.Enabled = false; sqlCityRepository = null; pickerFrom.Value = DateTime.Today; pickerTo.Value = DateTime.Today; }
private void LoadData() { sqlPriceListRepository = new SqlPriceListRepository(); PriceListGridView.ReadOnly = false; if (cboTypeSupplier.Text.ToLower().Equals("shipping lines")) { listPriceList = sqlPriceListRepository.GetPriceListByCriteria(pickerFrom.Value.Date, pickerTo.Value.Date, cbSupplier.SelectedValue.ToString(), cbDestination.SelectedValue.ToString(), (! cbDislayAll.Checked) ? searchResultCustomer.ID.ToString() : "", "", "", 1, ""); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if(cbDislayAll.Checked) PriceListGridView.ReadOnly = true; } else if (cboTypeSupplier.Text.ToLower().Equals("dooring agent")) { listPriceList = sqlPriceListRepository.GetPriceListByCriteria(pickerFrom.Value.Date, pickerTo.Value.Date, cbSupplier.SelectedValue.ToString(), cbDestination.SelectedValue.ToString(), "", (! cbRecipientDisplay.Checked) ? cboRecipient.SelectedValue.ToString() : "", "", 1, ""); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (cbRecipientDisplay.Checked) PriceListGridView.ReadOnly = true; } else if (cboTypeSupplier.Text.ToLower().Equals("trucking")) { listPriceList = sqlPriceListRepository.GetPriceListByCriteria(pickerFrom.Value.Date, pickerTo.Value.Date, cbSupplier.SelectedValue.ToString(), "", (!cbDislayAll.Checked) ? searchResultCustomer.ID.ToString() : "", "", cboStuffingPlace.SelectedValue.ToString(), 1, ""); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); if (cbDislayAll.Checked) PriceListGridView.ReadOnly = true; } else if (cboTypeSupplier.Text.ToLower().Equals("general")) { listPriceList = sqlPriceListRepository.GetPriceListByCriteria(pickerFrom.Value.Date, pickerTo.Value.Date, cbSupplier.SelectedValue.ToString(), "", "", "", "", 1, ""); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } PriceListGridView.Enabled = true; if (listPriceList != null) { for (int i = 0; i < listPriceList.Count(); i++) { object[] obj = {listPriceList.ElementAt(i).ID, listPriceList.ElementAt(i).DateFrom, listPriceList.ElementAt(i).DateTo, listPriceList.ElementAt(i).SupplierID, listPriceList.ElementAt(i).Destination, listPriceList.ElementAt(i).TypeID, listPriceList.ElementAt(i).ConditionID, listPriceList.ElementAt(i).StuffingID, listPriceList.ElementAt(i).Recipient, listPriceList.ElementAt(i).PriceSupplier, listPriceList.ElementAt(i).CustomerID, listPriceList.ElementAt(i).PriceCustomer, listPriceList.ElementAt(i).PriceCourier }; PriceListGridView.Rows.Add(obj); } } sqlPriceListRepository = null; }
private void RefreshTypeSupplier() { PriceListGridView.Rows.Clear(); PriceListGridView.DataSource = null; PriceListGridView.Enabled = false; sqlPriceListRepository = new SqlPriceListRepository(); listSupplier = sqlPriceListRepository.GetSupplier(Utility.Utility.ConvertToUUID(cboTypeSupplier.SelectedValue.ToString())); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cbSupplier.Enabled = true; cbSupplier.DataSource = listSupplier; cbSupplier.DisplayMember = "SupplierName"; cbSupplier.ValueMember = "Id"; cbSupplier.SelectedIndex = -1; cbSupplier.Text = "-- Choose --"; sqlPriceListRepository = null; }
private void radButtonElement1_Click(object sender, EventArgs e) { //save if (cbSupplier.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) MessageBox.Show(this, "Please choose supplier name", "Information"); else if (etItem.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill item", "Information"); else if (etPrice.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill price", "Information"); else { try { Convert.ToInt32(etPrice.Text.Trim()); } catch (Exception err) { MessageBox.Show(this, "price must be numeric", "Information"); Logging.Error("AtkEdit.cs - " + err.Message); return; } sqlPriceListRepository = new SqlPriceListRepository(); if (wantToCreateNew) { SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "dateFrom", "item", "suplier_id" }, new object[] { Utility.Utility.ChangeDateMMDD(pickerDate.Value.Date.ToString()), etItem.Text.Trim(), cbSupplier.SelectedValue }); if (sqlPriceListRepository.GetExistsDatePriceATK(sqlParam, wantToCreateNew)) { MessageBox.Show(this, "Your data has already exist. \nDelete it first", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } sqlParam = null; SqlParameter[] sqlParamInsert = null; //14 is field who any in below for string[] key = new string[14]; object[] value = new object[14]; int nn = 0; key[nn] = "price_id"; value[nn++] = Guid.NewGuid(); key[nn] = "dateFrom"; value[nn++] = pickerDate.Value; key[nn] = "dateTo"; value[nn++] = DBNull.Value; key[nn] = "supplier_id"; value[nn++] = Utility.Utility.ConvertToUUID(cbSupplier.SelectedValue.ToString()); key[nn] = "destination"; value[nn++] = Guid.Empty; key[nn] = "type_cont_id"; value[nn++] = Guid.Empty; key[nn] = "condition_id"; value[nn++] = Guid.Empty; key[nn] = "price_supplier"; value[nn++] = Convert.ToInt32(etPrice.Text.Trim()); key[nn] = "customer_id"; value[nn++] = Guid.Empty; key[nn] = "price_customer"; value[nn++] = DBNull.Value; key[nn] = "stuffing_id"; value[nn++] = Guid.Empty; key[nn] = "recipient_id"; value[nn++] = Guid.Empty; key[nn] = "price_courier"; value[nn++] = DBNull.Value; key[nn] = "item"; value[nn++] = etItem.Text.Trim(); sqlParamInsert = SqlUtility.SetSqlParameter(key, value); if (sqlPriceListRepository.SavePriceList(null, sqlParamInsert)) { MessageBox.Show(this, "Success saving !", "Information"); radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show(this, "Failed save data !", "Information"); sqlParamInsert = null; } else { SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "dateFrom", "item", "supplier_id", "price_id" }, new object[] { Utility.Utility.ChangeDateMMDD(pickerDate.Value.Date.ToString()), etItem.Text.Trim(), cbSupplier.SelectedValue, this.price.ID }); if (sqlPriceListRepository.GetExistsDatePriceATK(sqlParam, wantToCreateNew)) { MessageBox.Show(this, "Your data has already exist. \nDelete it first", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } sqlParam = null; SqlParameter[] sqlParamEdit = SqlUtility.SetSqlParameter(new string[] { "supplier_id", "dateFrom", "item", "price_supplier", "price_id" }, new object[] { Utility.Utility.ConvertToUUID(cbSupplier.SelectedValue.ToString()), pickerDate.Value.Date, etItem.Text.Trim(), etPrice.Text.Trim(), this.price.ID }); if (sqlPriceListRepository.EditPriceATK(sqlParamEdit)) { MessageBox.Show(this, "Success Edit Price ATK", "Information"); radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot Edit Price ATK", "Information"); } sqlParamEdit = null; } } sqlPriceListRepository = null; }
private void LoadData() { SqlPriceListRepository sqlPriceListRepository = new SqlPriceListRepository(); listPrice = sqlPriceListRepository.GetPriceListByCriteria(pickerFrom.Value.Date, pickerTo.Value.Date, "", cbDestination.SelectedValue.ToString(), searchResultCustomer.ID.ToString(), "", "", 0, cboType.SelectedValue.ToString()); radGridView1.Enabled = true; if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (listPrice != null) { for (int i = 0; i < listPrice.Count(); i++) { object[] obj = {listPrice.ElementAt(i).ID, listPrice.ElementAt(i).DateFrom, listPrice.ElementAt(i).DateTo, listPrice.ElementAt(i).CustomerID, listPrice.ElementAt(i).Destination, listPrice.ElementAt(i).TypeID, listPrice.ElementAt(i).ConditionID, listPrice.ElementAt(i).PriceCustomer }; radGridView1.Rows.Add(obj); } } sqlPriceListRepository = 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; } }