public ReturnDataTable bind_Remedy_cellsalt_by_id(bl_common ur) { query = "select * from cellsalts i where i.id=@id group by id"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("id", ur.Cellsalt_id) }; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_symptoms_name(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("Name", ur.Desc + "%") }; query = @"select id,name,description from symptoms where name like @Name group by id order by Name limit 20"; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_affrected_code(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("id", ur.Desc) }; query = @"select s.affected_area_id from symptoms s where s.id=@id order by name; "; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_diseases_code(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("id", ur.Desc) }; query = @"select id,Name,description from diseases where id=@id group by id order by Name "; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_topic_code(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("id", ur.Desc) }; query = @"select Topic_id as id,Topic_Name as Name, Topic_Description as description from topics_wise_subject where Topic_id=@id group by Topic_id order by Topic_Name "; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_subject_id(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("Name", ur.Desc + "%"), new MySqlParameter("class_id", ur.Class_code) }; query = @"select * from subjects s where s.class_id=@class_id and subject_name like @Name "; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_topic_name(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("Name", ur.Desc + "%"), new MySqlParameter("Subject_id", ur.Symptom_id) }; query = @"select Topic_id as id,Topic_Name as Name, Topic_Description as description from topics_wise_subject where Topic_Name like @Name and Subject_id=@Subject_id group by Topic_id order by Topic_Name limit 20"; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable know_my_cell_salt_query_details(bl_common ur) { query = @"select *,date_format(date_time,'%d/%m/%Y %h:%i:%s %p') as datetime from know_my_cekk_salt_queries where user_id=@user_id order by date_time desc;"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("user_id", ur.User_id) }; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable get_sports_by_corner_name(bl_common ur) { MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("id", ur.Desc) }; query = @"select cc.name, dc.effect from pets_corner d join sports_corner_cellsalts dc on dc.disease_id= d.id join cellsalts cc on cc.id= dc.cellsalt_id where d.id=@id group by cc.id order by cc.name"; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable bind_checkbox(bl_common ur) { query = "select * from symptoms s where s.affected_area_id=@affected_area_id order by name"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("affected_area_id", ur.Category) }; dt = db.executeSelectQuery(query, pm); return(dt); }
public ReturnDataTable bind_checkbox_by_name(bl_common ur) { query = "select * from symptoms s where s.affected_area_id=@affected_area_id and name like @Name order by name"; MySqlParameter[] pm = new MySqlParameter[] { new MySqlParameter("affected_area_id", ur.Category), new MySqlParameter("Name", ur.Desc_text + "%") }; dt = db.executeSelectQuery(query, pm); return(dt); }
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 ReturnDataTable bind_Remedy_cellsalt(bl_common ur) { query = "select * from cellsalts i where i.id in (" + ur.Cellsalt_id + ") group by id"; dt = db.executeSelectQuery(query); return(dt); }
public ReturnDataTable bind_Remedy(bl_common ur) { query = "select * from cellsalt_symptom c where c.symptom_id in (" + ur.Symptom_id + ") order by symptom_id desc"; dt = db.executeSelectQuery(query); return(dt); }
public ReturnDataTable get_sportscorner_name(bl_common ur) { query = @"select id,Name,description from sports_corner group by id order by Name "; dt = db.executeSelectQuery(query); return(dt); }