public void INSERT_EmpInfoChangeLog(GridView grEmpDesig, string strChangeType, string strInsBy, string strInsDate, string strLastUpFrom)
{
int i = 0;
SqlCommand[] command = new SqlCommand[grEmpDesig.Rows.Count * 2];
string sSeqId = Common.getMaxId("EmpInfoChangeLog", "SeqId");
if (grEmpDesig.Rows.Count > 0)
{
foreach (GridViewRow gRow in grEmpDesig.Rows)
{
command[i] = InsertEmpInfoChangeLog(sSeqId, gRow.Cells[0].Text.Trim(), gRow.Cells[1].Text.Trim(), gRow.Cells[2].Text.Trim(),
strChangeType, strInsBy, strInsDate, strLastUpFrom);
sSeqId = Convert.ToString(Convert.ToInt32(sSeqId) + 1);
i++;
command[i] = objEmpMgr.InsertEmpInfoLog(gRow.Cells[0].Text.Trim());
i++;
}
}
try
{
objDC.MakeTransaction(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}