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"); }
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(); }