protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
int activePackage = 0, deActivePackage = 0, activeActivity = 0, deActiveActivity = 0, customPackage = 0, user = 0;
dt = dbCommon.DisplayDataQuery("select (select count(*) from package where isactive=0) as pacactivetotal,(select count(*) from activity where activitystatus = 0) as actactivebooktotal,(select count(*) from package where isactive = 1) as pacdeactivetotal,(select count(*) from activity where activitystatus = 1) as actdeactivetotal,(select count(*) from custompackage) as customenqtotal,(select count(*) from user_details) as usertotal").Tables[0];
foreach (DataRow dr in dt.Rows)
{
activePackage = Convert.ToInt32(dr["pacactivetotal"].ToString());
deActivePackage = Convert.ToInt32(dr["pacdeactivetotal"].ToString());
activeActivity = Convert.ToInt32(dr["actactivebooktotal"].ToString());
deActiveActivity = Convert.ToInt32(dr["actdeactivetotal"].ToString());
customPackage = Convert.ToInt32(dr["customenqtotal"].ToString());
user = Convert.ToInt32(dr["usertotal"].ToString());
}
lblTotalActiveActivity.Text = activeActivity.ToString();
lblTotalActivePackage.Text = activePackage.ToString();
lblTotalDeActiveActivity.Text = deActiveActivity.ToString();
lblTotalDeActivePackage.Text = deActivePackage.ToString();
lblTotalCustomPackage.Text = customPackage.ToString();
lblTotalUser.Text = user.ToString();
packageRepeter();
activityRepeter();
}
}
protected void grdArea_RowEditing(object sender, GridViewEditEventArgs e)
{
int id = Convert.ToInt32(grdArea.DataKeys[e.NewEditIndex].Values[0]);
dbCommon.SetUpdateId("editId", id.ToString());
string sql = "select * from area where areaid='" + id + "'";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sql).Tables[0];
btnSubmit.Text = "Update";
btncancel.Visible = true;
foreach (DataRow dr in dt.Rows)
{
sql = "select * from city where cityid='" + dr["cityid"].ToString() + "'";
DataTable dtCity = new DataTable();
dtCity = dbCommon.DisplayDataQuery(sql).Tables[0];
foreach (DataRow drcity in dtCity.Rows)
{
ddCountry.SelectedValue = drcity["countryid"].ToString();
break;
}
combocity();
txtArea.Text = dr["areaname"].ToString();
ddCity.SelectedValue = dr["cityid"].ToString();
break;
}
}
public void GetDetalis()
{
string sqlStr = "";
sqlStr = "select * from LAS_Login where login_id='" + Session["Slogin_id"].ToString() + "'";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
txtEmail.Text = dr["email_id"].ToString();
txtName.Text = dr["first_name"].ToString() + " " + dr["last_name"].ToString();
}
dt.Rows.Clear();
sqlStr = "Select a.office_name,a.address,a.pincode,c.area_name,d.city_name, " +
" b.first_name,b.last_name " +
" from LAS_office a " +
" Left Join LAS_login b on a.login_id = b.login_id " +
" Left Join LAS_area c on c.area_id = a.area_id " +
" Left Join LAS_city d on d.city_id = c.city_id " +
" where a.office_id = '" + dbCommon.GetUpdateId("officeId").ToString() + "'";
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
lblLName.Text = dr["first_name"].ToString() + " " + dr["last_name"].ToString();
lblOffice.InnerHtml = dr["office_name"].ToString() + " <br />" + dr["address"].ToString() + "<br />" + dr["area_name"].ToString() + "<br />" + dr["city_name"].ToString() + " - " + dr["pincode"].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session["Suser_type"] == null)
{
Response.Redirect("../logout.aspx");
}
if (Request.QueryString.AllKeys.Length > 1)
{
Response.Redirect("../logout.aspx");
}
if (!IsPostBack)
{
fillTable();
Fill_Combo_Country();
if (Request.QueryString.AllKeys.Contains("eid"))
{
if (!Request.QueryString["eid"].ToString().All(char.IsDigit))
{
Response.Redirect("../logout.aspx");
}
btnSubmit.Text = "Update";
string id = Request.QueryString["eid"];
ViewState["id"] = Request.QueryString["eid"];
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select a.area_id,a.area_name,b.city_id,b.country_id from LAS_area a, LAS_city b where a.city_id=b.city_id and a.area_id='" + id + "'").Tables[0];
if (dt.Rows.Count == 0)
{
Response.Redirect("city.aspx");
}
else
{
foreach (DataRow dr in dt.Rows)
{
ViewState["description"] = dr["area_name"].ToString();
cmbCountry.SelectedValue = dr["country_id"].ToString();
Fill_Combo_City();
cmbCity.SelectedValue = dr["city_id"].ToString();
txtArea.Text = dr["area_name"].ToString();
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
}
protected void Fill_Combo_Office()
{
DataTable dtCat = new DataTable();
dtCat = dbCommon.DisplayDataQuery("select office_id, Concat(office_name,'-',address) as office_name from LAS_office where login_id='" + Session["Slogin_id"] + "'").Tables[0];
cmbOffice.Items.Clear();
cmbOffice.Items.Add(new ListItem("Select Office", "select"));
foreach (DataRow drUserInfo in dtCat.Rows)
{
cmbOffice.Items.Add(new ListItem(drUserInfo["office_name"].ToString(), drUserInfo["office_id"].ToString()));
}
}
protected void Fill_Combo_area()
{
DataTable dtCat = new DataTable();
dtCat = dbCommon.DisplayDataQuery("select * from LAS_specialization").Tables[0];
cmbSpec.Items.Clear();
cmbSpec.Items.Add(new ListItem("Select Specialization", "select"));
foreach (DataRow drUserInfo in dtCat.Rows)
{
cmbSpec.Items.Add(new ListItem(drUserInfo["description"].ToString(), drUserInfo["specialization_id"].ToString()));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session["Suser_type"] == null)
{
Response.Redirect("../LogOut.aspx");
}
if (Request.QueryString.AllKeys.Length > 1)
{
Response.Redirect("../logout.aspx");
}
if (!IsPostBack)
{
fillTable();
if (Request.QueryString.AllKeys.Contains("eid"))
{
if (!Request.QueryString["eid"].ToString().All(char.IsDigit))
{
Response.Redirect("../logout.aspx");
}
btnSubmit.Text = "Update";
string id = Request.QueryString["eid"];
ViewState["id"] = Request.QueryString["eid"];
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from LAS_experience where experience_id='" + id + "'").Tables[0];
if (dt.Rows.Count == 0)
{
Response.Redirect("experience.aspx");
}
else
{
foreach (DataRow dr in dt.Rows)
{
txtfrom.Text = Convert.ToDateTime(dr["from_date"].ToString()).ToString("yyyy-MM-dd");
txttodate.Text = Convert.ToDateTime(dr["to_date"].ToString()).ToString("yyyy-MM-dd");
txtdescription.Text = dr["description"].ToString();
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select top 1 * from about_us").Tables[0];
foreach (DataRow dr in dt.Rows)
{
lblPhone.Text = dr["phone"].ToString();
lblTime.InnerHtml = dr["timing"].ToString();
break;
}
dt.Rows.Clear();
StringBuilder html = new StringBuilder();
dt = dbCommon.DisplayDataQuery("select * from service").Tables[0];
foreach (DataRow dr in dt.Rows)
{
html.Append("<div class='col-md-4 col-sm-6 col-xs-12 service-column'>");
html.Append("<div class='single-service-content'>");
html.Append("<div class='single -item-hoverly'>");
html.Append("<figure class='img -box'>");
byte[] bytes;
string base64String = "";
try
{
bytes = (byte[])dr["image_src"];
base64String = "data:image/png;base64," + Convert.ToBase64String(bytes, 0, bytes.Length);
}
catch (Exception)
{
bytes = null;
}
html.Append("<img src = '" + base64String + "' height='200px' width='200px' alt=''>");
html.Append("<div class='overlay'>");
html.Append("</div>");
html.Append("</figure>");
html.Append("<div class='lower-content'>");
html.Append("<h3>" + dr["sname"].ToString() + "</h3 >");
html.Append("<div class='text lh-24'>" + dr["description"].ToString() + "</div>");
html.Append("</div>");
html.Append("</div>");
html.Append("</div>");
html.Append("</div>");
}
displayService.InnerHtml = html.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session["Suser_type"] == null)
{
Response.Redirect("../LogOut.aspx");
}
if (!IsPostBack)
{
fillTable();
Fill_Combo_area();
if (Request.QueryString.AllKeys.Contains("eid"))
{
if (!Request.QueryString["eid"].ToString().All(char.IsDigit))
{
Response.Redirect("../logout.aspx");
}
btnsubmit.Text = "Update";
string id = Request.QueryString["eid"];
ViewState["id"] = Request.QueryString["eid"];
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from LAS_office where office_id='" + id + "'").Tables[0];
if (dt.Rows.Count == 0)
{
Response.Redirect("office_info.aspx");
}
else
{
foreach (DataRow dr in dt.Rows)
{
txtname.Text = dr["office_name"].ToString();
txtaddress.Text = dr["address"].ToString();
txtpostalcode.Text = dr["pincode"].ToString();
txtemail.Text = dr["email_id"].ToString();
cmbarea.SelectedValue = dr["area_id"].ToString();
txtmobile.Text = dr["mobile"].ToString();
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session["Srole"] == null)
{
Response.Redirect("../LogOut.aspx");
}
//if (Request.QueryString.AllKeys.Length > 1)
//{
// Response.Redirect("../logout.aspx");
//}
if (!IsPostBack)
{
fillTable();
if (Request.QueryString.AllKeys.Contains("eid"))
{
if (!Request.QueryString["eid"].ToString().All(char.IsDigit))
{
Response.Redirect("../logout.aspx");
}
btnSubmit.Text = "Update";
string id = Request.QueryString["eid"];
ViewState["id"] = Request.QueryString["eid"];
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from designation where designation_id='" + id + "'").Tables[0];
if (dt.Rows.Count == 0)
{
Response.Redirect("designation.aspx");
}
else
{
foreach (DataRow dr in dt.Rows)
{
ViewState["description"] = dr["designation_name"].ToString();
txtDescription.Text = dr["designation_name"].ToString();
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
}
public void fillData()
{
if (Request.QueryString.AllKeys.Contains("eid"))
{
if (!Request.QueryString["eid"].ToString().All(char.IsDigit))
{
Response.Redirect("../logout.aspx");
}
btnSubmit.Text = "Update";
string id = Request.QueryString["eid"];
ViewState["id"] = Request.QueryString["eid"];
string sqlP = "select * from login where login_id='" + id + "'";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlP).Tables[0];
if (dt.Rows.Count >= 0)
{
btnSubmit.Text = "Update";
btnCancel.Visible = true;
foreach (DataRow dr in dt.Rows)
{
txtFName.Text = dr["fname"].ToString();
txtLName.Text = dr["lname"].ToString();
cmbItemtype.SelectedValue = dr["designation_id"].ToString();
txtEmail.Text = dr["email"].ToString();
txtAddress.Text = dr["address"].ToString();
byte[] bytes;
try
{
bytes = (byte[])dr["profile_src"];
Session["imageupdate"] = bytes;
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
displayImg.ImageUrl = "data:image/png;base64," + base64String;
}
catch (Exception)
{
bytes = null;
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from Item").Tables[0];
StringBuilder html = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
html.Append("<div class='single-price'>");
html.Append("<div class='view-content'>");
byte[] bytes;
string base64String = "";
try
{
bytes = (byte[])dr["photo_src"];
base64String = "data:image/png;base64," + Convert.ToBase64String(bytes, 0, bytes.Length);
}
catch (Exception)
{
bytes = null;
}
html.Append("<div class='icon-box'><img src='" + base64String + "' height='100px' width='100px' alt=''></div>");
html.Append("<div class='name'><h4>" + dr["item_name"].ToString() + "</h4></div>");
html.Append("</div>");
html.Append("<div class='hidden-content'>");
html.Append("<div class='name'><h4>" + dr["item_name"].ToString() + "</h4></div>");
html.Append("<div class='icon-box'><i class='flaticon-dress'></i></div>");
html.Append("<div class='price'>Price : " + dr["price"].ToString() + "<br /> For " + dr["item_type"].ToString() + "</div>");
html.Append("</div>");
html.Append("</div>");
}
displayPrice.InnerHtml = html.ToString();
}
}
public void fillData()
{
string sqlStr = "select a.order_id,a.login_id,b.fname,b.lname,a.pick_up_date,a.date_time,a.amount,a.totalqty,c.company_name,c.company_address_l1,c.company_address_l2,c.company_address_l3 " +
" from orderMst a, login b, company c where a.login_id = b.login_id and c.company_id=b.company_id " +
" order by order_id desc";
DataTable dt = new DataTable();
StringBuilder html = new StringBuilder();
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr> ");
html.Append("<td>" + dr["company_name"].ToString() + "</td>");
html.Append("<td>" + dr["company_address_l1"].ToString() + "<br />" + dr["company_address_l2"].ToString() + "<br />" + dr["company_address_l3"].ToString() + "</td>");
html.Append("<td>" + dr["fname"].ToString() + " " + dr["lname"].ToString() + "</td>");
html.Append("<td>" + dr["date_time"].ToString() + "</td>");
html.Append("<td>" + dr["pick_up_date"].ToString() + "</td>");
html.Append("<td>" + dr["totalQty"].ToString() + "</td>");
html.Append("<td>" + dr["amount"].ToString() + "</td>");
html.Append("<td><a href='complain.aspx?cid=" + dr["order_id"] + "' color='red'>View complain</a></td>");
html.Append("<td><a href='vieworder.aspx?uid=" + dr["order_id"] + "' color='red'>View Order</a></td>");
html.Append("</tr>");
}
displayData.InnerHtml = html.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (HttpContext.Current.Session["Srole"] == null)
{
// Response.Redirect("logout.aspx");
}
else if (Session["Srole"].ToString() != "user")
{
// Response.Redirect("logout.aspx", false);
}
else
{
lblUserInfo.Text = Session["Sname"].ToString();
menuOrder.Visible = true;
btnRegister.Visible = false;
btnLogin.Visible = false;
btnLogout.Visible = true;
}
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select top 1 * from about_us").Tables[0];
foreach (DataRow dr in dt.Rows)
{
lblEmail.Text = dr["email"].ToString();
lblMobile.Text = dr["phone"].ToString();
lblDescription.Text = dr["description2"].ToString();
lblAddress.InnerHtml = dr["address_l1"].ToString() + "<br />" + dr["address_l2"].ToString() + "<br />" + dr["address_l3"].ToString();
break;
}
}
}
public void fillTable()
{
string sqlP = "select a.specialization_id, a.description,IsNull(temp.countLawyer,0) as countLawyer from LAS_specialization a " +
" left Join " +
" (select count(b.login_id) as 'countLawyer',b.specialization_id " +
" from LAS_lawyer_profile b , LAS_login c where c.login_id=b.login_id and c.user_type='lawyer' and c.active_flag='0' group by b.specialization_id) temp on temp.specialization_id = a.specialization_id ";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlP).Tables[0];
string div_add = "";
foreach (DataRow dr in dt.Rows)
{
div_add += "<div class='col-lg-3 col-md-6'>";
div_add += "<a href = 'search_lawyer.aspx?speId=" + dr["specialization_id"].ToString() + "' class='box_cat_home'>";
div_add += "<i class='icon-info-4'></i>";
div_add += "<h3><font size='5' color='blue' face='arial'>" + dr["description"].ToString() + "</font></h3>";
div_add += "<ul class='clearfix'>";
div_add += "<li><strong>" + dr["countLawyer"].ToString() + "</strong> Lawyer in " + dr["description"].ToString() + "</li>";
div_add += "</ul>";
div_add += "</a>";
div_add += "</div>";
}
displaySpec.InnerHtml = div_add;
}
public void fillTable()
{
DBConnectionClass sp3 = new DBConnectionClass("displayData");
string sqlP = "select a.review_id,a.description, CONCAT(CONCAT(e.first_name,' '),e.last_name) as 'LName', " +
" CONCAT(CONCAT(c.first_name, ' '), c.last_name) as 'UName' " +
" from LAS_review a " +
" Left Join LAS_appointment b on a.appointment_id = b.appointment_id " +
" Left Join LAS_login c on c.login_id = b.user_login_id " +
" Left Join LAS_office d on d.office_id = b.office_id " +
" Left Join LAS_login e on e.login_id = d.login_id order by a.create_date desc ";
DataTable dt = new DataTable();
dt = sp3.DisplayDataQuery(sqlP).Tables[0];
StringBuilder html = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr>");
html.Append("<td>" + dr["LName"] + "</td>");
html.Append("<td>" + dr["UName"] + "</td>");
html.Append("<td>" + dr["description"] + "</td>");
html.Append("<td align='center' width='4%'><a href='Javascript:deletefunction(" + dr["review_id"].ToString() + ");'><i class='fa fa-1x fa-trash-o'></i></a></td>");
html.Append("</tr>");
}
displayReview.InnerHtml = html.ToString();
}
public void fillData()
{
string sqlP = "select Top 1 * from about_us";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlP).Tables[0];
if (dt.Rows.Count >= 0)
{
foreach (DataRow dr in dt.Rows)
{
txtPhone.Text = dr["phone"].ToString();
txtEmail.Text = dr["email"].ToString();
txtAddress1.Text = dr["address_l1"].ToString();
txtAddress2.Text = dr["address_l2"].ToString();
txtAddress3.Text = dr["address_l3"].ToString();
txtTitle.Text = dr["title"].ToString();
txtDescriptionOne.Text = dr["description"].ToString();
txtDescTwo.Text = dr["description2"].ToString();
txtTiming.Text = dr["timing"].ToString();
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("../Logout.aspx");
}
}
public void fillData()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from company where company_id='" + Session["Scompany_id"].ToString() + "'").Tables[0];
if (dt.Rows.Count == 0)
{
}
else
{
foreach (DataRow dr in dt.Rows)
{
if (dr["auto_order"].ToString() == "0")
{
cmbAutoOrder.SelectedValue = "no";
}
else
{
cmbAutoOrder.SelectedValue = "yes";
}
txtDays.Text = dr["days_of_order"].ToString();
txtDate.Text = Convert.ToDateTime(dr["start_from_date"].ToString()).ToString("yyyy-MM-dd");
txtCompanyName.Text = dr["company_name"].ToString();
txtAddress1.Text = dr["company_address_l1"].ToString();
txtAddress2.Text = dr["company_address_l2"].ToString();
txtAddress3.Text = dr["company_address_l3"].ToString();
txtContact.Text = dr["company_phone"].ToString();
}
}
}
public void fillData()
{
string sqlStr = "";
sqlStr = "select a.first_name,a.last_name,a.mobile_no,a.email_id,b.address_line1, b.address_line2,b.address_line3,b.gender,b.date_of_birth " +
" from LAS_login a left join LAS_user b on b.login_id=a.login_id " +
" where a.login_id='" + Session["Slogin_id"] + "' ";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
txtFirstName.Text = dr["first_name"].ToString();
txtLastName.Text = dr["last_name"].ToString();
txtMobile.Text = dr["mobile_no"].ToString();
lblEmai.Text = dr["email_id"].ToString();
txtAddress1.Text = dr["address_line1"].ToString();
txtAddress2.Text = dr["address_line2"].ToString();
txtAddress3.Text = dr["address_line3"].ToString();
cmbGender.SelectedValue = dr["gender"].ToString();
if (dr["date_of_birth"].ToString() != "")
{
txtDOB.Text = DateTime.Parse(dr["date_of_birth"].ToString()).ToString("yyyy-MM-dd");
}
}
}
public void fillData()
{
if (Request.QueryString.AllKeys.Contains("cid"))
{
if (!Request.QueryString["cid"].ToString().All(char.IsDigit))
{
Response.Redirect("logout.aspx");
}
string id = Request.QueryString["cid"];
ViewState["id"] = Request.QueryString["cid"];
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from complain where order_id='" + id + "'").Tables[0];
if (dt.Rows.Count == 0)
{
}
else
{
btnSubmit.Text = "Update";
foreach (DataRow dr in dt.Rows)
{
txtComplaint.Text = dr["description"].ToString();
}
}
}
else if (Request.QueryString.AllKeys.Length == 1)
{
Response.Redirect("Logout.aspx");
}
}
public void fillData()
{
string sqlStr = "";
sqlStr = "select a.*,b.book_date,b.book_time,c.first_name,c.last_name,c.email_id,c.mobile_no " +
" from LAS_review a " +
" left " +
" join LAS_appointment b on a.appointment_id = b.appointment_id " +
" left " +
" join LAS_login c on b.user_login_id = c.login_id " +
" left join LAS_office d on d.office_id=b.office_id " +
" where d.login_id='" + Session["Slogin_id"].ToString() + "' order by create_date ";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
StringBuilder html = new StringBuilder();
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr>");
html.Append("<td>" + dr["first_name"].ToString() + " " + dr["last_name"].ToString() + "</td>");
html.Append("<td>" + dr["email_id"].ToString() + "</td>");
html.Append("<td>" + dr["mobile_no"] + "</td>");
html.Append("<td>" + DateTime.Parse(dr["book_date"].ToString()).ToString("dd-MM-yyyy") + " " + DateTime.Parse(dr["book_time"].ToString()).ToString("H:mm tt") + "</td>");
html.Append("<td>" + dr["description"].ToString() + "</td>");
html.Append("</tr>");
}
displayReview.InnerHtml = html.ToString();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string sql = "";
sql = "select login_id,active_flag,user_type,first_name,last_name from LAS_Login where email_id='" + txtEmail.Text.ToString().Trim() + "' and Password='******' ";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sql).Tables[0];
if (dt.Rows.Count <= 0)
{
lblLogin.Visible = true;
lblLogin.Text = "Invalid Login Id or Password.";
}
else
{
foreach (DataRow dr in dt.Rows)
{
switch (dr["active_flag"].ToString())
{
case "1":
lblLogin.Visible = true;
lblLogin.Text = "Your account is deactivated. Contact admin to activate.";
break;
//case "0":
case "0":
lblLogin.Visible = false;
Session["Slogin_id"] = dr["login_id"].ToString();
Session["Suser_type"] = dr["user_type"].ToString();
Session["Sfirst_name"] = dr["first_name"].ToString();
Session["Slast_name"] = dr["last_name"].ToString();
switch (dr["user_type"].ToString())
{
case "user":
if (dbCommon.IsEmptyUpdateId("bookTime") && dbCommon.IsEmptyUpdateId("officeId"))
{
Response.Redirect("confirmbook.aspx");
}
else
{
Response.Redirect("index.aspx");
}
break;
case "admin":
Response.Redirect("admin/s_lawyer.aspx");
break;
case "lawyer":
Response.Redirect("lawyer/index.aspx");
break;
}
break;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (HttpContext.Current.Session["LoginUserId"] == null)
{
Response.Redirect("../User/LogOut.aspx");
}
if (!IsPostBack)
{
txtdob.Attributes["max"] = DateTime.Parse(DateTime.Now.ToString()).ToString("yyyy-MM-dd");
Fill_Combo();
string sql = "select * from user_details a " +
"left join address b on a.userid = b.userid " +
"left join contact c on c.userid = a.userid " +
"where " +
"a.userid = '" + Session["LoginUserId"].ToString() + "'";
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery(sql).Tables[0];
btnadduser.Text = "Update";
foreach (DataRow dr in dt.Rows)
{
displayImg.ImageUrl = "~/Images/User/" + dr["profileimg"].ToString();
ViewState["imgState"] = dr["profileimg"].ToString();
txtfname.Text = dr["user_fname"].ToString();
txtlname.Text = dr["user_lname"].ToString();
if (!String.IsNullOrEmpty(dr["dob"].ToString()))
{
txtdob.Text = DateTime.Parse(dr["dob"].ToString()).ToString("yyyy-MM-dd");
}
if (Convert.ToInt32(dr["gender"].ToString()) == 0)
{
radiofemale.Checked = true;
}
else
{
radiomale.Checked = true;
}
txtemailid.Text = dr["emailid"].ToString();
ddCountry.SelectedValue = dr["countryid"].ToString();
Fill_City_Combo((String.IsNullOrEmpty(dr["countryid"].ToString())) ? 0 : Convert.ToInt32(dr["countryid"].ToString()));
txtPrimaryPhone.Text = dr["primaryphone"].ToString();
txtSecondaryPhone.Text = dr["secondaryphone"].ToString();
txtStreetName.Text = dr["streetname"].ToString();
txtSuburb.Text = dr["suburb"].ToString();
ddCity.SelectedValue = dr["cityid"].ToString();
txtPostalCode.Text = dr["postalcode"].ToString();
break;
}
}
}
public void fillData(string linenFor)
{
DataTable dt = new DataTable();
string sqlQry = "";
sqlQry = "select * from item ";
if (linenFor != "all")
{
sqlQry += "where item_type='" + linenFor + "'";
}
dt = dbCommon.DisplayDataQuery(sqlQry).Tables[0];
DataTable dtData = new DataTable();
dtData.Columns.Add("item_Id");
dtData.Columns.Add("item_name");
dtData.Columns.Add("item_type");
dtData.Columns.Add("description");
dtData.Columns.Add("price");
dtData.Columns.Add("photo_src");
dtData.Columns.Add("qty");
foreach (DataRow dr in dt.Rows)
{
DataRow drTab = dtData.NewRow();
drTab["item_id"] = dr["item_id"].ToString();
drTab["item_name"] = dr["item_name"].ToString();
drTab["item_type"] = dr["item_type"].ToString();
drTab["description"] = dr["description"].ToString();
drTab["price"] = dr["price"].ToString();
byte[] bytes;
try
{
bytes = (byte[])dr["photo_src"];
drTab["photo_src"] = "data:image/png;base64," + Convert.ToBase64String(bytes, 0, bytes.Length);
}
catch (Exception)
{
bytes = null;
}
dtData.Rows.Add(drTab);
}
GridView1.DataSource = dtData.Copy();
GridView1.DataBind();
}
public void ProfileImage()
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select profileimg from user_details where userid=" + ViewState["userid"]).Tables[0];
foreach (DataRow dr in dt.Rows)
{
displayImg.ImageUrl = "~/Images/User/" + dr["profileimg"].ToString();
break;
}
}
public void fillData()
{
DataTable dt = new DataTable();
StringBuilder html = new StringBuilder();
dt = dbCommon.DisplayDataQuery("select a.amount,a.totalqty,a.pick_up_date,a.date_time,b.company_address_l1,b.company_address_l2,b.company_address_l3,b.company_name " +
" from orderMst a, company b where a.company_id = b.company_id and order_id='" + Request.QueryString["uid"].ToString() + "'").Tables[0];
foreach (DataRow dr in dt.Rows)
{
txtAddr1.Text = dr["company_address_l1"].ToString();
txtAddr2.Text = dr["company_address_l2"].ToString();
txtAddr3.Text = dr["company_address_l3"].ToString();
txtCompany.Text = dr["company_name"].ToString();
txtQuentity.Text = dr["totalqty"].ToString();
txtAmount.Text = dr["amount"].ToString();
txtPickUp.Text = dr["pick_up_date"].ToString();
txtOrder.Text = dr["date_time"].ToString();
}
dt.Rows.Clear();
string sqlStr = "select c.item_id,c.item_name,c.item_type,b.quantity,b.price,c.description,c.photo_src " +
" from OrderMst a, order_details b, item c " +
" where a.order_id = b.order_id and c.item_id = b.item_id and a.order_id ='" + Request.QueryString["uid"].ToString() + "'";
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr>");
html.Append("<td>" + dr["item_name"].ToString() + "</td>");
html.Append("<td>" + dr["item_type"].ToString() + "</td>");
html.Append("<td>" + dr["price"].ToString() + "</td>");
html.Append("<td>" + dr["Quantity"] + "</td>");
html.Append("</tr>");
}
displayData.InnerHtml = html.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from about_us").Tables[0];
foreach (DataRow dr in dt.Rows)
{
displayDesc.InnerHtml = dr["description"].ToString();
}
}
}
public void FillDetails()
{
string sqlStr = "";
DataTable dt = new DataTable();
StringBuilder html = new StringBuilder();
sqlStr = "select a.appointment_id,a.book_date,a.book_time,a.book_reason,a.a_status,CONCAT(b.first_name,' ',b.last_name) as 'UserName', " +
" c.office_name, CONCAT(d.first_name, ' ', d.last_name) as 'LawyerName' " +
" from LAS_appointment a " +
" left " +
" join LAS_login b on a.user_login_id = b.login_id " +
" left " +
" join LAS_office c on a.office_id = c.office_id " +
" left " +
" join LAS_login d on c.login_id = d.login_id " +
" where b.login_id='" + Session["Slogin_id"].ToString() + "' ";
dt = dbCommon.DisplayDataQuery(sqlStr).Tables[0];
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr>");
html.Append("<td>" + dr["LawyerName"].ToString() + "</td>");
html.Append("<td>" + dr["office_name"].ToString() + "</td>");
html.Append("<td>" + DateTime.Parse(dr["book_date"].ToString()).ToString("dd-MM-yyyy") + "</td>");
html.Append("<td>" + DateTime.Parse(dr["book_time"].ToString()).ToString("h:mm tt") + "</td>");
if (dr["a_status"].ToString() == "0")
{
html.Append("<td>Active</td>");
html.Append("<td><a href='Javascript:deletefunction(" + dr["appointment_id"].ToString() + ");'>Cancel</a></td>");
html.Append("<td></td>");
}
else
if (dr["a_status"].ToString() == "1")
{
html.Append("<td>Canceled</td>");
html.Append("<td></td>");
html.Append("<td></td>");
}
else
{
html.Append("<td>Closed</td>");
html.Append("<td></td>");
html.Append("<td><a href='review.aspx?aid=" + dr["appointment_id"].ToString() + "'>Review</a></td>");
}
html.Append("</tr>");
}
displayData.InnerHtml = html.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt = dbCommon.DisplayDataQuery("select * from about_us").Tables[0];
foreach (DataRow dr in dt.Rows)
{
lblAddress.InnerHtml = dr["address_l1"].ToString() + "<br />" + dr["address_l2"].ToString() + "<br />" + dr["address_l3"].ToString();
lblMail.InnerText = dr["email"].ToString();
lblPhone.InnerText = dr["phone"].ToString();
}
}
}
public void fillData()
{
DataTable dt = new DataTable();
StringBuilder html = new StringBuilder();
dt = dbCommon.DisplayDataQuery("select * from complain where order_id='" + Request.QueryString["cid"].ToString() + "'").Tables[0];
foreach (DataRow dr in dt.Rows)
{
html.Append("<tr>");
html.Append("<td>" + dr["order_id"].ToString() + "</td>");
html.Append("<td>" + dr["description"].ToString() + "</td>");
html.Append("</tr>");
}
displayData.InnerHtml = html.ToString();
}
