protected void btnDownload_Click(object sender, EventArgs e)
{
bool bIs = false;
bool IsDeviceSelected = false;
DataTable dtEmp = objEmp.GetEmployeeMaster(Session["CompId"].ToString());
dtEmp = new DataView(dtEmp, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "'", "", DataViewRowState.CurrentRows).ToTable();
DataTable dtUser = new DataTable();
foreach (GridViewRow gvdevicerow in gvDevice.Rows)
{
if (((CheckBox)gvdevicerow.FindControl("chkSelectDevice")).Checked)
{
IsDeviceSelected = true;
IsDeviceSelected = true;
int index = gvdevicerow.RowIndex;
string port = gvDevice.DataKeys[index]["Port"].ToString();
string IP = gvDevice.DataKeys[index]["IP_Address"].ToString();
string DeviceId = gvDevice.DataKeys[index]["Device_Id"].ToString();
bIs = objDeviceOp.Device_Connection(IP, Convert.ToInt32(port), 0);
if (bIs)
{
DataTable dtUserTemp = new DataTable();
dtUserTemp = objDeviceOp.GetUser(IP, Convert.ToInt32(port));
if (dtUserTemp.Rows.Count > 0)
{
dtUserTemp.Columns.Add("Device_Id");
dtUserTemp.Columns.Add("IP");
dtUserTemp.Columns.Add("Port");
dtUserTemp.Columns.Add("Emp_Id");
for (int userrowid = 0; userrowid < dtUserTemp.Rows.Count; userrowid++)
{
DataTable dtEmpTemp = new DataTable();
dtUserTemp.Rows[userrowid]["Device_Id"] = DeviceId;
dtUserTemp.Rows[userrowid]["IP"] = IP;
dtUserTemp.Rows[userrowid]["Port"] = port;
if ((!Convert.IsDBNull(dtUserTemp.Rows[userrowid]["sdwEnrollNumber"])) && dtUserTemp.Rows[userrowid]["sdwEnrollNumber"].ToString() != "")
{
dtEmpTemp = new DataView(dtEmp, "Emp_Code='" + dtUserTemp.Rows[userrowid]["sdwEnrollNumber"] + "'", "", DataViewRowState.CurrentRows).ToTable();
}
if (dtEmpTemp.Rows.Count > 0)
{
dtUserTemp.Rows[userrowid]["sdwEnrollNumber"] = dtUserTemp.Rows[userrowid]["sdwEnrollNumber"].ToString();
dtUserTemp.Rows[userrowid]["Emp_Id"] = dtUserTemp.Rows[userrowid]["sdwEnrollNumber"];
}
else
{
dtUserTemp.Rows[userrowid]["Emp_Id"] = dtUserTemp.Rows[userrowid]["sdwEnrollNumber"];
dtUserTemp.Rows[userrowid]["sdwEnrollNumber"] = "";
}
}
//now merge it to User table
if (dtUser.Rows.Count == 0)
{
dtUser = dtUserTemp;
}
else
{
dtUser.Merge(dtUserTemp);
}
}
}
}
}
if (rbtnNew.Checked)
{
try
{
dtUser = new DataView(dtUser, "sdwEnrollNumber=''", "", DataViewRowState.CurrentRows).ToTable();
}
catch
{
dtUser = null;
}
}
if (dtUser != null && dtUser.Rows.Count > 0)
{
Session["DtDeviceUser"] = dtUser;
gvUser.DataSource = dtUser;
gvUser.DataBind();
lblUserCount.Text = dtUser.Rows.Count.ToString();
DisplayMessage(dtUser.Rows.Count.ToString() + " " + "Users Downloaded");
pnlDeviceOp.Visible = true;
pnlList.Visible = false;
}
else
{
if (!IsDeviceSelected)
{
DisplayMessage("Please Select Device");
}
else
{
DisplayMessage("User does not exists");
}
}
}
