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);
}
