public static List <All_Employees> GetEditData(string eid)
{
List <All_Employees> list_det = new List <All_Employees>();
DataTable dt = get_all_products(Convert.ToInt32(eid));
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
All_Employees p = new All_Employees();
p.emp_name = Convert.ToString(dt.Rows[i]["emp_name"]);
p.mobile = Convert.ToString(dt.Rows[i]["mobile"]);
p.Designation = Convert.ToString(dt.Rows[i]["Designation"]);
p.Img = Convert.ToString(dt.Rows[i]["Img"]);
p.father = Convert.ToString(dt.Rows[i]["f_name"]);
p.cnic = Convert.ToString(dt.Rows[i]["cnic"]);
p.license = Convert.ToString(dt.Rows[i]["license"]);
p.curadd = Convert.ToString(dt.Rows[i]["currant_address"]);
p.per_add = Convert.ToString(dt.Rows[i]["permenant_address"]);
p.emer_num = Convert.ToString(dt.Rows[i]["emer_number"]);
p.exp = Convert.ToString(dt.Rows[i]["experience"]);
p.bankAccount = Convert.ToString(dt.Rows[i]["bankAccount"]);
list_det.Add(p);
}
return(list_det);
}
public static List <All_Employees> GetPrint_Data(string eid)
{
List <All_Employees> list_det = new List <All_Employees>();
DataTable dt = getprint(Convert.ToInt32(eid));
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
All_Employees p = new All_Employees();
p.emp_name = Convert.ToString(dt.Rows[i]["emp_name"]);
p.father = Convert.ToString(dt.Rows[i]["f_name"]);
p.curadd = Convert.ToString(dt.Rows[i]["currant_address"]);
p.per_add = Convert.ToString(dt.Rows[i]["permenant_address"]);
p.cnic = Convert.ToString(dt.Rows[i]["cnic"]);
p.mobile = Convert.ToString(dt.Rows[i]["mobile"]);
p.gender = Convert.ToString(dt.Rows[i]["gender"]);
p.dep_name = Convert.ToString(dt.Rows[i]["dep_name"]);
p.exp = Convert.ToString(dt.Rows[i]["experience"]);
p.emp_id = Convert.ToInt32(dt.Rows[i]["total"]);
p.Designation = Convert.ToString(dt.Rows[i]["Designation"]);
p.DOB = Convert.ToString(dt.Rows[i]["dob"]);
p.license = Convert.ToString(dt.Rows[i]["license"]);
p.degree = Convert.ToString(dt.Rows[i]["degree"]);
p.emp_type = Convert.ToString(dt.Rows[i]["type_name"]);
p.bankAccount = Convert.ToString(dt.Rows[i]["bankAccount"]);
p.Img = Convert.ToString(dt.Rows[i]["Img"]);
p.emer_num = Convert.ToString(dt.Rows[i]["emer_number"]);
p.job_type = Convert.ToString(dt.Rows[i]["contract"]);
list_det.Add(p);
}
return(list_det);
}
public static List <All_Employees> GetUserDetail(string date)
{
string con1 = System.Configuration.ConfigurationManager.ConnectionStrings["DBMS"].ConnectionString;
SqlConnection conn = new SqlConnection(con1);
SqlCommand cmd = new SqlCommand(@"select Count(*) from Attendence where date=@date and time_in=null", conn);
cmd.Parameters.AddWithValue("@date", SqlDbType.Date).Value = date;
conn.Open();
int count = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
if (count == 0)
{
List <All_Employees> list_det = new List <All_Employees>();
DataTable dt = getprint();
for (Int32 i = 0; i < dt.Rows.Count; i++)
{
All_Employees p = new All_Employees();
p.emp_name = Convert.ToString(dt.Rows[i]["emp_name"]);
p.emp_id = Convert.ToInt32(dt.Rows[i]["emp_id"]);
list_det.Add(p);
}
return(list_det);
}
All_Employees obj = new All_Employees();
List <All_Employees> list = new List <All_Employees>();
list.Add(obj);
return(list);
}
public void GetAll_Employees(int iDisplayLength, int iDisplayStart, int iSortCol_0, string sSortDir_0, string sSearch)
{
int displayLength = iDisplayLength;
int displayStart = iDisplayStart;
int sortCol = iSortCol_0;
string sortDir = sSortDir_0;
string search = sSearch;
string cs = ConfigurationManager.ConnectionStrings["DBMS"].ConnectionString;
List <All_Employees> listEmployees = new List <All_Employees>();
int filteredCount = 0;
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spGetEmployees", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter paramDisplayLength = new SqlParameter()
{
ParameterName = "@DisplayLength",
Value = displayLength
};
cmd.Parameters.Add(paramDisplayLength);
SqlParameter paramDisplayStart = new SqlParameter()
{
ParameterName = "@DisplayStart",
Value = displayStart
};
cmd.Parameters.Add(paramDisplayStart);
SqlParameter paramSortCol = new SqlParameter()
{
ParameterName = "@SortCol",
Value = sortCol
};
cmd.Parameters.Add(paramSortCol);
SqlParameter paramSortDir = new SqlParameter()
{
ParameterName = "@SortDir",
Value = sortDir
};
cmd.Parameters.Add(paramSortDir);
SqlParameter paramSearchString = new SqlParameter()
{
ParameterName = "@Search",
Value = string.IsNullOrEmpty(search) ? null : search
};
cmd.Parameters.Add(paramSearchString);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
All_Employees emp = new All_Employees();
emp.emp_id = Convert.ToInt32(rdr["ID"]);
filteredCount = Convert.ToInt32(rdr["TotalCount"]);
emp.emp_name = rdr["Name"].ToString();
emp.Designation = Convert.ToString(rdr["Designation"]);
emp.mobile = rdr["mobile"].ToString();
emp.Img = Convert.ToString(rdr["Img"]);
emp.status = Convert.ToInt32(rdr["status"]);
listEmployees.Add(emp);
}
}
var result = new
{
iTotalRecords = GetEmployeesTotalCount(),
iTotalDisplayRecords = filteredCount,
aaData = listEmployees
};
JavaScriptSerializer js = new JavaScriptSerializer();
Context.Response.Write(js.Serialize(result));
}
