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