protected void upd_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("quizsection", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "update");
//cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
//cmd.Parameters.AddWithValue("@section", sname_txt.Text);
//cmd.ExecuteNonQuery();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.addsectionupdate(Convert.ToInt32(Label_id.Text), sname_txt.Text);
if (a > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!');", true);
gridshow();
}
blank();
upd_btn.Visible = false;
submit_btn.Visible = true;
con.Close();
}
public void gridshow()
{
//SqlDataAdapter da = new SqlDataAdapter("allempdetail_dlt_proc", con);
//da.SelectCommand.CommandType = CommandType.StoredProcedure;
//da.SelectCommand.Parameters.AddWithValue("@action", "show");
//da.SelectCommand.Parameters.AddWithValue("@pk_id", "");
//DataTable dt = new DataTable();
//da.Fill(dt);
employee.employeeservice obj = new employee.employeeservice();
GridView1.DataSource = obj.allempshow();
GridView1.DataBind();
}
protected void btn_delete_Click(object sender, EventArgs e)
{
con.Open();
LinkButton lnk = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnk.NamingContainer;
Label l1 = (Label)row.FindControl("Lbl_id");
employee.employeeservice obj = new employee.employeeservice();
int a = obj.addsectiondelete(Convert.ToInt32(l1.Text));
if (a > 0)
{
gridshow();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Deleted!!');", true);
}
con.Close();
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand com = new SqlCommand("employeetype_proc", con);
//com.CommandType = CommandType.StoredProcedure;
//com.Parameters.AddWithValue("@action", "insert");
//com.Parameters.AddWithValue("@pk_id", "");
//com.Parameters.AddWithValue("@name", Tb_rname.Text);
//com.ExecuteNonQuery();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.insert(Tb_rname.Text);
if (a > 0)
{
show();
blank();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Type are Submitted Sucessfully !!!!');", true);
}
}
protected void btn_delete_Click(object sender, EventArgs e)
{
con.Open();
LinkButton lnk = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnk.NamingContainer;
Label l1 = (Label)row.FindControl("Lbl_id");
//SqlCommand cmd = new SqlCommand("allempdetail_dlt_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "delete");
//cmd.Parameters.AddWithValue("@pk_id", l1.Text);
//cmd.ExecuteNonQuery();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.allempdelete(Convert.ToInt32(l1.Text));
if (a > 0)
{
gridshow();
Response.Write("<script>alert('Data Deleted')</script>");
}
con.Close();
}
protected void upd_btn_Click(object sender, EventArgs e)
{
//con.Open();
//SqlCommand com = new SqlCommand("employeetype_proc", con);
//com.CommandType = CommandType.StoredProcedure;
//com.Parameters.AddWithValue("@action", "update");
//com.Parameters.AddWithValue("@pk_id", Label_id.Text);
//com.Parameters.AddWithValue("@name", Tb_rname.Text);
//com.ExecuteNonQuery();
//con.Close();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.update(Convert.ToInt32(Label_id.Text), Tb_rname.Text);
if (a > 0)
{
blank();
show();
submit_btn.Visible = true;
upd_btn.Visible = false;
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Type name Updated Sucessfully !!!!');", true);
}
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("quizsection", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "insert");
//cmd.Parameters.AddWithValue("@pk_id", "");
//cmd.Parameters.AddWithValue("@section", sname_txt.Text);
//cmd.ExecuteNonQuery();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.addsectioninsert(sname_txt.Text);
if (a > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!');", true);
gridshow();
blank();
}
con.Close();
}
protected void submit_btn_Click(object sender, EventArgs e)
{
string senderusername;
senderusername = Label9.Text;
string senderpassword;
senderpassword = Label10.Text;
string senderid;
senderid = Label11.Text;
con.Open();
//SqlCommand com = new SqlCommand("select * from allempdetail where emp_name='" + name_txt.Text + "' and father_name='" + father_txt.Text + "' and email='" + email_txt.Text + "'", con);
SqlCommand com = new SqlCommand("allempdetail_proc", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@action", "exist");
com.Parameters.AddWithValue("@pk_id", "");
com.Parameters.AddWithValue("@type", "");
com.Parameters.AddWithValue("@emp_no", "");
com.Parameters.AddWithValue("@designation", "");
com.Parameters.AddWithValue("@doj", "");
com.Parameters.AddWithValue("@emp_name", name_txt.Text);
com.Parameters.AddWithValue("@father_name", father_txt.Text);
com.Parameters.AddWithValue("@gender", "");
com.Parameters.AddWithValue("@dob", "");
com.Parameters.AddWithValue("@country", "");
com.Parameters.AddWithValue("@state", "");
com.Parameters.AddWithValue("@city", "");
com.Parameters.AddWithValue("@address", "");
com.Parameters.AddWithValue("@mobile", "");
com.Parameters.AddWithValue("@email", email_txt.Text);
com.Parameters.AddWithValue("@maritial_status", "");
com.Parameters.AddWithValue("@blood_group", "");
com.Parameters.AddWithValue("@total_experience_year", "");
com.Parameters.AddWithValue("@total_exp_month", "");
com.Parameters.AddWithValue("@experiencedetail", "");
com.Parameters.AddWithValue("@salary", "");
com.Parameters.AddWithValue("@password", "");
com.Parameters.AddWithValue("@emp_id", "");
com.Parameters.AddWithValue("@image", "");
com.ExecuteNonQuery();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
Response.Write("<script>alert('Record Exist Already')</script>");
dr.Close();
}
else
{
dr.Close();
string imgg = "";
if (emp_img.HasFile)
{
imgg = ("~/img/" + emp_img.FileName);
emp_img.SaveAs(Server.MapPath("~/img/") + emp_img.FileName);
}
//SqlCommand cmd = new SqlCommand("allempdetail_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "insert");
//cmd.Parameters.AddWithValue("@pk_id", "");
//cmd.Parameters.AddWithValue("@type",DropDownList1.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@emp_no", emp_no.Text);
//cmd.Parameters.AddWithValue("@designation", designation.Text);
//cmd.Parameters.AddWithValue("@doj", joindate_txt.Text);
//cmd.Parameters.AddWithValue("@emp_name", name_txt.Text);
//cmd.Parameters.AddWithValue("@father_name", father_txt.Text);
//cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
//cmd.Parameters.AddWithValue("@country", ddl_country.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@state", ddl_state.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@city", ddl_city.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@address", addres1_txt.Text);
//cmd.Parameters.AddWithValue("@mobile", mob_txt.Text);
//cmd.Parameters.AddWithValue("@email", email_txt.Text);
//cmd.Parameters.AddWithValue("@maritial_status", martial_ddl.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@blood_group", blood_txt.Text);
//cmd.Parameters.AddWithValue("@total_experience_year", exyear_txt.Text);
//cmd.Parameters.AddWithValue("@total_exp_month", exmonth_txt.Text);
//cmd.Parameters.AddWithValue("@experiencedetail", exdetail_txt.Text);
//cmd.Parameters.AddWithValue("@salary", salary_txt.Text);
//Random ran = new Random();
//int i = ran.Next(1, 9);
//int j = i * 289;
//pass = "******" + j + "ER";
//cmd.Parameters.AddWithValue("@password", pass);
//Random ran1 = new Random();
//int k = ran1.Next(1, 5);
//int l = k * 256;
//pass1 = "Emp" + l + "LE";
//cmd.Parameters.AddWithValue("@emp_id", pass1);
//cmd.Parameters.AddWithValue("@image", imgg);
employee.employeeservice obj = new employee.employeeservice();
int a = obj.allempinsert(DropDownList1.SelectedItem.ToString(), emp_no.Text, designation.Text, joindate_txt.Text, name_txt.Text, father_txt.Text, gender_ddl.SelectedItem.ToString(), dob_txt.Text, ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, martial_ddl.SelectedItem.ToString(), blood_txt.Text, exyear_txt.Text, exmonth_txt.Text, exdetail_txt.Text, salary_txt.Text, pass, pass1, imgg);
if (a > 0)
{
var smtp = new System.Net.Mail.SmtpClient();
{
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.Credentials = new NetworkCredential("*****@*****.**".ToString(), "my1234567".ToString());
}
smtp.Send("*****@*****.**".ToString(), email_txt.Text, "Message".ToString(), "Your Loginid:- " + email_txt.Text + "\r\n" + "Your Password:- " + pass + "\r\n" + "Teacher id:- " + pass1);
//System.Net.Mail.MailMessage mail = new MailMessage();
//mail.From = new MailAddress("*****@*****.**");
//mail.To.Add(email_txt.Text);
//mail.Subject = "Login Id Details";
//mail.Body = "<html><head><title>Login Id Details:</title></head><body><div><br/><br/><p>Your Loginid:" + email_txt.Text + "<br/>Your Password:-" + pass + "<br/>" + "Teacher id:-" + pass1 + "<br/> </div></body></Html>";
//mail.IsBodyHtml = true;
//SmtpClient smtp = new SmtpClient();
//smtp.Host = "relay-hosting.secureserver.net";
//smtp.Port = 25;
//smtp.EnableSsl = false;
//smtp.Send(mail);
//cmd.ExecuteNonQuery();
}
string sURL;
string message1 = "Thanks For Registration" + "\n\n" + "Email:" + email_txt.Text + "\n\n" + "Password:"******"\n" + "Teacher_ID:" + pass1 + "\n";
StreamReader objReader;
sURL = "http://pointsms.in/API/sms.php?username="******"&password="******"&from=" + senderid + "&to=" + mob_txt.Text + "&msg=" + message1;
WebRequest wrGETURL;
wrGETURL = WebRequest.Create(sURL);
try
{
Stream objStream;
objStream = wrGETURL.GetResponse().GetResponseStream();
objReader = new StreamReader(objStream);
objReader.Close();
}
catch (Exception ex)
{
ex.ToString();
}
Response.Write("<script>alert('Thanks For Registartion')</script>");
gridshow();
blank();
}
con.Close();
}
protected void upd_btn_Click(object sender, EventArgs e)
{
con.Open();
string imgg = "";
if (emp_img.HasFile)
{
imgg = ("~/img/" + emp_img.FileName);
emp_img.SaveAs(Server.MapPath("~/img/") + emp_img.FileName);
}
else
{
imgg = Image2.ImageUrl;
}
//SqlCommand cmd = new SqlCommand("allempdetail_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "update");
//cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
//cmd.Parameters.AddWithValue("@type", DropDownList1.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@emp_no", emp_no.Text);
//cmd.Parameters.AddWithValue("@designation",designation.Text);
//cmd.Parameters.AddWithValue("@doj", joindate_txt.Text);
//cmd.Parameters.AddWithValue("@emp_name", name_txt.Text);
//cmd.Parameters.AddWithValue("@father_name", father_txt.Text);
//cmd.Parameters.AddWithValue("@gender", gender_ddl.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@dob", dob_txt.Text);
//cmd.Parameters.AddWithValue("@country", ddl_country.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@state", ddl_state.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@city", ddl_city.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@address", addres1_txt.Text);
//cmd.Parameters.AddWithValue("@mobile", mob_txt.Text);
//cmd.Parameters.AddWithValue("@email", email_txt.Text);
//cmd.Parameters.AddWithValue("@maritial_status", martial_ddl.SelectedItem.ToString());
//cmd.Parameters.AddWithValue("@blood_group", blood_txt.Text);
//cmd.Parameters.AddWithValue("@total_experience_year", exyear_txt.Text);
//cmd.Parameters.AddWithValue("@total_exp_month", exmonth_txt.Text);
//cmd.Parameters.AddWithValue("@experiencedetail", exdetail_txt.Text);
//cmd.Parameters.AddWithValue("@salary", salary_txt.Text);
//cmd.Parameters.AddWithValue("@password", lbl_pass.Text);
//cmd.Parameters.AddWithValue("@emp_id", lbl_tid.Text);
//cmd.Parameters.AddWithValue("@image", imgg);
//cmd.ExecuteNonQuery();
employee.employeeservice obj = new employee.employeeservice();
int a = obj.allempupdate(Convert.ToInt32(Label_id.Text), DropDownList1.SelectedItem.ToString(), emp_no.Text, designation.Text, joindate_txt.Text, name_txt.Text, father_txt.Text, gender_ddl.SelectedItem.ToString(), dob_txt.Text, ddl_country.SelectedItem.ToString(), ddl_state.SelectedItem.ToString(), ddl_city.SelectedItem.ToString(), addres1_txt.Text, mob_txt.Text, email_txt.Text, martial_ddl.SelectedItem.ToString(), blood_txt.Text, exyear_txt.Text, exmonth_txt.Text, exdetail_txt.Text, salary_txt.Text, lbl_pass.Text, lbl_tid.Text, imgg);
if (a > 0)
{
Response.Write("<script>alert('Data Updated')</script>");
gridshow();
blank();
}
clr_btn.Visible = true;
upd_btn.Visible = false;
submit_btn.Visible = true;
Image2.Visible = false;
con.Close();
}
public void show()
{
employee.employeeservice obj = new employee.employeeservice();
GridView1.DataSource = obj.show();
GridView1.DataBind();
}
