public ActionResult GetUserProfile()
{
try
{
MasterGET_UserList getter = new MasterGET_UserList();
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandType = CommandType.StoredProcedure;
cmdSql.CommandText = @"dbo.MasterGET_UserList";
cmdSql.Parameters.Clear();
cmdSql.Parameters.Add("@PageCount", SqlDbType.Int).Value = 0;
cmdSql.Parameters.Add("@RowCount", SqlDbType.Int).Value = 1;
cmdSql.Parameters.Add("@OrderBy", SqlDbType.NVarChar).Value = "ID";
cmdSql.Parameters.Add("@Filter", SqlDbType.NVarChar).Value = user.EmployeeNo;
cmdSql.Parameters.Add("@RecordCount", SqlDbType.Int).Value = 0;
cmdSql.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
cmdSql.CommandTimeout = 0;
conn.Open();
//cmdSql.ExecuteNonQuery();
using (SqlDataReader rdr = cmdSql.ExecuteReader())
{
while (rdr.Read())
{
getter.ID = Convert.ToInt64(rdr["ID"]); //.ToString();
getter.Rownum = Convert.ToInt32(rdr["Rownum"]); //.ToString();
getter.EmployeeNo = rdr["EmployeeNo"].ToString();
getter.FirstName = rdr["FirstName"].ToString();
getter.LastName = rdr["LastName"].ToString();
getter.Email = rdr["Email"].ToString();
getter.MobileNo = rdr["MobileNo"].ToString();
getter.LocalNo = rdr["LocalNo"].ToString();
getter.Password = rdr["Password"].ToString();
getter.UserPhoto = rdr["UserPhoto"].ToString();
getter.Division = rdr["DivisionID"].ToString();
getter.Department = rdr["DepartmentID"].ToString();
getter.Section = rdr["SectionID"].ToString();
getter.IsApproved = Convert.ToInt32(rdr["IsApproved"]);
}
}
return(Json(new { data = getter }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetUsersList()
{
try
{
//Server Side Parameter
int start = (Convert.ToInt32(Request["start"]) == 0) ? 0 : (Convert.ToInt32(Request["start"]) / Convert.ToInt32(Request["length"])); //Convert.ToInt32(Request["start"]);
int length = Convert.ToInt32(Request["length"]);
string searchValue = Request["search[value]"];
string sortColumnName = Request["columns[" + Request["order[0][column]"] + "][name]"];
string sortDirection = Request["order[0][dir]"];
//ObjectParameter totalCount = new ObjectParameter("RecordCount", typeof(int));
List <MasterGET_UserList> list = new List <MasterGET_UserList>();
SqlCommand cmdSql = new SqlCommand();
cmdSql.Connection = conn;
cmdSql.CommandTimeout = 0;
cmdSql.CommandType = CommandType.StoredProcedure;
cmdSql.CommandText = @"dbo.MasterGET_UserList";
cmdSql.Parameters.Clear();
cmdSql.Parameters.Add("@PageCount", SqlDbType.Int).Value = start;
cmdSql.Parameters.Add("@RowCount", SqlDbType.Int).Value = length;
cmdSql.Parameters.Add("@OrderBy", SqlDbType.NVarChar).Value = sortColumnName;
cmdSql.Parameters.Add("@Filter", SqlDbType.NVarChar).Value = searchValue;
cmdSql.Parameters.Add("@RecordCount", SqlDbType.Int).Value = 0;
cmdSql.Parameters["@RecordCount"].Direction = ParameterDirection.Output;
cmdSql.CommandTimeout = 0;
conn.Open();
//cmdSql.ExecuteNonQuery();
using (SqlDataReader rdr = cmdSql.ExecuteReader())
{
while (rdr.Read())
{
MasterGET_UserList getter = new MasterGET_UserList();
getter.ID = Convert.ToInt64(rdr["ID"]); //.ToString();
getter.Rownum = Convert.ToInt32(rdr["Rownum"]); //.ToString();
getter.EmployeeNo = rdr["EmployeeNo"].ToString();
getter.FirstName = rdr["FirstName"].ToString();
getter.LastName = rdr["LastName"].ToString();
getter.Email = rdr["Email"].ToString();
getter.MobileNo = rdr["MobileNo"].ToString();
getter.LocalNo = rdr["LocalNo"].ToString();
getter.Password = rdr["Password"].ToString();
getter.UserPhoto = rdr["UserPhoto"].ToString();
getter.Division = rdr["DivisionID"].ToString();
getter.Department = rdr["DepartmentID"].ToString();
getter.CanReceive = Convert.ToBoolean(rdr["CanReceive"]);
getter.Section = rdr["SectionID"].ToString();
getter.IsApproved = Convert.ToInt32(rdr["IsApproved"]);
list.Add(getter);
}
}
int totalCount = Convert.ToInt32(cmdSql.Parameters["@RecordCount"].Value);
conn.Close();
int?totalrows = totalCount;
int?totalrowsafterfiltering = totalCount;
return(Json(new { data = list, draw = Request["draw"], recordsTotal = totalrows, recordsFiltered = totalrowsafterfiltering }, JsonRequestBehavior.AllowGet));
}
catch (Exception err)
{
return(Json(new { }, JsonRequestBehavior.AllowGet));
}
}
