public string retrievBoatStatus(clsBoat objBoat)
{
try
{
cmd = new SqlCommand();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spGetData";
cmd.Parameters.Add("@reqId", SqlDbType.Int).Value = objBoat.reqId;
cmd.Parameters.Add("@cName", SqlDbType.VarChar, 50).Value = Convert.ToString(HttpContext.Current.Session["UserId"]);
cmd.Parameters.Add("@BoatNo", SqlDbType.VarChar, 50).Value = objBoat.BNo;
dad = new SqlDataAdapter();
dad.SelectCommand = cmd;
dtbl = new DataTable();
dad.Fill(dtbl);
con.Close();
if (dtbl.Rows.Count > 0)
{
string status = Convert.ToString(dtbl.Rows[0]["Status"]);
if (status == "NC")
{
return("boat is not booked");
}
else if (status == "CN")
{
return("boat is booked");
}
else
{
return("");
}
}
else
{
return("no record found");
}
}
catch (Exception ex)
{
return("error");
}
}
public string InsertBoatInformation(clsBoat objBoat)
{
try
{
cmd = new SqlCommand();
if (con.State == ConnectionState.Closed)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spInsertData";
cmd.Parameters.Add("@reqId", SqlDbType.Int).Value = objBoat.reqId;
cmd.Parameters.Add("@cName", SqlDbType.VarChar, 50).Value = Convert.ToString(HttpContext.Current.Session["UserId"]);
cmd.Parameters.Add("@hRate", SqlDbType.Int).Value = objBoat.hRate;
cmd.Parameters.Add("@BoatName", SqlDbType.VarChar, 50).Value = objBoat.BName;
SqlParameter param = new SqlParameter("@BoatId", SqlDbType.Int);
//SqlParameter param = new SqlParameter("@BoatId", SqlDbType.VarChar, -1);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
int boatId = Convert.ToInt32(param.Value);
//string boatId = Convert.ToString(param.Value);
con.Close();
if (boatId == -1)
{
return("error");
}
else
{
return(Convert.ToString(boatId));
}
//return "";
}
catch (Exception ex)
{
return("error");
}
}
