protected void LinkButton1_Click(object sender, EventArgs e)
{
int id = Int32.Parse((sender as LinkButton).CommandArgument);
Promotions lst = new PromotionAccess().Getpro(id);
con = new SqlConnection(constr);
SqlDataAdapter da = new SqlDataAdapter("select s.Basics,s.EmpID, s.HouseRent,s.Medical,s.Convences,s.Taxes,s.Gross_Salary from SalaryHistory s where EmpID=" + id + ";", con);
DataTable dt = new DataTable();
da.Fill(dt);
Label1.Text = dt.Rows[0]["Basics"].ToString();
Label2.Text = dt.Rows[0]["HouseRent"].ToString();
Label3.Text = dt.Rows[0]["Medical"].ToString();
Label4.Text = dt.Rows[0]["Convences"].ToString();
Label5.Text = dt.Rows[0]["Taxes"].ToString();
Label6.Text = dt.Rows[0]["Gross_Salary"].ToString();
TextBox1.Text = dt.Rows[0]["EmpID"].ToString();
double previous = double.Parse(dt.Rows[0]["Gross_Salary"].ToString());
HiddenField2.Value = previous.ToString();
TextBox1.Text = lst.empid.ToString();
TextBox2.Text = lst.amount.ToString();
TextBox3.Text = lst.Basic.ToString();
TextBox4.Text = lst.HouseRent.ToString();
TextBox5.Text = lst.Medicalmoney.ToString();
TextBox6.Text = lst.Convences.ToString();
TextBox7.Text = lst.taxes.ToString();
TextBox8.Text = lst.Gross_Salary.ToString();
TextBox9.Text = lst.activedate.ToString();
TextBox10.Text = lst.pro_active.ToString();
DropDownList1.SelectedValue = lst.pro_type.ToString();
HiddenField1.Value = id.ToString();
}
protected void Button4_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(HiddenField1.Value);
Promotions dpt = new Promotions();
dpt.empid = Int32.Parse(TextBox1.Text);
dpt.pro_type = DropDownList1.SelectedValue;
dpt.amount = double.Parse(TextBox2.Text);
dpt.activedate = DateTime.Parse(TextBox9.Text);
dpt.pro_active = DateTime.Parse(TextBox10.Text);
dpt.id = id;
dpt.Basic = double.Parse(TextBox3.Text);
dpt.HouseRent = double.Parse(TextBox4.Text);
dpt.Medicalmoney = double.Parse(TextBox5.Text);
dpt.Convences = double.Parse(TextBox6.Text);
dpt.taxes = double.Parse(TextBox7.Text);
dpt.Gross_Salary = double.Parse(TextBox8.Text);
PromotionAccess manager = new PromotionAccess();
if (manager.Update(dpt) > 0)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ClientScript", "alert('Successfully Updated')", true);
GridView1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "ClientScript", "alert('Update Fail')", true);
}
//int id = Int32.Parse(TextBox1.Text.ToString());
//Promotions lst = new PromotionAccess().Getpro(id);
//TextBox2.Text=lst.amount.ToString();
//TextBox3.Text=lst.Basic.ToString();
//TextBox4.Text=lst.HouseRent.ToString();
//TextBox5.Text=lst.Medicalmoney.ToString();
//TextBox6.Text=lst.Convences.ToString();
//TextBox7.Text=lst.taxes.ToString();
//TextBox8.Text=lst.Gross_Salary.ToString();
//TextBox9.Text=lst.activedate.ToString();
//TextBox10.Text = lst.pro_active.ToString();
//DropDownList1.SelectedValue = lst.pro_type.ToString();
}
