public DataSet get_users_details(logiclayer li) { da = new SqlDataAdapter("select * from user_master where ID='" + li.uid + "'", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_city_by_interest(logiclayer li) { da = new SqlDataAdapter("select top 1 * from places where interest_topic='" + li.interest + "' order by NEWID()", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_users_last_post(logiclayer li) { da = new SqlDataAdapter("select top 1 * from all_user_experience where uid='" + li.uid + "' order by UEID DESC", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_packeges_by_interest(logiclayer li) { da = new SqlDataAdapter("select * from packeges_basic_Details where cities like '%" + li.city + "%' order by NEWID()", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_story_to_information(logiclayer li) { da = new SqlDataAdapter("select * from all_user_experience where UEID='" + li.eid + "'", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_comments_to_reletaed_story(logiclayer li) { da = new SqlDataAdapter("select * from comment_master where eid='" + li.eid + "' order by CMID DESC", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_users_story(logiclayer li) { da = new SqlDataAdapter("select * from all_user_experience order by UEID DESC", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataSet get_related_users_to_locations(logiclayer li) { da = new SqlDataAdapter("select * from all_user_experience where place='" + li.place + "' and uid!='" + li.uid + "' order by UEID DESC", cn); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataTable fb_view(logiclayer li) { cmd = new SqlCommand("select * from feedback", cn); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable city_view(logiclayer li) { cmd = new SqlCommand(" select * from City_table c inner join State_table s on s.State_id=c.State_id", cn); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable trans_view(logiclayer li) { cmd = new SqlCommand("select * from transaction_table", cn); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public DataSet login(logiclayer li) { da = new SqlDataAdapter("select * from user_master where email=@username and pwd=@password", cn); da.SelectCommand.Parameters.AddWithValue("@username", li.email); da.SelectCommand.Parameters.AddWithValue("@password", li.password); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataTable selelectname(logiclayer li) { cmd = new SqlCommand("select * from user_table where card_no =@tp", cn); cmd.Parameters.AddWithValue("@tp", li.ccd); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public DataTable t_profile(logiclayer li) { cmd = new SqlCommand("select * from toll_trans where card_no=@cd ", cn); cmd.Parameters.AddWithValue("@cd", li.ptcn); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public void insertdb(logiclayer li) { cmd = new SqlCommand("update user_table set card_no=@crd_no where User_name=@uname", cn); cmd.Parameters.AddWithValue("@crd_no", li.iddb_crd); cmd.Parameters.AddWithValue("@uname", li.cduname); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void car(logiclayer li) { cmd = new SqlCommand("update user_table set balance=(balance-50) where card_no=@crdno", cn); cmd.Parameters.AddWithValue("@crdno", li.ccd); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void ins_add(logiclayer li) { cmd = new SqlCommand("update user_table set balance=(balance+@amount) where card_no=@crdno", cn); cmd.Parameters.AddWithValue("@crdno", li.t_crdno); cmd.Parameters.AddWithValue("@amount", li.t_amount); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public DataTable get(logiclayer li) { cmd = new SqlCommand("select * from User_table where user_name=@guname", cn); cmd.Parameters.AddWithValue("@guname", li.guname); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public DataSet city_query(logiclayer li) { cmd = new SqlCommand("select * from city_table where state_id=@sid", cn); cmd.Parameters.AddWithValue("@sid", li.state_id); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); return(ds); }
public DataTable operator_login(logiclayer li) { SqlCommand cmd = new SqlCommand("select * from operator_table where Uplace_name =@Ausername and Password=@password", cn); cmd.Parameters.AddWithValue("@Ausername", li.user_name); cmd.Parameters.AddWithValue("@password", li.admin_password); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); }
public void insert_toll(logiclayer li) { cmd = new SqlCommand(@"INSERT INTO tolltax.dbo.toll_trans(card_no,amount,type,date) VALUES(@cn,@amount,@type,getdate())", cn); cmd.Parameters.AddWithValue("@cn", li.crd); cmd.Parameters.AddWithValue("@amount", li.amount); cmd.Parameters.AddWithValue("@type", li.type); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_recharge(logiclayer li) { cmd = new SqlCommand(@"INSERT INTO tolltax.dbo.transaction_table(user_name,card_no,trans_date,Balance,trans_type) VALUES(@un,@cn,getdate(),@ta,@tt)", cn); cmd.Parameters.AddWithValue("@un", li.t_uname); cmd.Parameters.AddWithValue("@cn", li.t_crdno); cmd.Parameters.AddWithValue("@ta", li.t_amount); cmd.Parameters.AddWithValue("@tt", li.t_type); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_comment(logiclayer li) { cmd = new SqlCommand("insert into comment_master (uid,eid,fname,comment,added_date) values(@uid,@eid,@fname,@comment,getdate())", cn); cmd.Parameters.AddWithValue("@uid", li.uid); cmd.Parameters.AddWithValue("@eid", li.eid); cmd.Parameters.AddWithValue("@fname", li.fname); cmd.Parameters.AddWithValue("@comment", li.comment); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_contact(logiclayer li) { cmd = new SqlCommand(@"INSERT INTO tolltax.dbo.contact(Username,Email,Message) VALUES(@UN,@mail,@msg)", cn); cmd.Parameters.AddWithValue("@UN", li.cntct_user1); cmd.Parameters.AddWithValue("@mail", li.cntct_email1); cmd.Parameters.AddWithValue("@msg", li.cntct_msg); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_feedback(logiclayer li) { cmd = new SqlCommand(@"INSERT INTO feedback(fb_uname,fb_mail,fb_help,fb_review) VALUES (@fbname,@fbmail,@fbhelp,@fbreview)", cn); cmd.Parameters.AddWithValue("@fbname", li.fb_uname); cmd.Parameters.AddWithValue("@fbmail", li.fb_mail); cmd.Parameters.AddWithValue("@fbhelp", li.fb_help); cmd.Parameters.AddWithValue("@fbreview", li.fb_review); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_user_experience(logiclayer li) { cmd = new SqlCommand("insert into all_user_experience (uid,fname,user_filename,user_filepath,place,topic_name,topic_filename,topic_filepath,topic_desc,added_date,ip_add) values(@uid,@fname,@u_fn,@u_fp,@place,@name,@fn,@fp,@desc,getdate(),@ip_add)", cn); cmd.Parameters.AddWithValue("@uid", li.uid); cmd.Parameters.AddWithValue("@fname", li.fname); cmd.Parameters.AddWithValue("@u_fn", li.user_filename); cmd.Parameters.AddWithValue("@u_fp", li.user_filepath); cmd.Parameters.AddWithValue("@place", li.place); cmd.Parameters.AddWithValue("@name", li.topic_name); cmd.Parameters.AddWithValue("@fn", li.filename); cmd.Parameters.AddWithValue("@fp", li.filepath); cmd.Parameters.AddWithValue("@desc", li.topic_desc); cmd.Parameters.AddWithValue("@ip_add", li.ip); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public void insert_query(logiclayer li) { cmd = new SqlCommand(@"INSERT INTO tolltax.dbo.User_table(F_name,L_name,Mob_no,Email_id,Address,City_name,Pin_code,[User_name],Password) VALUES (@fn,@ln,@mob,@em,@add,@ct,@pin,@un,@pass)", cn); cmd.Parameters.AddWithValue("@fn", li.fname); cmd.Parameters.AddWithValue("@ln", li.lname); cmd.Parameters.AddWithValue("@em", li.email); cmd.Parameters.AddWithValue("@un", li.uname); cmd.Parameters.AddWithValue("@pass", li.pass); cmd.Parameters.AddWithValue("@add", li.address); cmd.Parameters.AddWithValue("@ct", li.dcity); cmd.Parameters.AddWithValue("@mob", li.mob_no); cmd.Parameters.AddWithValue("@pin", li.pc); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public DataSet get_user_all_details(logiclayer li) { return(dl.get_users_details(li)); }
public void insert_all_user_experience_details(logiclayer li) { dl.insert_user_experience(li); }
public DataSet get_all_usera_post(logiclayer li) { return(dl.get_users_post(li)); }