public static ClsDepartments GetEditData(string Val) { try { string con1 = System.Configuration.ConfigurationManager.ConnectionStrings["DBMS"].ConnectionString; SqlConnection conn = new SqlConnection(con1); SqlCommand cmd = new SqlCommand(@"select dep_name,dep_discription from Department where dep_id=@id", conn); cmd.Parameters.AddWithValue("@id", Convert.ToInt32(Val)); conn.Open(); SqlDataReader rea = cmd.ExecuteReader(); ClsDepartments obj = new ClsDepartments(); while (rea.Read()) { obj.dep_name = rea["dep_name"].ToString(); obj.desc = rea["dep_discription"].ToString(); } return(obj); } catch (Exception ex) { ClsDepartments dep = new ClsDepartments(); dep.dep_name = "" + ex.Message; return(dep); } }
public void Get_Departments(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 <ClsDepartments> listEmployees = new List <ClsDepartments>(); int filteredCount = 0; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Sp_GetDepartment", 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()) { ClsDepartments emp = new ClsDepartments(); emp.dep_name = Convert.ToString(rdr["dep_name"]); filteredCount = Convert.ToInt32(rdr["TotalCount"]); emp.dep_id = Convert.ToInt32(rdr["dep_id"].ToString()); emp.desc = Convert.ToString(rdr["dep_discription"]); listEmployees.Add(emp); } } var result = new { iTotalRecords = GetDepTotalCount(), iTotalDisplayRecords = filteredCount, aaData = listEmployees }; JavaScriptSerializer js = new JavaScriptSerializer(); Context.Response.Write(js.Serialize(result)); }