Try to check your SP and run it with all the parameters required if they return data. You have many conditions on your code all you have to do is use that condition in your SP and try it to run and then check if they return data again. If your SP returned
data then that's that time you have to debug your C# code. Thanks
adura
Member
133 Points
105 Posts
data not come out
Mar 21, 2012 08:09 AM|LINK
hai guys..can u help me...
i have 2 pages which is tpkbookingenquiry.aspx and tpkbooking.aspx...
in page tpkbooking.aspx has a details info about the tour package in tpkbookingenquiry.aspx.
my problem is that..only few fields data come out..i need all the data come out...
this is my tpkprovider.cs
public tpkPosting GetInfoBooking(string TPKID)
{
tpkPosting tpkPosting = new tpkPosting();
tpkPosting = GetInfoBookingList(TPKID);
return tpkPosting;
}
{
tpkPosting tpkPosting = new tpkPosting();
DbCommand cmd = null;
DataTable dt = null;
try
{
cmd = DatabaseHelper.GetStoredProcCommand(SP_GetTpkBookingInfoList);
DatabaseHelper.AddInParameter(cmd, "TPKID", DbType.String, TPKID);
dt = DatabaseHelper.ExecuteDataSet(cmd).Tables[0];
DataTableReader dttpkPosting = dt.CreateDataReader();
using (dttpkPosting)
{
while (dttpkPosting.Read())
{
// Guid CompanyID = new Guid();
tpkPosting.TPKID = TPKID;
tpkPosting.Status = dttpkPosting["Status"].ToString();
if (dttpkPosting["Version"].ToString() != "")
tpkPosting.Version = int.Parse(dttpkPosting["Version"].ToString());
if (dttpkPosting["TourFare"].ToString() != "")
tpkPosting.TourFare = decimal.Parse(dttpkPosting["TourFare"].ToString());
tpkPosting.TPKID = dttpkPosting["TPKID"].ToString();
tpkPosting.CompanyID = Guid.Parse(dttpkPosting["CompanyID"].ToString());
tpkPosting.TourCode = dttpkPosting["TourCode"].ToString();
// tpkPosting.TPKID = dttpkPosting["TPKID"].ToString();
tpkPosting.Title = dttpkPosting["Title"].ToString();
tpkPosting.DestinationID = dttpkPosting["DestinationID"].ToString();
tpkPosting.TPKPostingCityList = GetTPKPostingCity(TPKID);
if (dttpkPosting["EffDate"].ToString() != "")
tpkPosting.EffDate = DateTime.Parse(dttpkPosting["EffDate"].ToString());
if (dttpkPosting["UsageID"].ToString() != "")
tpkPosting.UsageID = Convert.ToInt32(dttpkPosting["UsageID"].ToString());
if (dttpkPosting["NoOfDays"].ToString() != "")
tpkPosting.NoOfDays = Convert.ToInt32(dttpkPosting["NoOfDays"].ToString());
if (dttpkPosting["IsMuslim"].ToString() != "")
tpkPosting.IsMuslim = bool.Parse(dttpkPosting["IsMuslim"].ToString());
if (dttpkPosting["TourFare"].ToString() != "")
tpkPosting.TourFare = decimal.Parse(dttpkPosting["TourFare"].ToString());
if (dttpkPosting["IsAPTaxInc"].ToString() != "")
tpkPosting.IsAPTaxInc = bool.Parse(dttpkPosting["IsAPTaxInc"].ToString());
if (dttpkPosting["APTax"].ToString() != "")
tpkPosting.APTax = decimal.Parse(dttpkPosting["APTax"].ToString());
if (dttpkPosting["IsTippingInc"].ToString() != "")
tpkPosting.IsTippingInc = bool.Parse(dttpkPosting["IsTippingInc"].ToString());
if (dttpkPosting["Tipping"].ToString() != "")
tpkPosting.Tipping = decimal.Parse(dttpkPosting["Tipping"].ToString());
if (dttpkPosting["CommAgent"].ToString() != "")
tpkPosting.CommAgent = decimal.Parse(dttpkPosting["CommAgent"].ToString());
if (dttpkPosting["CommStaff"].ToString() != "")
tpkPosting.CommStaff = decimal.Parse(dttpkPosting["CommStaff"].ToString());
if (dttpkPosting["ACF"].ToString() != "")
tpkPosting.ACF = decimal.Parse(dttpkPosting["ACF"].ToString());
if (dttpkPosting["IsReqVisa"].ToString() != "")
tpkPosting.IsReqVisa = bool.Parse(dttpkPosting["IsReqVisa"].ToString());
if (dttpkPosting["Visa"].ToString() != "")
tpkPosting.Visa = decimal.Parse(dttpkPosting["Visa"].ToString());
if (dttpkPosting["MinPax"].ToString() != "")
tpkPosting.MinPax = int.Parse(dttpkPosting["MinPax"].ToString());
//tpkPosting.ReturnDate = Convert.ToDateTime(dttpkPosting["ReturnDate"]);
tpkPosting.Specialty = dttpkPosting["Specialty"].ToString();
tpkPosting.AvailableSeats = int.Parse(dttpkPosting["AvailableSeats"].ToString());
tpkPosting.ContactPerson = dttpkPosting["ContactPerson"].ToString();
tpkPosting.ContactEmail = dttpkPosting["ContactEmail "].ToString();
}
}
}
catch
{
throw;
}
finally
{
if (cmd != null)
{
cmd.Dispose();
cmd = null;
}
}
return tpkPosting;
}
and this is my tpkbooking.aspx.cs
private void GetBookingInfo()
{
CommonFunc func = new CommonFunc();
// tpkPosting tpkProvider = null;
tpkPosting tpkposting = new tpkPosting();
tpkPosting = tpkBookingProvider.GetInfoBooking(TPKID);
lblResultsTourCode.Text = tpkPosting.TourCode;
lblResultsTitle.Text = tpkPosting.Title.ToString();
lblResultsDestination.Text=(tpkPosting.Country.ToString());
lblEffDate.Text = tpkPosting.EffDate.ToString("dd/MM/yyyy");
lblResultsNoOfDays.Text = tpkPosting.NoOfDays.ToString();
lblResultsTourFare.Text = tpkPosting.TourFare.ToString("#,##0.00;-#,##0.00;0.00");
lblResultsACommission.Text = tpkPosting.CommAgent.ToString("#,##0.00;-#,##0.00;0.00");
lblResultsStaffCommission.Text = tpkPosting.CommStaff.ToString("#,##0.00;-#,##0.00;0.00");
lblResultsAvaiSeats.Text = tpkPosting.AvailableSeats.ToString();
lblResultsFlightNo.Text = tpkPosting.FlightNo.ToString();
lblResultsCarrier.Text = tpkPosting.CarrierID.ToString();
//txtAvailSeats.Text = tpkPosting.MinPax.ToString();
lblResultsSpecialty.Text = tpkPosting.Specialty.ToString();
lblResultsRemarks.Text = tpkPosting.Remarks.ToString();
lblResultsMuslimPackage.Text=(tpkPosting.IsMuslim.ToString());
lblResultsTourCode.Enabled = false;
//tpkPosting.Title = Title;
//tpkPosting.Specialty = Specialty;
//tpkPosting.Status = "PEN";
//tpkPosting.TourCode = TourCode;
//tpkPosting.TourFare = func.ParseDec(txtTourFare.Text);
//tpkPosting.NoOfDays = func.ParseInt(txtNoOfDays.Text);
//tpkPosting.TourCode = TourCode;
//tpkPosting.PromotionCode = PromotionCode;
//tpkPosting.CommAgent = func.ParseDec(txtAgentComm.Text);
//tpkPosting.CommStaff = func.ParseDec(txtStaffComm.Text);
}
please help me
adura
Member
133 Points
105 Posts
Re: data not come out
Mar 21, 2012 08:10 AM|LINK
only shows the fields of title, tour fare, muslim package..
adura
Member
133 Points
105 Posts
Re: data not come out
Mar 21, 2012 08:20 AM|LINK
why when i debug...the value of object is null
there is no data..but the data is already in db...
joejake
Member
239 Points
42 Posts
Re: data not come out
Mar 21, 2012 09:12 AM|LINK
Hi adura,
Try to check your SP and run it with all the parameters required if they return data. You have many conditions on your code all you have to do is use that condition in your SP and try it to run and then check if they return data again. If your SP returned data then that's that time you have to debug your C# code. Thanks
Hope it will help you.
Thanks,
Joejake