protected void btnUpdate_Click(object sender, EventArgs e)
{
u.Email = tbEmail.Text;
Membership.UpdateUser(u);
Int32 day = Int32.Parse(ddlDay.SelectedValue);
Int32 month = Int32.Parse(ddlMonth.SelectedValue);
Int32 year = Int32.Parse(ddlYear.SelectedValue);
Int32 Age = DateTime.Now.Year - year;
DateTime DOB = new DateTime(year, month, day);
if (artist != null)
{
artist.ContactNo = tbContact.Text;
artist.Name = tbName.Text;
artist.Address = tbAddress.Text;
artist.Age = Age;
artist.DateOfBirth = DOB;
_db.ARTISTs.Attach(artist);
_db.Entry(artist).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
}
else
{
customer.ContactNo = tbContact.Text;
customer.Name = tbName.Text;
customer.Address = tbAddress.Text;
customer.Age = Age;
customer.DateOfBirth = DOB;
_db.CUSTOMERs.Attach(customer);
_db.Entry(customer).State = System.Data.Entity.EntityState.Modified;
_db.SaveChanges();
}
Response.Redirect("~/UpdateProfile.aspx");
}
protected void btnAddToCart_Click(object sender, EventArgs e)
{
//Get the reference of the clicked button.
Button button = (sender as Button);
//Get the command argument
string[] commandArgument = button.CommandArgument.ToString().Split(';');
int wishlistId = Convert.ToInt32(commandArgument[0]);
int productId = Convert.ToInt32(commandArgument[1]);
//System.Diagnostics.Debug.WriteLine(wishlistId + "," + productId);
ShoppingCart sc = new ShoppingCart();
sc.AddToCart(productId);
GalleryEntities1 db = new GalleryEntities1();
var item = new WISHLIST {
WishlistId = wishlistId
};
db.Entry(item).State = EntityState.Deleted;
try
{
db.SaveChanges();
Response.Redirect("~/Wishlistaspx.aspx");
}
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", wishlistId));
}
}
protected void DeleteButton_Click(object sender, ImageClickEventArgs e)
{
//Get the reference of the clicked button.
ImageButton button = (sender as ImageButton);
//Get the command argument
string commandArgument = button.CommandArgument;
int wishlistid = int.Parse(commandArgument);
GalleryEntities1 db = new GalleryEntities1();
var item = new WISHLIST {
WishlistId = wishlistid
};
db.Entry(item).State = EntityState.Deleted;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", wishlistid));
}
}
protected void CreateUserWizard1_CreatedUser(Object sender, EventArgs e)
{
MembershipUser newUser = Membership.GetUser(CreateUserWizard1.UserName);
Guid newUserId = (Guid)newUser.ProviderUserKey;
string Name = ((TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Name")).Text;
string Address = ((TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Address")).Text;
string Contact = ((TextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Contact")).Text;
DropDownList ddlYear = (DropDownList)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Year");
DropDownList ddlMonth = (DropDownList)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Month");
DropDownList ddlDay = (DropDownList)CreateUserWizardStep1.ContentTemplateContainer.FindControl("Day");
Int32 day = Int32.Parse(ddlDay.SelectedValue);
Int32 month = Int32.Parse(ddlMonth.SelectedValue);
Int32 year = Int32.Parse(ddlYear.SelectedValue);
Int32 Age = DateTime.Now.Year - year;
DateTime DOB = new DateTime(year, month, day);
DropDownList registerAs = (DropDownList)(CreateUserWizardStep1.ContentTemplateContainer.FindControl("registerAs"));
String value = registerAs.SelectedValue;
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
SqlCommand mycommand = null;
if (value.Equals("Members"))
{
mycommand = new SqlCommand("new_user", myConnection);
}
else
{
mycommand = new SqlCommand("new_artist", myConnection);
}
mycommand.CommandType = System.Data.CommandType.StoredProcedure;
mycommand.Parameters.Add("Name", SqlDbType.VarChar).Value = Name;
mycommand.Parameters.Add("Address", SqlDbType.VarChar).Value = Address;
mycommand.Parameters.Add("DateOfBirth", SqlDbType.Date).Value = DOB.Date;
mycommand.Parameters.Add("UserId", SqlDbType.UniqueIdentifier).Value = newUserId;
mycommand.Parameters.Add("Age", SqlDbType.Int).Value = Age;
mycommand.Parameters.Add("Contact", SqlDbType.VarChar).Value = Contact;
myConnection.Open();
mycommand.ExecuteNonQuery();
myConnection.Close();
Roles.AddUserToRole(CreateUserWizard1.UserName, value);
}
GalleryEntities1 _db = new GalleryEntities1();
CART cart = new Models.CART();
cart.UserId = newUserId;
cart.Date = DateTime.Now;
cart.Discount = 0;
_db.CARTs.Add(cart);
_db.SaveChanges();
HttpContext.Current.Session["CartId"] = cart.CartId;
}
protected void btnPayment_Click(object sender, EventArgs e)
{
GalleryEntities1 _db = new GalleryEntities1();
ShoppingCart cs = new ShoppingCart();
List <CARTITEM> orderItem = cs.GetCartItems();
ORDER order = new ORDER
{
date = DateTime.Now,
discount = 0,
UserId = (Guid)u.ProviderUserKey,
//PaymentId = null,
status = "pending"
};
_db.ORDERs.Add(order);
_db.SaveChanges();
for (int i = 0; i < orderItem.Count(); i++)
{
ORDERDETAIL orderDetail = new ORDERDETAIL();
orderDetail.ProductId = orderItem[i].ProductId;
orderDetail.OrderId = order.OrderId;
orderDetail.Quantity = orderItem[i].Quantity;
orderDetail.TotalPrice = (orderItem[i].Quantity * _db.PRODUCTs.Find(orderItem[i].ProductId).Price);
_db.ORDERDETAILs.Add(orderDetail);
_db.SaveChanges();
}
Session["total"] = cs.GetTotal().ToString();
Session["orderid"] = order.OrderId.ToString();
Response.Redirect("~/Payment.aspx");
}
protected void btnWishlist_Click(object sender, EventArgs e)
{
bool loginStatus = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated;
if (loginStatus)
{
GalleryEntities1 _db = new GalleryEntities1();
int productID = Convert.ToInt32(Request.QueryString["ProductID"]);
Guid userId = (Guid)Membership.GetUser().ProviderUserKey;
var existingItem = from w in _db.WISHLISTs
where w.ProductId == productID && w.UserId == userId
select w;
if (existingItem.Any())
{
successAdd.Style["display"] = "none";
failedAdd.Style["display"] = "block";
System.Diagnostics.Debug.WriteLine("exist");
}
else
{
WISHLIST item = new WISHLIST();
item.ProductId = productID;
item.UserId = userId;
if (ModelState.IsValid)
{
// Save changes here
_db.WISHLISTs.Add(item);
_db.SaveChanges();
successAdd.Style["display"] = "block";
failedAdd.Style["display"] = "none";
}
System.Diagnostics.Debug.WriteLine("not exist");
}
}
else
{
MasterPage masterPage = this.Master as MasterPage;
ModalPopupExtender ModalPopupExtender1 = (ModalPopupExtender)masterPage.FindControl("ModalPopupExtender1");
ModalPopupExtender1.Show();
}
}
//Update the item in the database
public void UpdateItem(int updateCartID, int updateProductID, int quantity)
{
using (var _db = new GalleryEntities1())
{
try
{
var myItem = (from c in _db.CARTITEMs where c.CartId == updateCartID && c.PRODUCT.ProductId == updateProductID select c).FirstOrDefault();
if (myItem != null)
{
myItem.Quantity = quantity;
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
}
}
}
public void FormViewPayment_InsertItem()
{
String orderid = (String)Session["orderid"];
int orderidInt = Convert.ToInt32(Session["orderid"]);
TextBox address = (TextBox)FormViewPayment.FindControl("txtboxAddress");
Session["address"] = address.Text;
using (var _db1 = new GalleryEntities1())
{
try
{
var myItem = (from c in _db1.ORDERs where c.OrderId == orderidInt select c).FirstOrDefault();
if (myItem != null)
{
myItem.status = "Paid";
_db1.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Update Order Status - " + exp.Message.ToString(), exp);
}
PAYMENT payment = new PAYMENT();
TryUpdateModel(payment);
payment.Date = DateTime.Now;
payment.OrderId = orderid;
// Guid userId = (Guid)Membership.GetUser().ProviderUserKey;
if (ModelState.IsValid)
{
GalleryEntities1 _db = new GalleryEntities1();
_db.PAYMENTs.Add(payment);
_db.SaveChanges();
}
Response.Redirect("~/PaymentSucess.aspx");
}
}
//Remove the item from the database
public void RemoveItem(int removeCartID, int removeProductID)
{
using (var _db = new GalleryEntities1())
{
try
{
var myItem = (from c in _db.CARTITEMs where c.CartId == removeCartID && c.PRODUCT.ProductId == removeProductID select c).FirstOrDefault();
if (myItem != null)
{
// Remove Item.
_db.CARTITEMs.Remove(myItem);
_db.SaveChanges();
}
}
catch (Exception exp)
{
throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp);
}
}
}
// The id parameter name should match the DataKeyNames value set on the control
public void fvAddItem_UpdateItem([QueryString] int ProductId)
{
Testing.Models.PRODUCT item = null;
GalleryEntities1 _db = new GalleryEntities1();
item = _db.PRODUCTs.Find(ProductId);
// Load the item here, e.g. item = MyDataLayer.Find(id);
if (item == null)
{
// The item wasn't found
ModelState.AddModelError("", String.Format("Item with id {0} was not found", ProductId));
return;
}
TryUpdateModel(item);
//To convert the image to binary
FileUpload imageUpload = (FileUpload)fvAddItem.FindControl("imageUpload");
HttpPostedFile postedFile = imageUpload.PostedFile;
string fileName = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(fileName);
int fileSize = postedFile.ContentLength;
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" ||
fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
Stream stream = postedFile.InputStream;
BinaryReader binaryReader = new BinaryReader(stream);
byte[] bytes = binaryReader.ReadBytes((int)stream.Length);
item.Image = bytes;
}
if (ModelState.IsValid)
{
// Save changes here, e.g. MyDataLayer.SaveChanges();
_db.SaveChanges();
Response.Redirect("~/UpdateGallery.aspx");
}
}
public void fvAddItem_InsertItem()
{
var item = new PRODUCT();
TryUpdateModel(item);
//Get the username for the currently logged in user
Guid userId = (Guid)Membership.GetUser().ProviderUserKey;
item.ArtistId = userId;
//To convert the image to binary
FileUpload imageUpload = (FileUpload)fvAddItem.FindControl("imageUpload");
HttpPostedFile postedFile = imageUpload.PostedFile;
string fileName = Path.GetFileName(postedFile.FileName);
string fileExtension = Path.GetExtension(fileName);
int fileSize = postedFile.ContentLength;
if (fileExtension.ToLower() == ".jpg" || fileExtension.ToLower() == ".bmp" ||
fileExtension.ToLower() == ".gif" || fileExtension.ToLower() == ".png")
{
Stream stream = postedFile.InputStream;
byte[] bytes = ResizeUploadedImage(stream);
item.Image = bytes;
}
item.Description = item.Description.Replace(Environment.NewLine, "<br />");
if (ModelState.IsValid)
{
// Save changes here
GalleryEntities1 _db = new GalleryEntities1();
_db.PRODUCTs.Add(item);
_db.SaveChanges();
Response.Redirect("~/ViewGallery.aspx");
}
}
public void fvAddProduct_InsertItem()
{
PRODUCT item = new PRODUCT();
TryUpdateModel(item);
//Get the username for the currently logged in user
MembershipUser membershipUser = Membership.GetUser("Username");
Guid userId = (Guid)membershipUser.ProviderUserKey;
item.ArtistId = userId;
Image productImage = (Image)fvAddProduct.FindControl("productImage");
byte[] imgData = System.IO.File.ReadAllBytes(Server.MapPath(productImage.ImageUrl));
item.Image = imgData;
if (ModelState.IsValid)
{
// Save changes here
GalleryEntities1 _db = new GalleryEntities1();
_db.PRODUCTs.Add(item);
_db.SaveChanges();
Response.Redirect("~/ViewGallery.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (ShoppingCart shoppingCart = new ShoppingCart())
{
shoppingCart.EmptyCart();
}
int orderid = Convert.ToInt32(Session["orderid"]);
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[4] {
new DataColumn("ProductId", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Quantity", typeof(int)),
new DataColumn("TotalPrice", typeof(Double))
});
GalleryEntities1 _db = new GalleryEntities1();
List <ORDERDETAIL> orderdetails = _db.ORDERDETAILs.Where(
c => c.OrderId == orderid).ToList();
for (int i = 0; i < orderdetails.Count; i++)
{
PRODUCT product = _db.PRODUCTs.Find(orderdetails[i].ProductId);
String stockCount = product.Stock;
int stockCountValue = Convert.ToInt32(stockCount);
stockCountValue--;
stockCount = stockCountValue.ToString();
product.Stock = stockCount;
_db.SaveChanges();
dt.Rows.Add(orderdetails[i].ProductId, product.Name, orderdetails[i].Quantity, orderdetails[i].TotalPrice);
}
GridView1.DataSource = dt;
GridView1.DataBind();
double total1 = Convert.ToDouble(Session["total"]);
// Label lblTotal = (Label)GridView1.FindControl("lblTotal");
lblTotal.Text = String.Format("{0:0.00}", total1);
//for receipt email
string companyName = "Gallery Website";
string address = Convert.ToString(Session["address"]);
int orderid1 = Convert.ToInt32(Session["orderid"]);
int orderNo = orderid1;
DataTable dt1 = new DataTable();
dt1.Columns.AddRange(new DataColumn[4] {
new DataColumn("ProductId", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("Quantity", typeof(int)),
new DataColumn("Total Price", typeof(Double))
});
GalleryEntities1 _db1 = new GalleryEntities1();
List <ORDERDETAIL> orderdetails1 = _db1.ORDERDETAILs.Where(
c => c.OrderId == orderid1).ToList();
for (int i = 0; i < orderdetails1.Count; i++)
{
PRODUCT product = _db1.PRODUCTs.Find(orderdetails1[i].ProductId);
dt1.Rows.Add(orderdetails1[i].ProductId, product.Name, orderdetails1[i].Quantity, orderdetails1[i].TotalPrice);
}
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter hw = new HtmlTextWriter(sw))
{
StringBuilder sb = new StringBuilder();
//Generate Invoice/Receipt Header.
sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");
sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'><b>Receipt</b></td></tr>");
sb.Append("<tr><td colspan = '2'></td></tr>");
sb.Append("<tr><td><b>Order No: </b>");
sb.Append(orderNo);
sb.Append("</td><td align = 'right'><b>Date: </b>");
sb.Append(DateTime.Now);
sb.Append(" </td></tr>");
sb.Append("<tr><td><b>Company Name: </b>");
sb.Append(companyName);
sb.Append("</td><td align = 'right'><b>Address: </b>");
sb.Append(address);
sb.Append("</td></tr>");
sb.Append("</table>");
sb.Append("<br />");
//Generate Invoice (Bill) Items Grid.
sb.Append("<table border = '1'>");
sb.Append("<tr>");
foreach (DataColumn column in dt1.Columns)
{
sb.Append("<th>");
sb.Append(column.ColumnName);
sb.Append("</th>");
}
sb.Append("</tr>");
foreach (DataRow row in dt1.Rows)
{
sb.Append("<tr>");
foreach (DataColumn column in dt1.Columns)
{
sb.Append("<td>");
sb.Append(row[column]);
sb.Append("</td>");
}
sb.Append("</tr>");
}
sb.Append("<tr><td align = 'right' colspan = '");
sb.Append(dt1.Columns.Count - 1);
sb.Append("'>Total</td>");
sb.Append("<td>");
double total2 = Convert.ToDouble(Session["total"]);
sb.Append(String.Format("{0:0.00}", total2));
sb.Append("</td>");
sb.Append("</tr></table>");
//Export HTML String as PDF.
StringReader sr = new StringReader(sb.ToString());
Document pdfDoc1 = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc1);
using (MemoryStream memoryStream = new MemoryStream())
{
PdfWriter writer = PdfWriter.GetInstance(pdfDoc1, memoryStream);
pdfDoc1.Open();
htmlparser.Parse(sr);
pdfDoc1.Close();
byte[] bytes = memoryStream.ToArray();
memoryStream.Close();
MembershipUser u = Membership.GetUser(User.Identity.Name);
_db = new Models.GalleryEntities1();
MailMessage mm = new MailMessage("*****@*****.**", u.Email);
mm.Subject = "Receipt PDF";
mm.Body = "Receipt PDF Attachment";
mm.Attachments.Add(new Attachment(new MemoryStream(bytes), "ReceiptPDF.pdf"));
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
System.Net.NetworkCredential NetworkCred = new System.Net.NetworkCredential();
NetworkCred.UserName = "******";
NetworkCred.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = NetworkCred;
smtp.Port = 587;
try {
smtp.Send(mm);
}catch (Exception ex)
{
Console.Write(ex.StackTrace);
}
}
}
}
}