protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DropDownList2.Items.Add("Processing");
DropDownList2.Items.Add("Done");
DropDownList1.Items.Add("Processing");
DropDownList1.Items.Add("Done");
VisaRequestClass vc = ConnectionClass.GetVisaRequestById(Session["id"].ToString(), "RqstVisaServices");
TextBox1.Text = vc.RequestId.ToString();
TextBox2.Text = vc.UserName;
TextBox3.Text = vc.Name;
TextBox4.Text = vc.Email;
TextBox5.Text = vc.VisaTitle;
TextBox6.Text = vc.NameofApplicant;
TextBox7.Text = vc.DateofBirth.ToShortDateString();
TextBox8.Text = vc.PassportNo;
TextBox9.Text = vc.MotherName;
TextBox10.Text = vc.Deadline.ToString();
TextBox11.Text = vc.Description;
ViewState["uploadfile"] = vc.UploadFile;
ViewState["passportcopy"] = vc.PassportCopy;
DropDownList1.SelectedItem.Text = vc.VisaType;
DropDownList2.SelectedItem.Text = vc.RequestStatus;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
if (FileUpload1.PostedFile.ContentType == "application/pdf")
{
try
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/ResultFiles/VisaServices/") + TextBox1.Text + ".pdf");
}
catch (Exception ex)
{
lblError.Text = "File could not be uploaded" + ex.Message;
}
}
else
{
lblError.Text = "File must be a PDF";
}
if (lblError.Text == "")
{
VisaRequestClass vc = new VisaRequestClass(Convert.ToInt32(TextBox1.Text), TextBox3.Text, TextBox2.Text, TextBox4.Text, TextBox5.Text, DropDownList1.SelectedItem.Text, TextBox6.Text, Convert.ToDateTime(TextBox7.Text), TextBox8.Text, TextBox9.Text, ViewState["passportcopy"].ToString(), Convert.ToDateTime(TextBox10.Text), TextBox11.Text, ViewState["uploadfile"].ToString(), DropDownList2.SelectedItem.Text, FileUpload1.PostedFile.FileName);
string result = ConnectionClass.UpdateVisaRequest(vc, "RqstVisaServices");
Label1.Text = result;
}
else
{
Label1.Text = "";
}
}
}
public static string UpdateVisaRequest(VisaRequestClass c, string tablename)
{
try
{
conn.Open();
string query = String.Format("UPDATE {0} SET requestStatus='{1}',resultFile='{2}' WHERE requestId='{3}'", tablename, c.RequestStatus, c.ResultFile, c.RequestId);
com.CommandText = query;
com.ExecuteNonQuery();
return("Request updated successfully");
}
finally
{
conn.Close();
}
}
public static string AddVisaRequest(VisaRequestClass visarequest)
{
try
{
conn.Open();
string query = string.Format("INSERT INTO RqstVisaServices VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}')", visarequest.Name, visarequest.UserName, visarequest.Email, visarequest.VisaTitle, visarequest.VisaType, visarequest.NameofApplicant, visarequest.DateofBirth, visarequest.PassportNo, visarequest.MotherName, visarequest.PassportCopy, visarequest.Deadline, visarequest.Description, visarequest.UploadFile, visarequest.RequestStatus, visarequest.ResultFile);
com.CommandText = query;
com.ExecuteNonQuery();
return("Request Added Successfully");
}
finally
{
conn.Close();
}
}
public static VisaRequestClass GetVisaRequestById(string i, string tablename)
{
int id = Convert.ToInt32(i);
try
{
conn.Open();
string query = String.Format("SELECT * FROM {0} WHERE requestId={1}", tablename, i);
com.CommandText = query;
VisaRequestClass c = null;
SqlDataReader reader = com.ExecuteReader();
while (reader.Read())
{
int requestid = reader.GetInt32(0);
string name = reader.GetString(1);
string username = reader.GetString(2);
string email = reader.GetString(3);
string title = reader.GetString(4);
string type = reader.GetString(5);
string nameofapplicant = reader.GetString(6);
DateTime dob = reader.GetDateTime(7);
string passportno = reader.GetString(8);
string mothername = reader.GetString(9);
string passportcopy = reader.GetString(10);
DateTime deadline = reader.GetDateTime(11);
string description = reader.GetString(12);
string uploadfile = reader.GetString(13);
string status = reader.GetString(14);
string resultfile = reader.GetString(15);
c = new VisaRequestClass(requestid, name, username, email, title, type, nameofapplicant, dob, passportno, mothername, passportcopy, deadline, description, uploadfile, status, resultfile);
}
return(c);
}
finally
{
conn.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
if (FileUpload1.PostedFile.ContentType.Equals("application/pdf"))
{
if (flag_deadline == true)
{
try
{
string filename = Path.GetFileName(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/RequestFiles/") + filename);
flag = true;
}
catch (Exception ex)
{
lblResult.Text = ex.ToString();
}
}
}
else
{
lblFileUpload.Text = "Passport File must be a PDF File";
flag = false;
}
}
if (FileUpload2.HasFile)
{
if (FileUpload2.PostedFile.ContentType.Equals("application/pdf"))
{
if (flag_deadline == true)
{
try
{
string filename = Path.GetFileName(FileUpload2.FileName);
FileUpload2.SaveAs(Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/PassportFiles/") + filename);
flag = true;
}
catch (Exception ex)
{
lblResult.Text = ex.ToString();
}
}
}
else
{
lblFileUpload.Text = "Request File must be a PDF File";
flag = false;
}
}
if (flag == true)
{
string selectedDate = txtDeadline.Text;
DateTime dt1 = DateTime.Parse(selectedDate);
selectedDate = txtCalendar.Text;
DateTime dt2 = DateTime.Parse(selectedDate);
VisaRequestClass visarequestclass = new VisaRequestClass(txtName.Text, Session["login"].ToString(), txtMail.Text, txtTitle.Text, DropDownList1.SelectedItem.Text, txtNameOfAppl.Text, dt2, txtPassNo.Text, txtMother.Text, FileUpload2.PostedFile.FileName.ToString(), dt1, txtDescription.Text, FileUpload1.PostedFile.FileName.ToString(), "Processing", "");
string result = ConnectionClass.AddVisaRequest(visarequestclass);
int a = ConnectionClass.RetrieveLastId("RqstVisaServices");
ConnectionClass.UpdateVisaFilenamebyId(a);
string oldname = Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/RequestFiles/") + FileUpload1.PostedFile.FileName;
string newname = Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/RequestFiles/") + Convert.ToString(a) + ".pdf";
File.Move(oldname, newname);
oldname = Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/PassportFiles/") + FileUpload2.PostedFile.FileName;
newname = Server.MapPath("~/Files/" + Session["login"] + "/VisaServices/PassportFiles/") + Convert.ToString(a) + ".pdf";
File.Move(oldname, newname);
lblResult.Text = result;
lblFileUpload.Text = "";
}
}
