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 + "')");
}
