public void GetEnginerrDetails()
{
String strConnString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(strConnString);
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = " select [eng_id],[Name] ,[mobile_no] from [dbo].[Engineer-Details];";
cmd.Connection = con;
con.Open();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dtEng = new DataTable();
adp.Fill(dtEng);
if (dtEng != null && dtEng.Rows.Count > 0)
{
GrdEmpList.DataSource = dtEng;
GrdEmpList.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
con.Dispose();
}
}
public void BindData(string emp_id)
{
objmysqldb.ConnectToDatabase();
try
{
DataTable EmpDetail = objmysqldb.GetData("select empid as emp_id,Concat(if(Employee_master.EmpFirstName is null,'',Employee_master.EmpFirstName) , ' ' , if(Employee_master.EmpMiddleName is null,'',Employee_master.EmpMiddleName) , ' ' , if(Employee_master.EmpLastName is null,'',Employee_master.EmpLastName)) AS FullName from employee_master where employee_master.IsDelete=0 and EmpStatusFlag=0 and employee_master.FP_Id>0 order by empid");
string dt = lblDate1.Text.ToString();
DateTime oDate = Convert.ToDateTime(dt.ToString());
long Tikcs = oDate.Ticks;
DataTable dtEmpAttendance = objmysqldb.GetData("SELECT distinct Dateticks,emp_id,Day_id,concat(In_hour,':',In_min)as InMin,concat(out_hour,':',out_min)As outHour,concat(Ext_Early_hour,':',Ext_Early_min)as ExtEarlyHour,concat(Ext_Late_hour,':',Ext_Late_min)as ExtLateHour FROM employee_management.employeewise_punchtime_details_datewise where Dateticks <" + Tikcs + " and emp_id=" + emp_id + "");
if (dtEmpAttendance != null && dtEmpAttendance.Rows.Count > 0)
{
string InTime = "";
string outTime = "";
string ExtEarly = "";
string ExtLate = "";
foreach (DataRow drEmp in dtEmpAttendance.Rows)
{
InTime = drEmp["InMin"].ToString();
outTime = drEmp["outHour"].ToString();
ExtEarly = drEmp["ExtEarlyHour"].ToString();
ExtLate = drEmp["ExtLateHour"].ToString();
}
txtinTime.Text = InTime;
txtoutTime.Text = outTime;
txtExtremeEarly.Text = ExtEarly;
txtExtremeLate.Text = ExtLate;
}
if (EmpDetail != null && EmpDetail.Rows.Count > 0)
{
GrdEmpList.DataSource = EmpDetail;
GrdEmpList.DataBind();
}
}
catch (Exception ex)
{
}
finally
{
//objmysqldb.CloseSQlConnection();
objmysqldb.disposeConnectionObj();
}
}
