public ISubscription Create(
int plan_id,
int client_id,
string phone_number,
DateTime start_date,
DateTime?end_date
)
{
using (var context = new EPEntities())
{
subscription s = new subscription()
{
plan_id = plan_id,
client_id = client_id,
phone_number = phone_number,
start_date = start_date,
};
if (end_date != null)
{
s.end_date = (DateTime)end_date;
}
context.subscription.Add(s);
context.SaveChanges();
if (s.subscription_id > 0)
{
return(s);
}
return(null);
}
}
private void SubscriptionInfo_Click(object sender, RoutedEventArgs e)
{
subscription nextPage = new subscription();
NavigationService navService = NavigationService.GetNavigationService(this);
navService.Navigate(nextPage);
}
public ActionResult DeleteConfirmed(int id)
{
subscription subscription = db.subscriptions.Find(id);
db.subscriptions.Remove(subscription);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Unsubscribe(int id)
{
using (NavetteEntities nv = new NavetteEntities()) {
subscription sub = nv.subscriptions.SingleOrDefault(x => x.line_id == id);
nv.subscriptions.Remove(sub);
nv.SaveChanges();
return(RedirectToAction("Index", "Traveller"));
}
}
public ActionResult Edit([Bind(Include = "id,name,category,description,price,quantity,dateAdded,addedBy")] subscription subscription)
{
if (ModelState.IsValid)
{
db.Entry(subscription).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.addedBy = new SelectList(db.Users, "UserID", "FirstName", subscription.addedBy);
return(View(subscription));
}
public ISubscription GetById(int id)
{
using (var context = new EPEntities())
{
subscription subscription = context.subscription.Find(id);
context.Entry(subscription).Collection(c => c.history).Load();
context.Entry(subscription).Collection(c => c.sub_option).Load();
context.Entry(subscription).Reference(c => c.client).Load();
context.Entry(subscription).Reference(c => c.plan).Load();
return(subscription);
}
}
// POST: odata/subscription
public async Task <IHttpActionResult> Post(subscription subscription)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.subscription.Add(subscription);
await db.SaveChangesAsync();
return(Created(subscription));
}
public ActionResult Create([Bind(Include = "id,name,category,description,price,quantity,dateAdded,addedBy")] subscription subscription)
{
if (ModelState.IsValid)
{
subscription.dateAdded = DateTime.UtcNow;
db.subscriptions.Add(subscription);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.addedBy = new SelectList(db.Users, "UserID", "FirstName", subscription.addedBy);
return(View(subscription));
}
public async Task <ActionResult> Index()
{
string secretKey = ConfigurationManager.AppSettings["PaystackSecret"];
var paystackTransactionAPI = new PaystackTransaction(secretKey);
var tranxRef = HttpContext.Request.QueryString["reference"];
if (tranxRef != null)
{
var response = await paystackTransactionAPI.VerifyTransaction(tranxRef);
if (response.status)
{
try
{
using (var db = new LoanComparerModel())
{
int currentCount = 0;
currentCount = (int)Session["count"];
db.loandetails.Find((int)Session["selectedItemId"]).count = currentCount + 1;
db.loandetails.Find((int)Session["selectedItemId"]).date = DateTime.Now;
// Update subscription table
var user = new subscription
{
userid = User.Identity.GetUserName().ToLower(),
startdate = DateTime.Now,
enddate = DateTime.Now.AddMonths(1)
};
db.subscriptions.Add(user);
db.SaveChanges();
}
}
catch (Exception e)
{
return(View("Error"));
}
return(View(response));
}
}
return(View("PaymentError"));
}
// DELETE: odata/subscription(5)
public async Task <IHttpActionResult> Delete([FromODataUri] int key)
{
subscription subscription = await db.subscription.FindAsync(key);
if (subscription == null)
{
return(NotFound());
}
subscription.ModificationDatetime = DateTime.UtcNow;
await db.SaveChangesAsync();
return(StatusCode(HttpStatusCode.NoContent));
}
// GET: subscriptions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
subscription subscription = db.subscriptions.Find(id);
if (subscription == null)
{
return(HttpNotFound());
}
return(View(subscription));
}
// GET: subscriptions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
subscription subscription = db.subscriptions.Find(id);
if (subscription == null)
{
return(HttpNotFound());
}
ViewBag.addedBy = new SelectList(db.Users, "UserID", "FirstName", subscription.addedBy);
return(View(subscription));
}
public ActionResult Subscribe(int id)
{
var sub = new subscription();
sub.traveller_id = (int)Session["user_id"];
sub.line_id = id;
sub.price = 20;
sub.reduction = 0;
using (NavetteEntities nv = new NavetteEntities())
{
nv.subscriptions.Add(sub);
nv.SaveChanges();
}
return(RedirectToAction("Index", "Traveller"));
}
// GET: /subscription/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
subscription subscription = await db.subscription.FindAsync(id);
if (subscription == null)
{
return(HttpNotFound());
}
ViewBag.AllSubscriptions = db.subscription.Where(s => s.DeletionDatetime == null).OrderBy(s => s.SortFactor);
return(View(subscription));
}
public void TestSubscription_CanContainCreateAddOns()
{
subscription subscription = new subscription();
subscription.planCode = "123abc";
createAddOn cao1 = new createAddOn();
cao1.addOnCode = "1";
cao1.name = "addOn1";
cao1.amount = 100;
cao1.startDate = new DateTime(2013, 9, 5);
cao1.endDate = new DateTime(2013, 9, 6);
createAddOn cao2 = new createAddOn();
cao2.addOnCode = "2";
cao2.name = "addOn2";
cao2.amount = 200;
cao2.startDate = new DateTime(2013, 9, 4);
cao2.endDate = new DateTime(2013, 9, 5);
subscription.createAddOns.Add(cao1);
subscription.createAddOns.Add(cao2);
String actual = subscription.Serialize();
String expected = @"
<planCode>123abc</planCode>
<createAddOn>
<addOnCode>1</addOnCode>
<name>addOn1</name>
<amount>100</amount>
<startDate>2013-09-05</startDate>
<endDate>2013-09-06</endDate>
</createAddOn>
<createAddOn>
<addOnCode>2</addOnCode>
<name>addOn2</name>
<amount>200</amount>
<startDate>2013-09-04</startDate>
<endDate>2013-09-05</endDate>
</createAddOn>";
Assert.AreEqual(Regex.Replace(expected, @"\s+", String.Empty), Regex.Replace(actual, @"\s+", String.Empty));
}
public void TestSubscription_CanContainCreateDiscounts()
{
subscription subscription = new subscription();
subscription.planCode = "123abc";
createDiscount cd1 = new createDiscount();
cd1.discountCode = "1";
cd1.name = "cheaper";
cd1.amount = 200;
cd1.startDate = new DateTime(2013, 9, 5);
cd1.endDate = new DateTime(2013, 9, 6);
createDiscount cd2 = new createDiscount();
cd2.discountCode = "2";
cd2.name = "cheap";
cd2.amount = 100;
cd2.startDate = new DateTime(2013, 9, 3);
cd2.endDate = new DateTime(2013, 9, 4);
subscription.createDiscounts.Add(cd1);
subscription.createDiscounts.Add(cd2);
String actual = subscription.Serialize();
String expected = @"
<planCode>123abc</planCode>
<createDiscount>
<discountCode>1</discountCode>
<name>cheaper</name>
<amount>200</amount>
<startDate>2013-09-05</startDate>
<endDate>2013-09-06</endDate>
</createDiscount>
<createDiscount>
<discountCode>2</discountCode>
<name>cheap</name>
<amount>100</amount>
<startDate>2013-09-03</startDate>
<endDate>2013-09-04</endDate>
</createDiscount>";
Assert.AreEqual(Regex.Replace(expected, @"\s+", String.Empty), Regex.Replace(actual, @"\s+", String.Empty));
}
public async Task <ActionResult> Activate(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
subscription subscription = await db.subscription.FindAsync(id);
if (subscription == null)
{
return(HttpNotFound());
}
subscription.DeletionDatetime = null;
await db.SaveChangesAsync();
return(new HttpStatusCodeResult(HttpStatusCode.OK));
}
//Dodanie abonamentu klienta
private void Save()
{
try
{
SubscriptionContext context = new SubscriptionContext();
subscription subscript = new subscription();
subscript.registration_data = DateTime.Now;
subscript.tariff = SelectedOffer;
context.subscriptions.Add(subscript);
context.SaveChanges();
MessageBox.Show("Dodano abonament.");
}
catch (Exception ex)
{
File.AppendAllText(MainWindowViewModel.PathToLog, ex.ToString());
MessageBox.Show("Błąd! Nie udało się dodać abonamentu.", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
// GET: /subscription/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
subscription subscription = await db.subscription.FindAsync(id);
if (subscription == null)
{
return(HttpNotFound());
}
var all_subscriptions = get(false);
ViewBag.AllSubscriptions = all_subscriptions.OrderBy(s => s.SortFactor);
return(View(subscription));
}
public async Task <ActionResult> Edit([Bind(Include = "IdSubscription,Name,SortFactor,Duration")] subscription subscription, string Pricing, List <HttpPostedFileBase> fileUpload)
{
if (ModelState.IsValid)
{
if (!String.IsNullOrEmpty(Pricing))
{
subscription.Pricing = Convert.ToDecimal(Pricing);
}
if (fileUpload.Count > 0)
{
subscription.Icon = GeneratePhisicalFile(fileUpload.FirstOrDefault());
}
db.Entry(subscription).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(subscription));
}
public async Task <ActionResult> Create([Bind(Include = "Name,SortFactor,Duration")] subscription subscription, string Pricing, List <HttpPostedFileBase> fileUpload)
{
if (ModelState.IsValid)
{
if (!String.IsNullOrEmpty(Pricing))
{
subscription.Pricing = Convert.ToDecimal(Pricing);
}
fileUpload = FilterFiles(fileUpload);
if (fileUpload.Count() == 1)
{
subscription.Icon = GeneratePhisicalFile(fileUpload.FirstOrDefault());
}
db.subscription.Add(subscription);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(subscription));
}
// PUT: odata/subscription(5)
public async Task <IHttpActionResult> Put([FromODataUri] int key, Delta <subscription> patch)
{
Validate(patch.GetEntity());
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
subscription subscription = await db.subscription.FindAsync(key);
if (subscription == null)
{
return(NotFound());
}
patch.Put(subscription);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!subscriptionExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(subscription));
}
public bool Process(int merchantid, decimal amount_deposit)
{
try
{
merchant_advertisers tMerchant = (from m in DB.merchant_advertisers where m.merchant_id == merchantid select m).FirstOrDefault();
if (tMerchant == null)
{
return(false);
}
tMerchant.status = "A";
tMerchant.deposit_balance += amount_deposit;
advertiser_deposit tAdDeposit = new advertiser_deposit();
tAdDeposit.amount_deposit = amount_deposit;
tAdDeposit.deposit_received_dt = DateTime.Now;
tAdDeposit.merchant_id = merchantid;
tAdDeposit.created_at = DateTime.Now;
DB.advertiser_deposit.Add(tAdDeposit);
subscription tSub = (from s in DB.subscriptions where s.id == tMerchant.subscription_id select s).FirstOrDefault();
if (tSub != null && tMerchant.deposit_balance > tSub.min_deposit_balance)
{
tMerchant.merchant.opt_out = "N";
}
else
{
return(false);
}
DB.merchant_advertisers.Attach(tMerchant);
DB.SaveChanges();
}
catch (Exception ex)
{
return(false);
}
return(true);
}
private static subscription EnsureSubscription(FrameworkElement frameworkElement)
{
if (frameworkElement == null)
{
return null;
}
subscription subs = frameworkElement.GetValue(subscriptionProperty) as subscription;
if (subs == null)
{
subs = new subscription(frameworkElement);
frameworkElement.SetValue(subscriptionProperty, subs);
}
return subs;
}
.PublishAsync(subscription, payload, default, cancellationToken);
.PublishAsync(subscription, payload, default, CancellationToken.None);
AuthenticationType.ManagedIdentity => new AzureServiceBusClient(_hostname, _topic, subscription, _tenantId),
public void TestSubscription_CanContainCreateAddOns()
{
var subscription = new subscription();
subscription.planCode = "123abc";
var cao1 = new createAddOn();
cao1.addOnCode = "1";
cao1.name = "addOn1";
cao1.amount = 100;
cao1.startDate = new DateTime(2013, 9, 5);
cao1.endDate = new DateTime(2013, 9, 6);
var cao2 = new createAddOn();
cao2.addOnCode = "2";
cao2.name = "addOn2";
cao2.amount = 200;
cao2.startDate = new DateTime(2013, 9, 4);
cao2.endDate = new DateTime(2013, 9, 5);
subscription.createAddOns.Add(cao1);
subscription.createAddOns.Add(cao2);
var actual = subscription.Serialize();
var expected = @"
<planCode>123abc</planCode>
<createAddOn>
<addOnCode>1</addOnCode>
<name>addOn1</name>
<amount>100</amount>
<startDate>2013-09-05</startDate>
<endDate>2013-09-06</endDate>
</createAddOn>
<createAddOn>
<addOnCode>2</addOnCode>
<name>addOn2</name>
<amount>200</amount>
<startDate>2013-09-04</startDate>
<endDate>2013-09-05</endDate>
</createAddOn>";
Assert.AreEqual(expected, actual);
}
public void TestSubscription_CanContainCreateDiscounts()
{
var subscription = new subscription();
subscription.planCode = "123abc";
var cd1 = new createDiscount();
cd1.discountCode = "1";
cd1.name = "cheaper";
cd1.amount = 200;
cd1.startDate = new DateTime(2013, 9, 5);
cd1.endDate = new DateTime(2013, 9, 6);
var cd2 = new createDiscount();
cd2.discountCode = "2";
cd2.name = "cheap";
cd2.amount = 100;
cd2.startDate = new DateTime(2013, 9, 3);
cd2.endDate = new DateTime(2013, 9, 4);
subscription.createDiscounts.Add(cd1);
subscription.createDiscounts.Add(cd2);
var actual = subscription.Serialize();
var expected = @"
<planCode>123abc</planCode>
<createDiscount>
<discountCode>1</discountCode>
<name>cheaper</name>
<amount>200</amount>
<startDate>2013-09-05</startDate>
<endDate>2013-09-06</endDate>
</createDiscount>
<createDiscount>
<discountCode>2</discountCode>
<name>cheap</name>
<amount>100</amount>
<startDate>2013-09-03</startDate>
<endDate>2013-09-04</endDate>
</createDiscount>";
Assert.AreEqual(expected, actual);
}
var(subscription, _) = e;
public subscription Put(int subscriptionId, [FromBody] subscription subscription)
{
return(subscription);
}
