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