public int AddCustomer(SiteSubscriber customer) { int id = 0; string connectionString = ConfigurationManager.ConnectionStrings["con"].ToString(); try { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_CustomerInsert", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ULDSurveyID", SqlDbType.VarChar).Value = customer.ULDSurveyID; cmd.Parameters.Add("@firstName", SqlDbType.VarChar).Value = customer.FirstName; cmd.Parameters.Add("@lastName", SqlDbType.VarChar).Value = customer.LastName; cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = customer.Email; cmd.Parameters.Add("@ProductIDPurchased", SqlDbType.VarChar).Value = customer.SubscriptionId; con.Open(); //var dd = cmd.ExecuteNonQuery(); //var idd = cmd.Parameters["@newCustomerID"].Value; var d = cmd.ExecuteScalar(); id = Convert.ToInt32(d); } } } catch { } return id; }
public ActionResult CreateSubscriber(SiteSubscriber obj) { if (ModelState.IsValid) { Guid guid = new Guid(); Random rnmd = new Random(); ULDEntities db = new ULDEntities(); if (ModelState.IsValid) { ULDCustomer.Models.ULDCustomer obtbl = new ULDCustomer.Models.ULDCustomer(); CustomerModel model = new CustomerModel(); int cutomerid = model.AddCustomer(obj); xml = "<subscriber><customer-id>" + cutomerid + "</customer-id><screen-name>" + obj.FirstName + obj.LastName + "</screen-name></subscriber>"; site = ConfigurationManager.AppSettings["apiUrl"].ToString(); url = string.Format("https://subs.pinpayments.com/api/v4/{0}/subscribers.xml", site); CreateSubscriberApi(url, xml, "Post"); CardDetail obj1 = new CardDetail(); obj1.token = GenrateInvoice(obj.SubscriptionId, cutomerid.ToString(), obj.FirstName, obj.Email); obj1.firstName = obj.FirstName; obj1.lastName = obj.LastName; obj1.fullName = obj.FirstName + " " + obj.LastName; var planDetail = DBCommon.GetPlanDetailByProductID(obj.SubscriptionId); obj1.title = planDetail.Rows[0]["title"].ToString(); obj1.CustomerId = cutomerid; obj1.description = planDetail.Rows[0]["description"].ToString(); obj1.price = planDetail.Rows[0]["price"].ToString(); ViewBag.year = DBCommon.BindYear(); ViewBag.month = DBCommon.BindMonth(); TempData["CardDetail"] = obj1; TempData["email"] = obj.Email; TempData["PrimaryEmail"] = obj.Email; // return RedirectToAction("AddCardDetail", new { id = cutomerid }); return RedirectToAction("AddCardDetail"); } return View("CreateSubscriber"); } else { return View(obj); } }
//[Route("{id}")] public ActionResult CreateSubscriber(string id, int SurveyID) { try { List<Plans> plans = DBCommon.GetPlans(); var f = plans.FirstOrDefault(x => x.Name == id); SiteSubscriber obj = new SiteSubscriber(); obj.SubscriptionId = f.Id.ToString(); obj.ULDSurveyID = SurveyID; //obj.ServiceLevel = f.ServiceLevel.ToString(); return View("CreateSubscriber", obj); } catch { return null; } }