public void UploadClick(object sender, EventArgs e) { String filePath; String filetype = Filetype.SelectedValue; HttpPostedFile incomingFile = FileUploaded.PostedFile; if (Filetype.SelectedIndex.Equals(0) || Filetype.SelectedIndex.Equals(null)) { incomingFile = FileUploadpic.PostedFile; filetype = "Profile Picture"; } /*Get all fields and insert them into the Applicant Table on the WLS Database*/ //Image upload part. Also check if there is a file to upload if (incomingFile.FileName != "") { //file name fileName = incomingFile.FileName; //type of content contentType = incomingFile.ContentType; //size of file fileSize = incomingFile.ContentLength; //File extension fileExtension = Path.GetExtension(incomingFile.FileName); //create a byte array to store the binary image data filePath = "http:/localhost:58532/WLS-CSHARP/Data/UserData/" + filetype + "/" + UserID + "_" + fileName + "_" + fileSize; incomingFile.SaveAs(Server.MapPath("~/Data/UserData/" + filetype + "/") + UserID + "_" + fileName + "_" + fileSize); uploaded = SavingFiles.UploadStatement(filetype, filePath, UserID); if (!(Filetype.SelectedIndex.Equals(0) || Filetype.SelectedIndex.Equals(null))) { switch (uploaded) { case 0: UploadLabel.Text.Equals("Please Select a File."); UploadLabel.ForeColor = System.Drawing.Color.Red; UploadLabel.Visible = true; break; case 1: UploadLabel.Visible = true; break; case 3: UploadLabel.Text = "ERROR While uploding Please Try Again."; UploadLabel.ForeColor = System.Drawing.Color.Red; UploadLabel.Visible = true; break; } } } }
protected void saveForLater(object sender, EventArgs e) { System.Data.SqlClient.SqlCommand insert = new System.Data.SqlClient.SqlCommand(); SQLisConnect.SQLConnection(); String Stringdate = DOB.Text; DateTime?dOB = datestoNull(Stringdate); String gender = Gender.Text; String address1 = Address1.Text; String address2 = Address2.Text; String city = City.Text; String state = State.Text; String zipCode = ZipCode.Text; String phoneNumber = (PhoneNumber.Text); String eMName = EMName.Text; String eMRelation = EMRelation.Text; String eMAddress1 = EMAddress.Text; String eMAddress2 = EMAddress2.Text; String eMcity = EMCity.Text; String eMstate = EMState.Text; String eMzipCode = EMZipCode.Text; String eMPhoneNumber = (EMPhoneNumber.Text); String vacinationdoc = VaccinatedRadio.SelectedValue; String rehabpermit = RehabpermitRadio.SelectedValue; String allergies = Allergies.Text; String medicalCondition = MedicalConditions.Text; String limitation = limitations.Text; String distance = Distance.Text; String specieslimitation = Specieslimitation.Text; string[,] Aval = { { "Monday", Day1St.Text.ToString(), Day1f.Text.ToString() }, { "Tuesday", Day2St.Text.ToString(), Day2f.Text.ToString() }, { "Wednesday", Day3St.Text.ToString(), Day3f.Text.ToString() }, { "Thursday", Day4St.Text.ToString(), Day4f.Text.ToString() }, { "Friday", Day5St.Text.ToString(), Day5f.Text.ToString() } }; for (int i = 0; i < 5; i++) { String Dayofweek = Aval[i, 0]; String StartTime = Aval[i, 1]; String EndTime = Aval[i, 2]; saved = SavingFiles.SaveAvailibility(Dayofweek, StartTime, EndTime, UserID); } /*Insert stamtement order for application * * [PROFILEID] [int] NOT NULL, * [USERNAME] [varchar](50) NOT NULL, * [PHONE] [varchar](25) NOT NULL, * [DOB] [date] NOT NULL, * [GENDER] [varchar](25) NOT NULL, * [PROFSTATUS] [varchar](50) NOT NULL, * [USERTYPE] [varchar](50) NOT NULL, * [ALLERGIES] [bit] NOT NULL, * [ALLERGIESSPECIFY] [varchar](50) NULL, * [LIMITATIONS] [bit] NOT NULL, * [LIMITATIONSSPECIFY] [varchar](50) NULL, * [MEDICALCONDITIONS] [varchar](50) NULL, * [RABVACCINEFLAG] [bit] NOT NULL, * [RABATTACH] [varbinary](max) NULL, * [VALIDPERMITFLAG] [bit] NOT NULL, * [VALIDPERMITATTACH] [varbinary](max) NULL, * [PERMITCATEGORY] [int] NULL, * [RESUMEATTACH] [varbinary](max) NULL, * [LETTEROFRECOM] [varbinary](max) NULL, * [LASTUPDATED] [datetime] NOT NULL, * [LASTUPDATEDBY] [varchar](50) NOT NULL, * */ insert.CommandText = "insert into [dbo].[APPLICANT]" + "([PROFILEID],[USERID],[PHONE],[DOB],[GENDER],[PROFSTATUS],[USERTYPE],[ALLERGIES],[ALLERGIESSPECIFY]," + "[LIMITATIONS],[LIMITATIONSSPECIFY],[MEDICALCONDITIONS],[RABVACCINEFLAG],[RABATTACH],[VALIDPERMITFLAG],[VALIDPERMITATTACH]," + "[PERMITCATEGORY],[RESUMEATTACH],[LETTEROFRECOM],[LASTUPDATED],[LASTUPDATEDBY])"; insert.CommandText += " values (@PROFILEID,@USERID,@PHONE,@DOB,@GENDER,@PROFSTATUS,@USERTYPE,@ALLERGIES,@ALLERGIESSPECIFY," + "@LIMITATIONS,@LIMITATIONSSPECIFY,@MEDICALCONDITIONS,@RABVACCINEFLAG,@RABATTACH,@VALIDPERMITFLAG,@VALIDPERMITATTACH," + " @PERMITCATEGORY,@RESUMEATTACH,@LETTEROFRECOM,@LASTUPDATED,@LASTUPDATEDBY"; insert.Parameters.AddWithValue("@USERID", UserID); insert.Parameters.AddWithValue("@PHONE", phoneNumber); insert.Parameters.AddWithValue("@DOB", dOB); insert.Parameters.AddWithValue("@GENDER", gender); insert.Parameters.AddWithValue("@PROFSTATUS", AppStatues); insert.Parameters.AddWithValue("@USERTYPE", UserID); insert.Parameters.AddWithValue("@ALLERGIES", 1); insert.Parameters.AddWithValue("@ALLERGIESSPECIFY", allergies); insert.Parameters.AddWithValue("@LIMITATIONS", 1); insert.Parameters.AddWithValue("@LIMITATIONSSPECIFY", limitation); insert.Parameters.AddWithValue("@MEDICALCONDITIONS", medicalCondition); insert.Parameters.AddWithValue("@RABVACCINEFLAG", 1); insert.Parameters.AddWithValue("@RABATTACH", ""); insert.Parameters.AddWithValue("@VALIDPERMITFLAG", 1); insert.Parameters.AddWithValue("@VALIDPERMITATTACH", ""); insert.Parameters.AddWithValue("@PERMITCATEGORY", ""); insert.Parameters.AddWithValue("@RESUMEATTACH", ""); insert.Parameters.AddWithValue("@LETTEROFRECOM", ""); insert.Parameters.AddWithValue("@LASTUPDATED", UserID); insert.Parameters.AddWithValue("@LASTUPDATEDBY", DateTime.Now); insert.ExecuteNonQuery(); if (saved) { AppStatues = "Started"; saved = SavingFiles.ApplicationStatus(AppStatues, UserID); } if (saved) { } }