protected void changPwd_Click(object sender, EventArgs e)
{
string Newpassword = newpwd.Text.Replace("'", "\''");
string oldpassword = oldpwd.Text.Replace("'", "\''");
string query = "SELECT * FROM users" + " where id = '" + ID + "'";
dt = dbconnect.databaseReturnDt(query);
if (dt.Rows[0]["password"].ToString() != oldpassword)
{
msgPwd.Text = "Password entered is incorrect";
return;
}
else
{
string update = "update users set password='******' where id='" + ID + "'";
dbconnect.databaseInsert(update);
Panel1.Visible = true;
Panel2.Visible = false;
//Image6.Visible = true;
//msgSucc.Text = "Successfull";
}
}
protected void signUp_Click(object sender, EventArgs e)
{
bool Validrecord = true;
string query1 = "SELECT * FROM users WHERE email='" + email.Text.Replace("'", "\''") + "' and phone='" + phone.Text.Replace("'", "\''") + "'";
dt = dbconnect.databaseReturnDt(query1);
if (dt.Rows.Count > 0)
{
Validrecord = false;
msgfal.Text = "Email Or PhoneNo already exsist";
name.Focus();
Panel1.Visible = true;
Panel2.Visible = false;
//return;
}
if (Validrecord == true)
{
string query = "insert into users(names,phone,email,password,confirm,regdate) values ("
+ "'" + name.Text.Replace("'", "\''") + "',"
+ "'" + phone.Text.Replace("'", "\''") + "',"
+ "'" + email.Text.Replace("'", "\''") + "',"
+ "'" + pwd.Text.Replace("'", "\''") + "',"
+ "'" + confirm.Text.Replace("'", "\''") + "',"
+ "'" + DateTime.Now.ToString() + "')";
dbconnect.databaseInsert(query);
msgsucc.Text = "Successful Registration ";
Panel1.Visible = false;
Panel2.Visible = true;
}
else
{
msgfal.Text = "Something went wrong";
Panel1.Visible = true;
Panel2.Visible = false;
}
name.Text = "";
phone.Text = "";
email.Text = "";
pwd.Text = "";
confirm.Text = "";
msgsucc.Text = "";
msgfal.Text = "";
Panel1.Visible = false;
Panel2.Visible = false;
}
protected void delete_Click(object sender, EventArgs e)
{
Button delBtn = sender as Button;
GridViewRow gvrow = delBtn.NamingContainer as GridViewRow;
int del_id = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Value.ToString());
string name, type;
string query2 = "delete from users WHERE id =" + del_id + "";
dbconnect.databaseInsert(query2);
Response.Redirect("customerInfo.aspx");
}
protected void tranFile_Click(object sender, EventArgs e)
{
Button lnkbtn = sender as Button;
GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
int fileid = Convert.ToInt32(GridView1.DataKeys[gvrow.RowIndex].Value.ToString());
string name, type;
string query = "SELECT * FROM uploadfile" + " where id = '" + fileid + "'";
dt = dbconnect.databaseReturnDt(query);
if (dt.Rows.Count > 0)
{
string fileName = dt.Rows[0]["filename"].ToString();
string fileSize = dt.Rows[0]["filesize"].ToString();
double transTime = double.Parse(fileSize) / 8;
double transs = Math.Round(transTime);
string query1 = "insert into transferedFile(filename,filesize,transferedTime) values ("
+ "'" + fileName + "',"
+ "'" + fileSize + "',"
+ "'" + transs.ToString() + "')";
dbconnect.databaseInsert(query1);
string query2 = "delete from uploadfile WHERE id =" + fileid + "";
dbconnect.databaseInsert(query2);
System.Threading.Thread.Sleep(1000);
Response.Redirect("transferedFile.aspx");
}
}
protected void uploadf_Click(object sender, EventArgs e)
{
bool Validrecord = true;
if (Validrecord == true)
{
if (txtfile.HasFile == true)
{
string myMap = MapPath("~/").ToLower();
Random r = new Random();
int next = r.Next();
string ImageName = txtfile.PostedFile.FileName;
sImageFileExtension = ImageName.Substring(ImageName.LastIndexOf(".")).ToLower();
if (sImageFileExtension == ".docx" || sImageFileExtension == ".pdf" || sImageFileExtension == ".gif" || sImageFileExtension == ".png" || sImageFileExtension == ".jpg" || sImageFileExtension == ".jpeg" || sImageFileExtension == ".bmp")
{
string ImageSaveURL = myMap + "UserImage/" + next + sImageFileExtension;
txtfile.PostedFile.SaveAs(ImageSaveURL);
filename = Path.GetFileName(ImageName);
filesize = ImageName.Length.ToString();
double uploadTime = double.Parse(filesize) / 5;
double upTime = Math.Round(uploadTime);
string query2 = "insert into uploadfile(filename,filesize,uploadedTime,status) values ("
+ "'" + filename + "',"
+ "'" + filesize + "',"
+ "'" + upTime.ToString() + "',"
+ "" + status + ")";
dbconnect.databaseInsert(query2);
System.Threading.Thread.Sleep(8000);
msgsucc.Text = "Upload successfull!";
Panel1.Visible = false;
Panel2.Visible = true;
Panel3.Visible = true;
}
}
else
{
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
bool Validrecord = true;
string query1 = "SELECT * FROM users WHERE name='" + name.Text.Replace("'", "\''") + "' and phone='" + phone.Text.Replace("'", "\''") + "'";
dt = dbconnect.databaseReturnDt(query1);
if (dt.Rows.Count > 0)
{
Validrecord = false;
msgfal.Text = name.Text + "already exsist";
name.Focus();
Panel1.Visible = true;
Panel2.Visible = false;
return;
}
if (Validrecord == true)
{
string query = "insert into users(name,address,gender,state,phone,email,username,password) values ("
+ "'" + name.Text.Replace("'", "\''") + "',"
+ "'" + address.Text.Replace("'", "\''") + "',"
+ "'" + gender.Text.Replace("'", "\''") + "',"
+ "'" + state.Text.Replace("'", "\''") + "',"
+ "'" + phone.Text.Replace("'", "\''") + "',"
+ "'" + email.Text.Replace("'", "\''") + "',"
+ "'" + username.Text.Replace("'", "\''") + "',"
+ "'" + pwd.Text.Replace("'", "\''") + "')";
dbconnect.databaseInsert(query);
msgsucc.Text = "Successful Registration ";
Panel1.Visible = false;
Panel2.Visible = true;
}
}
protected void save_Click(object sender, EventArgs e)
{
bool Validrecord = true;
string Selectstring = "SELECT * FROM prisoner " + "WHERE name='" + fName.Text.Replace("'", "\''") + "' and age='" + age.Text.Replace("'", "\''") + "'";
dt = dbconnect.databaseReturnDt(Selectstring);
if (dt.Rows.Count > 0)
{
Validrecord = false;
msg2.Text = fName.Text + " " + age.Text + " already exsist";
fName.Focus();
age.Focus();
Panel3.Visible = true;
Panel2.Visible = false;
return;
}
if (Validrecord == true)
{
if (pic.HasFile == false)
{
string PicName = "NoImage";
string query = "insert into prisoner(name,gender,age,education,state_origin,nationality,marital,offence,date_convicted,date_judgement,prison_name,sentence,Ditem_time,file_no) values ("
+ "'" + fName.Text.Replace("'", "\''") + "',"
+ "'" + gender.Text.Replace("'", "\''") + "',"
+ "'" + age.Text.Replace("'", "\''") + "',"
+ "'" + education.Text.Replace("'", "\''") + "',"
+ "'" + state.Text.Replace("'", "\''") + "',"
+ "'" + nation.Text.Replace("'", "\''") + "',"
+ "'" + marital.Text.Replace("'", "\''") + "',"
+ "'" + offence.Text.Replace("'", "\''") + "',"
+ "'" + judge.Text.Replace("'", "\''") + "',"
+ "'" + convict.Text.Replace("'", "\''") + "',"
+ "'" + prisonN.Text.Replace("'", "\''") + "',"
+ "'" + sentence.Text.Replace("'", "\''") + "',"
+ "'" + DateTime.Now.ToString() + "',"
+ "'" + file.Text.Replace("'", "\''") + "')";
dbconnect.databaseInsert(query);
msg1.Text = "Successful Registration ";
Panel1.Visible = true;
Panel2.Visible = false;
}
else if (pic.HasFile == true)
{
string myMap = MapPath("~/").ToLower();
Random r = new Random();
int next = r.Next();
string ImageName = pic.PostedFile.FileName;
sImageFileExtension = ImageName.Substring(ImageName.LastIndexOf(".")).ToLower();
if (sImageFileExtension == ".gif" || sImageFileExtension == ".png" || sImageFileExtension == ".jpg" || sImageFileExtension == ".jpeg" || sImageFileExtension == ".bmp")
{
string ImageSaveURL = myMap + "UserImage/" + next + sImageFileExtension;
pic.PostedFile.SaveAs(ImageSaveURL);
string query = "insert into prisoner(name,gender,age,education,state_origin,nationality,marital,offence,date_convicted,date_judgement,prison_name,sentence,Ditem_time,imagename,file_no) values ("
+ "'" + fName.Text.Replace("'", "\''") + "',"
+ "'" + gender.Text.Replace("'", "\''") + "',"
+ "'" + age.Text.Replace("'", "\''") + "',"
+ "'" + education.Text.Replace("'", "\''") + "',"
+ "'" + state.Text.Replace("'", "\''") + "',"
+ "'" + nation.Text.Replace("'", "\''") + "',"
+ "'" + marital.Text.Replace("'", "\''") + "',"
+ "'" + offence.Text.Replace("'", "\''") + "',"
+ "'" + judge.Text.Replace("'", "\''") + "',"
+ "'" + convict.Text.Replace("'", "\''") + "',"
+ "'" + prisonN.Text.Replace("'", "\''") + "',"
+ "'" + sentence.Text.Replace("'", "\''") + "',"
+ "'" + DateTime.Now.ToString() + "',"
+ "'" + next + sImageFileExtension + "',"
+ "'" + file.Text.Replace("'", "\''") + "')";
dbconnect.databaseInsert(query);
msg1.Text = "Successful Registration ";
Panel1.Visible = true;
Panel2.Visible = false;
}
else
{
}
}
}
}
protected void Save_Click(object sender, EventArgs e)
{
string str = "SELECT * FROM prisoner" + " where id = '" + ID + "'";
dt = dbconnect.databaseReturnDt(str);
if (dataTime.Text == dt.Rows[0]["Ditem_time"].ToString())
{
if (picE.HasFile == false)
{
string str2 = "UPDATE prisoner SET " + "names='" + nameE.Text.Replace("'", "\''") + "', " +
"gender='" + genderE.Text.Replace("'", "\''") + "', " +
"age='" + ageE.Text.Replace("'", "\''") + "', " +
"education='" + educationE.Text.Replace("'", "\''") + "', " +
"state_origin='" + stateE.Text.Replace("'", "\''") + "', " +
"nationality='" + nationE.Text.Replace("'", "\''") + "', " +
"marital='" + maritalE.Text.Replace("'", "\''") + "', " +
"offence='" + offenceE.Text.Replace("'", "\''") + "', " +
"date_convicted='" + convictE.Text.Replace("'", "\''") + "', " +
"file_no='" + fileE.Text.Replace("'", "\''") + "', " +
"prison_name='" + prisonE.Text.Replace("'", "\''") + "', " +
"sentence='" + sentenceE.Text.Replace("'", "\''") + "'" +
" where id='" + ID + "'";
dt = dbconnect.databaseReturnDt(str2);
string update = "Update prisoner set Ditem_time ='" + transTime.Text + "' where id ='" + ID + "'";
dbconnect.databaseInsert(update);
Response.Redirect("inmates.aspx");
}
else if (picE.HasFile == true)
{
string myMap = MapPath("~/").ToLower();
Random r = new Random();
int next = r.Next();
string ImageName = picE.PostedFile.FileName;
sImageFileExtension = ImageName.Substring(ImageName.LastIndexOf(".")).ToLower();
if (sImageFileExtension == ".gif" || sImageFileExtension == ".png" || sImageFileExtension == ".jpg" || sImageFileExtension == ".jpeg" || sImageFileExtension == ".bmp")
{
string ImageSaveURL = myMap + "UserImage/" + next + sImageFileExtension;
picE.PostedFile.SaveAs(ImageSaveURL);
string str2 = "UPDATE prisoner SET " + "names='" + nameE.Text.Replace("'", "\''") + "', " +
"gender='" + genderE.Text.Replace("'", "\''") + "', " +
"age='" + ageE.Text.Replace("'", "\''") + "', " +
"education='" + educationE.Text.Replace("'", "\''") + "', " +
"state_origin='" + stateE.Text.Replace("'", "\''") + "', " +
"nationality='" + nationE.Text.Replace("'", "\''") + "', " +
"marital='" + maritalE.Text.Replace("'", "\''") + "', " +
"offence='" + offenceE.Text.Replace("'", "\''") + "', " +
"date_convicted='" + convictE.Text.Replace("'", "\''") + "', " +
"imagename='" + next + sImageFileExtension + "', " +
"file_no='" + fileE.Text.Replace("'", "\''") + "', " +
"prison_name'" + prisonE.Text.Replace("'", "\''") + "', " +
"sentence='" + sentenceE.Text.Replace("'", "\''") + "'" +
" where id='" + ID + "'";
dt = dbconnect.databaseReturnDt(str2);
string update = "Update prisoner set Ditem_time ='" + transTime.Text + "' where 1d ='" + ID + "'";
dbconnect.databaseInsert(update);
Response.Redirect("inmates.aspx");
}
}
else
{
}
}
else
{
Panel3.Visible = true;
Panel2.Visible = false;
Panel1.Visible = false;
msg2.Text = " not succesful! The record you attempted to update has been modified by another user"
+ " <br/>Click Continue to start over again";
}
}
