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