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()));
}
public SearchCustomerTrans()
{
InitializeComponent();
SqlCustomerTransRepository sqlCustomerTransRepository = new SqlCustomerTransRepository();
listCustomerTrans = sqlCustomerTransRepository.ListCustomerTrans();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
{
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
CustomerTransGridView.DataSource = listCustomerTrans;
sqlCustomerTransRepository = null;
}
public RptDeliveryControl()
{
InitializeComponent();
sqlCustomerRepository = new SqlCustomerRepository();
sqlCustomerTransRepository = new SqlCustomerTransRepository();
DateTime datetime = DateTime.Now;
cboMonth.SelectedIndex = datetime.Month-1;
spnYear.Value = datetime.Year;
cboMonth.SelectedIndex = datetime.Month - 1;
spnYear.Value = datetime.Year;
List<VisitaJayaPerkasa.Entities.Customer> listCustomer = sqlCustomerRepository.ListCustomers();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboCustomer.DataSource = listCustomer;
cboCustomer.DisplayMember = "CustomerName";
cboCustomer.ValueMember = "ID";
cboCustomer.SelectedIndex = -1;
cboCustomer.Text = "-- Choose --";
cboCustomer.SelectedIndex = 0;
cboCustomer2.DataSource = listCustomer;
cboCustomer2.DisplayMember = "CustomerName";
cboCustomer2.ValueMember = "ID";
cboCustomer2.SelectedIndex = -1;
cboCustomer2.Text = "-- Choose --";
cboTransDate.SelectedIndex = -1;
cboTransDate.Text = "-- Choose --";
cboTransDetail.SelectedIndex = -1;
cboTransDetail.Text = "-- Choose --";
cboCustomer2.SelectedIndexChanged += new EventHandler(Customer2_SelectedIndexChanged);
cboCustomer2.SelectedIndex = 0;
}
public void LoadData()
{
sqlCustomerTransRepository = new SqlCustomerTransRepository();
listCustomerTrans = null;
string searchValue = radTextBoxElementSearchWord.Text;
string searchKey = radComboBoxElement.Text;
listCustomerTrans = sqlCustomerTransRepository.ListCustomerTrans();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else if (listCustomerTrans != null)
{
if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey))
{
switch (searchKey)
{
case "Customer Name":
showListCustomerTrans = listCustomerTrans.Where(c => c.CustomerName.Contains(searchValue)).ToList<VisitaJayaPerkasa.Entities.CustomerTrans>();
break;
}
}
else
showListCustomerTrans = listCustomerTrans;
}
else
showListCustomerTrans = null;
if (showListCustomerTrans != null)
{
totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(showListCustomerTrans.Count() / Convert.ToDecimal(pageSize))));
currentPage = 1;
}
else
totalPage = 0;
RefreshGrid();
}
private void radButtonElementRemove_Click(object sender, EventArgs e)
{
if (showListCustomerTrans != null)
{
sqlCustomerTransRepository = new SqlCustomerTransRepository();
DialogResult dResult = MessageBox.Show(this, "Are you sure want delete master and detail this customer transaction ? ", "Confirmation", MessageBoxButtons.YesNo);
if (dResult == DialogResult.Yes)
{
GridViewRowInfo gridInfo = CustomerTransGridView.SelectedRows.First();
string id = gridInfo.Cells[0].Value.ToString();
SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "id" }, new object[] { id });
if (sqlCustomerTransRepository.DeleteCustomerTrans(sqlParam))
{
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 !");
sqlParam = null;
}
}
}
public PrintLeadTime(Surat objSurat)
{
InitializeComponent();
this.objSurat = objSurat;
sqlCustomerTransRepository = new SqlCustomerTransRepository();
reportDocument = new ReportDocument();
paramFields = new ParameterFields();
crtLeadTime = new CrtLeadTime();
//Execute Query
String strQry = "Select [CUSTOMER_TRANS_DETAIL].no_container as Column1, " +
"(Select Top 1 address From WareHouse Where stuffing_place_id = stuffing_place) as Column2, " +
"[CUSTOMER_TRANS_DETAIL].terima_toko as Column3 From [CUSTOMER_TRANS_DETAIL] " +
"Join [Customer_Trans] On " +
"[Customer_Trans].tgl_transaksi = cast('" + Utility.Utility.ConvertDateToString(objSurat.Tgl) + "' as date) And " +
"[Customer_Trans].Customer_id = '" + objSurat.CustomerID + "' And " +
"([Customer_Trans].deleted is not null Or [Customer_Trans].deleted = 0) " +
"And [Customer_Trans].id = [Customer_Trans_Detail].customer_trans_id";
int columnNo = 1;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Container";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
columnNo++;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Tgl penerimaan Container";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
columnNo++;
paramField = new ParameterField();
paramField.Name = "col" + columnNo.ToString();
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = "Gudang";
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "noSurat";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = objSurat.NoSurat;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
paramField = new ParameterField();
paramField.Name = "parameterReceive";
paramDiscreteValue = new ParameterDiscreteValue();
paramDiscreteValue.Value = objSurat.CustomerName;
paramField.CurrentValues.Add(paramDiscreteValue);
paramFields.Add(paramField);
crystalReportViewer1.ParameterFieldInfo = paramFields;
SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
SqlDataAdapter da = new SqlDataAdapter(strQry, VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString);
ShippingMainDataSet ds = new ShippingMainDataSet();
da.Fill(ds, "Surat_Lead_Time");
crtLeadTime.SetDataSource(ds);
crystalReportViewer1.ReportSource = crtLeadTime;
}
private void radButtonElement1_Click(object sender, EventArgs e)
{
if (CustomerTransDetailGridView.Rows.Count > 0) {
sqlCustomerTransRepository = new SqlCustomerTransRepository();
if (cboCustomer.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText))
MessageBox.Show(this, "Please choose customer name", "Information");
else {
//51 is number of field below
int k = 0;
string[] key = new string[listCustomerTransDetail.Count * 51];
object[] value = new object[listCustomerTransDetail.Count * 51];
Guid TransID;
if (wantToCreateVessel)
TransID = Guid.NewGuid();
else
TransID = customerTrans.CustomerTransID;
for (int i = 0; i < listCustomerTransDetail.Count; i++) {
key[k] = "id";
value[k++] = listCustomerTransDetail.ElementAt(i).CustomerDetailTransID;
key[k] = "customer_trans_id";
value[k++] = TransID;
key[k] = "type_id";
value[k++] = listCustomerTransDetail.ElementAt(i).TypeID;
key[k] = "pelayaran_detail_id";
value[k++] = listCustomerTransDetail.ElementAt(i).PelayaranDetailID;
key[k] = "origin";
value[k++] = listCustomerTransDetail.ElementAt(i).Origin;
key[k] = "destination";
value[k++] = listCustomerTransDetail.ElementAt(i).Destination;
key[k] = "condition_id";
value[k++] = listCustomerTransDetail.ElementAt(i).ConditionID;
key[k] = "no_seal";
value[k++] = listCustomerTransDetail.ElementAt(i).NoSeal;
key[k] = "price";
value[k++] = listCustomerTransDetail.ElementAt(i).Price;
key[k] = "stuffing_date";
value[k++] = listCustomerTransDetail.ElementAt(i).StuffingDate;
key[k] = "stuffing_place";
value[k++] = listCustomerTransDetail.ElementAt(i).StuffingPlace;
key[k] = "truck_number";
value[k++] = listCustomerTransDetail.ElementAt(i).TruckNo;
key[k] = "voy";
value[k++] = listCustomerTransDetail.ElementAt(i).Voyage;
key[k] = "etd";
value[k++] = listCustomerTransDetail.ElementAt(i).ETD;
key[k] = "td";
value[k++] = listCustomerTransDetail.ElementAt(i).TD;
key[k] = "eta";
value[k++] = listCustomerTransDetail.ElementAt(i).ETA;
key[k] = "ta";
value[k++] = listCustomerTransDetail.ElementAt(i).TA;
key[k] = "unloading";
value[k++] = listCustomerTransDetail.ElementAt(i).Unloading;
key[k] = "recipient_id";
value[k++] = listCustomerTransDetail.ElementAt(i).RecipientID;
key[k] = "jenis_barang";
value[k++] = listCustomerTransDetail.ElementAt(i).JenisBarang;
key[k] = "no_container";
value[k++] = listCustomerTransDetail.ElementAt(i).NoContainer;
key[k] = "quantity";
value[k++] = listCustomerTransDetail.ElementAt(i).Quantity;
key[k] = "sj1";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj1;
key[k] = "sj2";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj2;
key[k] = "sj3";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj3;
key[k] = "sj4";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj4;
key[k] = "sj5";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj5;
key[k] = "sj6";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj6;
key[k] = "sj7";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj7;
key[k] = "sj8";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj8;
key[k] = "sj9";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj9;
key[k] = "sj10";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj10;
key[k] = "sj11";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj11;
key[k] = "sj12";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj12;
key[k] = "sj13";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj13;
key[k] = "sj14";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj14;
key[k] = "sj15";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj15;
key[k] = "sj16";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj16;
key[k] = "sj17";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj17;
key[k] = "sj18";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj18;
key[k] = "sj19";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj19;
key[k] = "sj20";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj20;
key[k] = "sj21";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj21;
key[k] = "sj22";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj22;
key[k] = "sj23";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj23;
key[k] = "sj24";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj24;
key[k] = "sj25";
value[k++] = listCustomerTransDetail.ElementAt(i).Sj25;
key[k] = "terima_toko";
value[k++] = listCustomerTransDetail.ElementAt(i).TerimaToko;
key[k] = "keterangan";
value[k++] = listCustomerTransDetail.ElementAt(i).Keterangan;
key[k] = "no_ba";
value[k++] = listCustomerTransDetail.ElementAt(i).NoBA;
key[k] = "deleted";
value[k++] = listCustomerTransDetail.ElementAt(i).Deleted;
}
SqlParameter[] sqlParameterInsert = SqlUtility.SetSqlParameter(key, value);
if (wantToCreateVessel)
{
SqlParameter[] sqlParameterMaster = SqlUtility.SetSqlParameter(
new string[] { "id", "customer_id", "tgl_transaksi", "deleted" },
new object[] { TransID, cboCustomer.SelectedValue, DateTime.Today, 0 }
);
if (sqlCustomerTransRepository.CreateCustomerTrans(sqlParameterInsert, sqlParameterMaster)) {
MessageBox.Show(this, "Success save data", "Information");
radButtonElement2.PerformClick();
sqlParameterMaster = null;
}
else
MessageBox.Show(this, "Cannot save data", "Information");
}
else {
SqlParameter[] sqlParameterMaster = SqlUtility.SetSqlParameter(
new string[] { "id", "customer_id" },
new object[] { TransID, cboCustomer.SelectedValue }
);
if (sqlCustomerTransRepository.EditCustomerTrans(sqlParameterInsert, sqlParameterMaster)) {
MessageBox.Show(this, "Success edit data", "Information");
radButtonElement2.PerformClick();
ID = TransID;
sqlParameterMaster = null;
}
else
MessageBox.Show(this, "Cannot edit data", "Information");
}
sqlCustomerTransRepository = null;
sqlParameterInsert = null;
}
}
else
MessageBox.Show(this, "Please fill transaction detail", "Information");
}
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;
}
}