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