public int DL_InsUpdServiceDesk(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ServiceID", objML_Visitor.ID),
                            new SqlParameter("@GuestName", objML_Visitor.Name),
                            new SqlParameter("@RoomNo",    objML_Visitor.RoomNo),
                            new SqlParameter("@ItemID",    objML_Visitor.ItemName),
                            new SqlParameter("@ItemType",  objML_Visitor.ItemType),
                            new SqlParameter("@ItemPrice", objML_Visitor.RoomPrice),
                            new SqlParameter("@CreatedBy", objML_Visitor.CreatedBy),
                            new SqlParameter("@ModifyBy",  objML_Visitor.ModifyBy) };
     return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpd_Service_Desk_Master", par));
 }
 public int DL_SaveVisitorDetail(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@VisitorID",       objML_Visitor.ID),
                            new SqlParameter("@NamePrefix",      objML_Visitor.NamePrefix),
                            new SqlParameter("@GuestName",       objML_Visitor.Name),
                            new SqlParameter("@Address",         objML_Visitor.Address),
                            new SqlParameter("@State",           objML_Visitor.State),
                            new SqlParameter("@City",            objML_Visitor.City),
                            new SqlParameter("@ZipCode",         objML_Visitor.ZipCode),
                            new SqlParameter("@Country",         objML_Visitor.Country),
                            new SqlParameter("@RoomName",        objML_Visitor.RoomName),
                            new SqlParameter("@RoomNo",          objML_Visitor.RoomNo),
                            new SqlParameter("@ArrivalDate",     objML_Visitor.ArrivalDate),
                            new SqlParameter("@ArrivalTime",     objML_Visitor.ArrivalTime),
                            new SqlParameter("@DepartureDate",   objML_Visitor.DepartureDate),
                            new SqlParameter("@DepartureTime",   objML_Visitor.DepartureTime),
                            new SqlParameter("@Days",            objML_Visitor.Days),
                            new SqlParameter("@Adults",          objML_Visitor.Adults),
                            new SqlParameter("@Child",           objML_Visitor.Child),
                            new SqlParameter("@ReservationType", objML_Visitor.ReservationType),
                            new SqlParameter("@Email",           objML_Visitor.Email),
                            new SqlParameter("@PhoneNo",         objML_Visitor.PhoneNo),
                            new SqlParameter("@MobileNo",        objML_Visitor.MobileNo),
                            new SqlParameter("@Fax",             objML_Visitor.Fax),
                            new SqlParameter("@Identity",        objML_Visitor.Identity),
                            new SqlParameter("@IdentityNo",      objML_Visitor.IdentityNo),
                            new SqlParameter("@Gender",          objML_Visitor.Gender),
                            new SqlParameter("@BillType",        objML_Visitor.BillType),
                            new SqlParameter("@PaymentType",     objML_Visitor.PaymentType),
                            new SqlParameter("@PaymentMode",     objML_Visitor.PaymentMode),
                            new SqlParameter("@RoomPrice",       objML_Visitor.RoomPrice),
                            new SqlParameter("@CreatedBy",       objML_Visitor.CreatedBy),
                            new SqlParameter("@ModifyBy",        objML_Visitor.ModifyBy),
                            new SqlParameter("@Discount",        objML_Visitor.DiscountPer),
                            new SqlParameter("@TaxName1",        objML_Visitor.TaxName1),
                            new SqlParameter("@TaxRate1",        objML_Visitor.TaxRate1),
                            new SqlParameter("@TaxAmt1",         objML_Visitor.TaxAmt1),
                            new SqlParameter("@TaxName2",        objML_Visitor.TaxName2),
                            new SqlParameter("@TaxRate2",        objML_Visitor.TaxRate2),
                            new SqlParameter("@TaxAmt2",         objML_Visitor.TaxAmt2),
                            new SqlParameter("@TaxName3",        objML_Visitor.TaxName3),
                            new SqlParameter("@TaxRate3",        objML_Visitor.TaxRate3),
                            new SqlParameter("@TaxAmt3",         objML_Visitor.TaxAmt3),
                            new SqlParameter("@TaxableAmount",   objML_Visitor.TaxableAmount),
                            new SqlParameter("@DiscountAmt",     objML_Visitor.DiscountAmt),
                            new SqlParameter("@GrandTotal",      objML_Visitor.GrandTotal), };
     return(SqlHelper.ExecuteNonQuery(con, "SPCN_Insert_Hotel_Check_In", par));
 }
 public int DL_InsUpdVisitorCheckout(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@CheckOutID",       objML_Visitor.ID),
                            new SqlParameter("@VisitorID",        objML_Visitor.VisitorID),
                            new SqlParameter("@RoomNo",           objML_Visitor.RoomNo),
                            new SqlParameter("@RoomPrice",        objML_Visitor.RoomAmount),
                            new SqlParameter("@ServiceDeskPrice", objML_Visitor.ServiceDeskAmount),
                            new SqlParameter("@CreatedBy",        objML_Visitor.CreatedBy),
                            new SqlParameter("@ModifyBy",         objML_Visitor.ModifyBy),
                            new SqlParameter("@TotolAmount",      objML_Visitor.TotolAmount),
                            new SqlParameter("@TaxName1",         objML_Visitor.TaxName1),
                            new SqlParameter("@TaxRate1",         objML_Visitor.TaxRate1),
                            new SqlParameter("@TaxAmt1",          objML_Visitor.TaxAmt1),
                            new SqlParameter("@TaxName2",         objML_Visitor.TaxName2),
                            new SqlParameter("@TaxRate2",         objML_Visitor.TaxRate2),
                            new SqlParameter("@TaxAmt2",          objML_Visitor.TaxAmt2),
                            new SqlParameter("@TaxName3",         objML_Visitor.TaxName3),
                            new SqlParameter("@TaxRate3",         objML_Visitor.TaxRate3),
                            new SqlParameter("@TaxAmt3",          objML_Visitor.TaxAmt3),
                            new SqlParameter("@TaxableAmount",    objML_Visitor.TaxableAmount),
                            new SqlParameter("@DiscountAmt",      objML_Visitor.DiscountAmt),
                            new SqlParameter("@GrandTotal",       objML_Visitor.GrandTotal), };
     return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpd_CheckOut_Visitor", par));
 }
 public DataTable BL_BindCityList(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_BindCityList(objML_Visitor));
 }
 public DataTable DL_BindStateList(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_StateMasterProjectWise_Select", par).Tables[0]);
 }
 public DataTable DL_Get_Tax_Rate(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_GET_Tax_Rate", par).Tables[0]);
 }
 public DataTable DL_DropDownSelectionVisitors(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_Checkout_DropdownSelection", par).Tables[0]);
 }
 public int DL_InsUpdVisitorCheckoutDetail(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@CheckOutID", objML_Visitor.ID),
                            new SqlParameter("@ServiceID",  objML_Visitor.ServiceDaskID), };
     return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpd_CheckOut_Visitor_Detail", par));
 }
 public int BL_InsUpdVisitorCheckOutDetail(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_InsUpdVisitorCheckoutDetail(objML_Visitor));
 }
 public DataTable BL_Select_Service_Desk_Detail(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_Select_Service_Desk_Details(objML_Visitor));
 }
 public int BL_InsUpdServiceDesk(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_InsUpdServiceDesk(objML_Visitor));
 }
 public DataTable BL_Select_Item_List(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_Select_Item_List(objML_Visitor));
 }
 public DataTable BL_Bind_Check_In_List(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_Bind_Check_In_List(objML_Visitor));
 }
 public int BL_SaveVisitorsDetail(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_SaveVisitorDetail(objML_Visitor));
 }
 public DataTable DL_Select_Service_Desk_Details(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID",     objML_Visitor.Name),
                            new SqlParameter("@RoomNo", objML_Visitor.RoomNo) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_Service_Desk_Select_Against_Guest", par).Tables[0]);
 }
 public int BL_UpdVisitorCheckOutData(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_UpdVisitorCheckoutData(objML_Visitor));
 }
 public DataTable BL_DropdownSelectionVisitors(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_DropDownSelectionVisitors(objML_Visitor));
 }
 public int DL_UpdVisitorCheckoutData(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.VisitorID), };
     return(SqlHelper.ExecuteNonQuery(con, "SPCN_Update_CheckOut_Visitor_Detail", par));
 }
 public DataTable BL_Bind_Departure_List(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_Bind_Departure_List(objML_Visitor));
 }
 public DataTable DL_Bind_Departure_List(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_Hotel_Departure_bind", par).Tables[0]);
 }
 public DataTable BL_GET_Tax_Rate(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_Get_Tax_Rate(objML_Visitor));
 }
 public DataTable DL_SelectRoomNo(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_RoomMaster_Select", par).Tables[0]);
 }
 public DataTable DL_Select_Check_In_List(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_Hotel_Check_In_Select", par).Tables[0]);
 }
 public DataTable DL_BindCityList(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID", objML_Visitor.ID) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_City_Select", par).Tables[0]);
 }
 public DataTable DL_Select_Item_List(ML_Visitors objML_Visitor)
 {
     SqlParameter[] par = { new SqlParameter("@ID",     objML_Visitor.ID),
                            new SqlParameter("@ItemID", objML_Visitor.Name) };
     return(SqlHelper.ExecuteDataset(con, "SPCN_ITEM_Price_List", par).Tables[0]);
 }
 public DataTable BL_EditRoomVisitorDetail(ML_Visitors objML_RoomMaster)
 {
     return(objDL_RoomMaster.DL_EditRoomVisitorList(objML_RoomMaster));
 }
 public DataTable BL_SelectRoomNo(ML_Visitors objML_Visitor)
 {
     return(objDL_Visitor.DL_SelectRoomNo(objML_Visitor));
 }