public DataSet PreBookingUpdate(PrebookingBo PreBo)
{
try
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPreBookingDomain(PreBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Trans_No", Listing.Trans_No), //1
new SqlParameter("@paid_status", Listing.paid_status), //2
new SqlParameter("@credit_debit_card", Listing.credit_debit_card), //3
new SqlParameter("@card_no", Listing.card_no), //4
new SqlParameter("@card_type", Listing.card_type), //5
new SqlParameter("@Invce_Num", Listing.Invce_Num), //6
new SqlParameter("@BookingStatus", Listing.paid_status), //6
// new SqlParameter("@AllInfo",Listing.AllInfo),//6
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_UpdateTransaction]", Params);
return(ds);
}
catch (Exception ex)
{
ApplicationErrorLogServices.AppException(ex);
return(null);
}
}
public DataSet GetAllTransaction(PrebookingBo PreBo)
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPreBookingDomain(PreBo);
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Cons_Id", Listing.Cons_Id), //0
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_SelectAllTransaction]", Params);
return(ds);
}
public DataSet PreBooking(PrebookingBo PreBo)
{
var transactionStatus = new TransactionStatus();
var Listing = BuiltPreBookingDomain(PreBo);
if (Listing.Invce_note == null)
{
Listing.Invce_note = "";
}
CemexDb con = new CemexDb();
SqlParameter[] Params =
{
new SqlParameter("@Vndr_ID", Listing.Vndr_ID), //0
new SqlParameter("@Prop_Id", Listing.PropId), //3
new SqlParameter("@Room_Id", Listing.RoomID), //2
new SqlParameter("@Cons_Id", Listing.Cons_Id), //3
new SqlParameter("@Checkin", Listing.Room_Checkin), //5
new SqlParameter("@Checkout", Listing.Room_Checkout), //6
new SqlParameter("@Room_Count", Listing.Room_Count), //7
new SqlParameter("@prop_room_rate", Listing.prop_room_rate), //8
new SqlParameter("@camo_room_rate", Listing.camo_room_rate), //9
//new SqlParameter("@camo_room_rate",Listing.camo_room_rate),//9
new SqlParameter("@tax_amnt", Listing.tax_amnt), //10
new SqlParameter("@net_amt", Listing.net_amt), //11
new SqlParameter("@Invce_note", Listing.Invce_note), //12
new SqlParameter("@redmpt_points", Listing.redmpt_points), //18
new SqlParameter("@redmpt_value", Listing.redmpt_value), //19
new SqlParameter("@Promo_Type", Listing.Promo_Type), //20
new SqlParameter("@Prop_Value", Listing.Prop_Value), //21
new SqlParameter("@ipaddress", Listing.ipaddress), //22
new SqlParameter("@GuestName", Listing.GuestName), //23
};
DataSet ds = SqlHelper.ExecuteDataset(con.GetConnection(), CommandType.StoredProcedure, "[proc_AddTransaction]", Params);
return(ds);
}
private PreBookingDomain BuiltPreBookingDomain(PrebookingBo list)
{
return((PreBookingDomain) new PreBookingDomain().InjectFrom(list));
}