public ReturnBool update_password(bl_Usr_Registration ur)
{
using (TransactionScope transScope = new TransactionScope())
{
query = @"insert into user_login_log select * from user_login where applicant_verified=@applicant_verified and user_id=@user_id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("applicant_verified", ur.Verified),
new MySqlParameter("user_id", ur.User_Id)
};
rb = db.executeInsertQuery(query, pm);
if (rb.status == true)
{
query = @"update user_login set applicant_password=@applicant_password where applicant_verified=@applicant_verified and user_id=@user_id";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("applicant_password", ur.Password),
new MySqlParameter("applicant_verified", ur.Verified),
new MySqlParameter("user_id", ur.User_Id)
};
rb = db.executeUpdateQuery(query, pmm);
}
if (rb.status == true)
{
query = @"insert into user_registration_log select * from user_registration where applicant_active=@applicant_verified and applicant_mobile=@applicant_mobile";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("applicant_verified", ur.Verified),
new MySqlParameter("applicant_mobile", ur.User_Id)
};
rb = db.executeInsertQuery(query, pmm);
}
if (rb.status == true)
{
query = @"update user_registration set applicant_password=@applicant_password where applicant_active=@applicant_verified and applicant_mobile=@applicant_mobile";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("applicant_password", ur.Password),
new MySqlParameter("applicant_verified", ur.Verified),
new MySqlParameter("applicant_mobile", ur.User_Id)
};
rb = db.executeUpdateQuery(query, pmm);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool Insert_doc_qualification_details(doc_ba_layer ur)
{
using (TransactionScope transScope = new TransactionScope())
{
if (ur.Mode == "1")
{
query = @"insert into doctor_qualification (degree_name,client_ip,date_time,upload,user_id,university_name,college_name,degree_from,degree_to,complition_time,percentage)
values(@degree_name,@client_ip,@date_time,@upload,@user_id,@university_name,@college_name,@degree_from,@degree_to,@complition_time,@percentage)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("degree_name", ur.Degree_name),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("upload", "N"),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("university_name", ur.University_name),
new MySqlParameter("college_name", ur.College_name),
new MySqlParameter("degree_from", ur.Degree_from),
new MySqlParameter("degree_to", ur.Degree_to),
new MySqlParameter("complition_time", ur.Complition_time),
new MySqlParameter("percentage", ur.Percentage)
};
rb = db.executeInsertQuery(query, pm);
}
else if (ur.Mode == "2")
{
query = @"update doctor_qualification set degree_name=@degree_name,client_ip=@client_ip,date_time=@date_time,university_name=@university_name,college_name=@college_name,degree_from=@degree_from,degree_to=@degree_to,complition_time=@complition_time,percentage=@percentage where user_id=@user_id and id=@id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("id", ur.Degree_id),
new MySqlParameter("degree_name", ur.Degree_name),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("university_name", ur.University_name),
new MySqlParameter("college_name", ur.College_name),
new MySqlParameter("degree_from", ur.Degree_from),
new MySqlParameter("degree_to", ur.Degree_to),
new MySqlParameter("complition_time", ur.Complition_time),
new MySqlParameter("percentage", ur.Percentage)
};
rb = db.executeUpdateQuery(query, pm);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool delete_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_id", ur.Class_id)
};
query = @"delete from classes where Class_id=@Class_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool delete_Video(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("video_id", ur.Video_id)
};
query = @"delete from video_topic_wise where video_id=@video_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnClass.ReturnBool delete_file_upload(doc_ba_layer fu)
{
MySqlParameter[] t1 = new MySqlParameter[] {
new MySqlParameter("user_id", fu.User_id),
new MySqlParameter("file_id", fu.File_id)
};
rb = db.executeDeleteQuery("delete from doctor_upload where user_id=@user_id and file_id=@file_id ", t1);
return(rb);
}
public ReturnBool delete_subject(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Subject_id", ur.Subject_id)
};
query = @"delete from subjects where Subject_id=@Subject_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool delete_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_id", ur.Topic_id)
};
query = @"delete from topics_wise_subject where Topic_id=@Topic_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool update_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_Name", ur.Category),
new MySqlParameter("Class_id", ur.Class_id)
};
query = @"update classes set Class_Name=@Class_Name where Class_id=@Class_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool update_subject(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Subject_Name", ur.Category),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("class_id", ur.Class_id)
};
query = @"update subjects set Subject_Name=@Subject_Name,class_id=@class_id where Subject_id=@Subject_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
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 delete_doctor_certifications(doc_ba_layer ur)
{
query = @"delete from doctor_other_certification where user_id = @user_id and id=@id ";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("id", ur.Degree_id)
};
rb = db.executeDeleteQuery(query, pm);
return(rb);
}
public ReturnBool update_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_Name", ur.Headline),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("Topic_Description", ur.Description),
new MySqlParameter("Topic_id", ur.Topic_id)
};
query = @"update topics_wise_subject set Topic_Name=@Topic_Name,Topic_Description=@Topic_Description,Subject_id=@Subject_id where Topic_id=@Topic_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool Insert_doc_profile_part3_details(doc_ba_layer ur)
{
using (TransactionScope transScope = new TransactionScope())
{
if (ur.Mode == "1")
{
query = @"insert into doctor_account_details (user_id,client_ip,bank_name,branch_name,ifsc_code,account_number,entry_date_time) values (@user_id,@client_ip,@bank_name,@branch_name,@ifsc_code,@account_number,@entry_date_time)";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("bank_name", ur.Bank_name),
new MySqlParameter("branch_name", ur.Branch_name),
new MySqlParameter("ifsc_code", ur.Ifsc_code),
new MySqlParameter("account_number", ur.Account_number),
new MySqlParameter("entry_date_time", ur.Date_time)
};
rb = db.executeInsertQuery(query, pmm);
}
else if (ur.Mode == "2")
{
query = @"update doctor_account_details set client_ip=@client_ip,bank_name=@bank_name,branch_name=@branch_name,ifsc_code=@ifsc_code,account_number=@account_number,entry_date_time=@entry_date_time where user_id=@user_id";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("bank_name", ur.Bank_name),
new MySqlParameter("branch_name", ur.Branch_name),
new MySqlParameter("ifsc_code", ur.Ifsc_code),
new MySqlParameter("account_number", ur.Account_number),
new MySqlParameter("entry_date_time", ur.Date_time)
};
rb = db.executeUpdateQuery(query, pmm);
}
if (rb.status == true)
{
query = @"update doctor_profile_master set part_3=@part_3 where user_id=@user_id";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("part_3", "Y"),
new MySqlParameter("user_id", ur.User_id)
};
rb = db.executeUpdateQuery(query, pmm);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool Update_user_profile(bl_Usr_Registration ur)
{
query = @"update user_login set profile_update=@profile_update where user_id=@user_id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_Id),
new MySqlParameter("profile_update", "Y")
};
rb = db.executeUpdateQuery(query, pm);
return(rb);
}
public ReturnBool Insert_doc_experience_details(doc_ba_layer ur)
{
using (TransactionScope transScope = new TransactionScope())
{
if (ur.Mode == "1")
{
query = @"insert into doctor_work_experience (designation,client_ip,date_time,hospital_name,user_id,working_from,working_to)
values(@designation,@client_ip,@date_time,@hospital_name,@user_id,@working_from,@working_to)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("designation", ur.Degree_name),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("hospital_name", ur.University_name),
new MySqlParameter("working_from", ur.Degree_from),
new MySqlParameter("working_to", ur.Degree_to),
};
rb = db.executeInsertQuery(query, pm);
}
else if (ur.Mode == "2")
{
query = @"update doctor_work_experience set designation=@designation,client_ip=@client_ip,date_time=@date_time,hospital_name=@hospital_name,working_from=@working_from,working_to=@working_to where user_id=@user_id and id=@id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("id", ur.Degree_id),
new MySqlParameter("designation", ur.Degree_name),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("hospital_name", ur.University_name),
new MySqlParameter("working_from", ur.Degree_from),
new MySqlParameter("working_to", ur.Degree_to),
};
rb = db.executeUpdateQuery(query, pm);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool sms_log(doc_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 ReturnBool sms_log(bl_Usr_Registration 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.Cell_No),
new MySqlParameter("client_ip", lt.ClientIp),
new MySqlParameter("message", lt.Message),
new MySqlParameter("success", lt.Success),
new MySqlParameter("type", lt.Type)
};
rb = db.executeInsertQuery(query, pr);
return(rb);
}
public ReturnBool Insert_class(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Class_id", ur.Class_id),
new MySqlParameter("Class_Name", ur.Category),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
query = @"INSERT INTO classes(Class_id,Class_Name,client_ip,user_id,date_time)
VALUES(@Class_id,@Class_Name,@client_ip,@user_id,@date_time)";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool Update_testimonial(doc_ba_layer ur)
{
query = @"update testimonial set client_ip=@client_ip,date_time=@date_time,testimonial=@testimonial,category=@category,status=@status where user_id=@user_id ";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("testimonial", ur.Review),
new MySqlParameter("category", ur.Category),
new MySqlParameter("status", ur.Status)
};
rb = db.executeUpdateQuery(query, pmm);
return(rb);
}
public ReturnBool LoginTrail_new(LoginTrail lt)
{
query = @" INSERT INTO login_trail (user_id,client_ip,client_os,client_browser, useragent)
VALUES (@user_id, @client_ip, @client_os, @client_browser, @useragent)";
MySqlParameter[] pr = new MySqlParameter[] {
new MySqlParameter("user_id", lt.User_Id),
new MySqlParameter("client_ip", lt.Client_Ip),
new MySqlParameter("client_os", lt.Client_Os),
new MySqlParameter("client_browser", lt.Client_Browser),
new MySqlParameter("useragent", lt.UserAgent)
};
rb = db.executeInsertQuery(query, pr);
return(rb);
}
public ReturnBool Insert_testimonial(doc_ba_layer ur)
{
query = @"insert into testimonial (user_id,client_ip,date_time,testimonial,category,status)values(@user_id,@client_ip,@date_time,@testimonial,@category,@status)";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("testimonial", ur.Review),
new MySqlParameter("category", ur.Category),
new MySqlParameter("status", ur.Status)
};
rb = db.executeUpdateQuery(query, pmm);
return(rb);
}
public ReturnClass.ReturnBool Update_Upload_details(doc_ba_layer fu)
{
query = @"Update doctor_upload set document_name=@document_name,mime_type=@mime_type,file_extn=@file_extn,file_data=@file_data,client_ip=@client_ip,action_id=@action_id where user_id=@user_id and category_id=@category_id";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("user_id", fu.User_id),
new MySqlParameter("document_name", fu.Document_name),
new MySqlParameter("mime_type", fu.Mime_type),
new MySqlParameter("file_data", fu.Document_data),
new MySqlParameter("client_ip", fu.Client_id),
new MySqlParameter("category_id", fu.Panjiyan_category_id),
new MySqlParameter("file_extn", fu.File_extn),
new MySqlParameter("action_id", fu.Category_id)
};
rb = db.executeInsertQuery(query, pm1);
return(rb);
}
public ReturnBool Insert_doc_certifications_details(doc_ba_layer ur)
{
using (TransactionScope transScope = new TransactionScope())
{
if (ur.Mode == "1")
{
query = @"insert into doctor_other_certification (certification_name,client_ip,date_time,user_id,duration_from,duration_to)
values(@certification_name,@client_ip,@date_time,@user_id,@duration_from,@duration_to)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("certification_name", ur.Degree_name),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("duration_from", ur.Degree_from),
new MySqlParameter("duration_to", ur.Degree_to),
};
rb = db.executeInsertQuery(query, pm);
}
else if (ur.Mode == "2")
{
query = @"update doctor_other_certification set certification_name=@certification_name,client_ip=@client_ip,date_time=@date_time,duration_from=@duration_from,duration_to=@duration_to where user_id=@user_id and id=@id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("id", ur.Degree_id),
new MySqlParameter("certification_name", ur.Degree_name),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("duration_from", ur.Degree_from),
new MySqlParameter("duration_to", ur.Degree_to),
};
rb = db.executeUpdateQuery(query, pm);
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool Insert_topic(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("Topic_id", ur.Topic_id),
new MySqlParameter("Subject_id", ur.Subject_id),
new MySqlParameter("Topic_Name", ur.Headline),
new MySqlParameter("Topic_Description", ur.Description),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
query = @"INSERT INTO topics_wise_subject(Topic_id,Subject_id,Topic_Name,Topic_Description,client_ip,user_id,date_time)
VALUES(@Topic_id,@Subject_id,@Topic_Name,@Topic_Description,@client_ip,@user_id,@date_time)";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnBool update_Video(olu_ba_layer ur)
{
MySqlParameter[] pm11 = new MySqlParameter[] {
new MySqlParameter("video_id", ur.Video_id),
new MySqlParameter("Topic_id", ur.Topic_id),
new MySqlParameter("video_heading", ur.Headline),
new MySqlParameter("video_description", ur.Description),
new MySqlParameter("video_url", ur.User_type),
new MySqlParameter("contentType", ur.Mime_type),
new MySqlParameter("path", ur.Panjiyan_category_id),
new MySqlParameter("extension", ur.File_extn)
};
query = @"update video_topic_wise set Topic_id=@Topic_id,video_heading=@video_heading,video_description=@video_description,video_url=@video_url,contentType=@contentType,path=@path,extension=@extension where video_id=@video_id";
rb = db.executeInsertQuery(query, pm11);
return(rb);
}
public ReturnClass.ReturnBool Upload_details(doc_ba_layer fu)
{
query = @"INSERT INTO doctor_upload (user_id,document_name,mime_type,file_extn,file_data,client_ip,category_id,action_id)
VALUES(@user_id,@document_name,@mime_type,@file_extn,@file_data,@client_ip,@category_id,@action_id)";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("user_id", fu.User_id),
new MySqlParameter("document_name", fu.Document_name),
new MySqlParameter("mime_type", fu.Mime_type),
new MySqlParameter("file_data", fu.Document_data),
new MySqlParameter("client_ip", fu.Client_id),
new MySqlParameter("category_id", fu.Panjiyan_category_id),
new MySqlParameter("file_extn", fu.File_extn),
new MySqlParameter("action_id", fu.Category_id)
};
rb = db.executeInsertQuery(query, pm1);
return(rb);
}
public ReturnBool Insert_know_my_cell_slat_quries(bl_common ur)
{
query = @"insert into know_my_cekk_salt_queries (user_id,client_ip,date_time,Symptom_id,u_category,y_category) VALUES(@user_id,@client_ip,@date_time,@Symptom_id,@u_category,@y_category)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("client_ip", ur.Client_ip),
new MySqlParameter("date_time", ur.Date_time),
new MySqlParameter("Symptom_id", ur.Symptom_id),
new MySqlParameter("u_category", ur.U_category),
new MySqlParameter("y_category", ur.Y_category)
};
rb = db.executeUpdateQuery(query, pm);
return(rb);
}
public ReturnBool Insert_doctor_working_days_details(doc_ba_layer ur)
{
query = @"insert into doctor_working_days (user_id,panjiyan_cate_id,client_ip,datetime)
values(@user_id,@panjiyan_cate_id,@client_ip,@datetime)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("panjiyan_cate_id", ur.Category_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("datetime", ur.Date_time)
};
rb = db.executeInsertQuery(query, pm);
return(rb);
}
public ReturnBool Insert_refer_friend_details(doc_ba_layer ur)
{
query = @"insert into refer_friend (Name,email_id,mobile_no,client_ip,user_id,date_time)
values(@Name,@email_id,@mobile_no,@client_ip,@user_id,@date_time)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Name", ur.First_name),
new MySqlParameter("email_id", ur.Email_id),
new MySqlParameter("mobile_no", ur.Mobile),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
rb = db.executeInsertQuery(query, pm);
return(rb);
}
