public int Insert(PlannerDetails planDet)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO PlannerDetails (planId, userId, planCategory, planTitle, planType, planTime, planDuration, webLink, confirmNo, flightAirline, flightNo, flightTerminal, flightGate, planAddress, actETixNo, actPrice, actPax, actTotal, planNotes, planAttachment)" +
"VALUES (@paraPlanId,@paraUserId,@paraCategory, @paraTitle, @paraType, @paraTime, @paraDuration, @paraWebLink, @paraConNo, @paraFAirline, @paraFNo, @paraFTer, @paraFGate, @paraAddr, @paraETix, @paraPrice," +
" @paraPax, @paraTotal, @paraNotes, @paraAttachment)";
int result = 0; // Execute NonQuery return an integer value
SqlCommand sqlCmd = new SqlCommand(sqlStmt, myConn);
;
sqlCmd.Parameters.AddWithValue("@paraPlanId", planDet.planId);
sqlCmd.Parameters.AddWithValue("@paraUserId", planDet.userId);
sqlCmd.Parameters.AddWithValue("@paraCategory", planDet.category);
sqlCmd.Parameters.AddWithValue("@paraTitle", planDet.title);
sqlCmd.Parameters.AddWithValue("@paraType", planDet.type);
sqlCmd.Parameters.AddWithValue("@paraTime", planDet.planTime);
sqlCmd.Parameters.AddWithValue("@paraDuration", planDet.duration);
sqlCmd.Parameters.AddWithValue("@paraWebLink", planDet.webLink);
sqlCmd.Parameters.AddWithValue("@paraConNo", planDet.conNo);
sqlCmd.Parameters.AddWithValue("@paraFAirline", planDet.airline);
sqlCmd.Parameters.AddWithValue("@paraFNo", planDet.flightNo);
sqlCmd.Parameters.AddWithValue("@paraFTer", planDet.terminal);
sqlCmd.Parameters.AddWithValue("@paraFGate", planDet.gate);
sqlCmd.Parameters.AddWithValue("@paraAddr", planDet.addr);
sqlCmd.Parameters.AddWithValue("@paraETix", planDet.eTixNo);
sqlCmd.Parameters.AddWithValue("@paraPrice", planDet.price);
sqlCmd.Parameters.AddWithValue("@paraPax", planDet.pax);
sqlCmd.Parameters.AddWithValue("@paraTotal", planDet.ttl);
sqlCmd.Parameters.AddWithValue("@paraNotes", planDet.notes);
sqlCmd.Parameters.AddWithValue("@paraAttachment", planDet.attach);
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
myConn.Close();
return(result);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
var category = lblCat.Text;
string title;
string type;
//time
string pTime;
//duration
string duration;
string webLink;
string conNo;
string airline;
string flightNo;
string terminal;
string gate;
string addr;
string eTixNo;
string price;
string pax;
string ttl;
//notes
string notes;
string attach;
if (category == "flight")
{
title = tbTitleFlight.Text;
type = rblTypeFlight.SelectedValue;
//string timeF = Request["timepicker-selectbox-Flight"]; //!!!!
pTime = "";
//pTime = this.Request.Form["timepicker-selectbox-Flight"];
//string durationFlight = durationF.InnerHtml;
duration = "";
webLink = tbWebBookFlight.Text;
conNo = tbConNoFlight.Text;
airline = tbAirlineFlight.Text;
flightNo = tbFNoFlight.Text;
terminal = tbTerFlight.Text;
gate = tbGateFlight.Text;
addr = "";
eTixNo = "";
price = "";
pax = "";
ttl = "";
//string notesF = editorFlight.InnerHtml;
notes = "";
attach = FUFliAttachFlight.FileName;
PlannerDetails planDetF = new PlannerDetails();
planDetF = new PlannerDetails(category, title, type, pTime, duration, webLink, conNo, airline, flightNo, terminal, gate, addr, eTixNo, price, pax, ttl, notes, attach);
int resultF = planDetF.addPlanDetails();
if (resultF == 1)
{
string url = string.Format("~/S_Planner_Start.aspx");
Response.Redirect(url);
}
//var df = this.Request.Form["txtName"];
//Label1.Text = durationFlight;
//ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + durationFlight + "');", true);
}
else if (category == "accomodation")
{
title = tbTitleAcco.Text;
type = RBLAcco.SelectedValue;
//time
pTime = "";
//duration
duration = "";
webLink = tbWebBookAcco.Text;
conNo = tbConNoAcco.Text;
airline = "";
flightNo = "";
terminal = "";
gate = "";
addr = tbAddrAcco.Text;
eTixNo = "";
price = "";
pax = "";
ttl = "";
//string notesAcco = editorAcco.InnerHtml;
notes = null;
attach = FUAcco.FileName;
PlannerDetails planDetAcco = new PlannerDetails(category, title, type, pTime, duration, webLink, conNo, airline, flightNo, terminal, gate, addr, eTixNo, price, pax, ttl, notes, attach);
int resultAcco = planDetAcco.addPlanDetailsAcco();
if (resultAcco == 1)
{
string url = string.Format("~/S_Planner_Start.aspx");
Response.Redirect(url);
}
}
else if (category == "activity")
{
title = tbTitleAct.Text;
type = "";
//time
pTime = "";
//duration
duration = "";
webLink = tbWebLinkAct.Text;
conNo = "";
airline = "";
flightNo = "";
terminal = "";
gate = "";
addr = tbAddrAct.Text;
eTixNo = tbETixAct.Text;
price = tbPriceAct.Text;
pax = tbPaxAct.Text;
ttl = tbTtlPriceAct.Text;
//notes
notes = "";
attach = FUAct.FileName;
PlannerDetails planDetAct = new PlannerDetails(category, title, type, pTime, duration, webLink, conNo, airline, flightNo, terminal, gate, addr, eTixNo, price, pax, ttl, notes, attach);
int resultAct = planDetAct.addPlanDetails();
if (resultAct == 1)
{
string url = string.Format("~/S_Planner_Start.aspx");
Response.Redirect(url);
}
}
else if (category == "fooD")
{
title = tbTitleFnD.Text;
type = "";
//time
pTime = "";
//duration
duration = "";
webLink = tbWebLinkFnD.Text;
conNo = "";
airline = "";
flightNo = "";
terminal = "";
gate = "";
addr = tbAddrFnD.Text;
eTixNo = "";
price = "";
pax = "";
ttl = "";
//notes
notes = "";
attach = FUFnD.FileName;
PlannerDetails planDetFooD = new PlannerDetails(category, title, type, pTime, duration, webLink, conNo, airline, flightNo, terminal, gate, addr, eTixNo, price, pax, ttl, notes, attach);
int resultFooD = planDetFooD.addPlanDetails();
if (resultFooD == 1)
{
string url = string.Format("~/S_Planner_Start.aspx");
Response.Redirect(url);
}
}
}
