public DataTable GetBookableRoomDetails(BALAgentRooms obj) { try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_agentMaxRooms]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@AgentId", obj._AgentId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null && dtReturnData.Rows.Count > 0) { foreach (DataRow row in dtReturnData.Rows) { row["AgentName"] = DataSecurityManager.Decrypt(row["AgentName"].ToString()); } return(dtReturnData); } else { return(null); } } catch (Exception) { return(null); } }
protected void btnCustLogin_Click(object sender, EventArgs e) { try { blcus.Email = txtCustMailId.Text.Trim(); blcus.Password = txtCustPass.Text.Trim(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); if (dtCustomer != null) { if (dtCustomer.Rows.Count > 0) { Session["CustMailId"] = txtCustMailId.Text.Trim(); ViewState["Pass"] = txtCustPass.Text.Trim(); lblBillingAddress.Text = dtCustomer.Rows[0]["BillingAddress"].ToString(); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lbPaymentMethod.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["PaymentMethod"].ToString()); hdnfPhoneNumber.Value = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Telephone"].ToString()); Session["CustId"] = dtCustomer.Rows[0]["CustId"].ToString(); Session["CustomerCode"] = dtCustomer.Rows[0]["CustId"].ToString(); Session.Add("CustomerMailId", DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Email"].ToString())); Session.Add("CustPassword", DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Password"].ToString())); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()) + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Self"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "N/A"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; pnlBookButton.Visible = true; customerLogin.Visible = false; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } //Bookingdt = Session["Bookingdt"] as DataTable; // preparetables(Bookingdt); } catch { } }
public string GetBillingAddress(DataTable dataRow) { address1 = DataSecurityManager.Decrypt(dataRow.Rows[0]["Address1"].ToString()); address2 = DataSecurityManager.Decrypt(dataRow.Rows[0]["Address2"].ToString()); city = DataSecurityManager.Decrypt(dataRow.Rows[0]["City"].ToString()); state = DataSecurityManager.Decrypt(dataRow.Rows[0]["State"].ToString()); postalCode = DataSecurityManager.Decrypt(dataRow.Rows[0]["PostalCode"].ToString()); return(string.Format("{0} {1}, {2} {3} {4}", address1, address2, city, state, postalCode)); }
protected void Page_Load(object sender, EventArgs e) { string t = "VDIzaDQ1aXMxMjRJNTRz"; string PassportNo = DataSecurityManager.Decrypt(t.ToString()); if (Session["CustName"] != null) { //lblUsername.Text = "Hello " + Session["CustName"].ToString(); } if (!IsPostBack) { LoadCountries(); } }
public BookingDTMail[] GetBookingDetailsmail(int bookingid) { BookingDTMail[] oBRD = null; DatabaseManager oDB = null; try { oDB = new DatabaseManager(); string sProcName = "BookingDetailsformail"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@bookingid", DbType.Int32, bookingid); DataSet dsBRD = null; dsBRD = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; if (dsBRD != null) { oBRD = new BookingDTMail[dsBRD.Tables[0].Rows.Count]; for (int i = 0; i < oBRD.Length; i++) { oBRD[i] = new BookingDTMail(); oBRD[i].Bookingcode = dsBRD.Tables[0].Rows[i][0].ToString(); oBRD[i].AgentName = DataSecurityManager.Decrypt(dsBRD.Tables[0].Rows[i][1].ToString()); oBRD[i].RefAgentName = DataSecurityManager.Decrypt(dsBRD.Tables[0].Rows[i][2].ToString()); oBRD[i].Accomodation = Convert.ToString(dsBRD.Tables[0].Rows[i][3].ToString()); oBRD[i].checkin = Convert.ToDateTime(dsBRD.Tables[0].Rows[i][4].ToString()); oBRD[i].checkout = Convert.ToDateTime(dsBRD.Tables[0].Rows[i][5].ToString()); oBRD[i].bookingstatus = Convert.ToString(dsBRD.Tables[0].Rows[i][6].ToString()); oBRD[i].pax = Convert.ToInt32(dsBRD.Tables[0].Rows[i][7].ToString()); oBRD[i].Nights = Convert.ToInt32(dsBRD.Tables[0].Rows[i][8].ToString()); oBRD[i].Bookingref = Convert.ToString(dsBRD.Tables[0].Rows[i][9].ToString()); oBRD[i].chartered = Convert.ToBoolean((dsBRD.Tables[0].Rows[i][10] != null && dsBRD.Tables[0].Rows[i][10].ToString() != "")? dsBRD.Tables[0].Rows[i][10] : false); oBRD[i].packagename = Convert.ToString(dsBRD.Tables[0].Rows[i][11].ToString()); } dsBRD = null; } } catch (Exception exp) { oDB = null; // GF.LogError("clsBookingRoomReportsHandler.GetDetailedBookingDetails", exp.Message); return(null); } finally { oDB = null; } return(oBRD); }
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { string st = DataSecurityManager.Decrypt("VDIzaDQ1aXMxMjRJNTRzNTVNNjVpbDNxNDNGNVRpOXdoMHdnZGZnNDMzQzM0bDQ1U3RINTQ0aVNoNHM5U2YwbZa29muiOnz/yMzpkFm/2rcsgt8rk4zSTV0+MmcmpeZG"); UserDTO userDto; UserServices userServices; int iLoginId; userDto = new UserDTO(); userServices = new UserServices(); try { if (Login1.UserName.Trim().ToString() == "" || Login1.Password.Trim().ToString() == "") { e.Authenticated = false; } userDto.UserId = Login1.UserName.Trim().ToString(); userDto.Password = Login1.Password.Trim().ToString(); iLoginId = userServices.ValidateUser(userDto); if (iLoginId > 0) { Session["getadmin"] = Login1.UserName.Trim().ToString(); Session["iLoginId"] = iLoginId; e.Authenticated = true; SessionServices.LoginId = iLoginId; } else if (iLoginId <= 0) { iLoginId = 0; //SessionHandler"LoginId"] = 0; SessionServices.LoginId = iLoginId; e.Authenticated = false; } } catch (Exception exp) { Page.ClientScript.RegisterStartupScript(this.GetType(), "errorMsg", "" + exp.Message + "');"); //Console.Write(exp.Message); } finally { userServices = null; userDto = null; } }
public List <AgentMarket> BindControlsAgentmarket(BALLinks obj) { List <AgentMarket> agentMarkets = new List <AgentMarket>(); try { SqlConnection cn = new SqlConnection(strCon); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand("[dbo].[sp_Links]", cn); da.SelectCommand.Parameters.Clear(); da.SelectCommand.Parameters.AddWithValue("@Action", obj._Action); da.SelectCommand.Parameters.AddWithValue("@marketid", obj._MarketId); da.SelectCommand.CommandType = CommandType.StoredProcedure; cn.Open(); da.SelectCommand.ExecuteReader(); DataTable dtReturnData = new DataTable(); cn.Close(); da.Fill(dtReturnData); if (dtReturnData != null) { List <Action> actions = new List <Action>(); foreach (DataRow row in dtReturnData.Rows) { AgentMarket am = new AgentMarket { AgentId = Convert.ToInt32(row[0].ToString()), //AgentName = DataSecurityManager.Decrypt(row[1].ToString()), cnt = Convert.ToBoolean(row[2].ToString()) }; actions.Add(new Action(() => am.AgentName = DataSecurityManager.Decrypt(Convert.ToString(row[1])))); agentMarkets.Add(am); } ParallelOptions po = new ParallelOptions(); po.MaxDegreeOfParallelism = 100; Parallel.Invoke(po, actions.ToArray()); } return(agentMarkets); } catch (Exception) { return(null); } }
private void loaddetails(int bookingid) { blbooking._iBookingId = Convert.ToInt32(bookingid); DataTable dt = dlbooking.paymentreminder(blbooking); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["Name"] = DataSecurityManager.Decrypt(dt.Rows[i]["Name"].ToString()); dt.Rows[i]["lastname"] = DataSecurityManager.Decrypt(dt.Rows[i]["lastname"].ToString()); dt.Rows[i]["Email"] = DataSecurityManager.Decrypt(dt.Rows[i]["Email"].ToString()); dt.Rows[i]["Telephone"] = DataSecurityManager.Decrypt(dt.Rows[i]["Telephone"].ToString()); } } else { // ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Your final payment against this booking has been received. There is no outstanding.')", true); //ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('Your final payment against this booking has been received. There is no outstanding.');window.location.href = 'searchproperty1.aspx';", true); //string jv = "alert('Your final payment against this booking has been received. There is no outstanding.');"; //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "msg", jv, true); Response.Redirect("searchproperty1.aspx?ID=01"); // Response.Redirect("searchproperty1.aspx"); } lblAgentName.Text = dt.Rows[0]["Name"].ToString() + " " + dt.Rows[0]["lastname"].ToString(); Session["InvName"] = DataSecurityManager.Decrypt(dt.Rows[0]["Name"].ToString()) + " " + DataSecurityManager.Decrypt(dt.Rows[0]["lastname"].ToString()); try { { lblBillingAddress.Text = dt.Rows[0]["BillingAddress"].ToString(); Session["Address"] = dt.Rows[0]["BillingAddress"].ToString(); } } catch { lblBillingAddress.Text = GetBillingAddress(dt); Session["Address"] = GetBillingAddress(dt); } calculate(dt); Session["getdata"] = dt; }
private BookingTouristDTO[] FillTouristDetails(DataSet ds) { DataRow dr; BookingTouristDTO[] oBookingTouristDTO = null; if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; #region AssigningValues for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(1))); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(2))); } if (dr.ItemArray.GetValue(3) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))); } if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].Nationality = Convert.ToString(dr.ItemArray.GetValue(4)); } } #endregion AssigningValues } } return(oBookingTouristDTO); }
public AgentDTO AgentLoginForTouristEntry(BALLogin obj) { try { SqlConnection cn = new SqlConnection(strCon); string query = "select a.AgentId, AgentCode, AgentName, AgentEmailId, Password from tblAgentMaster a inner join tblBooking b on b.AgentId=a.AgentId where BookingID=" + obj.BookingId + " and AgentEmailId='" + DataSecurityManager.Encrypt(obj.EmailId) + "' and [password]='" + DataSecurityManager.Encrypt(obj.Password) + "'"; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = cn; cn.Open(); AgentDTO agent = null; SqlDataReader reader = cmd.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(reader); if (dt != null && dt.Rows.Count > 0) { agent = new AgentDTO(); agent.AgentId = dt.Rows[0]["AgentId"] != null?Convert.ToInt32(dt.Rows[0]["AgentId"]) : -1; agent.AgentCode = dt.Rows[0]["AgentCode"] != null ? dt.Rows[0]["AgentCode"].ToString() : string.Empty; agent.AgentName = dt.Rows[0]["AgentName"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["AgentName"].ToString()) : string.Empty; agent.EmailId = dt.Rows[0]["AgentEmailId"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["AgentEmailId"].ToString()) : string.Empty; agent.Password = dt.Rows[0]["Password"] != null?DataSecurityManager.Decrypt(dt.Rows[0]["Password"].ToString()) : string.Empty; } reader.Close(); cn.Close(); return(agent); } catch (Exception exp) { throw exp; } }
private UserDTO[] GetData(string sUserId) { UserDTO[] oUserData; oUserData = null; DataSet ds; string query = "select UserId, UserName, Password, Active, Administrator, UserRoleId, userEmailId from tbluserMaster where 1=1"; if (sUserId.Trim() != "") { query += " and UserId='" + sUserId + "'"; query += " order by UserId"; } ds = GetDataFromDB(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { oUserData = new UserDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { oUserData[i] = new UserDTO(); oUserData[i].UserId = Convert.ToString(ds.Tables[0].Rows[i][0]); oUserData[i].UserName = DataSecurityManager.Decrypt(Convert.ToString(ds.Tables[0].Rows[i][1])); oUserData[i].Password = DataSecurityManager.Decrypt(Convert.ToString(ds.Tables[0].Rows[i][2])); oUserData[i].Active = Convert.ToBoolean(ds.Tables[0].Rows[i][3]); oUserData[i].Administrator = Convert.ToBoolean(ds.Tables[0].Rows[i][4]); oUserData[i].EmailId = ds.Tables[0].Rows[i][6] != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(ds.Tables[0].Rows[i][6])) : String.Empty; UserRoleDTO userRoleDto = new UserRoleDTO(); if (ds.Tables[0].Rows[i][5] != DBNull.Value) { userRoleDto = GetUserRoleDetails(Convert.ToInt32(ds.Tables[0].Rows[i][5])); } oUserData[i].UserRoleData = userRoleDto; oUserData[i].RoleIdForDisplay = userRoleDto.UserRoleId; oUserData[i].RoleNameForDisplay = userRoleDto.UserRoleName; } } return(oUserData); }
private void btnDecryptText_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtEncryptedText.Text)) { MessageBox.Show("Please enter the encrypted text to decrypt"); return; } List <string> txtList = txtEncryptedText.Lines.ToList(); StringBuilder sb = new StringBuilder(); foreach (string encryptdText in txtList) { if (!string.IsNullOrWhiteSpace(encryptdText)) { sb.AppendLine(DataSecurityManager.Decrypt(encryptdText)); } } txtResult.Text = sb.ToString(); lblTotalLength.Text = txtResult.Text.Length.ToString(); }
private void getbycustid(int custid) { balcustomer.action = "selectbyCustid"; balcustomer.CustId = custid; DataTable dt = dalcustomer.selectbyCustid(balcustomer); if (dt != null && dt.Rows.Count > 0) { txtFisrtName.Text = DataSecurityManager.Decrypt(dt.Rows[0]["FirstName"].ToString()); txtLastName.Text = DataSecurityManager.Decrypt(dt.Rows[0]["LastName"].ToString()); txtEmail.Text = DataSecurityManager.Decrypt(dt.Rows[0]["Email"].ToString()); txtContactNo.Text = DataSecurityManager.Decrypt(dt.Rows[0]["Telephone"].ToString()); txtAddress1.Text = DataSecurityManager.Decrypt(dt.Rows[0]["Address1"].ToString()); txtAddress2.Text = DataSecurityManager.Decrypt(dt.Rows[0]["Address2"].ToString()); txtPost.Text = DataSecurityManager.Decrypt(dt.Rows[0]["City"].ToString()); txtState.Text = DataSecurityManager.Decrypt(dt.Rows[0]["State"].ToString()); txtCity.Text = DataSecurityManager.Decrypt(dt.Rows[0]["City"].ToString()); ddlCountry.SelectedValue = DataSecurityManager.Decrypt(dt.Rows[0]["CountryId"].ToString()); ddlTitle.SelectedValue = DataSecurityManager.Decrypt(dt.Rows[0]["Title"].ToString()); //ddlTitle.Items.FindByText(dt.Rows[0]["Title"].ToString()).Selected = true; //ddlCountry.Items.FindByValue(dt.Rows[0]["CountryId"].ToString()).Selected = true; } }
private void btnDecrypt_Click(object sender, EventArgs e) { List <UserMaster> userMasterDecryptedList = new List <UserMaster>(); foreach (DataGridViewRow row in dgEncrypted.Rows) { UserMaster um = row.DataBoundItem as UserMaster; UserMaster num = new UserMaster { Id = um.Id, UserId = um.UserId, UserName = DataSecurityManager.Decrypt(um.UserName), Password = DataSecurityManager.Decrypt(um.Password), userEmailId = um.userEmailId, Active = um.Active, Administrator = um.Administrator, UserRoleId = um.UserRoleId }; userMasterDecryptedList.Add(num); } dgDecrypted.DataSource = userMasterDecryptedList; }
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { try { blcus.Email = Login1.UserName.Trim().ToString(); blcus.Password = Login1.Password.Trim().ToString(); blcus.action = "LoginCust"; dtGetReturnedData = new DataTable(); dtGetReturnedData = dlcus.checkDuplicateemail(blcus); if (dtGetReturnedData != null) { Session.Add("CustName", DataSecurityManager.Decrypt(dtGetReturnedData.Rows[0]["FirstName"].ToString())); Session.Add("CustomerCode", dtGetReturnedData.Rows[0]["CustId"].ToString()); Session.Add("CustomerMailId", DataSecurityManager.Decrypt(Login1.UserName.Trim().ToString())); Session.Add("CustPassword", DataSecurityManager.Decrypt(dtGetReturnedData.Rows[0]["Password"].ToString())); Response.Redirect("SearchProperty.aspx"); } } catch (Exception exp) { throw exp; } }
private RoomBookingDateWiseDTO[] MapDBToObject(DataSet dbData) { List <RoomBookingDateWiseDTO> dateWiseBookingDataList = new List <RoomBookingDateWiseDTO>(); RoomBookingDateWiseDTO dateWiseBookingDTO = null; DataRow dr; try { if (dbData != null && dbData.Tables[0].Rows.Count > 0) { for (int i = 0; i < dbData.Tables[0].Rows.Count; i++) { dr = dbData.Tables[0].Rows[i]; dateWiseBookingDTO = new RoomBookingDateWiseDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { dateWiseBookingDTO.AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { dateWiseBookingDTO.RoomNo = Convert.ToString(dr.ItemArray.GetValue(1)); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { dateWiseBookingDTO.BookingId = Convert.ToInt32(dr.ItemArray.GetValue(2)); } if (dr.ItemArray.GetValue(3) != DBNull.Value) { dateWiseBookingDTO.BookingCode = Convert.ToString(dr.ItemArray.GetValue(3)).Trim(); } if (dr.ItemArray.GetValue(4) != DBNull.Value) { dateWiseBookingDTO.TourId = Convert.ToString(dr.ItemArray.GetValue(4)); } if (dr.ItemArray.GetValue(5) != DBNull.Value) { dateWiseBookingDTO.Startdate = Convert.ToDateTime(dr.ItemArray.GetValue(5).ToString()); } if (dr.ItemArray.GetValue(6) != DBNull.Value) { dateWiseBookingDTO.Enddate = Convert.ToDateTime(dr.ItemArray.GetValue(6).ToString()); } if (dr.ItemArray.GetValue(7) != DBNull.Value) { dateWiseBookingDTO.Noofnights = Convert.ToInt32(dr.ItemArray.GetValue(7)); } if (dr.ItemArray.GetValue(8) != null && dr.ItemArray.GetValue(8) != DBNull.Value) { dateWiseBookingDTO.BookingStatusId = Convert.ToInt32(dr.ItemArray.GetValue(8)); } else { dateWiseBookingDTO.BookingStatusId = 0; } if (dr.ItemArray.GetValue(9) != null && dr.ItemArray.GetValue(9) != DBNull.Value) { dateWiseBookingDTO.AgentName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(9))); } if (dr.ItemArray.GetValue(15) != null && dr.ItemArray.GetValue(15) != DBNull.Value) { dateWiseBookingDTO.RefAgentName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(15))); } if (dr.ItemArray.GetValue(10) != null && dr.ItemArray.GetValue(10) != DBNull.Value) { dateWiseBookingDTO.BookingReference = Convert.ToString(dr.ItemArray.GetValue(10)); } if (dr.ItemArray.GetValue(11) != null && dr.ItemArray.GetValue(11) != DBNull.Value) { dateWiseBookingDTO.BookingStatusType = Convert.ToString(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != null && dr.ItemArray.GetValue(12) != DBNull.Value) { dateWiseBookingDTO.Chartered = Convert.ToBoolean(dr.ItemArray.GetValue(12)); } else { dateWiseBookingDTO.Chartered = false; } if (dr.ItemArray.GetValue(13) != null && dr.ItemArray.GetValue(13) != DBNull.Value) { dateWiseBookingDTO.NoofRooms = Convert.ToInt32(dr.ItemArray.GetValue(13)); } if (dr.ItemArray.GetValue(14) != null && dr.ItemArray.GetValue(14) != DBNull.Value) { dateWiseBookingDTO.paxStaying = Convert.ToInt32(dr.ItemArray.GetValue(14)); } dateWiseBookingDataList.Add(dateWiseBookingDTO); } } } catch (Exception exp) { throw exp; } return(dateWiseBookingDataList.ToArray()); }
internal void DecryptData(List <ParentItem> items) { StringBuilder sb = new StringBuilder(); List <string> updateQueryCollection = new List <string>(); string updateQuery = string.Empty; List <string> columnNames = new List <string>(); foreach (var parentItem in items) { string tableName = parentItem.ItemName; foreach (var childItem in parentItem.Children) { string columnName = childItem.ItemName; //if (childItem.Selected) //{ // ChangeColumnLength(tableName, columnName); //} columnNames.Add(columnName); } string query = "select " + string.Join(", ", columnNames) + " from " + tableName; List <ColumnDetail> columnDetails = new List <ColumnDetail>(); var reader = GetData(query); while (reader.Read()) { columnDetails.Clear(); for (int i = 0; i < reader.FieldCount; i++) { ColumnDetail cd = new ColumnDetail(); cd.ColumnName = reader.GetName(i); cd.ColumnType = reader.GetFieldType(i); cd.Value = reader.GetValue(i); columnDetails.Add(cd); } #region Prepare the update part of the query updateQuery = "update " + tableName + " set "; foreach (var columnToBeEncrypted in parentItem.Children.Where(c => c.Selected)) { ColumnDetail cd = columnDetails.FirstOrDefault(c => string.Compare(c.ColumnName, columnToBeEncrypted.ItemName, true) == 0); updateQuery += columnToBeEncrypted.ItemName + " = '" + DataSecurityManager.Decrypt(cd.Value.ToString()).Replace("'", "''") + "', "; } if (updateQuery.Trim().EndsWith(",")) { updateQuery = updateQuery.Trim().Substring(0, updateQuery.Trim().Length - 1); } #endregion #region Prepare The Where Clause updateQuery += " where 1 = 1 "; foreach (var columnToBeEncrypted in parentItem.Children.Where(c => c.Selected)) { var otherColumn = columnDetails.FirstOrDefault(c => string.Compare(c.ColumnName, columnToBeEncrypted.ItemName, true) == 0); if (otherColumn == null) { continue; } string value = otherColumn.Value == DBNull.Value ? "NULL" : otherColumn.Value.ToString(); //Console.WriteLine(otherColumn.Value.ToString()); updateQuery += " and " + otherColumn.ColumnName + DecorateForSQlQuery(otherColumn.ColumnType, value); } #endregion updateQuery += ";"; updateQueryCollection.Add(updateQuery); sb.AppendLine(updateQuery); } reader.Close(); } string qc = sb.ToString(); foreach (var q in updateQueryCollection) { ExecuteNonQuery(q); } }
protected void btnPayProceed_Click(object sender, EventArgs e) { try { Session["Hotel"] = 1; if (btnPayProceed.Text == "Proceed For Payment") { if (Session["UserCode"] != null) { #region Book Via Agent //[email protected] [1:48:55 PM] Augurs Technologies Pvt. Ltd.: 12345 //DataTable dtrpax = Session["Bookingdt"] as DataTable; string BookRef = txtBookRef.Text + "X" + GetPax().ToString(); Session.Add("BookingRef", BookRef); Session["Paid"] = Convert.ToDouble(hftxtpaidamt.Value.Trim() == "" ? "0" : hftxtpaidamt.Value.Trim()); blagentpayment._Action = "MailValidate"; blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); var dtAgentData = dlagentpayment.BindControls(blagentpayment); if (dtAgentData.Rows.Count <= 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Agent not registered!!!')", true); return; } string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; BookTheHotel(); string Email = Session["AgentMailId"].ToString(); string PhoneNumber = "9999999999"; // hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = dtAgentData.Rows[0]["FirstName"] != DBNull.Value ? DataSecurityManager.Decrypt(dtAgentData.Rows[0]["FirstName"].ToString()) : "First Name"; string LastName = "XYZ"; //dtAgentData.Rows[0]["LastName"] != DBNull.Value ? DataSecurityManager.Decrypt(dtAgentData.Rows[0]["LastName"].ToString()) : "XYZ"; string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string BillingAddress = "abc/wsdd,vasant vihar"; // lblBillingAddress.Text.Trim().ToString(); Session["Address"] = lblBillingAddress.Text.Trim().ToString(); Session["InvName"] = FirstName; Session["SubInvName"] = FirstName; string[] arr = { }; if (FirstName != "" && FirstName != null) { arr = FirstName.Split(' '); } if (Debugger.IsAttached) { RedirectToPaymentGatewayResponse(); } else { //Response.Redirect("PaymentGatewayResponse.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://adventureresortscruises.in/Cruise/booking/sendtoairpay.aspx?BookedId=0&PackName=7N8D+Downstream+Cruise&NoOfNights=7&CheckinDate=12%2f4%2f2016&PackId=Pack4 Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + BookingPayId + "&EmailId=" + Email + "&PhoneNumber=" + PhoneNumber + "&FirstName=" + arr[0] + "&LastName=" + LastName + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress); //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } #endregion } else { #region Book Via Customer Session.Add("BookingRef", ViewState["BookRef"].ToString()); blcus.Email = DataSecurityManager.Decrypt(Session["CustomerMailId"].ToString()); blcus.Password = DataSecurityManager.Decrypt(Session["CustPassword"].ToString()); blcus.action = "LoginCust"; var dtCustomerData = new DataTable(); dtCustomerData = dlcus.checkDuplicateemail(blcus); Session["Paid"] = Convert.ToDouble(hftxtpaidamt.Value.Trim() == "" ? "0" : hftxtpaidamt.Value.Trim()); if (dtCustomerData.Rows.Count <= 0) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Customer not registered!!!')", true); return; } int persons = GetPax(); string bookingRef = string.Format("{0} {1} X {2}", DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["FirstName"].ToString()), DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["LastName"].ToString()), persons.ToString()); if (Session["BookingRef"] == null) { Session.Add("BookingRef", bookingRef); } else { Session["BookingRef"] = bookingRef; } Random rnd = new Random(); string BookingPayId = rnd.Next(10000, 20000).ToString() + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; BookTheHotel(); string Email = DataSecurityManager.Decrypt(Session["CustomerMailId"].ToString()); string PhoneNumber = "9999999999";// hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["FirstName"].ToString()); string LastName = dtCustomerData.Rows[0]["LastName"] == DBNull.Value ? DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["LastName"].ToString()) : "XYZ"; string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string PaymentId = BookingPayId.ToString(); string BillingAddress = "abc/wsdd,vasant vihar";// lblBillingAddress.Text.Trim().ToString(); Session["Address"] = lblBillingAddress.Text.Trim().ToString(); Session["InvName"] = DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["Title"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["LastName"].ToString()); Session["SubInvName"] = DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["LastName"].ToString()) + ", " + DataSecurityManager.Decrypt(dtCustomerData.Rows[0]["Title"].ToString()) + " " + FirstName; string[] arr = { }; if (FirstName != "" && FirstName != null) { arr = FirstName.Split(' '); } if (Debugger.IsAttached) { RedirectToPaymentGatewayResponse(); } else { Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + arr[0].ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://localhost:1897/ResortManager/Cruise/booking/SummerisedDetails.aspx?BookedId=0&PackName=Ganges+Exclusive&NoOfNights=5&CheckinDate=5%2f1%2f2016 //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } #endregion } } else { if (Convert.ToDecimal(hftxtpaidamt.Value) <= Convert.ToDecimal(hdnfCreditLimit.Value)) { string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; Session.Add("BookingRef", txtBookRef.Text.Trim().ToString()); Session["Paid"] = Convert.ToDouble(hftxtpaidamt.Value.Trim() == "" ? "0" : hftxtpaidamt.Value.Trim().ToString()); Session["InvName"] = DataSecurityManager.Decrypt(Session["UserName"].ToString()); Session["Address"] = null; Response.Redirect("PaymentGatewayResponse.aspx"); } else { lblPaymentErr.Text = "Payment Amount Exceeding Credit Limit"; } } } catch { } }
private UserAgentMapperDTO GetAgents(String query) { UserAgentMapperDTO userAgentMapperDTO = new UserAgentMapperDTO(); List <AgentDTO> hookedAgentList = new List <AgentDTO>(); AgentDTO hookedAgent = new AgentDTO(); DataSet ds; ds = GetDataFromDB(query); if (ds != null && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { hookedAgent = new AgentDTO(); hookedAgent.AgentId = ds.Tables[0].Rows[i][1] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i][1]); hookedAgent.AgentName = ds.Tables[0].Rows[i][2] == DBNull.Value ? String.Empty : DataSecurityManager.Decrypt(Convert.ToString(ds.Tables[0].Rows[i][2])); hookedAgentList.Add(hookedAgent); } } userAgentMapperDTO.AgentList = hookedAgentList; return(userAgentMapperDTO); }
protected void btnCustLogin_Click(object sender, EventArgs e) { if (Request.QueryString["bid"] != null) { try { string bid = Request.QueryString["bid"].ToString(); blcus.Email = txtCustMailId.Text.Trim(); blcus.Password = txtCustPass.Text.Trim(); blcus.action = "LoginCustForTEntry"; blcus.BookingId = Convert.ToInt32(bid); DataTable dtCustomer = dlcus.checkemailForTouristEntry(blcus); if (dtCustomer != null) { if (dtCustomer.Rows.Count > 0) { Session["userpass"] = txtCustPass.Text.Trim(); Session["CustMailId"] = txtCustMailId.Text.Trim(); Session["CustName"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()); Session["CustomerCode"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["CustId"].ToString()); string bEmail = dtCustomer.Rows[0][4].ToString(); string bPassword = dtCustomer.Rows[0][13].ToString(); string Email = DataSecurityManager.Encrypt(txtCustMailId.Text.Trim()); string Password = DataSecurityManager.Encrypt(txtCustPass.Text.Trim()); if (bEmail == Email) { if (bPassword == Password) { if (Request.QueryString["bid"] != null) { Response.Redirect("http://test1.adventureresortscruises.in/Cruise/Booking/Touristentry.aspx?bid=" + bid); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password incorrect')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Email Id incorrect')", true); } //customerLogin.Visible = false; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } //Bookingdt = Session["Bookingdt"] as DataTable; // preparetables(Bookingdt); } catch (Exception ex) { } } else { if (Session["CustMailId"] != null) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('You are already login')", true); return; } else { try { blcus.Email = txtCustMailId.Text.Trim(); blcus.Password = txtCustPass.Text.Trim(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); if (dtCustomer != null) { if (dtCustomer.Rows.Count > 0) { Session["userpass"] = txtCustPass.Text.Trim(); Session["CustMailId"] = txtCustMailId.Text.Trim(); Session["CustName"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()); Session["CustomerCode"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["CustId"].ToString()); if (Session["getavailable"] != null) { Response.Redirect(Session["getavailable"].ToString()); } else { Response.Redirect("../Booking/searchproperty1.aspx"); } //customerLogin.Visible = false; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } //Bookingdt = Session["Bookingdt"] as DataTable; // preparetables(Bookingdt); } catch (Exception ex) { } } } }
private void loadall() { if (Session["UserCode"] != null) { try { blagentpayment._Action = "MailValidate"; if (Session["AgentMailId"] != null && Session["Password"] != null) { blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { lblAgentName.Text = Session["UserName"].ToString(); lblBillingAddress.Text = dtAgent.Rows[0]["BillingAddress"].ToString(); lbPaymentMethod.Text = dtAgent.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtAgent.Rows[0]["Phone"].ToString(); hdnfCreditLimit.Value = dtAgent.Rows[0]["CreditLimit"].ToString(); bool oncredit = Convert.ToBoolean(dtAgent.Rows[0]["ChkCredit"].ToString()); pnlFullDetails.Visible = true; if (oncredit) { panelwithoutCreditAgent.Visible = false; panelwithoutCreditAgent.Visible = true; } else { panelwithoutCreditAgent.Visible = true; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Agent Payment Details Not found')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('It seems you are not logged in')", true); } } catch (Exception sqe) { } } else if (Session["CustomerCode"] != null) { try { DataTable dtCustomer = new DataTable(); blcus.Email = Session["CustMailId"].ToString(); if (Session["guest"] != null) { blcus.action = "getforguest"; dtCustomer = dlcus.getforguest(blcus); } else { blcus.Password = Session["userpass"].ToString(); Session["CustPassword"] = Session["userpass"].ToString(); blcus.action = "LoginCust"; dtCustomer = dlcus.checkDuplicateemail(blcus); } if (dtCustomer != null && dtCustomer.Rows.Count > 0) { Session["CustomerMailId"] = Session["CustMailId"].ToString(); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lblBillingAddress.Text = dlcus.GetBillingAddress(dtCustomer.Rows[0]); lbPaymentMethod.Text = dtCustomer.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtCustomer.Rows[0]["Telephone"].ToString(); Session["CustId"] = dtCustomer.Rows[0]["CustId"].ToString(); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("BookedRooms"); string BookRef = dtCustomer.Rows[0]["FirstName"].ToString() + dtCustomer.Rows[0]["LastName"].ToString() + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Direct Client"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "Online"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; } else { } } catch (Exception ex) { throw ex; } } }
private BookingTouristDTO[] GetTouristsDetails(int BookingId, int TouristNo) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; oBookingTouristDTO = null; string sProcName; try { oDB = new DatabaseManager(); sProcName = "up_Get_TouristDetails"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@TouristNo", DbType.Int32, TouristNo); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; GF.LogError("clsBookingTouristhandler.GetTouristDetails", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; #region AssigningValues for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); oBookingTouristDTO[i].BookingId = dr.ItemArray.GetValue(0) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(0)) : 0; oBookingTouristDTO[i].BookingCode = dr.ItemArray.GetValue(1) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(1)) : ""; oBookingTouristDTO[i].TouristNo = dr.ItemArray.GetValue(2) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(2)) : 0; oBookingTouristDTO[i].FirstName = dr.ItemArray.GetValue(3) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))) : ""; oBookingTouristDTO[i].MiddleName = dr.ItemArray.GetValue(4) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(4))) : ""; oBookingTouristDTO[i].LastName = dr.ItemArray.GetValue(5) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))) : ""; oBookingTouristDTO[i].Gender = dr.ItemArray.GetValue(6) != DBNull.Value ? Convert.ToChar(dr.ItemArray.GetValue(6)) : '\0'; oBookingTouristDTO[i].NationalityId = dr.ItemArray.GetValue(7) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(7)) : 0; oBookingTouristDTO[i].PassportNo = dr.ItemArray.GetValue(8) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(8))) : ""; oBookingTouristDTO[i].DateOfBirth = dr.ItemArray.GetValue(9) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(9).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].PlaceofBirth = dr.ItemArray.GetValue(10) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(10)) : ""; oBookingTouristDTO[i].PassportIssueDate = dr.ItemArray.GetValue(11) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(11).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].PassportExpiryDate = dr.ItemArray.GetValue(12) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(12).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].VisaNo = dr.ItemArray.GetValue(13) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(13))) : ""; oBookingTouristDTO[i].VisaExpiryDate = dr.ItemArray.GetValue(14) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(14).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].IndiaEntryDate = dr.ItemArray.GetValue(15) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(15).ToString()) : DateTime.MinValue; oBookingTouristDTO[i].ProposedStayInIndia = dr.ItemArray.GetValue(16) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(16)) : ""; oBookingTouristDTO[i].ArrivalDateTime = dr.ItemArray.GetValue(17) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(17)) : DateTime.MinValue; //oBookingTouristDTO[i].ArrivedFrom = dr.ItemArray.GetValue(18) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(18)):""; //oBookingTouristDTO[i].VehicleNo = dr.ItemArray.GetValue(19) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(19)):""; //oBookingTouristDTO[i].TransportCompany = dr.ItemArray.GetValue(20) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(20)):""; //oBookingTouristDTO[i].TransportMode = dr.ItemArray.GetValue(21) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(21)):""; oBookingTouristDTO[i].RoomDetails = dr.ItemArray.GetValue(22) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(22)) : ""; //oBookingTouristDTO[i].NextDestination = dr.ItemArray.GetValue(23) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(23)):""; oBookingTouristDTO[i].departuredate = dr.ItemArray.GetValue(24) != DBNull.Value ? Convert.ToDateTime(dr.ItemArray.GetValue(24)):DateTime.MinValue; oBookingTouristDTO[i].EmployedinIndia = dr.ItemArray.GetValue(25) != DBNull.Value ? Convert.ToBoolean(dr.ItemArray.GetValue(25)) : false; oBookingTouristDTO[i].VisitPurpose = dr.ItemArray.GetValue(26) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(26)) : ""; oBookingTouristDTO[i].PermanentAddressInIndia = dr.ItemArray.GetValue(27) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(27)) : ""; //oBookingTouristDTO[i].MealPlan = dr.ItemArray.GetValue(28) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(28)):""; oBookingTouristDTO[i].Allergies = dr.ItemArray.GetValue(29) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(29)) : ""; oBookingTouristDTO[i].MealPreferences = dr.ItemArray.GetValue(30) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(30)) : ""; oBookingTouristDTO[i].SpecialMessage = dr.ItemArray.GetValue(31) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(31)) : ""; //oBookingTouristDTO[i].VehicleName = dr.ItemArray.GetValue(32) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(32)) : ""; //oBookingTouristDTO[i].DriverName = dr.ItemArray.GetValue(33) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(33)) : ""; //oBookingTouristDTO[i].DriverPhoneNo = dr.ItemArray.GetValue(34) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(34)) : ""; //oBookingTouristDTO[i].TransportPhoneNo = dr.ItemArray.GetValue(35) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(35)) : ""; oBookingTouristDTO[i].Suffix = dr.ItemArray.GetValue(36) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(36)) : ""; oBookingTouristDTO[i].Nationality = GetNationalityName(oBookingTouristDTO[i].NationalityId); oBookingTouristDTO[i].CFormNo = dr.ItemArray.GetValue(37) != DBNull.Value ? Convert.ToInt32(dr.ItemArray.GetValue(37)) : 0; oBookingTouristDTO[i].EmailId = dr.ItemArray.GetValue(38) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(38)) : ""; oBookingTouristDTO[i].arrivalvehiaclno = dr.ItemArray.GetValue(40) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(40)) : ""; oBookingTouristDTO[i].departurevehicalno = dr.ItemArray.GetValue(41) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(41)) : ""; oBookingTouristDTO[i].departureairport = dr.ItemArray.GetValue(42) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(42)) : ""; oBookingTouristDTO[i].arrivalairport = dr.ItemArray.GetValue(43) != DBNull.Value ? Convert.ToString(dr.ItemArray.GetValue(43)) : ""; } #endregion AssigningValues } } return(oBookingTouristDTO); }
protected void btnSmbt_Click(object sender, EventArgs e) { if (Session["UserCode"] != null) { // pnlLogin.Visible = true; try { customerLogin.Visible = false; if (Session["AgentMailId"] != null && Session["Password"] != null) { blagentpayment._Action = "MailValidate"; blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { lblAgentName.Text = Session["UserName"].ToString(); lblBillingAddress.Text = dtAgent.Rows[0]["BillingAddress"].ToString(); lbPaymentMethod.Text = dtAgent.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtAgent.Rows[0]["Phone"].ToString(); hdnfCreditLimit.Value = dtAgent.Rows[0]["CreditLimit"].ToString(); bool oncredit = Convert.ToBoolean(dtAgent.Rows[0]["ChkCredit"].ToString()); pnlFullDetails.Visible = true; pnlBookButton.Visible = true; if (oncredit) { panelwithoutCreditAgent.Visible = false; btnPayProceed.Text = "Book"; } else { panelwithoutCreditAgent.Visible = true; btnPayProceed.Text = "Proceed For Payment"; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Agent Payment Details Not found')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('It seems you are not logged in')", true); } } catch (Exception sqe) { } } else if (Session["CustomerCode"] != null) { try { blcus.Email = Session["CustomerMailId"].ToString();; blcus.Password = Session["CustPassword"].ToString(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); if (dtCustomer != null) { Session["CustMailId"] = Session["CustomerMailId"].ToString(); ViewState["Pass"] = txtCustPass.Text.Trim(); lblBillingAddress.Text = dlcus.GetBillingAddress(dtCustomer.Rows[0]); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lbPaymentMethod.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["PaymentMethod"].ToString()); hdnfPhoneNumber.Value = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Telephone"].ToString()); Session["CustId"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["CustId"].ToString()); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()) + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Self"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "N/A"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; pnlBookButton.Visible = true; customerLogin.Visible = false; } Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); // preparetables(Bookingdt); } catch { } } else { pnlLogin.Visible = false; customerLogin.Visible = true; } //Bookingdt = Session["Bookingdt"] as DataTable; //preparetables(Bookingdt); }
protected void btnPayProceed_Click(object sender, EventArgs e) { try { Session["Hotel"] = 1; if (btnPayProceed.Text == "Proceed For Payment") { if (Session["UserCode"] != null) { //[email protected] [1:48:55 PM] Augurs Technologies Pvt. Ltd.: 12345 DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = txtBookRef.Text + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString(); Session.Add("BookingRef", BookRef); Session["Paid"] = Convert.ToDouble(txtPaidAmt.Text.Trim() == "" ? "0" : txtPaidAmt.Text.Trim()); blagentpayment._Action = "MailValidate"; blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); string Email = Session["AgentMailId"].ToString(); string PhoneNumber = hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = DataSecurityManager.Decrypt(dtAgent.Rows[0]["FirstName"].ToString()); string LastName = DataSecurityManager.Decrypt(dtAgent.Rows[0]["LastName"].ToString()); string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string PaymentId = BookingPayId.ToString(); string BillingAddress = lblBillingAddress.Text.Trim().ToString(); Session["BookingPayId"] = txtBookRef.Text.Trim();// BookingPayId; Session["Address"] = BillingAddress; Session["InvName"] = FirstName; Session["SubInvName"] = FirstName; //Response.Redirect("PaymentGatewayResponse.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://adventureresortscruises.in/Cruise/booking/sendtoairpay.aspx?BookedId=0&PackName=7N8D+Downstream+Cruise&NoOfNights=7&CheckinDate=12%2f4%2f2016&PackId=Pack4 Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } } else { Session.Add("BookingRef", ViewState["BookRef"].ToString()); blcus.Email = Session["CustomerMailId"].ToString(); blcus.Password = Session["CustPassword"].ToString(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); Session["Paid"] = Convert.ToDouble(txtPaidAmt.Text.Trim() == "" ? "0" : txtPaidAmt.Text.Trim()); if (dtCustomer.Rows.Count > 0) { Random rnd = new Random(); string BookingPayId = rnd.Next(10000, 20000).ToString() + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; string Email = Session["CustomerMailId"].ToString(); string PhoneNumber = hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()); string LastName = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string PaymentId = BookingPayId.ToString(); string BillingAddress = lblBillingAddress.Text.Trim().ToString(); Session["Address"] = BillingAddress; Session["InvName"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Title"].ToString()) + " " + LastName; Session["SubInvName"] = LastName + ", " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Title"].ToString()) + " " + FirstName; Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://localhost:1897/ResortManager/Cruise/booking/SummerisedDetails.aspx?BookedId=0&PackName=Ganges+Exclusive&NoOfNights=5&CheckinDate=5%2f1%2f2016 //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } } } else { if (Convert.ToDecimal(txtPaidAmt.Text) <= Convert.ToDecimal(hdnfCreditLimit.Value)) { string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; Session.Add("BookingRef", txtBookRef.Text.Trim().ToString()); Session["Paid"] = Convert.ToDouble(hftxtpaidamt.Value.Trim() == "" ? "0" : hftxtpaidamt.Value.Trim().ToString()); Session["InvName"] = Session["UserName"].ToString(); Session["Address"] = null; Response.Redirect("PaymentGatewayResponse.aspx"); } else { lblPaymentErr.Text = "Payment Amount Exceeding Credit Limit"; } } } catch { } }
private void BindAgents() { try { blAr._Action = "GetAllAgents"; dtGetReturnedData = dlAr.BindControls(blAr); List <BALAgent> agents = new List <BALAgent>(); if (dtGetReturnedData != null && dtGetReturnedData.Rows.Count > 0) { foreach (DataRow row in dtGetReturnedData.Rows) { BALAgent agent = new BALAgent { AgentId = Convert.ToInt32(row["AgentId"].ToString()), AgentName = DataSecurityManager.Decrypt(row["AgentName"].ToString()) }; agents.Add(agent); } List <BALAgent> sortedAgents = agents.OrderBy(a => a.AgentName).ToList(); ddlAgents.DataSource = sortedAgents; ddlAgents.DataTextField = "AgentName"; ddlAgents.DataValueField = "AgentId"; ddlAgents.DataBind(); ddlAgents.Items.Insert(0, "-Select-"); } else { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } } catch (Exception sqe) { GridAccomodations.DataSource = null; GridAccomodations.DataBind(); } }
protected void btnCustLogin_Click(object sender, EventArgs e) { if (rdbAgent.Checked == true || rdbCustomer.Checked == true) { } if (rdbAgent.Checked == true && rdbCustomer.Checked == true) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Please select only one type')", true); return; } if (rdbCustomer.Checked == true) { if (IsEmailValid(txtCustMailId.Value) == true) { if (Session["CustomerMailId"] == null) { try { // blcus.Email = txtCustMailId.Value blcus.Email = DataSecurityManager.Encrypt(txtCustMailId.Value.Trim()); blcus.action = "checkemail"; DataTable dtCustomer = dlcus.checkmail(blcus); if (dtCustomer != null && dtCustomer.Rows.Count > 0) { string password = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Password"].ToString()); sendMail(txtCustMailId.Value, password); txtCustMailId.Value = ""; rdbAgent.Checked = false; rdbCustomer.Checked = false; ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('We have send an email with your password,Please check your email')", true); //lblMsg.Text = "We have send an email with your password,Please check your email id"; //lblMsg.ForeColor = System.Drawing.Color.Green; //string BookRef = dtCustomer.Rows[0]["FirstName"].ToString() + dtCustomer.Rows[0]["LastName"].ToString() + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Direct Client"; //ViewState["BookRef"] = BookRef; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('This is not registered email')", true); return; } } catch (Exception ex) { throw ex; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('You are already log in')", true); return; //lblMsg.Text = "You are already log in"; //lblMsg.ForeColor = System.Drawing.Color.Red; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Please enter valid email ')", true); return; //lblMsg.Text = "Please enter valid email id"; //lblMsg.ForeColor = System.Drawing.Color.Red; } } if (rdbAgent.Checked == true) { if (IsEmailValid(txtCustMailId.Value) == true) { if (Session["AgentMailId"] == null) { try { // bagnt._EmailId = txtCustMailId.Value; bagnt._EmailId = DataSecurityManager.Encrypt(txtCustMailId.Value.Trim()); bagnt._Action = "checkagentemail"; DataTable dtagent = dagnt.checkagentemail(bagnt); if (dtagent != null && dtagent.Rows.Count > 0) { // string password = dtagent.Rows[0]["Password"].ToString(); string password = DataSecurityManager.Decrypt(dtagent.Rows[0]["Password"].ToString()); sendMail(txtCustMailId.Value, password); txtCustMailId.Value = ""; rdbAgent.Checked = false; rdbCustomer.Checked = false; ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('We have send an email with your password,Please check your email ')", true); //lblMsg.Text = "We have send an email with your password,Please check your email id"; //lblMsg.ForeColor = System.Drawing.Color.Green; //string BookRef = dtCustomer.Rows[0]["FirstName"].ToString() + dtCustomer.Rows[0]["LastName"].ToString() + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Direct Client"; //ViewState["BookRef"] = BookRef; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('This is not registered email')", true); return; } } catch (Exception ex) { throw ex; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('You are already log in ')", true); return; //lblMsg.Text = "You are already log in"; //lblMsg.ForeColor = System.Drawing.Color.Red; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Please enter valid email id')", true); return; //lblMsg.Text = "Please enter valid email id"; //lblMsg.ForeColor = System.Drawing.Color.Red; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Please select type')", true); return; //lblMsg.Text = "Please select type"; //lblMsg.ForeColor = System.Drawing.Color.Red; } }
public BookingTouristDTO[] GetTourists(int BookingId) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; string sProcName; oBookingTouristDTO = null; try { oDB = new DatabaseManager(); sProcName = "up_Get_Tourists"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingId", DbType.Int32, BookingId); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; GF.LogError("clsBookingTouristHandler.GetTourist", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].BookingId = Convert.ToInt32(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].BookingCode = Convert.ToString(dr.ItemArray.GetValue(1)); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(2)); } if (dr.ItemArray.GetValue(3) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))); } if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].MiddleName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(4))); } if (dr.ItemArray.GetValue(5) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))); } if (dr.ItemArray.GetValue(6) != DBNull.Value) { oBookingTouristDTO[i].RoomDetails = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(6))); } if (dr.ItemArray.GetValue(7) != DBNull.Value) { oBookingTouristDTO[i].Gender = (Convert.ToChar(dr.ItemArray.GetValue(7))); } if (dr.ItemArray.GetValue(8) != DBNull.Value) { oBookingTouristDTO[i].DateOfBirth = Convert.ToDateTime(Convert.ToDateTime(dr.ItemArray.GetValue(8)).ToString()); } if (dr.ItemArray.GetValue(9) != DBNull.Value) { oBookingTouristDTO[i].Nationality = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(9))); } if (dr.ItemArray.GetValue(10) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(10))); } if (dr.ItemArray.GetValue(11) != DBNull.Value) { oBookingTouristDTO[i].VisaExpiryDate = Convert.ToDateTime(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != DBNull.Value) { oBookingTouristDTO[i].ArrivalDateTime = Convert.ToDateTime(dr.ItemArray.GetValue(12)); } if (dr.ItemArray.GetValue(13) != DBNull.Value) { oBookingTouristDTO[i].vehicalno = Convert.ToString(dr.ItemArray.GetValue(13)); } if (dr.ItemArray.GetValue(14) != DBNull.Value) { oBookingTouristDTO[i].departuredate = Convert.ToDateTime(dr.ItemArray.GetValue(14)); } if (dr.ItemArray.GetValue(15) != DBNull.Value) { oBookingTouristDTO[i].departureairport = Convert.ToString(dr.ItemArray.GetValue(15)); } if (dr.ItemArray.GetValue(16) != DBNull.Value) { oBookingTouristDTO[i].guestname = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(16))) + ". " + DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(3))) + " " + DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(5))); } if (dr.ItemArray.GetValue(17) != DBNull.Value) { oBookingTouristDTO[i].arrivalvehiaclno = Convert.ToString(dr.ItemArray.GetValue(17)); } if (dr.ItemArray.GetValue(18) != DBNull.Value) { oBookingTouristDTO[i].departurevehicalno = Convert.ToString(dr.ItemArray.GetValue(18)); } if (dr.ItemArray.GetValue(20) != DBNull.Value) { oBookingTouristDTO[i].arrivalairport = Convert.ToString(dr.ItemArray.GetValue(20)); } } } } return(oBookingTouristDTO); }
protected override void OnLoad(EventArgs e) { // ... add custom logic here ... // Be sure to call the base class's OnLoad method! //Session["CssPath"] = ""; if (Convert.ToString(Request.QueryString["agentid"]) != null) { // string agentid = Request.QueryString["agentid"]; int agentid = 0; agentid = Convert.ToInt32(Request.QueryString["agentid"]); SqlDataAdapter adp = new SqlDataAdapter("select CssPath,AgentEmailId,IsPaymentByPass from tblagentmaster where agentid=" + agentid + "", strCon); DataTable dt = new DataTable(); adp.Fill(dt); if (dt.Rows.Count > 0) { string path = dt.Rows[0][0].ToString(); Session["CssPath"] = path; Session["AgentId"] = agentid; string email = DataSecurityManager.Decrypt(dt.Rows[0][1].ToString()); Session["AgentEmailId"] = email; string ss = dt.Rows[0][2].ToString(); if (ss != "") { Session["IsPaymentByPass"] = Convert.ToBoolean(dt.Rows[0][2]); } else { Session["IsPaymentByPass"] = false; } AddCss(path); try { if (Session["SetCurrency"].ToString() == "") { Session["SetCurrency"] = "INR"; } }catch { Session["SetCurrency"] = "INR"; } //Response.Cookies["agentInfo"]["CssPath"] = path; //Response.Cookies["agentInfo"]["AgentId"] = Convert.ToInt32(agentid).ToString(); //Response.Cookies["agentInfo"]["AgentEmailId"] = email; //Response.Cookies["agentInfo"]["IsPaymentByPass"] = Convert.ToBoolean(dt.Rows[0][2]).ToString(); //Response.Cookies["agentInfo"].Expires = DateTime.Now.AddDays(1); HttpCookie aCookie = new HttpCookie("agentInfo"); aCookie.Values["CssPath"] = path; aCookie.Values["AgentId"] = Convert.ToInt32(agentid).ToString(); aCookie.Values["AgentEmailId"] = email; if (ss != "") { aCookie.Values["IsPaymentByPass"] = Convert.ToBoolean(dt.Rows[0][2]).ToString(); } else { aCookie.Values["IsPaymentByPass"] = false.ToString(); } aCookie.Expires = DateTime.Now.AddDays(1); Response.Cookies.Add(aCookie); // changeCss.Href = "~/Cruise/Booking/css/agent_css/green.css"; } } //else if (Session["AgentId"]!=null) else if (Request.Cookies["agentInfo"] != null) { if (Convert.ToString(Request.QueryString["agentid"]) == null) { Session["CssPath"] = null; Session["AgentId"] = null; Session["AgentEmailId"] = null; Session["IsPaymentByPass"] = null; //Session["SetCurrency"] = ""; } else { HttpCookie reqCookies = Request.Cookies["agentInfo"]; if (reqCookies != null) { string csspath = reqCookies["CssPath"].ToString(); int agentid = Convert.ToInt32(reqCookies["AgentId"]); string email = reqCookies["AgentEmailId"].ToString(); bool ss = Convert.ToBoolean(reqCookies["IsPaymentByPass"]); Session["CssPath"] = csspath; Session["AgentId"] = agentid; Session["AgentEmailId"] = email; Session["IsPaymentByPass"] = ss; AddCss(csspath); } } // AddCss(Convert.ToString( Session["CssPath"])); } else { //Session["SetCurrency"] = ""; } //else //{ // Session["CssPath"] = "/Cruise/Booking/css/Newcss/style.css"; //} base.OnLoad(e); }
public BookingTouristDTO[] GetTouristsftr(string bcode, string email, string ppno, string firstName, DateTime chkin, DateTime chkout, int accomid) { DataSet ds; DataRow dr; BookingTouristDTO[] oBookingTouristDTO; string sProcName; oBookingTouristDTO = null; try { oDB = new DatabaseManager(); sProcName = "up_Get_Touristsftr"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingCode", DbType.String, bcode); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@name", DbType.String, DataSecurityManager.Encrypt(firstName)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@EmailId", DbType.String, email); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@passportNo", DbType.String, DataSecurityManager.Encrypt(ppno)); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@chkindate", DbType.Date, chkin); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@chkoutdate", DbType.Date, chkout); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@accomid", DbType.Int32, accomid); ds = oDB.ExecuteDataSet(oDB.DbCmd); oDB = null; } catch (Exception exp) { oDB = null; ds = null; // GF.LogError("clsBookingTouristHandler.GetTourist", exp.Message); } if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { oBookingTouristDTO = new BookingTouristDTO[ds.Tables[0].Rows.Count]; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { dr = ds.Tables[0].Rows[i]; oBookingTouristDTO[i] = new BookingTouristDTO(); if (dr.ItemArray.GetValue(0) != DBNull.Value) { oBookingTouristDTO[i].BookingCode = Convert.ToString(dr.ItemArray.GetValue(0)); } if (dr.ItemArray.GetValue(1) != DBNull.Value) { oBookingTouristDTO[i].BookingRef = Convert.ToString(dr.ItemArray.GetValue(1)); } if (dr.ItemArray.GetValue(2) != DBNull.Value) { oBookingTouristDTO[i].AgentName = dr.ItemArray.GetValue(2) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(2))) : string.Empty; } //if (dr.ItemArray.GetValue(3) != DBNull.Value) // oBookingTouristDTO[i].ClientName = Convert.ToString(dr.ItemArray.GetValue(3)); if (dr.ItemArray.GetValue(4) != DBNull.Value) { oBookingTouristDTO[i].Gender = Convert.ToChar(dr.ItemArray.GetValue(4)); } if (dr.ItemArray.GetValue(5) != DBNull.Value) { oBookingTouristDTO[i].DateOfBirth = Convert.ToDateTime(dr.ItemArray.GetValue(5)); } if (dr.ItemArray.GetValue(6) != DBNull.Value) { oBookingTouristDTO[i].Nationality = Convert.ToString(dr.ItemArray.GetValue(6)); } if (dr.ItemArray.GetValue(7) != DBNull.Value) { oBookingTouristDTO[i].PassportNo = dr.ItemArray.GetValue(7) != DBNull.Value ? DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(7))) : string.Empty; } if (dr.ItemArray.GetValue(8) != DBNull.Value) { oBookingTouristDTO[i].AccomName = Convert.ToString(dr.ItemArray.GetValue(8)); } if (dr.ItemArray.GetValue(9) != DBNull.Value) { oBookingTouristDTO[i].CheckinDate = Convert.ToDateTime(dr.ItemArray.GetValue(9)); } if (dr.ItemArray.GetValue(10) != DBNull.Value) { oBookingTouristDTO[i].CheckoutDate = Convert.ToDateTime(dr.ItemArray.GetValue(10)); } if (dr.ItemArray.GetValue(11) != DBNull.Value) { oBookingTouristDTO[i].EmailId = Convert.ToString(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != DBNull.Value) { oBookingTouristDTO[i].BookingId = Convert.ToInt32(dr.ItemArray.GetValue(12)); } if (dr.ItemArray.GetValue(13) != DBNull.Value) { oBookingTouristDTO[i].TouristNo = Convert.ToInt32(dr.ItemArray.GetValue(13)); } if (dr.ItemArray.GetValue(14) != DBNull.Value) { oBookingTouristDTO[i].FirstName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(14))); } if (dr.ItemArray.GetValue(15) != DBNull.Value) { oBookingTouristDTO[i].MiddleName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(15))); } if (dr.ItemArray.GetValue(16) != DBNull.Value) { oBookingTouristDTO[i].LastName = DataSecurityManager.Decrypt(Convert.ToString(dr.ItemArray.GetValue(16))); } } } } return(oBookingTouristDTO); }
protected void dgBookings_ItemCommand(object source, DataGridCommandEventArgs e) { string cFormUrl = string.Empty; try { if (e.Item.ItemIndex >= 0) { int iBookingID = Convert.ToInt32(dgBookings.DataKeys[e.Item.ItemIndex].ToString()); switch (e.CommandName.ToString().ToUpper()) { case "EDIT": Response.Redirect("Booking.aspx?bid=" + iBookingID); break; case "VIEW": if (string.Compare(e.Item.Cells[5].Text, "CONFIRMED", true) == 0) { Response.Redirect("Bookingconfirmation.aspx?bid=" + iBookingID.ToString()); } else { Response.Redirect("Booking.aspx?bid=" + iBookingID.ToString() + "&mode=view"); } break; case "CONFIRMATION": Response.Redirect("Bookingconfirmation.aspx?bid=" + iBookingID.ToString()); break; case "VIEWTOURIST": Response.Redirect("ViewTourists.aspx?bid=" + iBookingID.ToString()); break; case "ADDTOURIST": Response.Redirect("touristdetails.aspx?bid=" + iBookingID.ToString()); break; case "CFORMFOREIGNNATIONAL": Response.Redirect("CFormReport.aspx?bid=" + iBookingID.ToString() + "&cftype=fn"); break; case "CFORMINDIANNATIONAL": Response.Redirect("CFormReport.aspx?bid=" + iBookingID.ToString() + "&cftype=in"); break; case "UPLOADTOURIST": Response.Redirect("~\\uploader.aspx?bid=" + iBookingID.ToString() + "&upload=" + ENums.UploadXMLType.Tourist.ToString()); break; case "REMINDER": //Reminder Email //DialogResult result = MessageBox.Show("Are you sure you want to send reminder to the guest for the payment at" + DataSecurityManager.Decrypt(Session["Email"].ToString())+ "", "Yes or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); //if (result == DialogResult.Yes) //{ blbooking._iBookingId = iBookingID; DataTable dt = dlbooking.paymentreminder(blbooking); if (dt != null && dt.Rows.Count > 0) { Session["Email"] = dt.Rows[0]["Email"].ToString(); Session["AccomName"] = dt.Rows[0]["AccomName"].ToString(); double amt = 0; for (int i = 0; i < dt.Rows.Count; i++) { amt = amt + Convert.ToDouble(dt.Rows[i]["Amount"].ToString()); } //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:if(confirm('Are you sure you want to send reminder to the guest for the payment at " + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "?');", true); // ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:if(confirm('Are you sure you want to send reminder to the guest for the payment at " + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "?')==false)return false;", true); //RegisterClientScriptBlock //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:confirm('Are you sure you want to send reminder to the guest for the payment at" + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "?')", true); ScriptManager.RegisterStartupScript(this, GetType(), "Sc", "confirmation('" + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "');", true); //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:confirmation('" + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "')", true); //DialogResult result = MessageBox.Show("Are you sure you want to send reminder to the guest for the payment at " + DataSecurityManager.Decrypt(Session["Email"].ToString()) + "", "Yes or No", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); //if (result == DialogResult.Yes) //{ string L = dt.Rows[0]["LastName"].ToString(); if (L == " ") { dt.Rows[0]["LastName"] = "XYZ"; } sendMail(DataSecurityManager.Decrypt(dt.Rows[0]["Email"].ToString()), DataSecurityManager.Decrypt(dt.Rows[0]["Name"].ToString()), DataSecurityManager.Decrypt(dt.Rows[0]["LastName"].ToString()), iBookingID, amt, Convert.ToDouble(dt.Rows[0]["PaidAmt"].ToString()), dt.Rows[0]["StartDate"].ToString(), dt.Rows[0]["enddate"].ToString(), dt.Rows[0]["BookingCode"].ToString(), Convert.ToDateTime(dt.Rows[0]["BookingDate"].ToString()), dt.Rows[0]["Packagename"].ToString(), dt.Rows[0]["AccomName"].ToString(), dt.Rows[0]["RegionName"].ToString(), DataSecurityManager.Decrypt(dt.Rows[0]["Title"].ToString()), DataSecurityManager.Decrypt(dt.Rows[0]["Password"].ToString())); // } RefreshGrid(); } else { RefreshGrid(); } //} //else if (result == DialogResult.No) //{ // RefreshGrid(); //} break; default: break; } } } catch (Exception exp) { GF.LogError("ViewBookings.dgBookings_ItemCommand", exp.Message); return; } }