public static List <PackagesList> GetPackagesDetails()
{
List <PackagesList> PackageData = new List <PackagesList>();
PackagesList LPackages = null;
System.Data.SqlClient.SqlConnection conn = Connection.GetConnection();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("Select * from Packages order by Packages.PkgName Asc", conn);
System.Data.SqlClient.SqlDataReader reader;
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
LPackages = new PackagesList((int)reader["PackageId"], reader["PkgName"].ToString(), Convert.ToDateTime(reader["PkgStartDate"]), Convert.ToDateTime(reader["PkgEndDate"]), (string)reader["PkgDesc"], (decimal)reader["PkgBasePrice"], (decimal)reader["PkgAgencyCommission"], DateTime.Today, "", 0);
PackageData.Add(LPackages);
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(PackageData);
}
public static List <PackagesList> GetPackage(int PackageId)
{
List <PackagesList> PackageData = new List <PackagesList>();
PackagesList LPackages = null;
System.Data.SqlClient.SqlConnection conn = Connection.GetConnection();
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("select P.PackageId,P.PkgName,P.PkgStartDate,P.PkgEndDate,P.PkgDesc,P.PkgBasePrice,P.PkgAgencyCommission,B.BookingDate,B.BookingNo,B.TravelerCount from Bookings B inner join Packages P on P.PackageId = B.PackageId where B.PackageId = " + PackageId + "", conn);
System.Data.SqlClient.SqlDataReader reader;
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
LPackages = new PackagesList((int)reader["PackageId"], reader["PkgName"].ToString(), Convert.ToDateTime(reader["PkgStartDate"]), Convert.ToDateTime(reader["PkgEndDate"]), (string)reader["PkgDesc"], (decimal)reader["PkgBasePrice"], (decimal)reader["PkgAgencyCommission"], (DateTime)reader["BookingDate"], (string)reader["BookingNo"], (double)reader["TravelerCount"]);
PackageData.Add(LPackages);
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(PackageData);
}
public static List <PackagesList> PackagesList(int Idcus)
{
List <PackagesList> listofPackages = new List <PackagesList>();
PackagesList LPackages = null;
System.Data.SqlClient.SqlConnection connection = Connection.GetConnection();
string selectQuery = "select Packages.PackageId,CustFirstName,CustEmail,PkgName,PkgStartDate,PkgEndDate,PkgDesc,PkgBasePrice" +
" from Customers inner join UserLogin on Customers.UserId = UserLogin.UserId inner join Packages" +
" on UserLogin.PackageId = Packages.PackageId where Customers.CustomerId = " + Idcus + "";
System.Data.SqlClient.SqlCommand selectCommand = new System.Data.SqlClient.SqlCommand(selectQuery, connection);
try
{
connection.Open();
System.Data.SqlClient.SqlDataReader reader = selectCommand.ExecuteReader();
while (reader.Read())
{
LPackages = new PackagesList((int)reader["PackageId"], reader["PkgName"].ToString(), Convert.ToDateTime(reader["PkgStartDate"]), Convert.ToDateTime(reader["PkgEndDate"]), (string)reader["PkgDesc"], (decimal)reader["PkgBasePrice"], 0, DateTime.Today, "", 0);
listofPackages.Add(LPackages);
CustomersDetails.UserName = (string)reader["CustFirstName"];
}
}
catch (System.Data.SqlClient.SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(listofPackages);
}
