private void btnRegister_Click(object sender, EventArgs e)
{
if (this.contractVehicle == null)
{
MessageBox.Show("Please select a Vehicle");
}
else
{
VehicleMileage vm = new VehicleMileage();
int tmp = 0;
bool bTmp = false;
bTmp = int.TryParse(this.txtMileage.Text, out tmp);
if (bTmp)
{
vm.Mileage = tmp;
}
else
{
vm.Mileage = 0;
}
vm.MileageDate = this.datePicker1.Value;
vm.Info = "";
bool bTmp2 = VehicleMileage.saveMileages(vm, contractVehicle.VehiId);
if (bTmp2)
{
contractVehicle.Mileages.Add(vm);
this.dgvMileages.DataSource = this.loadMileage(contractVehicle);
}
else
{
MessageBox.Show("Not OK");
}
}
}
private void readFile()
{
var csvRows = File.ReadAllLines(filePath);
foreach (string r in csvRows)
{
if (r.Length > 0)
{
string[] fileds = r.Split(new string[] { separator }, StringSplitOptions.None);
System.Console.WriteLine(fileds[0]); //vin
System.Console.WriteLine(fileds[1]); //date
System.Console.WriteLine(fileds[2]); //mileage
List <ContractVehicle> cvList = new List <ContractVehicle>();
cvList = ContractVehicle.getByVIN(fileds[0]);
if (cvList != null && cvList.Count > 0)
{
this.contractVehicle = cvList[0];
VehicleMileage vm = new VehicleMileage();
int tmp = 0;
bool bTmp = false;
bTmp = int.TryParse(fileds[2], out tmp);
if (bTmp)
{
vm.Mileage = tmp;
}
else
{
vm.Mileage = 0;
}
DateTime myDate = new DateTime();
bool bTmp2 = false;
bTmp2 = DateTime.TryParse(fileds[1],
System.Globalization.CultureInfo.GetCultureInfo(myCulture),
System.Globalization.DateTimeStyles.None, out myDate);
if (bTmp2)
{
vm.MileageDate = myDate;
}
vm.Info = "";
VehicleMileage.saveMileages(vm, contractVehicle.VehiId);
}
}
}
}
public void loadVehicleData()
{
clearData();
//Load Data from DB
clsSqlFactory hSql = new clsSqlFactory();
contractVehicle.loadDynFields(hSql);
contractVehicle.loadMileages(hSql);
//Set Text
txtVin.Text = contractVehicle.VIN;
txtMake.Text = contractVehicle.Make;
//Set Dynamic
fillDynField();
//Load data grid
gridMileage.DataSource = LoadGridMileage(contractVehicle);
if (addCol)
{
addColumn();
addCol = false;
}
//Load Deviation
int diffMileage = 0;
int diffDate = 0;
VehicleMileage Mileage1 = null;
VehicleMileage Mileage2 = null;
List <VehicleMileage> Mileages = contractVehicle.Mileages;
if (Mileages != null && Mileages.Count > 1)
{
Mileage1 = Mileages[0];
Mileage2 = Mileages[1];
System.Diagnostics.Debug.WriteLine("---------------------Mileage1: " + Mileage1.MileageDate);
System.Diagnostics.Debug.WriteLine("---------------------Mileage2: " + Mileage2.MileageDate);
//T0 is the first, Tn is the last update to date mileage time stamp. The time stamps are read from V_ZSC_MileageReg.Created
TimeSpan difference = (DateTime.Compare(Mileage1.MileageDate, Mileage2.MileageDate) > 0) ? Mileage1.MileageDate - Mileage2.MileageDate : Mileage2.MileageDate - Mileage1.MileageDate;
diffDate = difference.Minutes;
//Mn are the mileages (at above time stamp), from V_ZSC_MileageReg.Mileage
diffMileage = Math.Abs(Mileage1.Mileage - Mileage2.Mileage);
System.Diagnostics.Debug.WriteLine("---------------------diffDate: " + diffDate);
System.Diagnostics.Debug.WriteLine("---------------------diffMileage: " + diffMileage);
}
if (diffMileage > 0)
{
float periodY = contract.ContractPeriodKm;
float periodM = contract.ContractPeriodKm / 12;
float avgDay = diffDate / diffMileage;
float avgMonth = avgDay * 30;
float devMonth = 100 * Math.Abs((avgMonth - periodM)) / periodM;
System.Diagnostics.Debug.WriteLine("---------------------avgMonth: " + avgMonth.ToString());
//Set data
txtMonAvg.Text = avgMonth.ToString();
txtMonDev.Text = devMonth.ToString();
txtQuarterAvg.Text = "";
txtQuarterDev.Text = "";
txtYearAvg.Text = "";
}
}
public void fillData()
{
initFrm();
if (ContractFrm.objContract != null && ContractFrm.objContract.ContractOID > 0)
{
//Start
txtStartDate.Value = ContractFrm.objContract.ContractDateData.ContractStartDate;
txtStartKm.Value = ContractFrm.objContract.ContractDateData.ContractStartKm;
txtStartHr.Value = ContractFrm.objContract.ContractDateData.ContractStartHour;
txtStartInvoice.Value = ContractFrm.objContract.ContractDateData.InvoiceStartDate;
txtPeriod.Value = ContractFrm.objContract.ContractDateData.ContractPeriodMonth;
txtKm.Value = ContractFrm.objContract.ContractDateData.ContractPeriodKm;
txtHr.Value = ContractFrm.objContract.ContractDateData.ContractPeriodHour;
rdKmBase.Checked = (ContractFrm.objContract.ContractDateData != null && ContractFrm.objContract.ContractDateData.ContractPeriodKmHour == 1);
rdHrBase.Checked = (ContractFrm.objContract.ContractDateData != null && ContractFrm.objContract.ContractDateData.ContractPeriodKmHour == 2);
//End
txtEndDate.Value = ContractFrm.objContract.ContractDateData.ContractEndDate;
txtEndKm.Value = ContractFrm.objContract.ContractDateData.ContractEndKm;
txtEndHr.Value = ContractFrm.objContract.ContractDateData.ContractEndHour;
txtEndInvoice.Value = ContractFrm.objContract.ContractDateData.InvoiceEndDate;
cbTemType.SelectedValue = ContractFrm.objContract.TerminationType.strValue1;
//Payment
if (ContractFrm.objContract.ContractPaymentData.PaymentPeriod != null && ContractFrm.objContract.ContractPaymentData.PaymentPeriod.strValue1 != null)
{
cbPayPeriod.SelectedValue = ContractFrm.objContract.ContractPaymentData.PaymentPeriod.strValue1;
}
else
{
cbPayPeriod.SelectedIndex = -1;
}
cbPayment.Checked = ContractFrm.objContract.ContractPaymentData.PaymentIsInBlock;
cbInvoice.Checked = ContractFrm.objContract.IsManualInvoice;
if (ContractFrm.objContract.ContractPaymentData != null && ContractFrm.objContract.ContractPaymentData.PaymentNextBlockStart != null)
{
txtNextBlock.Text = ContractFrm.objContract.ContractPaymentData.PaymentNextBlockStart.ToString("d", System.Globalization.CultureInfo.GetCultureInfo(objGlobal.CultureInfo));
}
else
{
txtNextBlock.Text = "";
}
if (ContractFrm.objContract.ContractPaymentData != null && ContractFrm.objContract.ContractPaymentData.PaymentNextBlockEnd != null)
{
txtNextBlockEnd.Text = ContractFrm.objContract.ContractPaymentData.PaymentNextBlockEnd.ToString("d", System.Globalization.CultureInfo.GetCultureInfo(objGlobal.CultureInfo));
}
else
{
txtNextBlockEnd.Text = "";
}
cbColType.SelectedValue = ContractFrm.objContract.ContractPaymentData.PaymentCollectionType;
cbGrpLevel.SelectedValue = ContractFrm.objContract.ContractPaymentData.PaymentGroupingLevel;
cbPayTerm.SelectedValue = ContractFrm.objContract.ContractPaymentData.PaymentTerm.strValue1;
if (ContractFrm.objContract.InvoiceSiteId != null)
{
cbInvoiceSite.SelectedValue = ContractFrm.objContract.InvoiceSiteId.strValue1;
}
else
{
cbInvoiceSite.SelectedValue = -1;
}
//captial
txtStartAmount.Text = ContractFrm.objContract.ContractCapitalData.CapitalStartAmount.ToString();
if (ContractFrm.objContract.ContractCapitalData != null && ContractFrm.objContract.ContractCapitalData.CapitalStartPayer != null &&
ContractFrm.objContract.ContractCapitalData.CapitalStartPayer.strValue1 != null && ContractFrm.objContract.ContractCapitalData.CapitalStartPayer.strValue1.Length > 0)
{
txtStartAmountPayer.SelectedValue = ContractFrm.objContract.ContractCapitalData.CapitalStartPayer.strValue1;
}
else
{
txtStartAmountPayer.SelectedValue = -1;
}
txtMonAmount.Text = ContractFrm.objContract.ContractCapitalData.CapitalMonthAmount.ToString();
if (ContractFrm.objContract.ContractCapitalData != null && ContractFrm.objContract.ContractCapitalData.CapitalMonthPayer != null &&
ContractFrm.objContract.ContractCapitalData.CapitalMonthPayer.strValue1 != null && ContractFrm.objContract.ContractCapitalData.CapitalMonthPayer.strValue1.Length > 0)
{
txtMonAmountPayer.SelectedValue = ContractFrm.objContract.ContractCapitalData.CapitalMonthPayer.strValue1;
}
else
{
txtMonAmountPayer.SelectedValue = -1;
}
txtTotalAmount.Text = (ContractFrm.objContract.ContractCapitalData.CapitalStartAmount
+ ContractFrm.objContract.ContractCapitalData.CapitalMonthAmount * ContractFrm.objContract.ContractDateData.ContractPeriodMonth).ToString();
//Cost
if (ContractFrm.objContract.ContractCostData.CostBasis != null &&
ContractFrm.objContract.ContractCostData.CostBasis.strValue1 != null &&
ContractFrm.objContract.ContractCostData.CostBasis.strValue1.Length > 0)
{
cbCostBassis.SelectedValue = ContractFrm.objContract.ContractCostData.CostBasis.strValue1;
}
else
{
cbCostBassis.SelectedIndex = -1;
}
txtCostBase.Value = ContractFrm.objContract.ContractCostData.CostBasedOnService;
txtCostBase2.Value = ContractFrm.objContract.ContractCostData.CostBasedOnService + ContractFrm.objContract.getPayerOptionPrice();
txtMonBassis.Value = ContractFrm.objContract.ContractCostData.CostMonthBasis;
txtKmBassis.Value = ContractFrm.objContract.ContractCostData.CostKmBasis;
DateTime? lastPay = ContractOption.GetLastPayDate(ContractFrm.objContract.ContractOID);
CultureInfo cu = new CultureInfo(ContractFrm.myCulture);
if (lastPay != null)
{
txtLastPay.Text = lastPay.ToString().ToString(cu);
}
else
{
txtLastPay.Text = "";
}
txtErr.Text = ContractFrm.objContract.ContractCostData.CostPerKm.ToString();
//LastKm info
VehicleMileage vehicleMileage = ContractFrm.objContract.VehiId.lastMileages();
if (vehicleMileage != null)
{
txtLastKm.Text = vehicleMileage.LastKmInfo();
}
else
{
txtLastKm.Text = "";
}
//Extra
if (ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicePeriod != null &&
ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicePeriod.strValue1 != null &&
ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicePeriod.strValue1 != "")
{
cbBiling.SelectedValue = ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicePeriod.strValue1;
}
else
{
cbBiling.SelectedIndex = -1;
}
if (ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicePeriod != null &&
ContractFrm.objContract.ContractExtraKmData.ExtraKmAccounting.strValue1 != null &&
ContractFrm.objContract.ContractExtraKmData.ExtraKmAccounting.strValue1 != "")
{
cbAccounting.SelectedValue = ContractFrm.objContract.ContractExtraKmData.ExtraKmAccounting.strValue1;
}
else
{
cbAccounting.SelectedIndex = -1;
}
txtMaxDev.Value = ContractFrm.objContract.ContractExtraKmData.ExtraKmMaxDeviation;
txtLowKm.Value = ContractFrm.objContract.ContractExtraKmData.ExtraKmLowAmount;
txtHighKm.Value = ContractFrm.objContract.ContractExtraKmData.ExtraKmHighAmount;
txtInvoiceAmount.Value = ContractFrm.objContract.ContractExtraKmData.ExtraKmInvoicedAmount;
//cbRoll
if (ContractFrm.objContract.RollingCode != null && ContractFrm.objContract.RollingCode.strValue1 != null && ContractFrm.objContract.RollingCode.strValue1 != "")
{
cbRoll.SelectedValue = ContractFrm.objContract.RollingCode.strValue1;
}
else
{
cbRoll.SelectedIndex = -1;
}
cbInvoiceDetail.Checked = ContractFrm.objContract.IsInvoiceDetail;
//Risk
ContractCustomer RiskCustId = ContractFrm.objContract.RiskCustId;
if (RiskCustId != null && RiskCustId.CustId > 0)
{
txtRiskCusId.Text = RiskCustId.CustId.ToString();
txtPatnerNr.Text = RiskCustId.CustNr.ToString();
txtParnerName.Text = RiskCustId.Name;
}
else
{
txtRiskCusId.Text = "";
txtPatnerNr.Text = "";
txtParnerName.Text = "";
}
txtRishLevel.Text = ContractFrm.objContract.RiskLevel.ToString();
if (ContractFrm.objContract.IndexingDate != DateTime.MinValue)
{
dtIndexingDate.Value = ContractFrm.objContract.IndexingDate;
}
dfIndexValue.Value = ContractFrm.objContract.IndexValue;
dfInvoicingDay.Value = ContractFrm.objContract.ContractPaymentData.InvoiceDate;
//Load data grid
fillRisk();
generateColumns();
}
else
{
//Start
txtStartDate.Value = DateTime.Now;
txtStartKm.Value = 0;
txtStartHr.Value = 0;
txtStartInvoice.Value = DateTime.Now;
txtPeriod.Value = 0;
txtKm.Value = 0;
txtHr.Value = 0;
//End
txtEndDate.Value = DateTime.Now;
txtEndKm.Value = 0;
txtEndHr.Value = 0;
txtEndInvoice.Value = DateTime.Now;
cbTemType.Text = "";
//Payment
cbPayPeriod.SelectedIndex = -1;
cbPayment.Checked = false;
cbInvoice.Checked = false;
txtNextBlock.Text = "";
txtNextBlockEnd.Text = "";
cbColType.SelectedIndex = -1;
cbGrpLevel.SelectedIndex = -1;
cbPayTerm.SelectedIndex = -1;
cbInvoiceSite.SelectedIndex = -1;
//captial
txtStartAmount.Text = "";
txtStartAmountPayer.Text = "";
txtMonAmount.Text = "";
txtMonAmountPayer.Text = "";
txtTotalAmount.Text = "";
//Cost
cbCostBassis.Text = "";
txtCostBase.Value = 0;
txtCostBase2.Value = 0;
txtMonBassis.Value = 0;
txtKmBassis.Value = 0;
txtLastPay.Text = "";
txtErr.Text = "";
txtLastKm.Text = "";
//Extra
cbBiling.SelectedIndex = -1;
cbAccounting.SelectedIndex = -1;
txtMaxDev.Value = 0;
txtLowKm.Value = 0;
txtHighKm.Value = 0;
txtInvoiceAmount.Value = 0;
cbRoll.SelectedIndex = -1;
cbInvoiceDetail.Checked = false;
//Risk
txtRiskCusId.Text = "";
txtPatnerNr.Text = "";
txtParnerName.Text = "";
txtRishLevel.Value = 0;
txtRishLevel.Value = 0;
//Grid
}
gridRisk.DataSource = dataTable;
//()
formatDecimal();
}
