protected void Page_Load(object sender, EventArgs e)
{
if ((bool)HttpContext.Current.Session["loggedIn"] == true)
{
btnAddToCart.Visible = true;
DetailsView1.Fields[4].Visible = false;
}
else
{
btnAddToCart.Visible = false;
DetailsView1.Fields[4].Visible = true;
}
if (GridView1.SelectedValue != null)
{
DataView productTable = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
productTable.RowFilter = "ProductID = " + GridView1.SelectedValue;
DataRowView row = productTable[0];
selectedProduct = new Product();
selectedProduct.ProductID = (int)row["ProductID"];
selectedProduct.Name = row["ProductName"].ToString();
selectedProduct.Category = row["Category"].ToString();
selectedProduct.Price = (decimal)row["Price"];
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Session["PID"] = Label2.Text;
Session["PName"] = Label3.Text;
Session["PPrice"] = Label4.Text;
Session["Qty"] = DropDownList1.Text;
Session["Total"] = Label5.Text;
if (Session["UserType"] == null || !Session["UserType"].ToString().Equals("user"))
{
Response.Redirect("~/Login.aspx");
}
Session["Now"] = DateTime.Now.ToString();
AccessDataSource2.Insert();
Response.Redirect("~/Member/ViewCart.aspx");
}
protected void g_relatedProducts_BeforePerformDataSelect(object sender, System.EventArgs e)
{
ASPxGridView gridView = (ASPxGridView)sender;
if (gridView.DataSource != null)
{
return;
}
if (Session[gridView.GetMasterRowKeyValue().ToString()] != null)
{
string selectCommand = (string)Session[gridView.GetMasterRowKeyValue().ToString()];
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
gridView.DataSource = view;
gridView.DataBind();
}
}
protected void relatedProducts_CustomCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomCallbackEventArgs e)
{
ASPxGridView g_relatedProducts = (ASPxGridView)sender;
int visibleIndex = int.Parse(e.Parameters);
ASPxPageControl pc = (ASPxPageControl)grid.FindDetailRowTemplateControl(visibleIndex, "ASPxPageControl1");
HtmlInputText editor = (HtmlInputText)pc.TabPages[0].FindControl("SearchString");
string searchString = editor.Value;
string selectCommand = "select * from [Products] where (([CategoryID]=" + g_relatedProducts.GetMasterRowKeyValue().ToString() + ") and ([ProductName] Like '%" + searchString + "%'))";
Session[g_relatedProducts.GetMasterRowKeyValue().ToString()] = selectCommand;
AccessDataSource2.SelectCommand = selectCommand;
DataView view = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
g_relatedProducts.DataSource = view;
g_relatedProducts.DataBind();
}
protected void productname_cmbbox_SelectedIndexChanged(object sender, EventArgs e)
{
AccessDataSource2.DataBind();
version_cmbbox.DataBind();
startdate_pick.Text = DateTime.Today.ToShortDateString().ToString();
startdate_pick.ReadOnly = false;
try
{
// this.products_individiualTableAdapter.Fillversion(this.gensymDataSet11.products_individiual, productname_cmbbox.SelectedValue.ToString());
if (productname_cmbbox.SelectedItem.Value == "G2")
{
Response.Cookies.Add(new HttpCookie("updateui", "g2options#blinddown"));
}
else
{
Response.Cookies.Add(new HttpCookie("updateui", "g2options#blindup"));
}
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserType"] == null || !Session["UserType"].ToString().Equals("user"))
{
Response.Redirect("~/Login.aspx");
}
if (Session["Username"] == null)
{
return;
}
DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty);
if (dv.Count == 0)
{
return;
}
TextBox2.Text = dv[0].Row["FullName"].ToString();
TextBox3.Text = dv[0].Row["Email"].ToString();
TextBox4.Text = dv[0].Row["ContactNo"].ToString();
TextBox5.Text = dv[0].Row["Address"].ToString();
}
private void InsertShipper()
{
String BDayString = "";
BDayString = cmbDay.Text + "-" + cmbMonth.Text + "-" + cmbYear.Text;
// Define the name and type of the client scripts on the page.
String csname1 = "PopupScript";
Type cstype = this.GetType();
// Get a ClientScriptManager reference from the Page class.
ClientScriptManager cs = Page.ClientScript;
// Check to see if the startup script is already registered.
if (!cs.IsStartupScriptRegistered(cstype, csname1))
{
String cstext1 = "alert('Hello World');";
cs.RegisterStartupScript(cstype, csname1, cstext1, true);
}
AccessDataSource2.InsertCommand = "INSERT INTO Customer (FirstName, LastName, Gender, BirthDate ,Address1,Address2,City, StateID,CountryID,PostalCode,Email, Phone, PassportNum, LanguageID, HowHearTextID, HowHearSpecific, WhereStayID, RoomOther,RoomNo, EmergencyName, Relationship, EmergencyNumber, EmergencyEmail, DiveLevelID, DiveOrgID, NumberOfDives, Insurance, InsuranceName, EmergencyCountryID, ArrivalDate, [image]) VALUES (@FirstName,@LastName, @Gender, @BirthDate, @Address1,@Address2,@City,@StateID, @Country,@PostalCode,@Email, @Phone, @PassportNum, @LanguageID, @HowHear, @HowHearSpecific, @WhereStayID, @RoomOther, @RoomNo, @EmergencyName, @Relationship, @EmergencyNumber, @EmergencyEmail, @DiveLevelID, @DiveOrgID, @NumberOfDives, @EmergencyCountryID, @ArrivalDate, @Insurance, @InsuranceName, @MyImage)";
AccessDataSource2.UpdateCommand = "Update Customer Set FirstName=@FirstName, LastName=@LastName, Gender=@Gender, BirthDate=@BirthDate, Address1=@Address1,Address2=@Address2,City=@City, StateID=@StateID, CountryID=@CountryID, PostalCode=@PostalCode,Email=@Email, Phone=@Phone, PassportNum=@PassportNum, LanguageID=@LanguageID, HowHearTextID=@HowHearTextID, HowHearSpecific=@HowHearSpecific, WhereStayID =@WhereStayID, RoomOther=@RoomOther,RoomNo=@RoomNo, EmergencyName=@EmergencyName, Relationship=@Relationship, EmergencyNumber=@EmergencyNumber, EmergencyEmail=@EmergencyEmail, DiveLevelID=@DiveLevelID, DiveOrgID=@DiveOrgID, NumberOfDives=@NumberOfDives, Insurance=@Insurance, InsuranceName=@InsuranceName, EmergencyCountryID=@EmergencyCountryID, ArrivalDate=@ArrivalDate, [image]=@MyImage WHERE CustomerID=" + CustomerNumberHidden.Value;
AccessDataSource2.InsertParameters.Add("FirstName", FirstName.Text);
AccessDataSource2.InsertParameters.Add("LastName", LastName.Text);
AccessDataSource2.InsertParameters.Add("Gender", Gender.SelectedValue);
AccessDataSource2.InsertParameters.Add("BirthDate", DateTime.Parse(BDayString, System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy"));
AccessDataSource2.InsertParameters.Add("Address1", Address1.Text);
AccessDataSource2.InsertParameters.Add("Address2", Address2.Text);
AccessDataSource2.InsertParameters.Add("City", City.Text);
AccessDataSource2.InsertParameters.Add("StateID", StateID.SelectedValue);
AccessDataSource2.InsertParameters.Add("CountryID", CountryID.SelectedValue);
AccessDataSource2.InsertParameters.Add("PostalCode", PostalCode.Text);
AccessDataSource2.InsertParameters.Add("Email", Email.Text);
AccessDataSource2.InsertParameters.Add("Phone", Phone.Text);
AccessDataSource2.InsertParameters.Add("PassportNum", PassportNum.Text);
AccessDataSource2.InsertParameters.Add("LanuguageID", LanguageID.SelectedValue);
AccessDataSource2.InsertParameters.Add("HowHear", HowHearTextID.SelectedValue);
AccessDataSource2.InsertParameters.Add("HowHearSpecific", HowHearSpecific.Text);
AccessDataSource2.InsertParameters.Add("WhereStayID", WhereStayID.SelectedValue);
AccessDataSource2.InsertParameters.Add("RoomOther", RoomOther.Text);
AccessDataSource2.InsertParameters.Add("RoomNo", RoomNo.Text);
AccessDataSource2.InsertParameters.Add("EmergencyName", EmergencyName.Text);
AccessDataSource2.InsertParameters.Add("Relationship", Relationship.Text);
AccessDataSource2.InsertParameters.Add("EmergencyNumber", EmergencyNumber.Text);
AccessDataSource2.InsertParameters.Add("EmergencyEmail", EmergencyEmail.Text);
AccessDataSource2.InsertParameters.Add("DiveLevelID", DiveLevelID.SelectedValue);
AccessDataSource2.InsertParameters.Add("DiveOrgID", DiveOrgID.SelectedValue);
AccessDataSource2.InsertParameters.Add("NumberOfDives", NumberOfDives.Text);
AccessDataSource2.InsertParameters.Add("Insurance", "1");
AccessDataSource2.InsertParameters.Add("InsuranceName", InsuranceName.Text);
AccessDataSource2.InsertParameters.Add("EmergencyCountryID", EmergencyCountryID.Text);
AccessDataSource2.InsertParameters.Add("ArrivalDate", DateTime.Now.ToShortDateString());
AccessDataSource2.UpdateParameters.Add("FirstName", FirstName.Text);
AccessDataSource2.UpdateParameters.Add("LastName", LastName.Text);
AccessDataSource2.UpdateParameters.Add("Gender", Gender.SelectedValue);
AccessDataSource2.UpdateParameters.Add("BirthDate", BDayString);
AccessDataSource2.UpdateParameters.Add("Address1", Address1.Text);
AccessDataSource2.UpdateParameters.Add("Address2", Address2.Text);
AccessDataSource2.UpdateParameters.Add("City", City.Text);
AccessDataSource2.UpdateParameters.Add("StateID", StateID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("CountryID", CountryID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("PostalCode", PostalCode.Text);
AccessDataSource2.UpdateParameters.Add("Email", Email.Text);
AccessDataSource2.UpdateParameters.Add("Phone", Phone.Text);
AccessDataSource2.UpdateParameters.Add("PassportNum", PassportNum.Text);
AccessDataSource2.UpdateParameters.Add("LanuguageID", LanguageID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("HowHear", HowHearTextID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("HowHearSpecific", HowHearSpecific.Text);
AccessDataSource2.UpdateParameters.Add("WhereStayID", WhereStayID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("RoomOther", RoomOther.Text);
AccessDataSource2.UpdateParameters.Add("RoomNo", RoomNo.Text);
AccessDataSource2.UpdateParameters.Add("EmergencyName", EmergencyName.Text);
AccessDataSource2.UpdateParameters.Add("Relationship", Relationship.Text);
AccessDataSource2.UpdateParameters.Add("EmergencyNumber", EmergencyNumber.Text);
AccessDataSource2.UpdateParameters.Add("EmergencyEmail", EmergencyEmail.Text);
AccessDataSource2.UpdateParameters.Add("DiveLevelID", DiveLevelID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("DiveOrgID", DiveOrgID.SelectedValue);
AccessDataSource2.UpdateParameters.Add("NumberOfDives", NumberOfDives.Text);
AccessDataSource2.UpdateParameters.Add("Insurance", "1");
AccessDataSource2.UpdateParameters.Add("InsuranceName", InsuranceName.Text);
AccessDataSource2.UpdateParameters.Add("EmergencyCountryID", EmergencyCountryID.Text);
AccessDataSource2.UpdateParameters.Add("ArrivalDate", DateTime.Now.ToShortDateString());
DataView dv = (DataView)LatestCustomerDataSource.Select(DataSourceSelectArguments.Empty);
int lastID = (int)dv.Table.Rows[0][0];
string fileName = "";
if (CustomerNumberHidden.Value == null || CustomerNumberHidden.Value == "")
{
fileName = FirstName.Text + " " + LastName.Text + "-" + lastID + ".jpg";
}
else
{
fileName = FirstName.Text + " " + LastName.Text + "-" + CustomerNumberHidden.Value + ".jpg";
}
//dv = (DataView)ImageFolderDataSource.Select(DataSourceSelectArguments.Empty);
string imagefolder = "C:/BubbleManager/Customer Photos/";
//(string)dv.Table.Rows[0][0];
if (!Directory.Exists(imagefolder))
{
//If it doesn't then we just create it before going any further
Directory.CreateDirectory(imagefolder);
}
if (useCamera == "Yes")
{
using (var fs = new FileStream(imagefolder + fileName, FileMode.Create))
{
using (var bw = new BinaryWriter(fs))
{
var image = this.imageData.Value;
var data = Convert.FromBase64String(image);
bw.Write(data);
bw.Close();
}
fs.Close();
}
AccessDataSource2.InsertParameters.Add("MyImage", fileName);
AccessDataSource2.UpdateParameters.Add("MyImage", fileName);
}
else
{
if (FileUpload1.FileName != "")
{
//UpdateImageDataSource.UpdateParameters[0].DefaultValue = fileName;
// UpdateImageDataSource.UpdateParameters[1].DefaultValue = "" + lastID;
// Create a bitmap of the content of the fileUpload control in memory
Bitmap originalBMP = new Bitmap(FileUpload1.FileContent);
// Calculate the new image dimensions
int origWidth = originalBMP.Width;
int origHeight = originalBMP.Height;
int maxSize = 240;
int newHeight = (origHeight * maxSize) / origWidth;
int newWidth = maxSize;
if (origHeight > origWidth)
{
newWidth = (origWidth * maxSize) / origHeight;
newHeight = maxSize;
}
//int sngRatio = origWidth / origHeight;
//int newWidth = 240;
//int newHeight = newWidth / sngRatio;
// Create a new bitmap which will hold the previous resized bitmap
Bitmap newBMP = new Bitmap(originalBMP, newWidth, newHeight);
// Create a graphic based on the new bitmap
Graphics oGraphics = Graphics.FromImage(newBMP);
// Set the properties for the new graphic file
oGraphics.SmoothingMode = SmoothingMode.AntiAlias; oGraphics.InterpolationMode = InterpolationMode.HighQualityBicubic;
// Draw the new graphic based on the resized bitmap
oGraphics.DrawImage(originalBMP, 0, 0, newWidth, newHeight);
//dv = (DataView)ImageFolderDataSource.Select(DataSourceSelectArguments.Empty);
//string imagefolder = (string)dv.Table.Rows[0][0];
// Save the new graphic file to the server
newBMP.Save(imagefolder + fileName);
AccessDataSource2.InsertParameters.Add("MyImage", fileName);
AccessDataSource2.UpdateParameters.Add("MyImage", fileName);
// Once finished with the bitmap objects, we deallocate them.
originalBMP.Dispose();
newBMP.Dispose();
oGraphics.Dispose();
//UpdateImageDataSource.Update();
}
else
{
AccessDataSource2.InsertParameters.Add("MyImage", "");
AccessDataSource2.UpdateParameters.Add("MyImage", "");
}
}
if (CustomerNumberHidden.Value == null || CustomerNumberHidden.Value == "")
{
AccessDataSource2.Insert();
}
else
{
AccessDataSource2.Update();
}
Response.Redirect("FormSubmitted.aspx");
}
protected void add_btn_Click(object sender, EventArgs e)
{
AccessDataSource2.Insert();
AccessDataSource1.DataBind();
GridView1.DataBind();
}
protected string GetImageFileNameById(string id)
{
AccessDataSource2.SelectParameters["ID"].DefaultValue = id;
return(((DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty))[0]["ImageFileName"].ToString());
}
