public void Populate_SubQuestion()
{
Hashtable htgetsub = new Hashtable();
DataTable dtgetsub = new DataTable();
Hashtable htchecklist = new Hashtable();
DataTable dtcecklist = new DataTable();
htgetsub.Add("@Trans", "SELECT_SUB");
htgetsub.Add("@Order_Status_Id", Order_Status);
htgetsub.Add("@Task_Confirm_Id", Task_Confirm_Id);
dtgetsub = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htgetsub);
if (dtgetsub.Rows.Count > 0)
{
Task_Sub_Id = int.Parse(dtgetsub.Rows[0]["Task_Confirm_Sub_Id"].ToString());
}
else
{
Task_Sub_Id = 0;
}
if (Task_Sub_Id != 0)
{
htchecklist.Add("@Trans", "SELECT_BEFORE_SUB");
htchecklist.Add("@Order_Status_Id", Order_Status);
htchecklist.Add("@Task_Confirm_Id", Task_Confirm_Id);
htchecklist.Add("@Question_PoPulate", Pop_Op_Value);
htchecklist.Add("@Order_ID", Order_ID);
dtcecklist = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htchecklist);
if (dtcecklist.Rows.Count > 0)
{
Order_Check_List chk = new Order_Check_List(int.Parse(dtcecklist.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID, Order_Status, int.Parse(dtcecklist.Rows[0]["Task_Confirm_Sub_Id"].ToString()), 0, "Sub", "Pop_New");
chk.Show();
}
else
{
Populate_Child_Quesion();
}
}
else
{
Populate_List();
}
}
private void Populate_List()
{
Hashtable htchecklist = new Hashtable();
DataTable dtcecklist = new DataTable();
htchecklist.Add("@Trans", "SELECT_BEFORE");
htchecklist.Add("@Order_Status_Id", Order_Status);
htchecklist.Add("@Order_ID", Order_ID);
dtcecklist = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htchecklist);
if (dtcecklist.Rows.Count > 0)
{
Order_Check_List chk = new Order_Check_List(int.Parse(dtcecklist.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID, Order_Status, 0, 0, "Parent", "Pop_New");
chk.Show();
}
}
public void Check_Parent_Sub_Chld()
{
Hashtable htchecklist = new Hashtable();
DataTable dtcecklist = new DataTable();
htchecklist.Add("@Trans", "SELECT_BEFORE");
htchecklist.Add("@Order_Status_Id", Order_Status);
htchecklist.Add("@Order_ID", Order_ID);
dtcecklist = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htchecklist);
Check_List_Count = int.Parse(dtcecklist.Rows.Count.ToString());
if (Check_List_Count > 0)
{
Hashtable htsubcount = new Hashtable();
DataTable dtsubcount = new DataTable();
htsubcount.Add("@Trans", "GET_COUNT_TASK_CONFIRM_ID");
htsubcount.Add("@Order_ID", Order_ID);
htsubcount.Add("@Order_Status_Id", Order_Status);
dtsubcount = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htsubcount);
int count = int.Parse(dtsubcount.Rows[0]["count"].ToString());
Hashtable htget_Parent = new Hashtable();
DataTable dtget_Partent = new DataTable();
if (count == 0)
{
htget_Parent.Add("@Trans", "GET_ORDER_WISE_TASK_ID");
}
else if (count > 0)
{
htget_Parent.Add("@Trans", "GET_NOT_ENTERED_ORDER_WISE_TASK_CONFIRM_ID");
}
htget_Parent.Add("@Order_ID", Order_ID);
htget_Parent.Add("@Order_Status_Id", Order_Status);
dtget_Partent = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htget_Parent);
if (dtget_Partent.Rows.Count > 0)
{
Hashtable htget_enteredsub = new Hashtable();
DataTable dtget_enteredsub = new DataTable();
dtget_enteredsub.Rows.Clear();
htget_enteredsub.Add("@Trans", "GET_ENTERED_SUB_ID");
htget_enteredsub.Add("@Task_Confirm_Id", dtget_Partent.Rows[0]["Task_Confirm_Id"].ToString());
htget_enteredsub.Add("@Order_ID", Order_ID);
htget_enteredsub.Add("@Order_Status_Id", Order_Status);
dtget_enteredsub = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htget_enteredsub);
if (dtget_enteredsub.Rows.Count > 0)
{
Hashtable htget_child = new Hashtable();
DataTable dtget_child = new DataTable();
htget_child.Add("@Trans", "GET_ALL_CHILD_QUESTION_ON_TASK_SUB_ID");
htget_child.Add("@Task_Confirm_Id", dtget_enteredsub.Rows[0]["Task_Confirm_Id"].ToString());
htget_child.Add("@Task_Confirm_Sub_Id", int.Parse(dtget_enteredsub.Rows[0]["Task_Confirm_Sub_Id"].ToString()));
htget_child.Add("@Order_ID", Order_ID);
htget_child.Add("@Order_Status_Id", Order_Status);
dtget_child = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htget_child);
if (dtget_child.Rows.Count > 0)
{
Order_Check_List chk = new Order_Check_List(int.Parse(dtget_Partent.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID, Order_Status, int.Parse(dtget_enteredsub.Rows[0]["Task_Confirm_Sub_Id"].ToString()), int.Parse(dtget_child.Rows[0]["Task_Confirm_Child_Id"].ToString()), "Child", "Pop_Old");
chk.Show();
}
}
else
{
Hashtable htget_sub = new Hashtable();
DataTable dtget_sub = new DataTable();
htget_sub.Add("@Trans", "GET_ALL_SUB_QUESION_ON_TASK_CONFIRM_ID");
htget_sub.Add("@Task_Confirm_Id", dtget_Partent.Rows[0]["Task_Confirm_Id"].ToString());
htget_sub.Add("@Order_ID", Order_ID);
htget_sub.Add("@Order_Status_Id", Order_Status);
dtget_sub = dataaccess.ExecuteSP("Sp_Order_Task_Confirmation", htget_sub);
if (dtget_sub.Rows.Count > 0)
{
Order_Check_List chk = new Order_Check_List(int.Parse(dtget_Partent.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID, Order_Status, int.Parse(dtget_sub.Rows[0]["Task_Confirm_Sub_Id"].ToString()), 0, "Sub", "Pop_Old");
chk.Show();
}
}
}
else
{
Check_List_Count = int.Parse(dtcecklist.Rows.Count.ToString());
Order_Check_List chk = new Order_Check_List(int.Parse(dtcecklist.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID, Order_Status, 0, 0, "Parent", "Pop_New");
chk.Show();
}
}
//else
//{
// Check_List_Count = int.Parse(dtcecklist.Rows.Count.ToString());
// Order_Check_List chk = new Order_Check_List(int.Parse(dtcecklist.Rows[0]["Task_Confirm_Id"].ToString()), userid, Order_ID,Order_Status, 0, 0, "Parent", "Pop_New");
// chk.Show();
//}
}
