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)
{
}
}
