protected void btnAdd_Click(object sender, EventArgs e) { JobPositionEN pos = ClassJopPosition.SearchByPosid(Convert.ToInt16(ddlPosition.SelectedValue)); JobPosition_EmpEN en = new JobPosition_EmpEN(); en.empid = this.empid; en.posid = Convert.ToInt16(ddlPosition.SelectedValue); en.cost = pos.cost; ClassJopPosition.InsertPosition_Emp(en); BindPosition_Emp(); }
public static JobPositionEN SearchByPosid(int id) { string sql = "Select * from " + tb_name + " Where id = " + id.ToString(); DataTable dt = ClassMain.ExecuteComandTable(sql); JobPositionEN en = new JobPositionEN(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; en.id = Convert.ToInt32(dr["ID"]); en.position = Convert.ToString(dr["position"]); en.cost = Convert.ToDecimal(dr["cost"]); } return(en); }