public ReturnDataTable find_payment_informatyion_of_doctor(admin_ba_layer bl) { query = @"select * from payment_information_of_doctor where user_id=@user_id "; MySqlParameter[] pmm = new MySqlParameter[] { new MySqlParameter("user_id", bl.Applicant_mobile), }; dt = db.executeSelectQuery(query, pmm); return(dt); }
public ReturnBool update_pending_login_application(admin_ba_layer ur) { using (TransactionScope transScope = new TransactionScope()) { query = @"update user_login set applicant_verified=@applicant_verified,client_ip=@client_ip,reason=@reason,extra_1=@extra_1 where applicant_mobile=@applicant_mobile and applicant_id=@applicant_id"; MySqlParameter[] pmm = new MySqlParameter[] { new MySqlParameter("applicant_verified", ur.Status), new MySqlParameter("extra_1", ur.Status), new MySqlParameter("applicant_verifiedd", "N"), new MySqlParameter("applicant_mobile", ur.Applicant_mobile), new MySqlParameter("applicant_id", ur.Applicant_id), new MySqlParameter("client_ip", ur.Client_id), new MySqlParameter("reason", ur.Reason) }; rb = db.executeUpdateQuery(query, pmm); if (ur.Status == "Y") { if (rb.status == true) { ReturnDataTable dt = find_payment_informatyion_of_doctor(ur); if (dt.table.Rows.Count > 0) { query = @"update payment_information_of_doctor set to_be_paid_by_user=@to_be_paid_by_user,client_ip=@client_ip where user_id=@applicant_mobile "; MySqlParameter[] pmmm = new MySqlParameter[] { new MySqlParameter("to_be_paid_by_user", ur.Type), new MySqlParameter("applicant_mobile", ur.Applicant_mobile), new MySqlParameter("client_ip", ur.Client_id) }; rb = db.executeUpdateQuery(query, pmmm); } else { query = @"insert into payment_information_of_doctor (user_id,to_be_paid_by_user,client_ip) values(@user_id,@to_be_paid_by_user,@client_ip) "; MySqlParameter[] pmmm = new MySqlParameter[] { new MySqlParameter("to_be_paid_by_user", ur.Type), new MySqlParameter("user_id", ur.Applicant_mobile), new MySqlParameter("client_ip", ur.Client_id) }; rb = db.executeInsertQuery(query, pmmm); } } } if (rb.status == true) { transScope.Complete(); } } return(rb); }
public ReturnBool sms_log(admin_ba_layer lt) { query = @" INSERT INTO sms_trail (mobile_no,client_ip,message,success, type) VALUES (@mobile_no,@client_ip,@message,@success, @type)"; MySqlParameter[] pr = new MySqlParameter[] { new MySqlParameter("mobile_no", lt.Mobile), new MySqlParameter("client_ip", lt.Client_id), new MySqlParameter("message", lt.Message_to), new MySqlParameter("success", lt.Success), new MySqlParameter("type", lt.Type) }; rb = db.executeInsertQuery(query, pr); return(rb); }
public ReturnBool update_pending_review_application(admin_ba_layer ur) { query = @"update website_review set status=@status,client_ip=@client_ip,reason=@reason where user_id=@user_id and id=@applicant_id"; MySqlParameter[] pmm = new MySqlParameter[] { new MySqlParameter("status", ur.Status), new MySqlParameter("statuss", "N"), new MySqlParameter("user_id", ur.Applicant_mobile), new MySqlParameter("applicant_id", ur.Applicant_id), new MySqlParameter("client_ip", ur.Client_id), new MySqlParameter("reason", ur.Reason) }; rb = db.executeUpdateQuery(query, pmm); return(rb); }
public void Getnewmessage() { admin_ba_layer bl = new admin_ba_layer(); admin_da_layer dl = new admin_da_layer(); ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable(); try { if (Session["User_Id"] != null) { bl.User_id = Session["User_Id"].ToString(); } else { if (Request.Cookies["User_Id"] != null) { Session["User_Id"] = Request.Cookies["User_Id"].Value; bl.User_id = Request.Cookies["User_Id"].Value; } } dt = dl.bind_Review_total(); if (dt.table.Rows.Count > 0) { lbl_new_message_review.Text = dt.table.Rows.Count.ToString(); lbl_new_message_review1.Text = dt.table.Rows.Count.ToString(); } else { lbl_new_message_review.Text = "0"; lbl_new_message_review1.Text = "0"; } dt = dl.bind_testimonial_total(); if (dt.table.Rows.Count > 0) { lbl_new_message_testimonial.Text = dt.table.Rows.Count.ToString(); lbl_new_message_testimonial1.Text = dt.table.Rows.Count.ToString(); } else { lbl_new_message_testimonial.Text = "0"; lbl_new_message_testimonial1.Text = "0"; } //dt = dl.select_pending_application_for_login_total(); //if (dt.table.Rows.Count > 0) //{ // lbl_new_message_login.Text = dt.table.Rows.Count.ToString(); // lbl_new_message_login1.Text = dt.table.Rows.Count.ToString(); //} //else //{ // lbl_new_message_login.Text = "0"; // lbl_new_message_login1.Text = "0"; //} //dt = dl.transction_report(); //if (dt.table.Rows.Count > 0) //{ // lbl_new_message_transction.Text = dt.table.Rows.Count.ToString(); //} //else //{ // lbl_new_message_transction.Text = "0"; //} dt = dl.bind_order_medicine(); if (dt.table.Rows.Count > 0) { // lbl_order.Text = dt.table.Rows.Count.ToString(); } else { // lbl_order.Text = "0"; } } catch (NullReferenceException) { // Utilities.MessageBox_UpdatePanel_Redirect(UpdatePanel2, "Your Session Has Expired Please Login Again", "../Logout.aspx"); } }