internal PaxDetails addEditPax(int ticket_id, int pax_id, string name, string mobile, DateTime dob, string anniversary, string email)
{
try
{
SqlCommand cmd = new SqlCommand("addEditPax", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ticket_id", ticket_id);
cmd.Parameters.AddWithValue("@pax_id", pax_id);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@mobile", mobile);
cmd.Parameters.AddWithValue("@dob", dob);
cmd.Parameters.AddWithValue("@anniversary", anniversary);
cmd.Parameters.AddWithValue("@email", email);
con.Open();
PaxDetails paxDetails = new PaxDetails();
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow dRow in ds.Tables[0].Rows)
{
paxDetails.status = true;
paxDetails.pax.anniversary = dRow["anniversary"] != DBNull.Value ? Convert.ToInt32(dRow["anniversary"].ToString()) : 0;
paxDetails.pax.id = dRow["id"] != DBNull.Value ? Convert.ToInt32(dRow["id"].ToString()) : 0;
paxDetails.pax.dob = dRow["dob"] != DBNull.Value ? Convert.ToInt32(dRow["dob"].ToString()) : 0;
paxDetails.pax.email = dRow["email"] != DBNull.Value ? dRow["email"].ToString() : "";
paxDetails.pax.name = dRow["name"] != DBNull.Value ? dRow["name"].ToString() : "";
paxDetails.pax.mobile = dRow["mobile"] != DBNull.Value ? dRow["mobile"].ToString() : "";
}
}
return(paxDetails);
}
catch (Exception ex)
{
throw;
}
finally
{
con.Close();
}
}
public object addEditPax(int ticket_id, int pax_id, string name, string mobile, DateTime dob, string anniversary, string email)
{
try
{
PaxDetails paxDetails = new PaxDetails();
paxDetails = db.addEditPax(ticket_id, pax_id, name, mobile, dob, anniversary, email);
object response = new object();
if (paxDetails == null)
{
response = new { Status = "false", Message = "Authentication failed" };
}
else
{
response = new { Status = "true", Payment = paxDetails };
}
return(JsonConvert.SerializeObject(response, Newtonsoft.Json.Formatting.Indented));
}
catch (Exception)
{
throw;
}
}