public static Cart CreateCart()
{
using (ArtShopEntities db = new ArtShopEntities())
{
Cart newCart = new Cart();
newCart.user_id = (Guid)getLoginUser().ProviderUserKey;
if (newCart.user_id == null)
{
return(null);
}
if (db.Carts.Count() == 0)
{
newCart.id = 1;
}
else
{
newCart.id = db.Carts.OrderByDescending(u => u.id).FirstOrDefault().id + 1;
}
try
{
db.Carts.Add(newCart);
db.SaveChanges();
return(newCart);
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Hello " + Functions.getLoginUser().UserName + " !!",
"Hi, new user you can click \"Shopping Cart\" navigation at the top to check you cart!!"));
}
catch (Exception e)
{
return(null);
}
}
}
public void AddPageNode()
{
string sql = "SELECT Pages.parent_id FROM [Pages] Group By Pages.parent_id Order By Pages.parent_id";
string sql2 = "SELECT [Pages].Id FROM [Pages] WHERE [Pages].parent_id = -1";
List <int> parent_id, id = new List <int>();
Page page;
List <Page> pages;
SiteMapNode siteMapNode, detailsNode;
using (ArtShopEntities db = new ArtShopEntities())
{
parent_id = db.Database.SqlQuery <int>(sql).ToList();
id = db.Database.SqlQuery <int>(sql2).ToList();
foreach (int x in id)
{
page = db.Pages.Find(x);
pages = db.Pages.SqlQuery("SELECT * FROM [Pages] WHERE [Pages].parent_id = " + x).ToList();
siteMapNode = new SiteMapNode(this, x + "key1", page.file_name, page.title, page.description);
AddNode(siteMapNode, parentNode);
if (pages.Count > 0)
{
foreach (Page page1 in pages)
{
detailsNode = new SiteMapNode(this, page1.Id + "key2", page1.file_name, page1.title, page1.description);
AddNode(detailsNode, siteMapNode);
}
}
}
}
}
private void deleterowdata(int cart_id, int art_id)
{
try
{
using (ArtShopEntities db = new ArtShopEntities())
{
CartDetail c = db.CartDetails.Find(cart_id, art_id);
db.CartDetails.Remove(c);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
2,
Notifications.SUCCESS_TYPE,
"Deleted Sucessful!!",
"you have remove item form your cart !!"));
}
}
catch (Exception e)
{
Functions.EnqueueNewNotifications(new Notifications(
2,
Notifications.ERROR_TYPE,
"Deleted Failed!!",
"you have following exception : " + e.Message + " !!"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
setValidatorAndVisible(true);
if (editMode)
{
using (ArtShopEntities db = new ArtShopEntities())
{
try
{
Art art = db.Arts.Find(int.Parse(artId));
this.putData(art);
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Art not found!!",
"you have following exception : " + ex.Message + " !!"));
}
}
btnSubmit.Text = "Updates Art";
}
}
}
protected List <Art> OrderDetailsDataTable(Guid order_id)
{
string sql = "SELECT Art.art_id as id, Art.[image] as [image], " +
"Art.date as date, " +
"[UserExtension].first_name + ' ' + [UserExtension].last_name as [description], " +
"Art.price as price, [PaymentDetails].product_quantity as artist_id, " +
"Art.[title] as [title] " +
"FROM [Art], [PaymentDetails], [UserExtension] " +
"WHERE PaymentDetails.payment_id = @order_id AND " +
"Art.artist_id = [UserExtension].[UserId] AND " +
"art_id = PaymentDetails.art_id";
using (ArtShopEntities db = new ArtShopEntities())
{
try
{
var da = db.Arts.SqlQuery(sql, new SqlParameter("@order_id", order_id));
return(da.ToList());
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"2 Rocord searching!!",
"<strong>You had occur an error in RepeaterOrder_ItemDataBound!!!</strong> " + ex.Message + "<br />"));
}
}
return(null);
}
protected string convert_user_role(Guid user_r)
{
using (ArtShopEntities db = new ArtShopEntities())
{
return(db.PaymentStatus.Find(user_r).name);
}
}
protected void confirmPayment(object sender, EventArgs e)
{
using (ArtShopEntities db = new ArtShopEntities())
{
bank.amount -= (decimal)payments.total_pay;
payments.payment_status = Guid.Parse("c595596d-8980-4138-bc20-a91056e1b1ce");
payments.payment_method = Guid.Parse("1c98a7a8-6449-4ca4-be81-8b21f1cc12e0");
payments.payment_meta = bank.bank_account;
payments.customer_paid = payments.total_pay;
payments.payment_date = DateTime.Now;
db.Payments.AddOrUpdate(payments);
db.PublicBanks.AddOrUpdate(bank);
try
{
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Payment sucessfull!!",
"you have complete the payment using following account: " + bank.bank_account + ""));
Functions.sendPaymentMail(payments);
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Payment Failed!!",
"you have following exception : " + ex.Message + " !!"));
}
}
}
private void retriveDataAndAnalysis(ArtShopEntities db)
{
IQueryable <vw_customer_cart2> x = db.vw_customer_cart2.Where(s => s.user_id == id);
vw_customer_cart2[] y = x.ToArray();
Painting paint;
for (int i = 0; i < x.Count(); i++)
{
if (y[i].@virtual)
{
if (y[i].@checked ?? false)
{
total += Convert.ToDouble(y[i].price);
checkedCount++;
}
}
else
{
if (y[i].@checked ?? false)
{
checkedCount++;
total += (Convert.ToDouble(y[i].price) * (double)y[i].availability);
}
}
}
totalCount = x.Count();
this.lblCount.Text = checkedCount + "";
this.lblTotal.Text = totalCount + "";
this.lblTotalPrice.Text = "RM " + total.ToString("0.00");
}
public void ProcessRequest(HttpContext context)
{
string guid = context.Request.QueryString["guid"].ToString();
string _default = context.Request.QueryString["default"].ToString();
byte[] data = null;
Artist artist;
using (ArtShopEntities db = new ArtShopEntities())
{
artist = db.Artists.Find(Guid.Parse(guid));
data = artist.signature;
}
try
{
if (data != null)
{
context.Response.BinaryWrite(data);
}
else
{
context.Response.BinaryWrite(
Functions.ImmageAssetToByte(getSelectionImage(_default))
);
}
}
catch
{
context.Response.BinaryWrite(
Functions.ImmageAssetToByte(getSelectionImage(_default))
);
}
}
protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
{
var chk = (CheckBox)sender;
var CommandName = chk.Attributes["CommandName"];
int id = int.Parse(CommandName);
using (ArtShopEntities db = new ArtShopEntities())
{
try
{
CartDetail cd = db.Carts.Find(cart_id).CartDetails.Where(c => c.art_id == id).FirstOrDefault();
cd.@checked = chk.Checked;
db.CartDetails.AddOrUpdate(cd);
db.SaveChanges();
total = 0;
totalCount = 0;
checkedCount = 0;
if (check_cart_count(db))
{
retriveDataAndAnalysis(db);
}
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Deleted Failed!!",
"you have following exception : " + ex.Message + " !!"));
}
}
Repeater2.DataBind();
}
protected void Delete(object sender, EventArgs e)
{
Button btn = (Button)sender;
int x = int.Parse(btn.CommandArgument);
using (ArtShopEntities db = new ArtShopEntities())
{
Art art = db.Arts.Find(x);
if (art != null)
{
try {
db.Arts.Remove(art);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Deleted Sucessful!!",
"you have deleted sucessful !!"));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Deleted Failed!!",
"you have following exception : " + ex.Message + " !!"));
}
}
else
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Deleted Failed!!",
"Art not founds !!"));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (ArtShopEntities db = new ArtShopEntities())
{
loginUser = (Guid)Functions.getLoginUser().ProviderUserKey;
putData(db.aspnet_Users.Find(loginUser));
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (ArtShopEntities db = new ArtShopEntities())
{
art = db.Arts.Find(int.Parse(Request.QueryString["id"]));
quantity.Enabled = !art.@virtual;
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (ArtShopEntities db = new ArtShopEntities())
{
List <Art> ts = db.Arts.ToList();
Repeater1.DataSource = ts.GetRange(0, ts.Count >= 5?5:ts.Count);
Repeater1.DataBind();
}
}
protected Art getData(ArtShopEntities db)
{
Art art = new Art();
// Art atr2;
art.title = this.TitleText.Text;
art.description = this.Discription.Text;
art.date = this.DateCreation.Text;
art.price = decimal.Parse(this.Price.Text);
art.artist_id = (Guid)Functions.getLoginUser().ProviderUserKey;
JArray data = (JArray)JsonConvert.DeserializeObject(realCatergory.Value);
string fileName = art.id + "-" + art.title.Replace(" ", "-");
string exe = new FileInfo(xFileUpload.PostedFile.FileName).Extension;
art.image = "/assets/image/Art/" + fileName + exe;
art.@virtual = Virtual.Checked;
xFileUpload.SaveAs(Server.MapPath("~/assets/image/Art/") + fileName + exe);
for (int i = 0; i < data.Count; i++)
{
art.Categories.Add(db.Categories.Find(data[i].ToObject <int>()));
}
if (!Virtual.Checked)
{
art.Categories.Add(db.Categories.Find(7));
}
else
{
art.Categories.Add(db.Categories.Find(8));
}
if (!Virtual.Checked)
{
Painting p = new Painting();
p.art_id = art.id;
p.quantity = int.Parse(this.txbQuantity.Text);
p.weight_g = int.Parse(this.txbWeight.Text);
p.lenght_mm = int.Parse(this.txbLL.Text);
p.width_mm = int.Parse(this.txbWW.Text);
p.height_mm = int.Parse(this.txbHH.Text);
p.Address = db.Addresses.Find(Guid.Parse(ddlAddress.SelectedValue));
art.Painting = p;
}
if (!this.editMode)
{
art.id = db.Arts.OrderByDescending(u => u.id).FirstOrDefault().id + 1;;
}
else
{
art.id = int.Parse(artId);
}
return(art);
}
protected string setCatergory(int cat_id)
{
string r = "";
using (ArtShopEntities db = new ArtShopEntities())
{
r = db.Categories.Find(cat_id).name;
}
return(r);
}
protected void Page_Init(object sender, EventArgs e)
{
SqlDataSource1.SelectParameters.Add("UserId", Functions.getLoginUser().ProviderUserKey.ToString());
using (ArtShopEntities db = new ArtShopEntities())
{
allcats = new List <CategoryCopy>();
int p_level = Roles.GetRolesForUser().Contains("Administrator") ? 1 : 0;
db.Categories.Where(c => c.enable == true && c.permission_level <= p_level)
.ToList().ForEach(c => allcats.Add(new CategoryCopy(c)));
allCatStr = JsonConvert.SerializeObject(allcats);
}
artId = Request.QueryString["id"];
editMode = artId != null;
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = this.CardName.Text;
string pass = this.CardPass.Text;
using (ArtShopEntities db = new ArtShopEntities())
{
PublicBank database = db.PublicBanks.Find(name);
modal.Payment payments = db.Payments.Find(paymentId);
if (database == null)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Invalid card number!!",
"Wrong card numbers"));
return;
}
if (database.bank_username != name)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Unassessable!!",
"Username not match"));
return;
}
if (database.password != pass)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Unassessable!!",
"Password not match"));
return;
}
if ((double)database.amount < payments.total_pay)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Not enought amount!!",
"Your card is only remain " + database.amount));
return;
}
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Login sucessfull!!",
"Welcome, " + database.bank_username));
Session[Constant.ACCOUNT_SESSION] = database.bank_account;
Response.Redirect("~/pages/Payment/PublicBank.aspx?id=" + this.paymentId);
}
}
private static void checkAddressExcite(string latlng_text, out bool created, out float lat, out float lng)
{
created = false;
dynamic latlng = JsonConvert.DeserializeObject(latlng_text);
lat = latlng["lat"];
lng = latlng["lng"];
using (ArtShopEntities db = new ArtShopEntities())
{
Address[] addresss = db.Addresses.ToArray();
for (int i = 0; i < addresss.Length; i++)
{
if ((addresss[i].latitude == lat && addresss[i].longitude == lng))
{
created = true;
if (db.UserAddresses.Find(Functions.getLoginUser().ProviderUserKey, addresss[i].id) != null)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Address excites",
"This address is been added to yours preference"));
}
else
{
try
{
UserAddress userAddress = new UserAddress();
userAddress.address_id = addresss[i].id;
userAddress.UserId = (Guid)Functions.getLoginUser().ProviderUserKey;
db.UserExtensions.Find(Functions.getLoginUser().ProviderUserKey).UserAddresses.Add(userAddress);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Adding successful",
"Your new reference address is updates to your profiles"));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Unknows error founds 2",
"Error : " + ex.Message));
}
}
}
}
}
}
private bool check_cart_count(ArtShopEntities db)
{
Cart cart_record = db.Carts.Where(s => s.user_id == id).FirstOrDefault();
if (cart_record != null ? cart_record.CartDetails.Count > 0 : false)
{
cart_id = cart_record.id;
GotCart.Visible = true;
NoCartFound.Visible = false;
return(true);
}
else
{
NoCartFound.Visible = true;
GotCart.Visible = false;
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
param_id = Request.QueryString["id"];
param_type = Request.QueryString["type"];
display_in_map = (param_type == "show" || param_type == "edit");
procide_map.Enabled = !display_in_map;
if (display_in_map)
{
using (ArtShopEntities db = new ArtShopEntities())
{
address = db.Addresses.Find(Guid.Parse(param_id));
}
procide_map.Text = "View Only";
}
if (param_type == "remove")
{
using (ArtShopEntities db = new ArtShopEntities())
{
try
{
Address add = db.Addresses.Find(Guid.Parse(param_id));
UserAddress userAddress = new UserAddress();
userAddress.UserId = (Guid)Functions.getLoginUser().ProviderUserKey;
userAddress.address_id = add.id;
userAddress = db.UserAddresses.Find(Functions.getLoginUser().ProviderUserKey, add.id);
db.UserAddresses.Remove(userAddress);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Address removed !!",
"The reference address is removed form your prefrence list."));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Unknows error founds",
"Error : " + ex.Message));
}
}
Response.Redirect("MyAccount.aspx?");
}
}
protected void updatesData(ArtShopEntities db)
{
UserExtension ux = db.UserExtensions.Find(loginUser);
aspnet_Membership am = db.aspnet_Membership.Find(loginUser);
ux.first_name = this.firstName.Text;
ux.last_name = this.lastName.Text;
if (this.radioMale.Checked)
{
ux.gender = "Male";
}
else
{
ux.gender = "Female";
}
db.aspnet_Membership.AddOrUpdate(am);
db.UserExtensions.AddOrUpdate(ux);
}
public static bool checkValidPayment(String param)
{
Guid id;
if (param == null)
{
HttpContext.Current.Response.Redirect("~/pages/Payment/PaymentInvalid.aspx");
return(false);
}
id = Guid.Parse(param);
if (id == null)
{
HttpContext.Current.Response.Redirect("~/pages/Payment/PaymentInvalid.aspx");
return(false);
}
using (ArtShopEntities db = new ArtShopEntities())
{
Payment p = db.Payments.Find(id);
if (p == null)
{
HttpContext.Current.Response.Redirect("~/pages/Payment/PaymentInvalid.aspx");
return(false);
}
switch (p.PaymentStatu.id.ToString())
{
case "80e85ebb-7401-45be-8080-4d16df2177bf":
return(true);
break; //Fail
case "20bd9f32-b531-4b7f-a89a-80babe9aa707":
return(true);
break; //Padding
default:
HttpContext.Current.Response.Redirect("~/pages/Payment/PaymentInvalid.aspx");
return(false);
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Functions.checkValidPayment(Request.QueryString["id"]);
paymentId = Guid.Parse(Request.QueryString["id"]);
if (Session[Constant.ACCOUNT_SESSION] == null)
{
Response.Redirect("~");
return;
}
using (ArtShopEntities db = new ArtShopEntities())
{
bank = db.PublicBanks.Find(Session[Constant.ACCOUNT_SESSION]);
payments = db.Payments.Find(paymentId);
CardName.Text = bank.bank_account;
CardPass.Text = DateTime.Now.ToString();
Label1.Text = payments.total_pay.ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
using (ArtShopEntities db = new ArtShopEntities())
{
try
{
updatesData(db);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Updates completed", "Your informations is up to date"));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Updates fail", ex.Message));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = (Guid)Functions.getLoginUser().ProviderUserKey;
if (!Page.IsPostBack)
{
SqlDataSource1.SelectParameters.Add("user_id", DbType.Guid, id.ToString());
SqlDataSource2.SelectParameters.Add("user_id", DbType.Guid, id.ToString());
}
using (ArtShopEntities db = new ArtShopEntities())
{
total = 0;
totalCount = 0;
checkedCount = 0;
if (check_cart_count(db))
{
retriveDataAndAnalysis(db);
}
//totalprice.Text = "Total price : RM" + total.ToString();
}
}
public void AddPaymentNode()
{
SiteMapNode siteMapNode = new SiteMapNode(this, "Haha-1", "Payment Node", "Payment", "Procide payment");
AddNode(siteMapNode, parentNode);
List <Payment> orders;
using (ArtShopEntities db = new ArtShopEntities())
{
orders = db.Payments.SqlQuery("SELECT * FROM [Payment]").ToList();
foreach (Payment pay in orders)
{
AddNode(
new SiteMapNode(this,
pay.id + "-payment",
PAGE_DIR + "Payment.aspx?order=" + pay.id.ToString(),
pay.id.ToString(),
pay.id.ToString()),
siteMapNode);
}
}
}
public void AddProductNode()
{
SiteMapNode siteMapNode = new SiteMapNode(this, "Haha-2", "Product Node", "Product", "The Art Sales.com sell");
AddNode(siteMapNode, parentNode);
List <Art> arts;
using (ArtShopEntities db = new ArtShopEntities())
{
arts = db.Arts.SqlQuery("SELECT * FROM [Art]").ToList();
foreach (Art art in arts)
{
AddNode(
new SiteMapNode(this,
art.id + "-art-products",
PAGE_DIR + "main/ArtShop/ArtShop_Cust_Details.aspx?id=" +
art.id,
art.title,
art.title),
siteMapNode);
}
}
}
protected void updates()
{
using (ArtShopEntities db = new ArtShopEntities())
{
Art art = getData(db);
try
{
db.Arts.AddOrUpdate(art);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Update completed",
"you have done the updates !!"));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Update Failed!!",
"you have following exception : " + ex.Message + " !!"));
}
}
Response.Redirect("ReadUpdateDeleteArt.aspx");
}
public void addAddress()
{
string address_text = this.form_address.Value;
string latlng_text = this.form_latlng.Value;
Console.Out.WriteLine("procide_map_Click");
if (latlng_text.Length <= 0)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"No address selected",
"Please select a address to procide"));
return;
}
bool created;
float lat, lng;
checkAddressExcite(latlng_text, out created, out lat, out lng);
if (created)
{
return;
}
dynamic result = MapApiProvider.GetReverseGeocoding(lat, lng);
JArray resultsDetails = result["results"];
if (result["status"] == "OK" ? resultsDetails.Count > 0 : false)
{
Address address = decodeGeoAddress(resultsDetails);
using (ArtShopEntities db = new ArtShopEntities())
{
Address old_address = db.Addresses.Where(
q => q.street == address.street &&
q.city == address.city &&
q.state == address.state &&
q.poscode == address.poscode &&
q.country == address.country
).FirstOrDefault();
if (old_address != null ? db.UserAddresses.Find(Functions.getLoginUser().ProviderUserKey, old_address.id) != null: false)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Address excites",
"This address is been added to yours preference"));
}
else
{
try
{
UserAddress userAddress = new UserAddress();
userAddress.UserId = (Guid)Functions.getLoginUser().ProviderUserKey;
address.id = Guid.NewGuid();
if (old_address != null)
{
userAddress.address_id = old_address.id;
}
else
{
userAddress.Address = address;
}
db.UserExtensions.Find(Functions.getLoginUser().ProviderUserKey).UserAddresses.Add(userAddress);
db.SaveChanges();
Functions.EnqueueNewNotifications(new Notifications(
Notifications.SUCCESS_TYPE,
"Adding successfu",
"Your new reference address is updates to your profiles"));
}
catch (Exception ex)
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Unknows error founds 1",
"Error : " + ex.Message));
}
}
}
}
else
{
Functions.EnqueueNewNotifications(new Notifications(
Notifications.ERROR_TYPE,
"Google Map API Error!",
result["status"] + ": " + result["error_message"] + " !!"));
}
}
