public DataTable vechile(Vechlogin A) { LogTraceWriter traceWriter = new LogTraceWriter(); SqlConnection conn = new SqlConnection(); StringBuilder str = new StringBuilder(); DataTable dt = new DataTable(); try { traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "vechile...."); str.Append("VechID:" + A.VechId + ","); str.Append("RegNo:" + A.RegNo + ","); str.Append("DriverMobileNo:" + A.DriverMobileNo + ","); 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 = "PSInsUpdVechlogin"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = A.flag; cmd.Parameters.Add(f); SqlParameter i = new SqlParameter("@Id", SqlDbType.Int); i.Value = A.Id; cmd.Parameters.Add(i); SqlParameter cc = new SqlParameter("@CompanyId", SqlDbType.Int); cc.Value = A.CompanyId; cmd.Parameters.Add(cc); SqlParameter CusID = new SqlParameter("@VechId", SqlDbType.Int); CusID.Value = A.VechId; cmd.Parameters.Add(CusID); SqlParameter PhoneNo = new SqlParameter("@RegNo", SqlDbType.NVarChar, 50); PhoneNo.Value = A.RegNo; cmd.Parameters.Add(PhoneNo); SqlParameter AltPhoneNo = new SqlParameter("@DriverName", SqlDbType.NVarChar, 50); AltPhoneNo.Value = A.DriverName; cmd.Parameters.Add(AltPhoneNo); SqlParameter Address = new SqlParameter("@LoginLandMark", SqlDbType.NVarChar, 50); Address.Value = A.LoginLandMark; cmd.Parameters.Add(Address); SqlParameter PickupAddress = new SqlParameter("@CurrentLandMark", SqlDbType.NVarChar, 50); PickupAddress.Value = A.CurrentLandMark; cmd.Parameters.Add(PickupAddress); SqlParameter LandMark = new SqlParameter("@StartKiloMtr", SqlDbType.NVarChar, 50); LandMark.Value = A.StartKiloMtr; cmd.Parameters.Add(LandMark); SqlParameter PickupPlace = new SqlParameter("@CurStatus", SqlDbType.NVarChar, 50); PickupPlace.Value = A.CurStatus; cmd.Parameters.Add(PickupPlace); SqlParameter DropPlace = new SqlParameter("@DriverMobileNo", SqlDbType.NVarChar, 255); DropPlace.Value = A.DriverMobileNo; cmd.Parameters.Add(DropPlace); SqlParameter ef = new SqlParameter("@ExecutiveName", SqlDbType.NVarChar, 50); ef.Value = A.ExecutiveName; cmd.Parameters.Add(ef); SqlParameter re = new SqlParameter("@Remarks", SqlDbType.NVarChar, 255); re.Value = A.Remarks; cmd.Parameters.Add(re); SqlParameter NoofVehicle = new SqlParameter("@GenratedAmount", SqlDbType.Int); NoofVehicle.Value = A.GenratedAmount; cmd.Parameters.Add(NoofVehicle); SqlParameter nh = new SqlParameter("@NoofTimesLogin", SqlDbType.Int); nh.Value = A.NoofTimesLogin; cmd.Parameters.Add(nh); SqlParameter pp = new SqlParameter("@TotalGeneratedAmount", SqlDbType.Int); pp.Value = A.TotalGeneratedAmount; cmd.Parameters.Add(pp); SqlParameter e = new SqlParameter("@VechType", SqlDbType.VarChar, 50); e.Value = A.VechType; cmd.Parameters.Add(e); SqlParameter vv = new SqlParameter("@VehicleModelId", SqlDbType.Int); vv.Value = A.VehicleModelId; cmd.Parameters.Add(vv); SqlParameter vf = new SqlParameter("@ServiceTypeId", SqlDbType.Int); vf.Value = A.ServiceTypeId; cmd.Parameters.Add(vf); SqlParameter vg = new SqlParameter("@VehicleGroupId", SqlDbType.Int); vg.Value = A.VehicleGroupId; cmd.Parameters.Add(vg); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "vechile successful...."); } catch (Exception ex) { traceWriter.Trace(Request, "0", TraceLevel.Error, "{0}", "vechile...." + 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); }
public DataTable vechile(Vechlogin A) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = ConfigurationManager.ConnectionStrings["btposdb"].ToString(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "PSInsUpdVechlogin"; cmd.Connection = conn; SqlParameter f = new SqlParameter("@flag", SqlDbType.VarChar); f.Value = A.flag; cmd.Parameters.Add(f); SqlParameter i = new SqlParameter("@Id", SqlDbType.Int); i.Value = A.Id; cmd.Parameters.Add(i); SqlParameter cc = new SqlParameter("@CompanyId", SqlDbType.Int); cc.Value = A.CompanyId; cmd.Parameters.Add(cc); SqlParameter CusID = new SqlParameter("@VechId", SqlDbType.Int); CusID.Value = A.VechId; cmd.Parameters.Add(CusID); SqlParameter PhoneNo = new SqlParameter("@RegNo", SqlDbType.NVarChar, 50); PhoneNo.Value = A.RegNo; cmd.Parameters.Add(PhoneNo); SqlParameter AltPhoneNo = new SqlParameter("@DriverName", SqlDbType.NVarChar, 50); AltPhoneNo.Value = A.DriverName; cmd.Parameters.Add(AltPhoneNo); SqlParameter Address = new SqlParameter("@LoginLandMark", SqlDbType.NVarChar, 50); Address.Value = A.LoginLandMark; cmd.Parameters.Add(Address); SqlParameter PickupAddress = new SqlParameter("@CurrentLandMark", SqlDbType.NVarChar, 50); PickupAddress.Value = A.CurrentLandMark; cmd.Parameters.Add(PickupAddress); SqlParameter LandMark = new SqlParameter("@StartKiloMtr", SqlDbType.NVarChar, 50); LandMark.Value = A.StartKiloMtr; cmd.Parameters.Add(LandMark); SqlParameter PickupPlace = new SqlParameter("@CurStatus", SqlDbType.NVarChar, 50); PickupPlace.Value = A.CurStatus; cmd.Parameters.Add(PickupPlace); SqlParameter DropPlace = new SqlParameter("@DriverMobileNo", SqlDbType.NVarChar, 255); DropPlace.Value = A.DriverMobileNo; cmd.Parameters.Add(DropPlace); SqlParameter ef = new SqlParameter("@ExecutiveName", SqlDbType.NVarChar, 50); ef.Value = A.ExecutiveName; cmd.Parameters.Add(ef); SqlParameter re = new SqlParameter("@Remarks", SqlDbType.NVarChar, 255); re.Value = A.Remarks; cmd.Parameters.Add(re); SqlParameter NoofVehicle = new SqlParameter("@GenratedAmount", SqlDbType.Int); NoofVehicle.Value = A.GenratedAmount; cmd.Parameters.Add(NoofVehicle); SqlParameter nh = new SqlParameter("@NoofTimesLogin", SqlDbType.Int); nh.Value = A.NoofTimesLogin; cmd.Parameters.Add(nh); SqlParameter pp = new SqlParameter("@TotalGeneratedAmount", SqlDbType.Int); pp.Value = A.TotalGeneratedAmount; cmd.Parameters.Add(pp); SqlParameter e = new SqlParameter("@VechType", SqlDbType.VarChar, 50); e.Value = A.VechType; cmd.Parameters.Add(e); SqlParameter vv = new SqlParameter("@VehicleModelId", SqlDbType.Int); vv.Value = A.VehicleModelId; cmd.Parameters.Add(vv); SqlParameter vf = new SqlParameter("@ServiceTypeId", SqlDbType.Int); vf.Value = A.ServiceTypeId; cmd.Parameters.Add(vf); SqlParameter vg = new SqlParameter("@VehicleGroupId", SqlDbType.Int); vg.Value = A.VehicleGroupId; cmd.Parameters.Add(vg); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); return(dt); }