protected void Button3_Click(object sender, EventArgs e) { DbLayer db = new DbLayer(); db.ExecuteNonQuery("Insert into Suggestion values('" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + DateTime.Now.ToString() + "','1')"); Label1.Text = "Thansks, for Suggestion !!!"; }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { Label1.Text = ""; DbLayer db = new DbLayer(); bool UserAvalable = db.ExecuteCheck("SELECT * FROM login where UserId='" + TextBox1.Text + "' and password='******'"); if (UserAvalable) { Label1.Text = "*User Id alreay avaliable plz user anoth Id."; } else { db.ExecuteNonQuery("Insert into Login (UserId,Password,UserType) values('" + TextBox1.Text + "','" + TextBox2.Text + "','Learner')"); db.ExecuteNonQuery("Insert into LearnerRegistration values('" + TextBox1.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + DropDownList1.SelectedValue + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','True')"); Label2.Text = "Registration Successfull !!! "; } }
public bool UpdateManPower(ManpowerUpdateDTO objManPower) { bool res = false; using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spUpdateManPower"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@Id", objManPower.ManPowerId); SqlCmd.Parameters.AddWithValue("@Name", objManPower.Name); SqlCmd.Parameters.AddWithValue("@Gender", objManPower.Gender); SqlCmd.Parameters.AddWithValue("@FatherName", objManPower.FatherName); SqlCmd.Parameters.AddWithValue("@MotherName", objManPower.MotherName); SqlCmd.Parameters.AddWithValue("@DateofBirth", objManPower.DateofBirth); SqlCmd.Parameters.AddWithValue("@Age", objManPower.Age); SqlCmd.Parameters.AddWithValue("@Mobile", ((objManPower.Mobile == null) ? "" : objManPower.Mobile)); SqlCmd.Parameters.AddWithValue("@AlternateNumber", ((objManPower.AlternateNumber == null) ? "" : objManPower.AlternateNumber)); SqlCmd.Parameters.AddWithValue("@MaritalStatus", objManPower.MaritalStatus); SqlCmd.Parameters.AddWithValue("@CurrentAddress", ((objManPower.CurrentAddress == null) ? "" : objManPower.CurrentAddress)); SqlCmd.Parameters.AddWithValue("@PermanentAddress", ((objManPower.PermanentAddress == null) ? "" : objManPower.PermanentAddress)); SqlCmd.Parameters.AddWithValue("@Photo", ((objManPower.Photo == null) ? "" : objManPower.Photo)); SqlCmd.Parameters.AddWithValue("@State", objManPower.State); SqlCmd.Parameters.AddWithValue("@City", objManPower.City); SqlCmd.Parameters.AddWithValue("@JobType", ((objManPower.JobType == null) ? "" : objManPower.JobType)); SqlCmd.Parameters.AddWithValue("@BloodGroup", ((objManPower.BloodGroup == null) ? "" : objManPower.BloodGroup)); SqlCmd.Parameters.AddWithValue("@Company", objManPower.Company); SqlCmd.Parameters.AddWithValue("@DateofJoin", objManPower.DateofJoin); SqlCmd.Parameters.AddWithValue("@Designation", objManPower.Designation); SqlCmd.Parameters.AddWithValue("@PreviousCompany", ((objManPower.PreviousCompany == null) ? "" : objManPower.PreviousCompany)); SqlCmd.Parameters.AddWithValue("@ReferenceBy", ((objManPower.ReferenceBy == null) ? "" : objManPower.ReferenceBy)); SqlCmd.Parameters.AddWithValue("@ReferenceContact1", ((objManPower.ReferenceContact1 == null) ? "" : objManPower.ReferenceContact1)); SqlCmd.Parameters.AddWithValue("@ReferenceContact2", ((objManPower.ReferenceContact2 == null) ? "" : objManPower.ReferenceContact2)); SqlCmd.Parameters.AddWithValue("@TotalExperience", ((objManPower.TotalExperience == null) ? "" : objManPower.TotalExperience)); SqlCmd.Parameters.AddWithValue("@VerificationStatus", objManPower.VerificationStatus); SqlCmd.Parameters.AddWithValue("@Payment", objManPower.Payment); SqlCmd.Parameters.AddWithValue("@Active", objManPower.Active); SqlCmd.Parameters.AddWithValue("@ModifiedBy", objManPower.ModifiedBy); int result = dbLayer.ExecuteNonQuery(SqlCmd); if (result != Int32.MaxValue) { res = true; } } return(res); }
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e) { lblError.ForeColor = Color.Red; if (Session["userId"] != null) { if (e.CommandName == "request") { ImageButton imgbut = (ImageButton)e.Item.FindControl("ImageButton2"); string trainerId = imgbut.AlternateText; DbLayer db = new DbLayer(); db.ExecuteNonQuery("Insert into TrainerRequest values ('" + trainerId + "','" + Session["userId"].ToString() + "',getdate(),'0')"); lblError.ForeColor = Color.Green; lblError.Text = "Your Query has been successfully Submited."; } } else { lblError.Text = "Please Login First !!!!"; } }
protected void Button1_Click(object sender, EventArgs e) { DbLayer db = new DbLayer(); DataSet ds = db.GetDataSet("select * from Login where UserId='" + Session["userId"].ToString() + "' and Password='******' "); if (ds.Tables[0].Rows.Count > 0) { int i = db.ExecuteNonQuery("Update Login set Password='******'where UserId='" + Session["userId"].ToString() + "' "); if (i > 0) { Label1.ForeColor = Color.Green; Label1.Text = "Your Password is Successfully Updated .."; } } else { Label1.ForeColor = Color.Red; Label1.Text = "Invalid Old Password plz Try again !!!"; } }
protected void Button1_Click(object sender, EventArgs e) { DbLayer db = new DbLayer(); db.ExecuteNonQuery("Insert into LearnerAdvancePro values('" + Session["userId"].ToString() + "','" + drpArea.SelectedValue + "','" + drpLevel.SelectedValue + "','" + drpExp.SelectedValue + "','" + txtTech.Text + "','" + txtrem.Text + "')"); }