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"); } }