public ActionResult DeleteProduct(int?id)
{
if (id != null && id > 0)
{
db_AirborneEntities OEM = new db_AirborneEntities();
var GetProductDetails = OEM.ItemDetails.Where(x => x.Item_ID == id).FirstOrDefault();
if (GetProductDetails != null)
{
OEM.ItemDetails.Remove(GetProductDetails);
}
OEM.SaveChanges();
}
return(RedirectToAction("Index", "StoreManager", new { area = "Admin" }));
}
/// <summary>
/// Save the order in database
/// </summary>
/// <param name="data"></param>
/// <param name="ShippingCharge"></param>
/// <param name="_tax"></param>
/// <param name="GrandTotal"></param>
/// <param name="description"></param>
private void SavePayments(List <string> data, string ShippingCharge, string _tax, string GrandTotal, string description, string _cartemail, string _cartphone, string _phoneType, string _acceptMessage)
{
try
{
string SubTotal = data[1];
var Items = JsonConvert.DeserializeObject <List <ItemModel> >(data[0]);
db_AirborneEntities OEM = new db_AirborneEntities();
Order_Payments _objOrderPayment = new Order_Payments();
_objOrderPayment.OrderID = OrderId;
_objOrderPayment.OrderDescription = description;
_objOrderPayment.OrderPrice = Convert.ToDecimal(GrandTotal);
_objOrderPayment.OrderItems = Items.Count;
_objOrderPayment.Email = _cartemail;
_objOrderPayment.PhoneNumber = _cartphone;
_objOrderPayment.ShippingAddress = "";
_objOrderPayment.Status = "0";
_objOrderPayment.ShippingPrice = Convert.ToDecimal(ShippingCharge);
_objOrderPayment.Tax = Convert.ToDecimal(_tax);
_objOrderPayment.CreatedDate = DateTime.UtcNow;
_objOrderPayment.PhoneType = (string.IsNullOrEmpty(_phoneType)) ? false : ((_phoneType.ToString().ToLower() == "true") ? true : false);
_objOrderPayment.AcceptMessage = (string.IsNullOrEmpty(_acceptMessage)) ? false : ((_acceptMessage.ToString().ToLower() == "true") ? true : false);
OEM.Order_Payments.Add(_objOrderPayment);
foreach (var Product in Items)
{
Order_Items _objOrderItem = new Order_Items();
_objOrderItem.OrderID = _objOrderPayment.OrderID;
_objOrderItem.Price = Convert.ToDecimal(Product.Item_Price);
_objOrderItem.ProductCode = Product.Item_code.ToString();
_objOrderItem.ProductName = Product.Item_Name;
_objOrderItem.Quantity = Product.ItemCounts;
_objOrderItem.TotalPrice = Product.ItemTotalPrice;
_objOrderItem.ProductID = Convert.ToInt64(Product.Item_ID);
_objOrderItem.ShippingPerUnit = Product.ItemShippingCost;
_objOrderItem.TaxPerUnit = Product.ItemTax;
_objOrderItem.CreatedDate = DateTime.UtcNow;
OEM.Order_Items.Add(_objOrderItem);
}
OEM.SaveChanges();
}
catch (Exception ex)
{
}
}
public ActionResult Edit(HttpPostedFileBase file, itemDetailsDataContract model)
{
var id = Convert.ToInt32(model.Item_ID);
try
{
string Message, fileName = string.Empty;
if (file != null)
{
fileName = file.FileName;
try
{
file.SaveAs(Path.Combine(Server.MapPath("~/images/Products"), fileName));
Message = "File uploaded";
}
catch (Exception)
{
Message = "File upload failed! Please try again";
}
}
db_AirborneEntities OEM = new db_AirborneEntities();
var GetProductDetails = OEM.ItemDetails.Where(x => x.Item_ID == id).FirstOrDefault();
GetProductDetails.Item_code = model.Item_code;
GetProductDetails.Item_Name = model.Item_Name;
GetProductDetails.Item_Price = model.Item_Price;
GetProductDetails.Image_Name = (!string.IsNullOrEmpty(fileName)) ? fileName : model.Image_Name;
GetProductDetails.Status = model.Status;
GetProductDetails.Description = model.Description;
GetProductDetails.Short_Description = model.Short_Description;
GetProductDetails.ShippingCost = model.Shipping_Price;
GetProductDetails.TaxAmount = model.Tax_Amount;
OEM.SaveChanges();
}
catch (Exception ex)
{
return(RedirectToAction("Index", "StoreManager", new { area = "Admin" }));
}
return(RedirectToAction("Index", "StoreManager", new { area = "Admin" }));
}
//Paypal payment
public ActionResult PaymentWithPaypal(List <string> data)
{
OrderId = DateTime.Now.ToString("ddmmyyyyhhmmss");
//getting the apiContext as earlier
APIContext apiContext = PaymentConfiguration.GetAPIContext();
try
{
string payerId = Request.Params["PayerID"];
if (string.IsNullOrEmpty(payerId))
{
//this section will be executed first because PayerID doesn't exist
//it is returned by the create function call of the payment class
// Creating a payment
// baseURL is the url on which paypal sendsback the data.
// So we have provided URL of this controller only
string baseURI = Request.Url.Scheme + "://" + Request.Url.Authority +
"/Paypal/PaymentWithPayPal?";
//guid we are generating for storing the paymentID received in session
//after calling the create function and it is used in the payment execution
var guid = Convert.ToString((new Random()).Next(100000));
//CreatePayment function gives us the payment approval url
//on which payer is redirected for paypal account payment
//var createdPayment = this.CreatePayment(apiContext, baseURI + "guid=" + guid);
var createdPayment = this.CreatePayment(apiContext, baseURI + "guid=" + guid, data);
//get links returned from paypal in response to Create function call
var links = createdPayment.links.GetEnumerator();
string paypalRedirectUrl = null;
while (links.MoveNext())
{
Links lnk = links.Current;
if (lnk.rel.ToLower().Trim().Equals("approval_url"))
{
//saving the payapalredirect URL to which user will be redirected for payment
paypalRedirectUrl = lnk.href;
}
}
// saving the paymentID in the key guid
Session.Add(guid, createdPayment.id);
return(Json(new { data = paypalRedirectUrl }, JsonRequestBehavior.AllowGet));
}
else
{
// This section is executed when we have received all the payments parameters
// from the previous call to the function Create
// Executing a payment
var guid = Request.Params["guid"];
var orderid = Request.Params["OrionOrderId"];
var executedPayment = ExecutePayment(apiContext, payerId, Session[guid] as string);
if (executedPayment.state.ToLower() != "approved")
{
return(RedirectToAction("FailureView", "Paypal", new { area = "Shopping" }));
}
var payment = Payment.Get(apiContext, Session[guid].ToString());
string city = payment.transactions[0].item_list.shipping_address.city;
string postalcode = payment.transactions[0].item_list.shipping_address.postal_code;
string countryCode = payment.transactions[0].item_list.shipping_address.country_code;
string recipentName = payment.transactions[0].item_list.shipping_address.recipient_name;
string state = payment.transactions[0].item_list.shipping_address.state;
string street = payment.transactions[0].item_list.shipping_address.line1;
StringBuilder sb = new StringBuilder();
sb.Append("Recipient name: ");
sb.Append(recipentName);
sb.Append(Environment.NewLine);
sb.Append("Address: ");
sb.Append(street);
sb.Append(Environment.NewLine);
sb.Append("City: ");
sb.Append(city);
sb.Append(Environment.NewLine);
sb.Append("State: ");
sb.Append(state);
sb.Append(Environment.NewLine);
sb.Append("Postal code: ");
sb.Append(postalcode);
sb.Append(Environment.NewLine);
sb.Append("Country code: ");
sb.Append(countryCode);
sb.Append(Environment.NewLine);
string ShippingAddress = sb.ToString();
//update order after recievining parameters from paypal
db_AirborneEntities OEM = new db_AirborneEntities();
var updatePayment = OEM.Order_Payments.Where(x => x.OrderID != null && x.OrderID == orderid).FirstOrDefault();
if (updatePayment != null)
{
TempData["Status"] = updatePayment.OrderID;
updatePayment.ShippingAddress = ShippingAddress;
updatePayment.RecipientName = recipentName ?? "";
updatePayment.Street = street ?? "";
updatePayment.City = city ?? "";
updatePayment.State = state ?? "";
updatePayment.PostalCode = postalcode ?? "";
updatePayment.CountryCode = countryCode ?? "";
updatePayment.Status = "1";
updatePayment.ModifiedDate = DateTime.UtcNow;
updatePayment.PaypalTransactionID = Convert.ToString(Session[guid]);
OEM.SaveChanges();
}
var emailStatus = HtmlHelpersUtility.SendOrderEmail(updatePayment.OrderID, updatePayment.Email);
}
}
catch (Exception ex)
{
log4net.ILog logger = log4net.LogManager.GetLogger("Errorlog");
logger.Error("Error" + ex.Message);
//Logger.log("Error" + ex.Message);
return(RedirectToAction("FailureView", "Paypal", new { area = "Shopping" }));
}
return(RedirectToAction("SuccessView", "Paypal", new { area = "Shopping" }));
}