private void FillDdlUPData() { using (productparameter obj = new productparameter()) { DataSet ds = new DataSet(); obj._pdid = Convert.ToInt64(Request.QueryString["id"].ToString()); ds = obj.productparameter_select_up_byproductid(); if (ds.Tables[0].Rows.Count > 0) { ddlpdname.DataSource = ds; ddlpdname.DataTextField = "Name"; ddlpdname.DataValueField = "ProductID"; ddlpdname.DataBind(); obj._pdid = Convert.ToInt64(ds.Tables[0].Rows[0]["prid"].ToString()); prid = Convert.ToInt64(ds.Tables[0].Rows[0]["prid"].ToString()); } //ds = obj.productparameter_select_bycategoryid(); using (parameter objp = new parameter()) { objp._id = prid; ds = objp.parameter_selectbyid(); if (ds.Tables[0].Rows.Count > 0) { ddlprname.DataSource = ds; ddlprname.DataTextField = "Name"; ddlprname.DataValueField = "ParameterID"; ddlprname.DataBind(); } } } }
protected void rbtnpd_CheckedChanged(object sender, EventArgs e) { foreach (RepeaterItem item in rptpdetails.Items) { RadioButton rbtn = (RadioButton)item.FindControl("rbtnpd"); rbtn.Checked = false; } ((RadioButton)sender).Checked = true; foreach (RepeaterItem item in rptpdetails.Items) { RadioButton rbtn = (RadioButton)item.FindControl("rbtnpd"); if (rbtn.Checked) { using (productparameter obj = new productparameter()) { ViewState["rbtnid"] = rbtn.ToolTip.ToString(); obj._id = Convert.ToInt64(ViewState["rbtnid"].ToString()); DataSet ds = new DataSet(); ds = obj.productparameter_select_byid(); if (ds.Tables[0].Rows.Count > 0) { lbltotal.Text = ds.Tables[0].Rows[0]["Credit"].ToString(); ViewState["prid"] = ds.Tables[0].Rows[0]["ParameterID"].ToString(); //ViewState["credit"] = lbltotal.Text; } } } } }
private void FillRepeater() { using (productparameter obj = new productparameter()) { DataSet dsR = new DataSet(); if (txtserch.Text == "") { obj._pdid = Convert.ToInt64(Session["mid"].ToString()); dsR = obj.productparameter_selectall(); } else { obj._serch = txtserch.Text.Trim(); dsR = obj.productparameter_Select_Searchdata(); } int cnt = dsR.Tables[0].Rows.Count; PagedDataSource page = new PagedDataSource(); page.DataSource = dsR.Tables[0].DefaultView; page.AllowPaging = true; page.PageSize = 5; page.CurrentPageIndex = Pgnm; vcnt = cnt / page.PageSize; if (Pgnm < 1) { linkprev.Visible = false; } else if (Pgnm > 0) { linkprev.Visible = true; } if (Pgnm == vcnt) { linknext.Visible = false; } if (Pgnm < vcnt) { linknext.Visible = true; } if (dsR.Tables[0].Rows.Count > 0) { rptproductparameter.DataSource = page; rptproductparameter.DataBind(); if (txtserch.Text != "") { lblMessage.Text = " Record Found :" + dsR.Tables[0].Rows.Count; messagegreen.Visible = true; } } else { rptproductparameter.Visible = false; } } }
protected void rptproductparameter_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "EditData") { Response.Redirect("Productparameteradd.aspx?id=" + e.CommandArgument.ToString()); } if (e.CommandName == "DeleteData") { using (productparameter obj = new productparameter()) { obj._id = Convert.ToInt64(e.CommandArgument.ToString()); obj.productparameter_delete(); FillRepeater(); } } }
private void FillRegData() { using (productparameter obj = new productparameter()) { DataSet ds = new DataSet(); obj._id = Convert.ToInt64(Request.QueryString["id"]); ds = obj.productparameter_select_byid(); if (ds.Tables[0].Rows.Count > 0) { txtcredit.Text = ds.Tables[0].Rows[0]["credit"].ToString(); //txtsize.Text = ds.Tables[0].Rows[0]["size"].ToString(); btnsubmit.Text = "Update"; } } }
private void FillDdlData() { using (productparameter obj = new productparameter()) { DataSet ds = new DataSet(); obj._pdid = Convert.ToInt64(Request.QueryString["mid"].ToString()); ds = obj.productparameter_select_byproductid(); if (ds.Tables[0].Rows.Count > 0) { ddlpdname.DataSource = ds; ddlpdname.DataTextField = "Name"; ddlpdname.DataValueField = "ProductID"; ddlpdname.DataBind(); using (category objc = new category()) { DataSet dsc = new DataSet(); objc._id = Convert.ToInt64(ds.Tables[0].Rows[0]["CategoryID"].ToString()); dsc = objc.category_selectbyid(); if (dsc.Tables[0].Rows.Count > 0) { ViewState["prid"] = dsc.Tables[0].Rows[0]["ParentID"].ToString(); } } } //ds = obj.productparameter_select_bycategoryid(); if (ViewState["prid"] != null) { obj._pdid = Convert.ToInt64(ViewState["prid"]); ds = obj.productparameter_select_bycategoryid(); if (ds.Tables[0].Rows.Count > 0) { ddlprname.DataSource = ds; ddlprname.DataTextField = "Name"; ddlprname.DataValueField = "ParameterID"; ddlprname.DataBind(); } } } }
protected void btnsubmit_Click(object sender, EventArgs e) { using (productparameter obj = new productparameter()) { obj._pdid = Convert.ToInt64(ddlpdname.SelectedValue.ToString()); obj._prid = Convert.ToInt64(ddlprname.SelectedValue.ToString()); obj._credit = Convert.ToInt64(txtcredit.Text.ToString()); if (fusproduct.HasFile) { obj._oproduct = fusproduct.FileName.ToString(); fusproduct.SaveAs(Server.MapPath("upload\\orignal\\") + fusproduct.FileName.ToString()); String fileloc = Server.MapPath("upload\\orignal\\") + fusproduct.FileName.ToString(); String siz = fusproduct.FileBytes.ToString(); double size = Convert.ToDouble(fileloc.Length); if (size < 1024) { obj._size = size + "B"; } else if (size > 1024 && size < 1024000) { obj._size = size / 1024 + "KB"; } else { obj._size = size / 1024 * 1024 + "MB"; } } //obj._size = txtsize.Text.Trim(); if (btnsubmit.Text == "Update") { obj._id = Convert.ToInt64(Request.QueryString["id"].ToString()); obj.productparameter_update(); Response.Redirect("Productparameterrepeater.aspx?flag=edit"); } else { obj.productparameter_insert(); Response.Redirect("Productparameterrepeater.aspx?flag=add"); } } }
private void downloaddata(object p) { //throw new NotImplementedException(); using (productparameter obj = new productparameter()) { obj._id = Convert.ToInt64(p.ToString()); DataSet ds = new DataSet(); ds = obj.productparameter_select_byid(); if (ds.Tables[0].Rows.Count > 0) { filename = ds.Tables[0].Rows[0]["OProduct"].ToString(); fileloc = Server.MapPath("Admin\\upload\\orignal\\") + filename; //download file from folder Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=" + filename); Response.WriteFile(fileloc); Response.End(); } } }
private void Choseiav() { int tag; // throw new NotImplementedException(); using (product obj = new product()) { obj._id = Convert.ToInt64(Request.QueryString["sid"].ToString()); DataSet ds = new DataSet(); ds = obj.product_details(); if (ds.Tables[0].Rows.Count > 0) { using (category objc = new category()) { objc._id = Convert.ToInt64(ds.Tables[0].Rows[0]["cid"].ToString()); DataSet dsr = new DataSet(); dsr = objc.category_selectbyid(); if (dsr.Tables[0].Rows.Count > 0) { tag = Convert.ToInt32(dsr.Tables[0].Rows[0]["ParentID"].ToString()); if (tag == 2) { imgpd.Src += ds.Tables[0].Rows[0]["image"].ToString(); using (productparameter objp = new productparameter()) { objp._pdid = Convert.ToInt64(Request.QueryString["sid"].ToString()); objp._prid = Convert.ToInt64("2"); DataSet dsp = new DataSet(); dsp = objp.productparameter_select_byparameterid(); if (dsp.Tables[0].Rows.Count > 0) { aimg.HRef += dsp.Tables[0].Rows[0]["OProduct"].ToString(); } } image.Visible = true; video.Visible = false; audio.Visible = false; lblrelated.Text = "Image"; } if (tag == 3) { using (productparameter objp = new productparameter()) { objp._pdid = Convert.ToInt64(Request.QueryString["sid"].ToString()); objp._prid = Convert.ToInt64("6"); DataSet dsp = new DataSet(); dsp = objp.productparameter_select_byparameterid(); if (dsp.Tables[0].Rows.Count > 0) { //aimg.HRef += dsp.Tables[0].Rows[0]["OProduct"].ToString(); flashvideo.VideoURL += dsp.Tables[0].Rows[0]["OProduct"].ToString(); } } image.Visible = false; video.Visible = true; audio.Visible = false; lblrelated.Text = "Video"; } if (tag == 4) { img1.Src += ds.Tables[0].Rows[0]["image"].ToString(); using (productparameter objp = new productparameter()) { objp._pdid = Convert.ToInt64(Request.QueryString["sid"].ToString()); objp._prid = Convert.ToInt64("10"); DataSet dsp = new DataSet(); dsp = objp.productparameter_select_byparameterid(); if (dsp.Tables[0].Rows.Count > 0) { audio1.AudioURL += dsp.Tables[0].Rows[0]["OProduct"].ToString(); } } image.Visible = false; video.Visible = false; audio.Visible = true; lblrelated.Text = "Audio"; } } } } } }
protected void btnconfirm_Click(object sender, EventArgs e) { double currentcredit = 0; double total = Convert.ToDouble(lbltotals.Text.ToString()); if (Session["UserID"] != null) { using (users objo = new users()) { objo.uid = Convert.ToInt64(Session["UserID"].ToString()); DataSet dsr = new DataSet(); dsr = objo.user_select_byid(); if (dsr.Tables[0].Rows.Count > 0) { currentcredit = Convert.ToDouble(dsr.Tables[0].Rows[0]["Balance"].ToString()); } if (currentcredit > total) { currentcredit = currentcredit - total; objo.balanceid = currentcredit; objo.user_updatebalance(); using (cart obj = new cart()) { obj._userid = Convert.ToInt64(Session["UserID"].ToString()); obj._sessionid = Session["Current"].ToString(); obj._orderid = Convert.ToInt64("0"); DataSet ds = new DataSet(); ds = obj.cart_details(); using (order objc = new order()) { WebClient client = new WebClient(); String htmlcode = client.DownloadString(Server.MapPath("Order.htm")); htmlcode = htmlcode.Replace("###username###", Session["Name"].ToString()); htmlcode = htmlcode.Replace("###credit###", lbltotals.Text.ToString()); MailMessage mail = new MailMessage(); mail.From = new MailAddress("*****@*****.**", "Dream Multimedia"); mail.To.Add(Session["Email"].ToString()); mail.Subject = "Order Massage"; string Body = htmlcode; mail.Body = Body; mail.IsBodyHtml = true; Attachment ob; //ob= new Attachment(Server.MapPath("my_friends_166225.jpg")); //mail.Attachments.Add(ob); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { objc._uid = Convert.ToInt64(Session["UserID"].ToString()); objc._date = Convert.ToDateTime(System.DateTime.Now); objc._cname = ds.Tables[0].Rows[i]["cname"].ToString(); objc._pname = ds.Tables[0].Rows[i]["pdname"].ToString(); objc._pcode = ds.Tables[0].Rows[i]["pcode"].ToString(); objc._image = ds.Tables[0].Rows[i]["image"].ToString(); objc._res = ds.Tables[0].Rows[i]["res"].ToString(); objc._size = ds.Tables[0].Rows[i]["size"].ToString(); objc._credit = Convert.ToInt64(ds.Tables[0].Rows[i]["credit"].ToString()); objc._prname = ds.Tables[0].Rows[i]["prname"].ToString(); Int64 ppid = Convert.ToInt64(ds.Tables[0].Rows[i]["PPID"].ToString()); objc._ppid = Convert.ToInt64(ds.Tables[0].Rows[i]["PPID"].ToString()); objc.order_insert(); using (productparameter obcpp = new productparameter()) { DataSet pp = new DataSet(); obcpp.id = ppid; pp = obcpp.productparameter_select_byid(); ob = new Attachment(Server.MapPath("Admin\\upload\\orignal\\") + pp.Tables[0].Rows[0]["OProduct"].ToString()); mail.Attachments.Add(ob); } } SmtpClient smtp = new SmtpClient(); smtp.Host = "smtp.gmail.com"; //Or Your SMTP Server Address smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Dream143"); smtp.EnableSsl = true; // Other then smtp.gmail.com = false; smtp.Send(mail); mail = null; smtp = null; } obj._orderid = Convert.ToInt64("1"); obj.cart_updateorderid(); } } else { Response.Redirect("Packagesub.aspx"); } } Response.Redirect("Currentorder.aspx"); } }