public DataSet getCategoryGV(int cde)
{
ConnectionLayer.ConnectionClass conto = null;
DataSet ds = null;
SqlDataAdapter sda = null;
try
{
conto = new ConnectionLayer.ConnectionClass();
ds = new DataSet();
sda = new SqlDataAdapter("getfromidplanets", conto.OpenConn());
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.SelectCommand.Parameters.AddWithValue("@pplntid", cde);
sda.Fill(ds);
return ds;
}
catch (SqlException x)
{
throw x;
}
finally
{
conto.CloseConn();
}
}
internal Task<int> DeleteRec(int id)
{
int res = 0;
ConnectionLayer.ConnectionClass conto = null;
SqlCommand cmd = null;
try
{
conto = new ConnectionLayer.ConnectionClass();
cmd = new SqlCommand("DeleteMyRecord", conto.OpenConn());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EID", id);
res = cmd.ExecuteNonQuery();
conto.CloseConn();
return Task.FromResult(res);
}
catch (Exception e)
{
throw e;
}
}
public DataSet GetDetails()
{
try
{
DataSet ds = new DataSet();
ConnectionLayer.ConnectionClass cn = new ConnectionLayer.ConnectionClass();
SqlDataAdapter sda = new SqlDataAdapter("getallplanets", cn.OpenConn());
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
sda.Fill(ds);
cn.CloseConn();
return ds;
}
catch (SqlException x)
{
throw x;
}
}
internal Task<int> InsertToTemp(Models.PlanetBooking book)
{
int res = 0;
ConnectionLayer.ConnectionClass conto = null;
SqlCommand cmd = null;
try
{
conto = new ConnectionLayer.ConnectionClass();
cmd = new SqlCommand("InsertOn", conto.OpenConn());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@pEID", book.EID);
cmd.Parameters.AddWithValue("@pPlID", book.PlanetID);
cmd.Parameters.AddWithValue("@pHumnNme", book.HumanName);
cmd.Parameters.AddWithValue("@pGendr", book.Gender);
cmd.Parameters.AddWithValue("@pFamily", book.FamilySize);
res = cmd.ExecuteNonQuery();
return Task.FromResult(res);
}
catch (Exception)
{
throw;
}
finally
{
conto.CloseConn();
}
}
