public int Create(Brand item)
{
Entity.Brand brand = new Entity.Brand();
brand.id = item.id;
brand.name = item.name;
database.Brands.Add(brand);
database.SaveChanges();
return(1);
}
public int Create(CategoryView item)
{
Entity.Category cate = new Entity.Category()
{
id = item.id, name_category = item.name_category, status = item.status
};
database.Categories.Add(cate);
database.SaveChanges();
return(cate.id);
}
public int Create(CustomerView item)
{
try
{
Models.Entity.Customer c = new Entity.Customer()
{
first_name = item.first_name, last_name = item.last_name, phone = item.phone, email = item.email, address = item.address, username = item.username, password = item.password, status = item.status
};
db.Customers.Add(c);
db.SaveChanges();
return(1);
}
catch (EntityException ex)
{
Debug.WriteLine(ex.Message);
return(0);
}
}
public int Create(OrderDetail item)
{
Entity.OrderDetail orderD = new Entity.OrderDetail()
{
id = item.id, id_orders = item.id_orders, id_product = item.id_product, quantity = item.quantity, sub_total = item.sub_total, status = item.status
};
database.OrderDetails.Add(orderD);
database.SaveChanges();
return(1);
}
public int Create(OrderView item)
{
Models.Entity.Order order = new Entity.Order()
{
id = item.id, email_order = item.email_order, address_order = item.address_order, phone_order = item.phone_order, id_customer = item.id_customer, order_date = item.order_date, total = item.total, status = item.status
};
database.Orders.Add(order);
database.SaveChanges();
return(order.id);
}
public int Create(ProductView item)
{
try
{
if (checkNameProduct(item.name_product) == false)
{
Entity.Product pro = new Entity.Product()
{
id = item.id, name_product = item.name_product, name_image = item.name_image, id_brand = item.id_brand, id_category = item.id_category, description = item.description, discount = item.discount, price = item.price, created = item.created, status = item.status
};
database.Products.Add(pro);
database.SaveChanges();
return(1);
}
return(0);
}
catch (Exception)
{
return(0);
}
}
public ActionResult Forget_Password()
{
Models.Dao.Security s = new Models.Dao.Security();
Models.Entity.ChocoGearEntities db = new Models.Entity.ChocoGearEntities();
var username = Request.Form["user"];
var email = Request.Form["email"];
var string_default = "aptechloveindia";
var tmp = username + string_default;
var tmp1 = s.Base64(tmp);
var tmp2 = s.MD5Hash(tmp1);
if (s.Check_email_username(email, username))
{
var q = db.Customers.Single(d => d.email == email && d.username == username);
q.password = tmp2;
db.SaveChanges();
//Send Mail
var senderEmail = new MailAddress("*****@*****.**", "ChocoGear");
var receiverEmail = new MailAddress(email, "Receiver");
var password = "******";
var sub = "Order Gear";
var body = string_default;
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(senderEmail.Address, password)
};
using (var mess = new MailMessage(senderEmail, receiverEmail)
{
Subject = sub,
Body = body
})
{
smtp.Send(mess);
}
return(Json("Success"));
}
else
{
return(Json("Email, Username are not available"));
}
}
public int Create(FeedBackView item)
{
try
{
Entity.Feedback fb = new Entity.Feedback()
{
id = item.id, email = item.email, content = item.content, created = item.created, status = item.status
};
db.Feedbacks.Add(fb);
db.SaveChanges();
return(1);
}
catch (Exception)
{
return(0);
}
}
public ActionResult Create_ChangePassword()
{
var id = int.Parse(Request.Form["id_cus"]);
var username = Request.Form["username"];
var password_old = Request.Form["pass_old"];
var password_new = Request.Form["pass_new"];
var password_new_cf = Request.Form["pass_new_cf"];
Models.Dao.Security s = new Models.Dao.Security();
var tmp_old = username + password_old;
var tmp_old1 = s.Base64(tmp_old);
var tmp_old2 = s.MD5Hash(tmp_old1);
var tmp_new = username + password_new;
var tmp_new1 = s.Base64(tmp_new);
var tmp_new2 = s.MD5Hash(tmp_new1);
Models.Entity.ChocoGearEntities db = new Models.Entity.ChocoGearEntities();
if (password_old == "" || password_new == "" || password_new_cf == "")
{
var a = "Please fill in your PassWord";
return(Json(a));
}
else
{
if (tmp_old2 == tmp_new2)
{
return(Json("Password already exists"));
}
else
{
if (s.CheckPass(tmp_old2))
{
var q = db.Customers.Single(d => d.id == id);
q.password = tmp_new2;
db.SaveChanges();
return(Json("Success"));
}
else
{
return(Json("PassWord Old Wrong"));
}
}
}
}
