protected void btnCalcDist_Click(object sender, EventArgs e) { addConsignmentBAL addConsignmentBALObj = new addConsignmentBAL(); string srcBrLong; cityEntity cityEntityObj = new cityEntity(); cityEntityObj.cityName_ = txtSrcBrCity.Text.Trim().ToUpper(); string srcBrLat = addConsignmentBALObj.consCityBALF(cityEntityObj, out srcBrLong); double srLatitude = Convert.ToDouble(srcBrLat); double srLongitude = Convert.ToDouble(srcBrLong); string destBrLong; cityEntityObj.cityName_ = txtDestBrCity.Text.Trim().ToUpper(); string destBrLat = addConsignmentBALObj.consCityBALF1(cityEntityObj, out destBrLong); double dsLatitude = Convert.ToDouble(destBrLat); double dsLongitude = Convert.ToDouble(destBrLong); double distance = DistanceBetweenPlaces(srLongitude, srLatitude, dsLongitude, dsLatitude); txtTotDist.Text = Convert.ToString(distance); //txtShpCharge.Text=(txtTotWeight.Text) string costAccDist; servicesEntity servicesEntityObj = new servicesEntity(); servicesEntityObj.serviceType_ = drpSrType.Text.Trim().ToUpper(); string costAccWeight = addConsignmentBALObj.consServiceCostBALF(servicesEntityObj, out costAccDist); //Label1.Text = "hello"+costAccWeight; double servCostAccWeight = Convert.ToDouble(costAccWeight); double servCostAccDist = Convert.ToDouble(costAccDist); double totWeightC = Convert.ToDouble(txtTotWeight.Text.Trim()); txtShpCharge.Text = Convert.ToString(costCalculationF(servCostAccWeight, servCostAccDist, distance, totWeightC)); }
public string consCityDALF(cityEntity cityEntityObj, out string srcBrLong) { string srcBrLat = string.Empty; string srcLong = string.Empty; using (SqlConnection conObj = new SqlConnection(CS)) { conObj.Open(); SqlCommand cmdObj = new SqlCommand("cityDist", conObj); cmdObj.CommandType = CommandType.StoredProcedure; cmdObj.Parameters.AddWithValue("@cityName", cityEntityObj.cityName_); using (SqlDataReader reader = cmdObj.ExecuteReader()) { while (reader.Read()) { srcBrLat = reader[0].ToString(); srcLong = reader[1].ToString(); } } } srcBrLong = srcLong; return(srcBrLat); }
public string consCityBALF1(cityEntity cityEntityObj, out string destBrLong) { string destBrLat = addConsignmentDALObj.consCityDALF1(cityEntityObj, out destBrLong); return destBrLat; }
public string consCityBALF(cityEntity cityEntityObj, out string srcBrLong) { string srcBrLat = addConsignmentDALObj.consCityDALF(cityEntityObj, out srcBrLong); return srcBrLat; }