public DataTable VehicleDistanceConfig(VehicleDistancePriceConfiguration vdpc)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PSInsUpdDelVehicleDistancePrice";
cmd.Connection = conn;
SqlParameter vdpcId = new SqlParameter("@Id", SqlDbType.Int);
vdpcId.Value = vdpc.Id;
cmd.Parameters.Add(vdpcId);
SqlParameter vdpcSourceLoc = new SqlParameter("@SourceLoc", SqlDbType.VarChar);
vdpcSourceLoc.Value = vdpc.SourceLoc;
cmd.Parameters.Add(vdpcSourceLoc);
SqlParameter vdpcDestinationLoc = new SqlParameter("@DestinationLoc", SqlDbType.VarChar);
vdpcDestinationLoc.Value = vdpc.DestinationLoc;
cmd.Parameters.Add(vdpcDestinationLoc);
SqlParameter vdpcSourceLat = new SqlParameter("@SourceLat", SqlDbType.Float);
vdpcSourceLat.Value = vdpc.SourceLat;
cmd.Parameters.Add(vdpcSourceLat);
SqlParameter vdpcSourceLng = new SqlParameter("@SourceLng", SqlDbType.Float);
vdpcSourceLng.Value = vdpc.SourceLng;
cmd.Parameters.Add(vdpcSourceLng);
SqlParameter vdpcDestinationLat = new SqlParameter("@DestinationLat", SqlDbType.Float);
vdpcDestinationLat.Value = vdpc.DestinationLat;
cmd.Parameters.Add(vdpcDestinationLat);
SqlParameter vdpcDestinationLng = new SqlParameter("@DestinationLng", SqlDbType.Float);
vdpcDestinationLng.Value = vdpc.DestinationLng;
cmd.Parameters.Add(vdpcDestinationLng);
SqlParameter vdpcVehicleModelId = new SqlParameter("@VehicleGroupId", SqlDbType.Int);
vdpcVehicleModelId.Value = vdpc.VehicleGroupId;
cmd.Parameters.Add(vdpcVehicleModelId);
SqlParameter vdpcVehicleTypeId = new SqlParameter("@VehicleTypeId", SqlDbType.Int);
vdpcVehicleTypeId.Value = vdpc.VehicleTypeId;
cmd.Parameters.Add(vdpcVehicleTypeId);
SqlParameter vdpcPricingTypeId = new SqlParameter("@PricingTypeId", SqlDbType.Int);
vdpcPricingTypeId.Value = vdpc.PricingTypeId;
cmd.Parameters.Add(vdpcPricingTypeId);
SqlParameter vdpcDistance = new SqlParameter("@Distance", SqlDbType.Float);
vdpcDistance.Value = vdpc.Distance;
cmd.Parameters.Add(vdpcDistance);
SqlParameter vdpcUnitPrice = new SqlParameter("@UnitPrice", SqlDbType.Float);
vdpcUnitPrice.Value = vdpc.UnitPrice;
cmd.Parameters.Add(vdpcUnitPrice);
SqlParameter vdpcAmount = new SqlParameter("@Amount", SqlDbType.Float);
vdpcAmount.Value = vdpc.Amount;
cmd.Parameters.Add(vdpcAmount);
SqlParameter ctry = new SqlParameter("@CountryId", SqlDbType.Int);
ctry.Value = vdpc.CountryId;
cmd.Parameters.Add(ctry);
SqlParameter flag = new SqlParameter("@flag", SqlDbType.VarChar);
flag.Value = vdpc.flag;
cmd.Parameters.Add(flag);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
return(dt);
}
public DataTable VehicleDistanceConfig(VehicleDistancePriceConfiguration vdpc)
{
DataTable dt = new DataTable();
LogTraceWriter traceWriter = new LogTraceWriter();
StringBuilder str = new StringBuilder();
SqlConnection conn = new SqlConnection();
try
{
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "TaxiPrice....");
str.Append("SourceLoc:" + vdpc.SourceLoc + ",");
str.Append("DestinationLoc:" + vdpc.DestinationLoc + ",");
str.Append("VehicleTypeId:" + vdpc.VehicleTypeId + ",");
str.Append("Amount:" + vdpc.Amount + ",");
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "Input sent...." + str.ToString());
conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelVehicleDistancePrice";
cmd.Connection = conn;
SqlParameter vdpcSourceLoc = new SqlParameter("@SourceLoc", SqlDbType.VarChar, 200);
vdpcSourceLoc.Value = vdpc.SourceLoc;
cmd.Parameters.Add(vdpcSourceLoc);
SqlParameter vdpcDestinationLoc = new SqlParameter("@DestinationLoc", SqlDbType.VarChar, 200);
vdpcDestinationLoc.Value = vdpc.DestinationLoc;
cmd.Parameters.Add(vdpcDestinationLoc);
SqlParameter vdpcSourceLat = new SqlParameter("@SourceLat", SqlDbType.Float);
vdpcSourceLat.Value = vdpc.SourceLat;
cmd.Parameters.Add(vdpcSourceLat);
SqlParameter vdpcSourceLng = new SqlParameter("@SourceLng", SqlDbType.Float);
vdpcSourceLng.Value = vdpc.SourceLng;
cmd.Parameters.Add(vdpcSourceLng);
SqlParameter vdpcDestinationLat = new SqlParameter("@DestinationLat", SqlDbType.Float);
vdpcDestinationLat.Value = vdpc.DestinationLat;
cmd.Parameters.Add(vdpcDestinationLat);
SqlParameter vdpcDestinationLng = new SqlParameter("@DestinationLng", SqlDbType.Float);
vdpcDestinationLng.Value = vdpc.DestinationLng;
cmd.Parameters.Add(vdpcDestinationLng);
SqlParameter vdpcVehicleModelId = new SqlParameter("@VehicleModelId", SqlDbType.Int);
vdpcVehicleModelId.Value = vdpc.VehicleModelId;
cmd.Parameters.Add(vdpcVehicleModelId);
SqlParameter vdpcVehicleTypeId = new SqlParameter("@VehicleTypeId", SqlDbType.Int);
vdpcVehicleTypeId.Value = vdpc.VehicleTypeId;
cmd.Parameters.Add(vdpcVehicleTypeId);
SqlParameter vdpcPricingTypeId = new SqlParameter("@PricingTypeId", SqlDbType.Int);
vdpcPricingTypeId.Value = vdpc.PricingTypeId;
cmd.Parameters.Add(vdpcPricingTypeId);
SqlParameter vdpcUnitPrice = new SqlParameter("@UnitPrice", SqlDbType.Float);
vdpcUnitPrice.Value = vdpc.UnitPrice;
cmd.Parameters.Add(vdpcUnitPrice);
SqlParameter vdpcAmount = new SqlParameter("@Amount", SqlDbType.Float);
vdpcAmount.Value = vdpc.Amount;
cmd.Parameters.Add(vdpcAmount);
SqlParameter flag = new SqlParameter("@flag", SqlDbType.VarChar);
flag.Value = vdpc.flag;
cmd.Parameters.Add(flag);
SqlParameter src = new SqlParameter("@SrcId", SqlDbType.Int);
src.Value = vdpc.srcid;
cmd.Parameters.Add(src);
SqlParameter dest = new SqlParameter("@DestId", SqlDbType.Int);
dest.Value = vdpc.destid;
cmd.Parameters.Add(dest);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "TaxiPrice successful....");
}
catch (Exception ex)
{
traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "TaxiPrice...." + ex.Message.ToString());
//throw ex;
//throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message));
dt.Columns.Add("Code");
dt.Columns.Add("description");
DataRow dr = dt.NewRow();
dr[0] = "ERR001";
dr[1] = ex.Message;
dt.Rows.Add(dr);
}
finally
{
conn.Close();
conn.Dispose();
SqlConnection.ClearPool(conn);
}
return(dt);
}