//public DataTable FinalBooking()
public DataSet funFinalBooking(String TransactionID, String Source, String DateOfBooking, String TimeOfBooking, String Location,
String Play, String ShowTime, String ShowDate, String Category, String PaymentType, String AgentCode, String SeatInfo,
String MobileNo, String EmailID, String CustomerName, int TotalSeats, decimal TotalAmount, String strPaymentReceiptNo)
{
try
{
if (SecurityHeaderValidation.Validate(objSecurity))
{
DataTable dt = VistaDAL._Select_Time_Api(TransactionID);
DateTime startdatetime = Convert.ToDateTime(dt.Rows[0][0]);
if (startdatetime.AddMinutes(25) >= DateTime.UtcNow)
{
TransactionRecord _tr = new TransactionRecord();
_tr.BookingID = long.Parse(TransactionID);
_tr.Location = Location;
_tr.Play = Play.ToUpper();
_tr.ShowTime = ShowTime;
_tr.ShowDate = ShowDate;
_tr.Category = Category;
_tr.SeatInfo = SeatInfo;
_tr.TotalSeats = TotalSeats;
_tr.Name = CustomerName;
_tr.MobileNo = MobileNo;
_tr.EmailID = EmailID;
_tr.AgentCode = AgentCode;
_tr.ReceiptNo = strPaymentReceiptNo;
_tr.DateOfBooking = DateOfBooking;
_tr.TimeOfBooking = TimeOfBooking;
_tr.Source = Source;
_tr.TotalAmount = TotalAmount;
_tr.TotalSeats = TotalSeats;
_tr.BookingID = long.Parse(TransactionID);
return(GTICKDAL.funFinalBooking(_tr));
}
else
{
DataSet dsexcep = new DataSet();
DataTable dtexcep = new DataTable();
dtexcep.Columns.Add("Column1", typeof(string));
dtexcep.Rows.Add("Session Time Out");
dsexcep.Tables.Add(dtexcep);
return(dsexcep);
}
}
}
catch (Exception ex)
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message);
}
return(null);
}
public static string NewYearBooking_Max()
{
string ID = GTICKDAL.NewYearBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("KODNY00000");
}
else
{
return(ID);
}
}
public static string EventBooking_Max()
{
string ID = GTICKDAL.EventBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("EVENT00000");
}
else
{
return(ID);
}
}
public static string YATRAPromotion_check(string pnrno)
{
string sum = GTICKDAL.YATRAPromotion_check(pnrno);
if (sum == null || sum.ToString() == "")
{
return("0");
}
else
{
return(sum);
}
}
public static string BotyBooking_Max()
{
string ID = GTICKDAL.BotyBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("BOTY00000");
}
else
{
return(ID);
}
}
public static string DandiyaBooking_Max()
{
string ID = GTICKDAL.DandiyaBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("KODDN00000");
}
else
{
return(ID);
}
}
public static string MMTpackage_check(string pnrno)
{
string sum = GTICKDAL.MMTpackage_check(pnrno);
if (sum == null || sum.ToString() == "")
{
return("0");
}
else
{
return(sum);
}
}
public static string ValentineBooking_Max()
{
string ID = GTICKDAL.ValentineBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("KODVL00000");
}
else
{
return(ID);
}
}
public static string MMTBooking_Max()
{
string ID = GTICKDAL.MMTBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("KODMMT00000");
}
else
{
return(ID);
}
}
public static string SummerBooking_Max()
{
string ID = GTICKDAL.SummerBooking_Max();
if (ID == null || ID.ToString() == "")
{
return("KODSUM00000");
}
else
{
return(ID);
}
}
public static string BollyLand_Max()
{
string ID = GTICKDAL.BollyLand_Max();
if (ID == null || ID.ToString() == "")
{
return("KOD/BL00000");
}
else
{
return(ID);
}
}
public long TransactionCounterMax()
{
try
{
if (SecurityHeaderValidation.Validate(objSecurity))
{
return(GTICKDAL._TransactionCounter_Max());
}
}
catch (Exception ex)
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message);
}
return(0);
}
public decimal GetSeatPriceSeatKeyNoWise(long TransactionID)
{
try
{
if (SecurityHeaderValidation.Validate(objSecurity))
{
return(GTICKDAL.GetSeatPriceSeatKeyNoWise(TransactionID));
}
}
catch (Exception ex)
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message);
}
return(0);
}
public DataSet CheckSeatsAndLock(string SeatNo, string showDate, string ShowTime, long TransactionID)
{
try
{
if (SecurityHeaderValidation.Validate(objSecurity))
{
DataTable classcode = VistaDAL._Select_classcode(SeatNo, showDate, ShowTime);//this functon select all the categories of the seats, selected by the user.
string classcodestring = "";
for (int i = 0; i < classcode.Rows.Count; i++)
{
classcodestring = classcodestring + classcode.Rows[i]["class Code"].ToString() + ",";
}
classcodestring = classcodestring.Remove(classcodestring.Length - 1);
string[] classcodearray = classcodestring.Split(',');
var distinctclasscode = (from w in classcodearray //decide whether categories are same or not
select w).Distinct().ToArray();
string[] SeatKeyNo = SeatNo.Split(',');
var distinctkeyno = (from w in SeatKeyNo //decide whether key no are repitative or not
select w).Distinct().ToArray();
if (SeatKeyNo.Length == distinctkeyno.Length && distinctclasscode.Length == 1)
{
return(GTICKDAL.CheckSeatsAndLock(TransactionID, SeatNo, showDate, ShowTime));
}
else
{
DataSet dsexcep = new DataSet();
DataTable dtexcep = new DataTable();
dtexcep.Columns.Add("Column1", typeof(int));
dtexcep.Rows.Add(0);
dsexcep.Tables.Add(dtexcep);
return(dsexcep);
}
}
}
catch (Exception ex)
{
Microsoft.Practices.EnterpriseLibrary.Logging.Logger.Write(ex.Message);
}
return(null);
}
public static long MarchPromotionTransactionCounter_Max(long ID)
{
return(GTICKDAL._MarchPromotionTransactionCounter_Max(ID));
}
public static DataTable Get_AllSeatPrice_SeatKeyNoWise(long TransactionID)
{
return(GTICKDAL._Get_AllSeatPrice_SeatKeyNoWise(TransactionID));
}
public static long TransactionCounter_Max()
{
return(GTICKDAL._TransactionCounter_Max());
}
public static int Check_Seats_BeforeProceed(TransactionRecord _tr)
{
return(int.Parse(GTICKDAL._Check_Seats_BeforeProceed(_tr.BookingID, _tr.SeatInfo, _tr.Play).Rows[0][0].ToString()));
}
public static decimal Get_SeatPrice_SeatKeyNoWise(long _TransactionID)
{
return(decimal.Parse(GTICKDAL._Get_SeatPrice_SeatKeyNoWise(_TransactionID).Rows[0][0].ToString()));
}
public static DataTable SelectTempSessionTable_one(long _TransactionID)
{
return(GTICKDAL._SelectTempSessionTable_one(_TransactionID));
}
public static int ON_Session_out(String _KeyNo)
{
return(GTICKDAL._ON_Session_out(_KeyNo));
}
public static DataTable select_Seat_Layout(String _AudiNo)
{
return(GTICKDAL._select_Seat_Layout(_AudiNo));
}
public static long Insert_tempTransaction_Table(TransactionRecord _tr)
{
return(GTICKDAL._Insert_tempTransaction_Table(_tr.KeyNo, _tr.BookingID, _tr.TotalSeats, _tr.Category, _tr.SeatInfo, _tr.ShowDate, _tr.ShowTime));
}
public static DataTable SelectRow_AudiWise(String _filmCode)
{
return(GTICKDAL._SelectRow_AudiWise(_filmCode));
}
public static int Insert_Payment_DB(string error, string bookingid, string pgname)
{
return(GTICKDAL.Insert_Payment_DB(error, bookingid, pgname));
}
public static void Insert_SeatInfo(string seatinfo, long TransectionCounter)
{
GTICKDAL.Insert_SeatInfo(seatinfo, TransectionCounter);
}
public static bool ValidateAgent(string username, string password)
{
return(GTICKDAL.ValidateAgent(username, password));
}
public static int Set_finalstatus(int AuditNo, string ShowName, string ShowLocation, string ShowDate, string ShowTime, int Iscompleted)
{
return(GTICKDAL.Set_finalstatus(AuditNo, ShowName, ShowLocation, ShowDate, ShowTime, Iscompleted));
}
public static int Delete_audit(string check)
{
return(GTICKDAL.Delete_audit(check));
}
public static int Update_audit(DataTable dt_insertvaccant)
{
return(GTICKDAL.Update_audit(dt_insertvaccant));
}