public ActionResult AddCustomer(OrderDetails model) { if (ModelState.IsValid) { if (repository.AddCustomer(model)) { ViewBag.Success = "Records inserted successfully"; return RedirectToAction("GetTransactionDetails", "OrderDetails"); } else { ViewBag.Success = "Something went wrong. Please try later"; } } return View(); }
/// <summary> /// add the /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddCustomer(OrderDetails model) { try { using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (SqlCommand sqlcmd = new SqlCommand("AddNewCustomer", sqlConnection)) { sqlConnection.Open(); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@customerName", SqlDbType.NVarChar).Value = model.CustomerName; sqlcmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = model.Email; sqlcmd.Parameters.Add("@BillingAddress", SqlDbType.NVarChar).Value = model.BillingAddress; sqlcmd.Parameters.Add("@ShippingAddress", SqlDbType.NVarChar).Value = model.ShippingAddress; sqlcmd.Parameters.Add("@Number", SqlDbType.NVarChar).Value = model.Number; sqlcmd.Parameters.Add("@NetAmount", SqlDbType.Decimal).Value = model.NetAmount; sqlcmd.Parameters.Add("@Quantity", SqlDbType.Int).Value = model.Quantity; sqlcmd.Parameters.Add("@OrderAmount", SqlDbType.Decimal).Value = model.OrderAmount; sqlcmd.Parameters.Add("@Tax", SqlDbType.Decimal).Value = model.Tax; sqlcmd.Parameters.Add("@Discount", SqlDbType.Decimal).Value = model.Discount; sqlcmd.Parameters.Add("@Rate", SqlDbType.Decimal).Value = model.Rate; sqlcmd.Parameters.Add("@amount", SqlDbType.Decimal).Value = model.Amount; sqlcmd.Parameters.Add("@CustomerID", SqlDbType.Int).Value = model.CustomerID; sqlcmd.Parameters.Add("@Orderno", SqlDbType.Int).Value = model.OrderID; sqlcmd.Parameters.Add("@OrderItemNumber", SqlDbType.Int).Value = model.OrderItemID; sqlcmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = 4; int Success = sqlcmd.ExecuteNonQuery(); sqlConnection.Close(); if (Success > 0) { return true; } return false; } } } catch (Exception ex) { ExceptionHandling.SaveException(ex); return false; } }
/// <summary> /// add the /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddCustomer(OrderDetails model) { try { var objCustomerDetails = new ClientDetail(); objCustomerDetails.Name = model.CustomerName; objCustomerDetails.Email = model.Email; objCustomerDetails.BillingAddress = model.BillingAddress; objCustomerDetails.ShippingAddress = model.ShippingAddress; objCustomerDetails.Number = model.Number; ObjEntity.ClientDetails.Add(objCustomerDetails); ObjEntity.SaveChanges(); var objContractDetail = new ContractDetail(); objContractDetail.NetAmount = model.NetAmount; objContractDetail.Quantity = model.Quantity; objContractDetail.OrderAmount = model.OrderAmount; objContractDetail.Tax = model.Tax; objContractDetail.Discount = model.Discount; objContractDetail.IsActive = true; objContractDetail.TransactionDate = DateTime.Now; objContractDetail.Customer_ID = objCustomerDetails.ID; ; ObjEntity.ContractDetails.Add(objContractDetail); int OrderNo= ObjEntity.SaveChanges(); var OrderItemDetails = new OrderItemDetail(); OrderItemDetails.Rate = model.Rate; OrderItemDetails.Order_ID = objContractDetail.ID; OrderItemDetails.Product_ID = 4; OrderItemDetails.Quantity = model.Quantity.Value; OrderItemDetails.Amount = model.Amount; ObjEntity.OrderItemDetails.Add(OrderItemDetails); ObjEntity.SaveChanges(); return true; } catch (Exception ex) { ExceptionHandling.SaveException(ex); return false; } }
/// <summary> /// update the order data /// </summary> /// <param name="model"></param> /// <param name="productName"></param> /// <returns></returns> public bool UpdateDetails(OrderDetails model, int productID) { try { var objCustomerDetails = ObjEntity.ClientDetails.Where(x => x.ID == model.CustomerID).FirstOrDefault(); objCustomerDetails.Name = model.CustomerName; objCustomerDetails.Email = model.Email; objCustomerDetails.BillingAddress = model.BillingAddress; objCustomerDetails.ShippingAddress = model.ShippingAddress; objCustomerDetails.Number = model.Number; var objContractDetail = ObjEntity.ContractDetails.Where(x => x.ID == model.OrderID).FirstOrDefault(); objContractDetail.NetAmount = model.NetAmount; objContractDetail.Quantity = model.Quantity; objContractDetail.OrderAmount = model.OrderAmount; objContractDetail.Tax = model.Tax; objContractDetail.Discount = model.Discount; var OrderItemDetails = ObjEntity.OrderItemDetails.Where(x => x.ID == model.OrderID).FirstOrDefault(); OrderItemDetails.Rate = model.Rate; OrderItemDetails.Quantity = model.Quantity.Value; OrderItemDetails.Amount = model.Amount; ObjEntity.SaveChanges(); return true; } catch (Exception ex) { ExceptionHandling.SaveException(ex); return false; } }