public IList<Customer> GetAll()
{
using (var db = new CustomersEntities())
{
return db.Customers.ToList();
}
}
protected void btnAddNewCustomer_Click(object sender, EventArgs e)
{
if (CheckValidEmail(txtEmail.Text) == true) {
lblInformLabel.Text = "";
var context = new CustomersEntities();
User customer = new User();
customer.Name = txtName.Text;
customer.Email = txtEmail.Text;
customer.Address = txtAddress.Text;
customer.CityID = int.Parse(ddlCity.SelectedValue);
customer.Country = txtCountry.Text;
User add = context.User.Add(customer);
context.SaveChanges();
ClearInputs();
lblInformLabel.Text = "Customer Add";
lblInformLabel.ForeColor = System.Drawing.Color.FromArgb(22, 139, 224);
}
else if(CheckValidEmail(txtEmail.Text) == false)
{
lblInformLabel.Text = "Not valid email";
lblInformLabel.ForeColor = System.Drawing.Color.Red;
}
else
{
Response.Redirect("Default.aspx");
}
}
// GET: Checkout
public ActionResult Index()
{
ViewBag.HeaderId = "back";
ViewBag.HeaderClass = "hide";
CheckoutModel model = new CheckoutModel();
string publicKey = ConfigurationManager.AppSettings["Braintree.PublicKey"];
string privateKey = ConfigurationManager.AppSettings["Braintree.PrivateKey"];
string environment = ConfigurationManager.AppSettings["Braintree.Environment"];
string merchantId = ConfigurationManager.AppSettings["Braintree.MerchantId"];
Braintree.BraintreeGateway braintree = new Braintree.BraintreeGateway(environment, merchantId, publicKey, privateKey);
using (CustomersEntities entities = new CustomersEntities())
{
var currentCustomer = entities.Customers.Single(x => x.EmailAddress == User.Identity.Name);
var currentPackage = currentCustomer.CustomerPackages.First(x => x.PurchaseDate == null);
model.Package = new PackageModel();
model.Package.Name = currentPackage.Package.Name;
model.Package.Price = currentPackage.Package.Price;
model.Package.Assistant = currentPackage.Package.Assistant;
model.Package.Task = currentPackage.Package.Task;
model.FirstName = currentCustomer.FirstName;
model.LastName = currentCustomer.LastName;
model.EmailAddress = currentCustomer.EmailAddress.Trim();
}
return(View(model));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var context = new CustomersEntities();
string ID = Request.QueryString["ID"];
int UserID = int.Parse(ID);
ddlCity.DataSource = context.City.ToList();
ddlCity.DataValueField = "ID";
ddlCity.DataTextField = "Name";
ddlCity.DataBind();
var user = context.User.Where(Name => Name.ID == UserID);
foreach (User userData in user)
{
txtAddress.Text = userData.Address;
txtCountry.Text = userData.Country;
txtEmail.Text = userData.Email;
txtName.Text = userData.Name;
var cityID = userData.CityID;
string idCity = cityID.ToString();
ddlCity.SelectedValue = idCity;
txtName.DataBind();
}
}
}
public Customer GetById(int id)
{
using (var db = new CustomersEntities())
{
return db.Customers.FirstOrDefault(c => c.Id.Equals(id));
}
}
public ActionResult Index(CheckoutModel model)
{
string publicKey = ConfigurationManager.AppSettings["Braintree.PublicKey"];
string privateKey = ConfigurationManager.AppSettings["Braintree.PrivateKey"];
string environment = ConfigurationManager.AppSettings["Braintree.Environment"];
string merchantId = ConfigurationManager.AppSettings["Braintree.MerchantId"];
Braintree.BraintreeGateway braintree = new Braintree.BraintreeGateway(environment, merchantId, publicKey, privateKey);
//int userId = -1;
if (ModelState.IsValid)
{
using (CustomersEntities entities = new CustomersEntities())
{
var currentCustomer = entities.Customers.Single(x => x.EmailAddress == User.Identity.Name);
var currentPackage = currentCustomer.CustomerPackages.First(x => x.PurchaseDate == null);
//TODO: Validate the credit card - if it errors out, add a model error and display it to the user
//TODO: Persist this information to the database
//var currentPackage = entities.Customers.Single(x => x.EmailAddress == User.Identity.Name).CustomerPackages.First(x => x.PurchaseDate == null);
//model.Package = new PackageModel();
//string publicKey = ConfigurationManager.AppSettings["Braintree.PublicKey"];
//string privateKey = ConfigurationManager.AppSettings["Braintree.PrivateKey"];
//string environment = ConfigurationManager.AppSettings["Braintree.Environment"];
//string merchantId = ConfigurationManager.AppSettings["Braintree.MerchantId"];
Braintree.CustomerRequest request = new Braintree.CustomerRequest();
request.Email = model.EmailAddress;
request.FirstName = model.FirstName;
request.LastName = model.LastName;
request.Phone = model.PhoneNumber;
request.CreditCard = new Braintree.CreditCardRequest();
request.CreditCard.Number = model.CreditCardNumber;
request.CreditCard.CardholderName = model.CreditCardName;
request.CreditCard.ExpirationMonth = (model.CreditCardExpirationMonth).ToString().PadLeft(2, '0');
request.CreditCard.ExpirationYear = model.CreditCardExpirationYear.ToString();
var customerResult = braintree.Customer.Create(request);
Braintree.TransactionRequest sale = new Braintree.TransactionRequest();
sale.Amount = currentPackage.Package.Price;
sale.CustomerId = customerResult.Target.Id;
sale.PaymentMethodToken = customerResult.Target.DefaultPaymentMethod.Token;
braintree.Transaction.Sale(sale);
currentPackage.PurchaseDate = DateTime.UtcNow;
entities.SaveChanges();
return(RedirectToAction("Receipt", "Membership", null));
}
}
return(View(model));
}
/// <summary>
/// Retunr a list of customers
/// </summary>
/// <param name="Name">filter of name customer</param>
/// <returns>list od customers</returns>
public List <Customers> SelectByName(string Name)
{
List <Customers> resultsList = null;
CustomersEntities ctx = CustomersEntities.Context;
resultsList = ctx.getCustomersByName(Name).ToList();
return(resultsList);
}
public void Delete(int Id)
{
CustomersEntities ctx = CustomersEntities.Context;
Customers cust = ctx.Customers.First(c => c.Id == Id);
ctx.DeleteObject(cust);
ctx.SaveChanges();
}
// GET: Home
public ActionResult Index()
{
CustomersEntities entities = new CustomersEntities();
List <Customer> customers = entities.Customers.ToList();
//Add a Dummy Row.
customers.Insert(0, new Customer());
return(View(customers));
}
public void Delete(int id)
{
using (var db = new CustomersEntities())
{
var cust = db.Customers.Single(c => c.Id.Equals(id)); ;
db.Customers.Remove(cust);
db.SaveChanges();
}
}
/// <summary>
/// Returns a set of Customerss that belongs to an employee
/// </summary>
/// <returns>A List of Customerss.</returns>
public List <Customers> Select()
{
List <Customers> resultsList = null;
CustomersEntities ctx = CustomersEntities.Context;//)
resultsList = ctx.Customers.ToList();
return(resultsList);
}
public Category GetCategory(int Id)
{
Category result = null;
CustomersEntities ctx = CustomersEntities.Context;
result = ctx.Category.First(c => c.Id == Id);
return(result);
}
public JsonResult InsertCustomer(Customer customer)
{
using (CustomersEntities entities = new CustomersEntities())
{
entities.Customers.Add(customer);
entities.SaveChanges();
}
return(Json(customer));
}
public void DeleteCustomer(Customer _customer)
{
using (CustomersEntities entities = new CustomersEntities())
{
Customer customer = (from c in entities.Customers
where c.CustomerId == _customer.CustomerId
select c).FirstOrDefault();
entities.Customers.Remove(customer);
entities.SaveChanges();
}
}
public Customers getCustomer(int Id)
{
Customers custre = null;
CustomersEntities ctx = CustomersEntities.Context;
{
custre = ctx.Customers.First(e => e.Id == Id);
}
custre.CategoryReference.Load();
return(custre);
}
public ActionResult DeleteCustomer(int customerId)
{
using (CustomersEntities entities = new CustomersEntities())
{
Customer customer = (from c in entities.Customers
where c.CustomerId == customerId
select c).FirstOrDefault();
entities.Customers.Remove(customer);
entities.SaveChanges();
}
return(new EmptyResult());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var context = new CustomersEntities();
ddlCity.DataSource = context.City.ToList();
ddlCity.DataValueField = "ID";
ddlCity.DataTextField = "Name";
ddlCity.DataBind();
}
}
public List <Category> Select()
{
List <Category> resultsList = null;
CustomersEntities ctx = CustomersEntities.Context;
resultsList = ctx.Category.ToList();
// (from category in ctx.Category
// select category).ToList();
return(resultsList);
}
private void Update(Customer customer)
{
using (var db = new CustomersEntities())
{
var cust = db.Customers.Single(c => c.Id.Equals(customer.Id));
cust.Name = customer.Name;
cust.Email = customer.Email;
cust.Phone = customer.Phone;
db.SaveChanges();
}
}
// GET: User
public ActionResult Index()
{
using (CustomersEntities entities = new CustomersEntities())
{
UserModel[] model = entities.Customers.Select(x => new UserModel
{
ID = x.ID,
EmailAddress = x.EmailAddress,
Roles = x.webpages_Roles.Select(y => y.RoleName)
}).ToArray();
return(View(model));
}
}
/// <summary>
/// Updates an Customers row.
/// </summary>
/// <param name="Customers">A Customers object.</param>
public void Update(Customers Customers)
{
CustomersEntities ctx = CustomersEntities.Context;//)
try
{
ctx.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw ex;
}
}
public ActionResult UpdateCustomer(Customer customer)
{
using (CustomersEntities entities = new CustomersEntities())
{
Customer updatedCustomer = (from c in entities.Customers
where c.CustomerId == customer.CustomerId
select c).FirstOrDefault();
updatedCustomer.Name = customer.Name;
updatedCustomer.Country = customer.Country;
entities.SaveChanges();
}
return(new EmptyResult());
}
public ActionResult Edit(int id)
{
using (CustomersEntities e = new CustomersEntities())
{
var x = e.Customers.Single(u => u.ID == id);
UserModel model = new UserModel
{
ID = x.ID,
EmailAddress = x.EmailAddress,
Roles = x.webpages_Roles.Select(y => y.RoleName).ToArray(),
AvailableRoles = e.webpages_Roles.Select(y => y.RoleName).ToArray()
};
return(View(model));
}
}
private void Add(Customer customer)
{
var newCust = new Customer
{
Name = customer.Name,
Email = customer.Email,
Phone = customer.Phone
};
using (var db = new CustomersEntities())
{
db.Customers.Add(newCust);
db.SaveChanges();
}
}
/// <summary>
/// Inserts an Customers row.
/// </summary>
/// <param name="Customers">An Customers object.</param>
public Customers Create(Customers customers)
{
CustomersEntities ctx = CustomersEntities.Context;//)
try
{
ctx.AddToCustomers(customers);
ctx.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
throw ex;
}
return(customers);
}
protected void btnEditCustomer_Click(object sender, EventArgs e)
{
string ID = Request.QueryString["ID"];
int UserID = int.Parse(ID);
if (CheckValidEmail(txtEmail.Text) == true)
{
lblInformLabel.Text = "";
var context = new CustomersEntities();
var customer = new User();
customer.Name = txtName.Text;
customer.Email = txtEmail.Text;
customer.Address = txtAddress.Text;
customer.CityID = int.Parse(ddlCity.SelectedValue);
customer.Country = txtCountry.Text;
customer.ID = UserID;
context.User.Attach(customer);
var entry = context.Entry(customer);
entry.Property(u => u.Name).IsModified = true;
entry.Property(u => u.Email).IsModified = true;
entry.Property(u => u.Address).IsModified = true;
entry.Property(u => u.CityID).IsModified = true;
entry.Property(u => u.Country).IsModified = true;
entry.Property(u => u.ID).IsModified = false;
context.SaveChanges();
lblInformLabel.Text = "Save changes";
lblInformLabel.ForeColor = System.Drawing.Color.FromArgb(22, 139, 224);
}
else if (CheckValidEmail(txtEmail.Text) == false)
{
lblInformLabel.Text = "Not valid email";
lblInformLabel.ForeColor = System.Drawing.Color.Red;
}
else
{
Response.Redirect("Default.aspx");
}
}
public ActionResult Index()
{
using (CustomersEntities db = new CustomersEntities())
{
var signups = db.Customers;
var quoteVMs = new List <QuoteVM>();
foreach (var signup in signups)
{
var signupVm = new QuoteVM();
signupVm.FirstName = signup.FirstName;
signupVm.LastName = signup.LastName;
signupVm.EmailAddress = signup.EmailAddress;
signupVm.DateOfBirth = signup.DateOfBirth;
signupVm.QuoteValue = signup.QuoteValue;
signupVm.CarYear = signup.CarYear;
signupVm.CarMake = signup.CarMake;
signupVm.CarModel = signup.CarModel;
quoteVMs.Add(signupVm);
}
return(View(quoteVMs));
}
}
protected void btnDeleteSelectedCustomer_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in grvCustomers.Rows)
{
CheckBox chkDeleteCustomer = (CheckBox)row.FindControl("chkDeleteCustomer");
if (chkDeleteCustomer.Checked)
{
var lblId = row.FindControl("lblID") as Label ;
int ID = int.Parse(lblId.Text);
var context = new CustomersEntities();
var employer = new User { ID = ID };
context.User.Attach(employer);
context.User.Remove(employer);
context.SaveChanges();
}
}
Response.Redirect("Default.aspx");
}
public ActionResult ProcessRequest(int id)
{
int Id = Convert.ToInt32(id.ToString());
using (CustomersEntities db = new CustomersEntities())
{
var v = db.FilestoDbs.Where(x => x.Id.Equals(Id)).FirstOrDefault();
if (v != null)
{
Response.ContentType = v.ContentType;
Response.AddHeader("content-disposition", "attachment; filename=" + v.FileName);
Response.BinaryWrite(v.FileContent);
Response.Flush();
Response.End();
}
}
//IEnumerable<FilestoDb> listofFiles;
//using (CustomersEntities db = new CustomersEntities())
//{
// listofFiles = db.FilestoDbs.ToList();
//}
return(View("Index"));
}
public Array GetCustomers(int startIndex, int maxRows, string sortColumn, string nameSearchString, string citySearchString)
{
int thisStartIndex = startIndex;
int thisMaxRows = maxRows;
string thisSortColumn = sortColumn;
string thisSearchString = nameSearchString;
string thisSearchStringCity = citySearchString;
using (var context = new CustomersEntities())
{
if (!String.IsNullOrWhiteSpace(citySearchString) && !String.IsNullOrWhiteSpace(nameSearchString))
{
return searchByNameAndByCity(thisStartIndex, thisMaxRows, thisSortColumn, thisSearchStringCity, thisSearchString);
}
else if (!String.IsNullOrWhiteSpace(nameSearchString))
{
return searchByName(thisStartIndex, thisMaxRows, thisSortColumn, thisSearchString);
}
else if (!String.IsNullOrWhiteSpace(citySearchString))
{
return searchByCity(thisStartIndex, thisMaxRows, thisSortColumn, thisSearchStringCity);
}
else if (sortColumn == "User.Name")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Name
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Name DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Name descending
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Email")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Email
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Email DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Email descending
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Address")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Address
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Address DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Address descending
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "City.Name")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby City.Name
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "City.Name DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby City.Name descending
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Country")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Country
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Country DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Country descending
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.ID
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
}
public Array searchByNameAndByCity(int startIndex, int maxRows, string sortColumn, string citySearchString, string nameSearchString)
{
using (var context = new CustomersEntities())
{
if (sortColumn == "User.Name")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Name
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Name DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Name descending
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Email")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Email
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Email DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Email descending
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Address")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Address
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Address DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Address descending
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "City.Name")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby City.Name
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "City.Name DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby City.Name descending
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Country")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Country
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
else if (sortColumn == "User.Country DESC")
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.Country descending
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
orderby User.ID
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User, City })
.Skip(startIndex).Take(maxRows).ToArray();
}
}
public int GetCustomersCount(string nameSearchString, string citySearchString)
{
using (var context = new CustomersEntities())
{
if (!String.IsNullOrWhiteSpace(nameSearchString) && !String.IsNullOrWhiteSpace(citySearchString))
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
where City.Name.Contains(citySearchString) && User.Name.Contains(nameSearchString)
select new { User.City })
.Count();
}
else if (!String.IsNullOrWhiteSpace(nameSearchString))
{
return (from User in context.User
where User.Name.Contains(nameSearchString)
select User)
.Count();
}
else if (!String.IsNullOrWhiteSpace(citySearchString))
{
return (from User in context.User
join City in context.City
on User.CityID equals City.ID
where City.Name.Contains(citySearchString)
select new { User.City })
.Count();
}
return context.User.Count();
}
}
public List <Customer> GetCustomers()
{
CustomersEntities entities = new CustomersEntities();
return(entities.Customers.ToList());
}
public ActionResult Quote(string FirstName, string LastName, string EmailAddress, DateTime DateOfBirth, int CarYear, string CarMake,
string CarModel, string Dui, int SpeedingTicket, string CoverageType, string PhoneNumber, int QuoteValue = 50)
{
if (string.IsNullOrEmpty(FirstName) || string.IsNullOrEmpty(LastName) || string.IsNullOrEmpty(EmailAddress) || string.IsNullOrEmpty(CarMake) ||
string.IsNullOrEmpty(CarModel) || string.IsNullOrEmpty(Dui) || string.IsNullOrEmpty(CoverageType))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (CustomersEntities db = new CustomersEntities())
{
var quote = new Customer();
quote.FirstName = FirstName;
quote.LastName = LastName;
quote.EmailAddress = EmailAddress;
quote.DateOfBirth = DateOfBirth;
quote.CarYear = CarYear;
quote.CarMake = CarMake;
quote.CarModel = CarModel;
quote.Dui = Dui;
quote.SpeedingTicket = SpeedingTicket;
quote.CoverageType = CoverageType;
quote.QuoteValue = QuoteValue;
{
quote.QuoteValue = Convert.ToInt32(quote.QuoteValue = 50);
if (quote.DateOfBirth < DateTime.Now.AddYears(-25))
{
quote.QuoteValue += 25;
}
if (quote.DateOfBirth < DateTime.Now.AddYears(-18))
{
quote.QuoteValue += 100;
}
if (quote.DateOfBirth > DateTime.Now.AddYears(-100))
{
quote.QuoteValue += 25;
}
if (quote.CarYear < 2000)
{
quote.QuoteValue += 25;
}
if (quote.CarYear > 2015)
{
quote.QuoteValue += 25;
}
if (quote.CarMake.ToLower() == "Porsche")
{
quote.QuoteValue += 25;
}
if (quote.CarMake.ToLower() == "Porsche" && quote.CarModel.ToLower() == "911 Carrera")
{
quote.QuoteValue += 25;
}
if (quote.SpeedingTicket++ > 0)
{
quote.QuoteValue += 10;
}
if (quote.Dui.ToLower() == "Yes")
{
quote.QuoteValue = Convert.ToInt32(quote.QuoteValue * 1.25);
}
if (quote.CoverageType.ToLower() == "Full Coverage")
{
quote.QuoteValue = Convert.ToInt32(quote.QuoteValue * 1.5);
}
else
{
quote.QuoteValue = Convert.ToInt32(quote.QuoteValue * 1.0);
}
db.Customers.Add(quote);
db.SaveChanges();
return(View("QuoteSubmitted"));
}
}
}
}
private string AddFiletoDB(CertificateObject fileList)
{
#region Old
/*
* HttpFileCollection filesColl = Request.Files;
* using (CustomersEntities db = new CustomersEntities())
* {
* foreach (string uploader in filesColl)
* {
* HttpPostedFile file = filesColl[uploader];
*
* if (file.ContentLength > 0)
* {
* BinaryReader br = new BinaryReader(file.InputStream);
*
* byte[] buffer = br.ReadBytes(file.ContentLength);
*
* db.tblFilestoDbs.Add(new tblFilestoDb
* {
* FileName = file.FileName,
* ContentType = file.ContentType,
* FileExtension = Path.GetExtension(file.FileName),
* FileSize = file.ContentLength,
* FileContent = buffer
* });
* }
* }
* db.SaveChanges();
* }
*/
#endregion
List <FilestoDb> filestoAddtoDb = new List <FilestoDb>();
string response = string.Empty;
try
{
using (CustomersEntities db = new CustomersEntities())
{
foreach (var fileObject in fileList.myfile)
{
if (fileObject.ContentLength > 0)
{
BinaryReader br = new BinaryReader(fileObject.InputStream);
byte[] buffer = br.ReadBytes(fileObject.ContentLength);
filestoAddtoDb.Add(new FilestoDb()
{
FileName = fileObject.FileName,
ContentType = fileObject.ContentType,
FileExtension = Path.GetExtension(fileObject.FileName),
FileSize = fileObject.ContentLength,
FileContent = buffer
});
}
}
db.FilestoDbs.AddRange(filestoAddtoDb);
db.SaveChanges();
response = "success";
return(response);
}
}
catch (Exception ex)
{
response = ex.Message;
return(response);
}
}
