public DataTable GetNightsDetail(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@packageId", obj._packageId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public int UpdatePackage(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.UpdateCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.UpdateCommand.Parameters.AddWithValue("@Action", obj._Action); da.UpdateCommand.Parameters.AddWithValue("@packageId", obj._packageId); da.UpdateCommand.Parameters.AddWithValue("@packageName", obj._packageName); da.UpdateCommand.Parameters.AddWithValue("@PackageDesc", obj.PackageDescription); da.UpdateCommand.Parameters.AddWithValue("@PackageImage", obj.ImagePath); da.UpdateCommand.Parameters.AddWithValue("@ItineraryLink", obj.ItineraryLink); da.UpdateCommand.Parameters.AddWithValue("@IsActive", obj.IsActive); da.UpdateCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.UpdateCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public int DeletePackage(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.DeleteCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.DeleteCommand.Parameters.AddWithValue("@Action", obj._Action); da.DeleteCommand.Parameters.AddWithValue("@packageId", obj._packageId); da.DeleteCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.DeleteCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public DataTable Getpackagebydates(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@CheckInDate", obj.Checkin); da.SelectCommand.Parameters.AddWithValue("@CheckOutDate", obj.checkout); //da.SelectCommand.Parameters.AddWithValue("@NoOfNights", obj._NoOfNights); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
public int AddPackageNights(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.InsertCommand.Parameters.AddWithValue("@Action", obj._Action); da.InsertCommand.Parameters.AddWithValue("@packageId", obj._packageId); da.InsertCommand.Parameters.AddWithValue("@night", obj._night); da.InsertCommand.Parameters.AddWithValue("@cityId", obj._cityId); da.InsertCommand.Parameters.AddWithValue("@checkIn", obj._AllowCheckIn); da.InsertCommand.Parameters.AddWithValue("@checkOut", obj._AllowCheckOut); da.InsertCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.InsertCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }
public int AddNewPackage(BALPackageMaster obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.InsertCommand = new SqlCommand("[dbo].[sp_Package]", cn); da.InsertCommand.Parameters.AddWithValue("@Action", obj._Action); da.InsertCommand.Parameters.AddWithValue("@packageId", obj._packageId); da.InsertCommand.Parameters.AddWithValue("@packageName", obj._packageName); da.InsertCommand.Parameters.AddWithValue("@NoOfNights", obj._NoOfNights); da.InsertCommand.Parameters.AddWithValue("@pakageType", obj._pakageType); da.InsertCommand.Parameters.AddWithValue("@MasterpackageId", obj._MasterPackageId); da.InsertCommand.Parameters.AddWithValue("@boardingFrom", obj._BoardingFrom); da.InsertCommand.Parameters.AddWithValue("@BoardingTo", obj._BoardingTo); da.InsertCommand.Parameters.AddWithValue("@HotelId", obj._HotelId); da.InsertCommand.Parameters.AddWithValue("@creationDate", obj._creationDate); da.InsertCommand.Parameters.AddWithValue("@ItineraryLink", obj.ItineraryLink); da.InsertCommand.Parameters.AddWithValue("@PackageDesc", obj.PackageDescription); da.InsertCommand.Parameters.AddWithValue("@PackageImage", obj.ImagePath); da.InsertCommand.Parameters.AddWithValue("@IsActive", obj.IsActive); da.InsertCommand.CommandType = CommandType.StoredProcedure; cn.Open(); int Status = da.InsertCommand.ExecuteNonQuery(); cn.Close(); if (Status > 0) { return(Status); } else { return(0); } } catch (Exception) { return(0); } }