//insert data gridview data to database table and insentive display insentive name but store database to insentive id //
private void btnsave_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//cmd.CommandText = "select EmployeeID from TK_Employee where EmployeeID='" + txtemployeeid.Text + "'";
//SqlDataReader dr1 = cmd.ExecuteReader();
//if (dr1.HasRows)
//{
// int a = 0;
// while (dr1.Read() == true)
// {
// a = Convert.ToInt32(dr1[0].ToString());
// }
// dr1.Close();
cmd.CommandText = "select DesignationID from TK_Designation where DesignationName='" + cmbdesignationname.Text + "'";
SqlDataReader dr2 = cmd.ExecuteReader();
if (dr2.HasRows)
{
int b = 0;
while (dr2.Read() == true)
{
b = Convert.ToInt32(dr2[0].ToString());
}
dr2.Close();
cmd.CommandText = "select SNO from TK_MasterIncentives where IncentiveName='" + cmbincentives.Text + "'";
SqlDataReader dr3 = cmd.ExecuteReader();
if (dr3.HasRows)
{
int c = 0;
while (dr3.Read() == true)
{
c = Convert.ToInt32(dr3[0].ToString());
}
dr3.Close();
cmd.CommandText = "select CompanyID from TK_Company ";
SqlDataReader dr4 = cmd.ExecuteReader();
if (dr4.HasRows)
{
int d = 0;
while (dr4.Read() == true)
{
d = Convert.ToInt32(dr4[0].ToString());
}
dr4.Close();
int DesignationID = b;
int IncentivesID = c;
int CompanyID = d;
SqlDataAdapter da = new SqlDataAdapter();
for (int i = 0; i < dgvincentives.Rows.Count; i++)
{
// cmd.CommandText = "insert into TK_EmployeeGroupEarnings(DesignationID,IncentivesID,Percentage,CompanyID) values("+DesignationID+","+IncentivesID+","+Convert.ToDecimal(txtpercentage.Text)+","+CompanyID+")";
//// SqlCommand cmd = new SqlCommand(insertData, con);
// cmd.Parameters.AddWithValue("@IncentivesID", dgvincentives.Rows[i].Cells[0].Value);
// cmd.Parameters.AddWithValue("@Percentage", dgvincentives.Rows[i].Cells[1].Value);
// //cmd.Parameters.AddWithValue("@PartsID", textBox1.Text);
// da.InsertCommand = cmd;
// cmd.ExecuteNonQuery();
cmd.CommandText = "insert into TK_EmployeeGroupIncentives(DesignationID,IncentivesID,Percentage,CompanyID) values(" + DesignationID + ",'" + dgvincentives.Rows[i].Cells["Incentives Name "].Value + "','" + dgvincentives.Rows[i].Cells["Percentage"].Value + "'," + CompanyID + ")";
int n = cmd.ExecuteNonQuery();
if (n > 0)
{
MessageBox.Show("Successfully Inserted");
}
else
{
MessageBox.Show("Not Inserted");
}
}
}
}
}
}