public KeyValuePair <string, List <TaskArrea> > GetTaskAreaDetailRecord(string recordID, int page, int pageSize, string whereCondition, string sort) { try { TaskArrea ta = new TaskArrea(); SqlParameter[] Parameters = { new SqlParameter("@Sno", recordID), new SqlParameter("@PageNo", 1), new SqlParameter("@PageSize", 100), new SqlParameter("@WhereCondition", ""), new SqlParameter("@OrderBy", sort) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetTaskArea", Parameters); //select sp.SNo, ProcessSNo,subProcessName, priority,isRequired,IsDisplay,IsActive,IsOneClick,DisplayCaption,ProgressCheck,IsPopUpSubProcess var talist = ds.Tables[0].AsEnumerable().Select(e => new TaskArrea { TASNo = Convert.ToInt32(e["taSNo"].ToString()), AreaName = e["AreaName"].ToString(), TAIsActive = true, totRowCount = ds.Tables[1].Rows[0][0].ToString() }); return(new KeyValuePair <string, List <TaskArrea> >(ds.Tables[1].Rows[0][0].ToString(), talist.AsQueryable().ToList())); } catch (Exception ex)// { throw ex; } }
public TaskArrea GetTaskAreaRecord(string recordID, string UserID) { TaskArrea TA = new TaskArrea(); SqlDataReader dr = null; try { SqlParameter[] Parameters = { new SqlParameter("@TSNo", recordID) }; dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordTaskArea", Parameters); if (dr.Read()) { TA.TaskSno = Convert.ToInt32(dr["SNo"].ToString()); TA.Text_TaskSno = dr["TaskName"].ToString(); TA.TIsActive = true; } } catch (Exception ex)// { dr.Close(); throw ex; } dr.Close(); return(TA); }