protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Saipreethi_Induri\source\repos\Registrationform\Registrationform\App_Data\Database1.mdf;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select * from Country", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
DropDownList4.DataSource = dt;
DropDownList4.DataBind();
}
}
protected void delcity_Click(object sender, EventArgs e)
{
controllerObj.deletecity(Convert.ToInt32(DropDownList12.SelectedValue));
DropDownList7.DataBind();
DropDownList6.DataBind();
DropDownList5.DataBind();
DropDownList4.DataBind();
DropDownList3.DataBind();
DropDownList2.DataBind();
DropDownList11.DataBind();
DropDownList12.DataBind();
DropDownList13.DataBind();
}
protected void DropDownList12_SelectedIndexChanged(object sender, EventArgs e)
{
sql_temp = "select distinct(t.dep_name) as dep_name from lh_onduty_record t where t.divname='" + DropDownList12.SelectedValue + "' ";
ds_temp = func.get_dataSet_access(sql_temp, conn);
DropDownList4.DataTextField = "dep_name";
DropDownList4.DataValueField = "dep_name";
DropDownList4.DataSource = ds_temp.Tables[0];
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, "請選擇");
ds_temp.Clear();
}
protected void Page_Load(object sender, EventArgs e)
{
Label9.Visible = false;
Label8.Visible = false;
UtilizadorRules utilizadorRules = new UtilizadorRules();
this.utilizadorExistente = new Utilizador();
string email = Session["email"].ToString();
string senha = Session["password"].ToString();
if (email != null || senha != null)
{
this.utilizadorExistente = utilizadorRules.Login(email, senha);
Label1.Text = "Agendar uma Consulta para: " + utilizadorExistente.Username;
}
Label6.Visible = false;
if (Calendar1.SelectedDate.Date < DateTime.Today)
{
Label6.Visible = true;
}
List <Tratamento> listaTratamentos = new List <Tratamento>();
List <Local> listaLocais = new List <Local>();
List <Utilizador> listaFisioterapeutas = new List <Utilizador>();
ConsultaRules consultaRules = new ConsultaRules();
listaLocais = consultaRules.GetLocais();
listaTratamentos = consultaRules.GetTratamentos();
if (!Page.IsPostBack)
{
DropDownList2.DataSource = listaLocais;
DropDownList2.DataTextField = "Nome";
DropDownList2.DataValueField = "ID";
DropDownList2.DataBind();
DropDownList4.DataSource = listaTratamentos;
DropDownList4.DataTextField = "Descricao";
DropDownList4.DataValueField = "ID";
DropDownList4.DataBind();
listaFisioterapeutas = utilizadorRules.GetFisioterapeutas();
DropDownList1.DataSource = listaFisioterapeutas;
DropDownList1.DataTextField = "Username";
DropDownList1.DataValueField = "ID";
DropDownList1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
TextBox14.Enabled = false;
TextBox1.Enabled = false;
DropDownList4.DataValueField = "Cmp_No";
DropDownList4.DataTextField = "Cmp_Nm";
DropDownList4.DataSource = db.MainCmpnam.ToList();
DropDownList4.DataBind();
TextBox28.Text = DropDownList4.SelectedValue;
DropDownList5.DataValueField = "Brn_No";
DropDownList5.DataTextField = "Brn_NmAr";
DropDownList5.DataSource = db.MainBranch.ToList();
DropDownList5.DataBind();
int id = int.Parse(Request.QueryString["no"]);
var cn = db.MtsCustmr.Where(o => o.Cstm_No == id).SingleOrDefault();
ViewState.Add("id", id);
TextBox14.Text = cn.Cstm_No.ToString();
TextBox15.Text = cn.Cstm_NmAr;
TextBox1.Text = cn.Level_no.ToString();
TextBox2.Text = cn.Cstm_NmEn.ToString();
//TextBox3.Text = cn.Sup_Rsp;
//TextBox4.Text = cn.Sup_Othr;
//TextBox5.Text = cn.Sup_Email;
if (!string.IsNullOrEmpty(cn.Tel1))
{
TextBox6.Text = cn.Tel1.ToString();
}
if (!string.IsNullOrEmpty(cn.Cstm_Tel))
{
TextBox7.Text = cn.Cstm_Tel;
}
TextBox8.Text = cn.Mobile1;
TextBox9.Text = cn.Credit_Value.ToString();
TextBox10.Text = cn.Credit_Days.ToString();
TextBox12.Text = cn.Fbal_Db.ToString();
TextBox11.Text = cn.Fbal_CR.ToString();
//TextBox13.Text = cn.Curncy_No.ToString();
DropDownList2.SelectedValue = cn.Catg_No.ToString();
DropDownList3.SelectedValue = cn.Cntry_No.ToString();
RadioButtonList1.SelectedValue = cn.Level_Status.ToString();
TextBox26.Text = cn.Brn_No.ToString();
load_tree();
}
}
//binding every month day
private void BindDays(int year, int month)
{
int i;
ArrayList AlDay = new ArrayList();
switch (month)
{
case 1:
case 3:
case 5:
case 7:
case 8:
case 10:
case 12:
for (i = 1; i <= 31; i++)
{
AlDay.Add(i);
}
break;
case 2:
if (CheckLeap(year))
{
for (i = 1; i <= 29; i++)
{
AlDay.Add(i);
}
}
else
{
for (i = 1; i <= 28; i++)
{
AlDay.Add(i);
}
}
break;
case 4:
case 6:
case 9:
case 11:
for (i = 1; i <= 30; i++)
{
AlDay.Add(i);
}
break;
}
DropDownList4.DataSource = AlDay;
DropDownList4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MultiView1.SetActiveView(View1);
DataGrid1.DataSource = db.DataReturn("select surgery_id as ID, surgery_name as SURGERY, category_name as CATEGORY, duration as DURATION, amount as AMOUNT, description as DESCRIPTION from surgeries inner join surgery_category on surgery_category.category_id = surgeries.category_id where surgeries.hospital_id = " + Session["hospital_id"].ToString());
DataGrid1.DataBind();
DropDownList4.DataSource = db.DataReturn("select surgeon_id,first_name+' '+last_name as sname from surgeons where hospital_id='" + Session["hospital_id"].ToString() + "'");
DropDownList4.DataValueField = "surgeon_id";
DropDownList4.DataTextField = "sname";
DropDownList4.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
label_GridPageState.Text = "默认数据源";
string state = "";
if (!IsPostBack)
{
if (Request.QueryString["state"] == null)
{
Response.Redirect("~/Default.aspx");
}
else
{
state = Request.QueryString["state"];
}
if (state == "devide")
{
Title = "随工单分单";
GridView_WOmain.Columns[0].Visible = false;
GridView_WOmain.Columns[1].Visible = false;
CheckBoxAll.Visible = false;
CheckBoxfanxuan.Visible = false;
Btn_deleting.Visible = false;
}
if (state == "combine")
{
Title = "随工单合单";
GridView1.Columns[15].Visible = false;
}
DropDownList3.DataSource = erl.S_WOError_Rework_PBCraft();
DropDownList3.DataTextField = "PBC_Name";
DropDownList3.DataValueField = "PBC_ID";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, new ListItem("请选择", ""));
DropDownList4.DataSource = erl.S_WOError_Rework_PBCraft();
DropDownList4.DataTextField = "PBC_Name";
DropDownList4.DataValueField = "PBC_ID";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("请选择", ""));
//this.Title = "随工单分单";
string condition = " and 1=1";
GridView_WOmain.DataSource = erl.S_WorkOrder_Check(condition);
GridView_WOmain.DataBind();
UpdatePanel_WOmain.Update();
}
}
private void GetFrancheeseNames()
{
da = new SqlDataAdapter("select fid,fname from tbl_francheese", con);
ds = new DataSet();
da.Fill(ds, "tbl_f");
if (ds.Tables.Count > 0 && ds.Tables["tbl_f"].Rows.Count > 0)
{
DropDownList4.DataSource = ds.Tables["tbl_f"].DefaultView;
DropDownList4.DataTextField = "fname";
DropDownList4.DataValueField = "fid";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, "---Select---");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
try
{
int check = Convert.ToInt32(TextBox1.Text);
if (check == Convert.ToInt32(ViewState["count"]))
// insert we selected questions
{
SqlCommand testCmd = new SqlCommand();
testCmd.CommandText = "INSERT INTO Test(Test_Type,Total_Questions,Total_Marks,Subject_Id) Values('" + Convert.ToString(DropDownList4.SelectedItem) + "'," + GridView1.Rows.Count + "," + check + "," + Convert.ToInt32(Label7.Text) + ")";
testCmd.Connection = cn;
testCmd.ExecuteNonQuery();
SqlCommand lastTest = new SqlCommand();
lastTest.CommandText = "SELECT max(Test_Id) FROM TEST";
lastTest.Connection = cn;
int t_id = Convert.ToInt32(lastTest.ExecuteScalar());
// Response.Write("Test Id " + t_id);
SqlCommand ins_queCmd = new SqlCommand();
for (int row = 0; row < GridView1.Rows.Count; row++)
{
ins_queCmd.CommandText = "INSERT INTO Test_Question(Test_Id,Question_Id) VALUES (" + t_id + "," + GridView1.Rows[row].Cells[0].Text + ")";
ins_queCmd.Connection = cn;
ins_queCmd.ExecuteNonQuery();
//Response.Write(GridView1.Rows[row].Cells[0].Text);
}
DropDownList1.ClearSelection();
DropDownList2.ClearSelection();
DropDownList3.ClearSelection();
DropDownList4.ClearSelection();
TextBox1.Text = "";
CheckBoxList1.Items.Clear();
CheckBoxList2.Items.Clear();
GridView1.DataSource = null;
GridView1.DataBind();
Response.Write(@"<script language='javascript'>alert('Test is successfully generated')</script>");
}
else
{
Response.Write("Select Entered Mark paper");
}
}
catch (Exception a)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["AdminName"] == null)
{
Response.Redirect("login.aspx");
}
if (!IsPostBack)
{
MySqlDataReader reader = SqlHelper.GetExecuteReader("SELECT bookstyle FROM book_style");
DropDownList1.DataSource = reader;
DropDownList1.DataTextField = "bookstyle";
DropDownList1.DataValueField = "bookstyle";
DropDownList1.DataBind();
SqlHelper.Closeconn();
DropDownList1.Items.Insert(0, new ListItem("<-- 请选择 -->", "0"));
}
////////////////////////////
DateTime tnow = DateTime.Now; //现在时间
ArrayList alyear = new ArrayList();
int i;
for (i = 1980; i <= 2018; i++)
{
alyear.Add(i);
}
ArrayList almonth = new ArrayList();
for (i = 1; i <= 12; i++)
{
almonth.Add(i);
}
ArrayList alday = new ArrayList();
for (i = 1; i <= 31; i++)
{
alday.Add(i);
}
if (!this.IsPostBack)
{
DropDownList2.DataSource = alyear;
DropDownList2.DataBind();
DropDownList2.SelectedValue = tnow.Year.ToString();
DropDownList3.DataSource = almonth;
DropDownList3.DataBind();
DropDownList3.SelectedValue = tnow.Month.ToString();
DropDownList4.DataSource = alday;
DropDownList4.DataBind();
DropDownList4.SelectedValue = tnow.Day.ToString();
}
}
protected void Button5_Click(object sender, EventArgs e)
{
string connectionString = @"Server=Localhost;Database=Consultorio;Trusted_Connection=true";
SqlConnection conexao2 = new SqlConnection(connectionString);
conexao2.Open();
SqlCommand acha = new SqlCommand("select Hora,Dia_Consulta from Paciente_Clinica_Tijuca where Dia_Consulta='" + DropDownList3.Text + "'", conexao2);
DropDownList4.DataTextField = "Hora";
DropDownList4.DataValueField = "Hora";
DropDownList4.DataSource = acha.ExecuteReader();
DropDownList4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ArrayList arry = new ArrayList();
arry.Add("男");
arry.Add("女");
DropDownList4.DataSource = arry;
DropDownList4.DataBind();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string str = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["constring"].ToString();
SqlConnection conn = new SqlConnection(str);
SqlDataAdapter myCommand = new SqlDataAdapter("select stationName from station ", conn);
DataSet ds = new DataSet();
myCommand.Fill(ds);
DropDownList4.DataTextField = "stationName";
DropDownList4.DataSource = ds.Tables[0].DefaultView;
DropDownList4.DataBind();
}
}
private void GetBranchNames(int fid)
{
da = new SqlDataAdapter("select bid,bname from tbl_branches where fid=" + fid + " ", con);
ds = new DataSet();
da.Fill(ds, "tbl_b");
if (ds.Tables.Count > 0 && ds.Tables["tbl_b"].Rows.Count > 0)
{
DropDownList4.DataSource = ds.Tables["tbl_b"].DefaultView;
DropDownList4.DataTextField = "bname";
DropDownList4.DataValueField = "bid";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, "---Select---");
}
}
protected void Button6_Click(object sender, EventArgs e)
{
string conexao = @"Server=Localhost;Database=Consultorio;Trusted_Connection=true";
SqlConnection conecta = new SqlConnection(conexao);
conecta.Open();
SqlCommand acha = new SqlCommand("select mes,data from dataIlha where mes='" + DropDownList3.Text + "'", conecta);
DropDownList4.DataTextField = "data";
DropDownList4.DataValueField = "data";
DropDownList4.DataSource = acha.ExecuteReader();
DropDownList4.DataBind();
}
private void RestartGeneration()
{
DropDownList1.DataSource = Classes.HogwartsDataAccess.GetSemesterList();
DropDownList1.DataBind();
DropDownList1.SelectedIndex = 0;
DropDownList2.DataSource = Classes.HogwartsDataAccess.GetDepartmentList();
DropDownList2.DataBind();
DropDownList2.SelectedIndex = 0;
DropDownList3.DataSource = Classes.HogwartsDataAccess.GetDisciplineList(DropDownList2.SelectedValue);
DropDownList3.DataBind();
RadioButtonList1.SelectedIndex = 0;
DropDownList4.DataSource = Classes.HogwartsDataAccess.GetTeacherList(DropDownList2.SelectedValue);
DropDownList4.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "";
if (!Page.IsPostBack)
{
DropDownList3.DataValueField = "Brn_No";
DropDownList3.DataTextField = "Brn_NmAr";
DropDownList3.DataSource = db.MainBranch.ToList();
DropDownList3.DataBind();
DropDownList4.DataValueField = "ACC_No";
DropDownList4.DataTextField = "Acc_NmAr";
DropDownList4.DataSource = db.GLAstbank.ToList();
DropDownList4.DataBind();
DropDownList5.DataValueField = "Sup_No";
DropDownList5.DataTextField = "Sup_NmAr";
DropDownList5.DataSource = db.MtsSuplir.ToList();
DropDownList5.DataBind();
DropDownList6.DataValueField = "Cntry_No";
DropDownList6.DataTextField = "Cntry_NmAr";
DropDownList6.DataSource = db.InvAstCntry.ToList();
DropDownList6.DataBind();
DropDownList7.DataValueField = "Pym_No";
DropDownList7.DataTextField = "Pym_Nmar";
DropDownList7.DataSource = db.LcPymwys.ToList();
DropDownList7.DataBind();
DropDownList1.DataValueField = "Curncy_No";
DropDownList1.DataTextField = "Curncy_Nmar";
DropDownList1.DataSource = db.InvAstCurncy.ToList();
DropDownList1.DataBind();
DropDownList2.DataValueField = "Curncy_No";
DropDownList2.DataTextField = "Curncy_Nmar";
DropDownList2.DataSource = db.InvAstCurncy.ToList();
DropDownList2.DataBind();
TextBox1.Enabled = false;
TextBox1.Text = (db.MtsLC.Max(o => o.Doc_No) + 1).ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
AddSeat.Attributes.Add("onclick", " javascript : return confirm (' Are you sure want to select the seat ?');");
int adultfare = Convert.ToInt32(DropDownList1.SelectedValue);
int childfare = Convert.ToInt32(DropDownList2.SelectedValue);
if (!IsPostBack)
{
SqlCommand cmd = new SqlCommand("Select adult_fare from Trip where boarding_point = '" + Session["boarding_point"] + "' and arrival_point = '" + Session["arrival_point"] + "' and depart_date ='" + Session["depart_date"] + "' and depart_time = '" + Session["depart_time"] + "'", con);
con.Open();
DropDownList3.DataSource = cmd.ExecuteReader();
DropDownList3.DataTextField = "adult_fare";
DropDownList3.DataValueField = "adult_fare";
DropDownList3.DataBind();
con.Close();
int Dbadultfare = Convert.ToInt32(DropDownList3.SelectedValue);
}
if (!IsPostBack)
{
SqlCommand cmd = new SqlCommand("Select child_fare from Trip where boarding_point = '" + Session["boarding_point"] + "' and arrival_point = '" + Session["arrival_point"] + "' and depart_date ='" + Session["depart_date"] + "' and depart_time = '" + Session["depart_time"] + "'", con);
con.Open();
DropDownList4.DataSource = cmd.ExecuteReader();
DropDownList4.DataTextField = "child_fare";
DropDownList4.DataValueField = "child_fare";
DropDownList4.DataBind();
con.Close();
int Dbchildfare = Convert.ToInt32(DropDownList4.SelectedValue);
}
if (Session["userName"] != null)
{
Label8.Text = Session["userName"].ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
DropDownList1.ClearSelection();
DropDownList2.ClearSelection();
DropDownList3.ClearSelection();
DropDownList4.ClearSelection();
RadioButtonList1.ClearSelection();
RadioButtonList2.ClearSelection();
RadioButtonList3.ClearSelection();
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds2 = new DataSet();
DAL obj2 = new DAL();
string schoolid = Convert.ToString(Session["schoolid"]);
string strm = DropDownList3.SelectedValue;
ds2 = obj2.getCoursesByTerm(strm, schoolid);
DropDownList4.DataSource = ds2.Tables[0];
DropDownList4.DataTextField = "coursenameid";
DropDownList4.DataValueField = "courseid";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("--Select Course--", "0"));
}
private void filldrop()
{
DropDownList4.DataSource = getuserdata();
DropDownList4.DataTextField = "CourseId";
DropDownList4.DataBind();
DropDownList3.DataSource = getsectiondata();
DropDownList3.DataTextField = "Id";
DropDownList3.DataBind();
DropDownList2.DataSource = getTeacherdata();
DropDownList2.DataTextField = "TeacherId";
DropDownList2.DataBind();
}
public void selectCountry()
{
SqlCommand cmd = new SqlCommand("Select * from Country", con);
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = cmd;
DataSet ds = new DataSet();
adp.Fill(ds);
DropDownList4.DataSource = ds;
DropDownList4.DataValueField = "C_Id";
DropDownList4.DataTextField = "C_Name";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, " Select Country");
}
protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
{
int no = int.Parse(DropDownList4.SelectedValue);
DropDownList4.DataValueField = "Cmp_No";
DropDownList4.DataTextField = "Cmp_Nm";
DropDownList4.DataSource = db.MtsSuplir.Where(o => o.Cmp_No == no).ToList();
DropDownList4.DataBind();
load_tree();
//Session.Add("tree_node_path", " ");
TreeView1.CollapseAll();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList4.Items.Clear();
Code_Leitour.DataBind();
DropDownList4.Items.Add(new ListItem(" Επιλογή Kωδικού ...", "0"));
DropDownList4.DataBind();
Leitourgika_Search.DataBind();
GridView2.DataBind();
Check_Leit.DataBind();
Check_Leit_LC.DataBind();
GridView3.DataBind();
GridView4.DataBind();
Ypologos.DataBind();
GridView5.DataBind();
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList4.Enabled = true;
mysql = "SELECT distinct 市 FROM Area WHERE 省份 = '"
+ DropDownList3.SelectedValue.ToString().Trim() + "'";
myds = mydb.ExecuteQuery(mysql, "Area");
DataRow nrow = myds.Tables["Area"].NewRow(); //插入一个空行
nrow["市"] = "";
myds.Tables["Area"].Rows.InsertAt(nrow, 0);
DropDownList4.DataSource = myds.Tables["Area"];
DropDownList4.DataTextField = "市";
DropDownList4.DataBind();
DropDownList5.Items.Clear();
}
protected void DropDownList1_SelectedIndexChanged1(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("Select * from Mall_regi where M_Name='" + DropDownList1.SelectedItem.Value + "'", con);
SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = cmd;
DataSet ds = new DataSet();
adp.Fill(ds);
DropDownList4.DataSource = ds;
DropDownList4.DataValueField = "M_Area";
DropDownList4.DataTextField = "M_Area";
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, " Select Area");
}
protected void addnewfilluser()
{
string str = "";
str = "select User_master.UserID, Party_master.PartyID,Party_master.Compname +' : '+ Party_master.Contactperson as PartyName from Party_master inner join PartytTypeMaster on PartytTypeMaster.PartyTypeId=Party_master.PartyTypeId inner join User_master on User_master.PartyID=Party_master.PartyID where Party_master.Whid='" + DropDownList2.SelectedValue + "' and Party_master.PartyTypeId='" + DropDownList3.SelectedValue + "' order by PartyName ";
SqlDataAdapter da = new SqlDataAdapter(str, con);
DataTable dt = new DataTable();
da.Fill(dt);
DropDownList4.DataSource = dt;
DropDownList4.DataTextField = "PartyName";
DropDownList4.DataValueField = "UserID";
DropDownList4.DataBind();
}
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{
int ch = Convert.ToInt32(DropDownList3.SelectedValue);
var stateid = from Tbl_chapter in db.Tbl_chapter where Tbl_chapter.Subject_ID.Equals(ch) select new { Tbl_chapter.Name_Ar, Tbl_chapter.Chapter_ID };
var statename = stateid.ToList();
if (statename.Count > 0)
{
DropDownList4.DataValueField = "Chapter_ID";
DropDownList4.DataTextField = "Name_Ar";
DropDownList4.DataSource = statename;
DropDownList4.DataBind();
//DropDownList1.Items.Insert(0, "--- select chapter ----");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
if (FileUpload1.HasFile)
{
dp = FileUpload1.PostedFile.FileName;
dp = "~/Uploaded/dp/" + dp;
FileUpload1.PostedFile.SaveAs(Server.MapPath(dp));
}
if (FileUpload2.HasFile)
{
map = FileUpload2.PostedFile.FileName;
map = "~/Uploaded/map/" + map;
FileUpload2.PostedFile.SaveAs(Server.MapPath(map));
}
string sa = "insert into users(catid,spid,uname,uno,uemail,username,upass,sid,cid,address,udp,umap) values('" + DropDownList1.SelectedValue + "','" + DropDownList2.SelectedValue + "','" + TextBox1.Text
+ "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + DropDownList3.SelectedValue + "','" + DropDownList4.SelectedValue + "','" + TextBox7.Text + "','" + dp + "','" + map + "')";
cmd = new SqlCommand(sa, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>$(document).ready(function () { $('#signup').modal('show');});</script>");
Label14.Text = "You have successfully registered";
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
con.Close();
DropDownList1.ClearSelection();
DropDownList2.ClearSelection();
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
DropDownList3.ClearSelection();
DropDownList4.ClearSelection();
}
}
}
