[HttpPost, Route("ActivatePackage")] public async Task ActivatePackage([FromBody] RegisterServiceParamsMiniApp param) { ActivatePackageResultMiniApp result = new ActivatePackageResultMiniApp(); try { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTIme = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); var packages = dbInsurance.Products.Where(r => r.CompanyName == "miniapp" && r.Id == param.PackageId) .FirstOrDefault(); string subscriptionId = null; string bulkUserId = null; string policyNumber = null; string StatusCheck = "Active"; if (packages == null) { result.Message = "Fail!. Invlaid Package Id"; result.ResponseCode = "0001"; return result; } var apikey = packages.Category; var email = param.MobileNumber + "@webdoc.com.pk"; PasswordHasher h = new PasswordHasher(); var pass = h.HashPassword("1234"); int duration = Convert.ToInt32(packages.Duration.Split(' ')[0]); #region Insurance Entries var usercheckInsurance = dbInsurance.AspNetUsers.Where(r => r.Email == email) .FirstOrDefault(); if (usercheckInsurance == null) { var idInsurance = Guid.NewGuid(); var securitystampInsurance = Guid.NewGuid(); UserStore userStoreInsurance = new UserStore(); userStoreInsurance.Context.Database.Connection.ConnectionString = "data source=14.192.148.12,1433;initial catalog=KhushalInsurance;user id=sa;password=Admin@6464"; UserManager managerInsurance = new UserManager(userStoreInsurance); Models.AspNetUser aspInsurance = new Models.AspNetUser(); aspInsurance.Email = email; aspInsurance.Id = idInsurance.ToString(); aspInsurance.LockoutEnabled = true; aspInsurance.EmailConfirmed = false; aspInsurance.PasswordHash = pass; aspInsurance.SecurityStamp = securitystampInsurance.ToString(); aspInsurance.PhoneNumber = "0"; aspInsurance.PhoneNumberConfirmed = false; aspInsurance.TwoFactorEnabled = false; aspInsurance.AccessFailedCount = 1; aspInsurance.UserName = email; aspInsurance.Role = "Customer"; aspInsurance.Status = "Active"; dbInsurance.AspNetUsers.Add(aspInsurance); dbInsurance.SaveChanges(); //register role IdentityUserRole roleInsurance = new IdentityUserRole(); roleInsurance.RoleId = "Customer"; roleInsurance.UserId = idInsurance.ToString(); managerInsurance.AddToRoleAsync(roleInsurance.UserId, roleInsurance.RoleId); Models.CustomerProfile cpInsurance = new Models.CustomerProfile(); cpInsurance.ApplicationUserId = idInsurance.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; cpInsurance.Address = "-"; cpInsurance.Cnic = "-"; cpInsurance.IssuedDateCnic = "-"; cpInsurance.Gender = " "; cpInsurance.OpenId = param.OpenId; dbInsurance.CustomerProfiles.Add(cpInsurance); dbInsurance.SaveChanges(); if (param.PackageId == 1462 || param.PackageId == 1465) { string startDate = PakistanTIme.ToString("yyyy-MM-dd"); var bulkResponse = await BulkRegisterAsync(param.MobileNumber, packages.WebServiceUrl, startDate); dynamic bulkResult = Newtonsoft.Json.JsonConvert.DeserializeObject(bulkResponse); if (bulkResult != null && bulkResult.payLoad != null) { int successCount = bulkResult.payLoad.success_count; int failedCount = bulkResult.payLoad.failed_count; if (successCount > 0) { var firstSuccess = bulkResult.payLoad.success[0]; bulkUserId = firstSuccess.user_id; subscriptionId = firstSuccess.subscription.subscription_id; policyNumber = firstSuccess.subscription.policy_number; StatusCheck = "Active"; result.Message = "Success: Bulk Register Completed"; result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; result.UserId = firstSuccess.user_id; result.SubscriptionId = firstSuccess.subscription.subscription_id; result.PolicyNumber = firstSuccess.subscription.policy_number; } else { StatusCheck = "Failed"; // Extract first failed reason if available var reason = bulkResult.payLoad.failed != null && bulkResult.payLoad.failed.Count > 0 ? string.Join(", ", bulkResult.payLoad.failed[0].reason) : "Bulk Register failed"; result.Message = "Fail: " + reason; result.ResponseCode = "0001"; } } else { result.Message = "Warning: Bulk Register API returned unexpected result"; result.ResponseCode = "0001"; } } Models.Productsubscription ps = new Models.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = idInsurance.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ps.OpenId = param.OpenId; ps.RecUniqueid = " "; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme.AddDays(-1); ps.PolicyUserId = bulkUserId; ps.PolicySubscriptionId = subscriptionId; ps.Cnic = string.IsNullOrWhiteSpace(param.CNIC) ? null : param.CNIC; ps.RegistrationNo = string.IsNullOrWhiteSpace(param.RegistrationNo) ? null : param.RegistrationNo; dbInsurance.Productsubscriptions.Add(ps); dbInsurance.SaveChanges(); Models.RecursiveCharging rc = new Models.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(param.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = cpInsurance.ApplicationUserId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.OpenId = param.OpenId; rc.RecTransectionId = param.TransactionId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbInsurance.RecursiveChargings.Add(rc); dbInsurance.SaveChanges(); Models.TransactionDetail td = new Models.TransactionDetail(); td.Psid = ps.Id; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbInsurance.TransactionDetails.Add(td); dbInsurance.SaveChanges(); if (param.PackageId != 1462 && param.PackageId != 1465) { var service = "Insurance"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddHHmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } else { var checksubid = dbInsurance.Productsubscriptions.Where(t => t.ProductId == packages.Id //&& t.Status == "Active" && t.CustomerId == usercheckInsurance.Id && t.ExpiryDate < PakistanTIme) .FirstOrDefault(); if (checksubid != null) { result.Message = "Fail! already subscribe to same package"; result.ResponseCode = "0001"; result.TransectionID = "-"; result.PaymentMode = "-"; return result; } var profilecheckInsurance = dbInsurance.CustomerProfiles.Where(t => t.ApplicationUserId == usercheckInsurance.Id) .FirstOrDefault(); if (profilecheckInsurance == null) { Models.CustomerProfile cpInsurance = new Models.CustomerProfile(); cpInsurance.ApplicationUserId = usercheckInsurance.Id.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; cpInsurance.Address = "-"; cpInsurance.Cnic = "-"; cpInsurance.IssuedDateCnic = "-"; cpInsurance.Gender = "-"; cpInsurance.OpenId = param.OpenId; dbInsurance.CustomerProfiles.Add(cpInsurance); dbInsurance.SaveChanges(); if (param.PackageId == 1462 || param.PackageId == 1465) { string startDate = PakistanTIme.ToString("yyyy-MM-dd"); var bulkResponse = await BulkRegisterAsync(param.MobileNumber, packages.WebServiceUrl, startDate); dynamic bulkResult = Newtonsoft.Json.JsonConvert.DeserializeObject(bulkResponse); if (bulkResult?.payLoad != null) { int successCount = bulkResult.payLoad.success_count; int failedCount = bulkResult.payLoad.failed_count; if (successCount > 0 && bulkResult.payLoad.success.Count > 0) { var firstSuccess = bulkResult.payLoad.success[0]; bulkUserId = firstSuccess.user_id; subscriptionId = firstSuccess.subscription.subscription_id; policyNumber = firstSuccess.subscription.policy_number; result.Message = "Success: Bulk Register Completed"; result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddHHmmss"); // ✅ HH fix result.PaymentMode = "MiniApp"; result.UserId = bulkUserId; result.SubscriptionId = subscriptionId; result.PolicyNumber = policyNumber; } else { string reason = "Bulk Register failed"; if (bulkResult.payLoad.failed != null && bulkResult.payLoad.failed.Count > 0) { reason = string.Join(", ", bulkResult.payLoad.failed[0].reason); } result.Message = "Fail: " + reason; result.ResponseCode = "0001"; } } else { result.Message = "Fail: Invalid Bulk API response"; result.ResponseCode = "0001"; } } Models.Productsubscription ps = new Models.Productsubscription(); ps.BuyPkgDate = PakistanTIme; ps.ActiveDate = PakistanTIme; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ; ps.ProductId = packages.Id; ps.Status = "Active"; ps.OpenId = param.OpenId; ps.PolicyUserId = bulkUserId; ps.PolicySubscriptionId = subscriptionId; ps.Cnic = string.IsNullOrWhiteSpace(param.CNIC) ? null : param.CNIC; ps.RegistrationNo = string.IsNullOrWhiteSpace(param.RegistrationNo) ? null : param.RegistrationNo; dbInsurance.Productsubscriptions.Add(ps); dbInsurance.SaveChanges(); Models.RecursiveCharging rc = new Models.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(param.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = cpInsurance.ApplicationUserId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbInsurance.RecursiveChargings.Add(rc); dbInsurance.SaveChanges(); int psid = ps.Id; int pkgid = ps.ProductId; Models.TransactionDetail td = new Models.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = "Package Id is " + Convert.ToString(pkgid); td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbInsurance.TransactionDetails.Add(td); dbInsurance.SaveChanges(); if (param.PackageId != 1462 && param.PackageId != 1465) { var service = "Insurance"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddHHmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } else { if (profilecheckInsurance.OpenId == null) { profilecheckInsurance.OpenId = param.OpenId; dbInsurance.CustomerProfiles.Update(profilecheckInsurance); dbInsurance.SaveChanges(); } if (param.PackageId == 1462 || param.PackageId == 1465) { string startDate = PakistanTIme.ToString("yyyy-MM-dd"); var bulkResponse = await BulkRegisterAsync(param.MobileNumber, packages.WebServiceUrl, startDate); dynamic bulkResult = Newtonsoft.Json.JsonConvert.DeserializeObject(bulkResponse); if (bulkResult?.payLoad != null) { int successCount = bulkResult.payLoad.success_count; int failedCount = bulkResult.payLoad.failed_count; if (successCount > 0 && bulkResult.payLoad.success.Count > 0) { var firstSuccess = bulkResult.payLoad.success[0]; bulkUserId = firstSuccess.user_id; subscriptionId = firstSuccess.subscription.subscription_id; policyNumber = firstSuccess.subscription.policy_number; result.Message = "Success: Bulk Register Completed"; result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddHHmmss"); // ✅ HH fix result.PaymentMode = "MiniApp"; result.UserId = bulkUserId; result.SubscriptionId = subscriptionId; result.PolicyNumber = policyNumber; } else { string reason = null; if (bulkResult.payLoad.failed != null && bulkResult.payLoad.failed.Count > 0) { reason = string.Join(", ", bulkResult.payLoad.failed[0].reason); } result.Message = "Fail: " + reason; result.ResponseCode = "0001"; } } else { result.Message = "Fail: Invalid Bulk API response"; result.ResponseCode = "0001"; } } Models.Productsubscription ps = new Models.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ps.OpenId = param.OpenId; ps.RecUniqueid = " "; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; ps.PolicyUserId = bulkUserId; ps.PolicySubscriptionId = subscriptionId; ps.Cnic = string.IsNullOrWhiteSpace(param.CNIC) ? null : param.CNIC; ps.RegistrationNo = string.IsNullOrWhiteSpace(param.RegistrationNo) ? null : param.RegistrationNo; dbInsurance.Productsubscriptions.Add(ps); dbInsurance.SaveChanges(); Models.RecursiveCharging rc = new Models.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(param.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = profilecheckInsurance.ApplicationUserId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbInsurance.RecursiveChargings.Add(rc); dbInsurance.SaveChanges(); int psid = ps.Id; Models.TransactionDetail td = new Models.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbInsurance.TransactionDetails.Add(td); dbInsurance.SaveChanges(); if (param.PackageId != 1462 && param.PackageId != 1465) { var service = "Insurance"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddHHmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } } #endregion return result; } catch (Exception ex) { result.Message = "Fail!. Please contact the Webdoc Tech team" + ex.ToString(); result.ResponseCode = "0010"; return result; } } #region VetnaryPackage Activation [HttpPost, Route("MiniAppPackageActivationVetnary")] public async Task MiniAppPackageActivationVetnary([FromBody] RegisterServiceParamsMiniApp param) { ActivatePackageResultMiniApp result = new ActivatePackageResultMiniApp(); try { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTIme = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); var packages = dbVet.Products.Where(r => r.CompanyName == "MiniApp" && r.Id == param.PackageId) .FirstOrDefault(); if (packages == null) { result.Message = "Fail!. Invlaid Package Id"; result.ResponseCode = "0001"; return result; } var email = param.MobileNumber + "@vetdoctor.com.pk"; PasswordHasher h = new PasswordHasher(); var pass = h.HashPassword("1234"); int duration = Convert.ToInt32(packages.Duration.Split(' ')[0]); #region Insurance Entries var usercheckInsurance = dbVet.AspNetUsers.Where(r => r.Email == email) .FirstOrDefault(); if (usercheckInsurance == null) { var idInsurance = Guid.NewGuid(); var securitystampInsurance = Guid.NewGuid(); UserStore userStoreInsurance = new UserStore(); userStoreInsurance.Context.Database.Connection.ConnectionString = "data source=14.192.148.12,1433;initial catalog=KhushalInsurance;user id=sa;password=Admin@6464"; UserManager managerInsurance = new UserManager(userStoreInsurance); VetModels.AspNetUser aspInsurance = new VetModels.AspNetUser(); aspInsurance.Email = email; aspInsurance.Id = idInsurance.ToString(); aspInsurance.LockoutEnabled = true; aspInsurance.EmailConfirmed = false; aspInsurance.PasswordHash = pass; aspInsurance.SecurityStamp = securitystampInsurance.ToString(); aspInsurance.PhoneNumber = "0"; aspInsurance.PhoneNumberConfirmed = false; aspInsurance.TwoFactorEnabled = false; aspInsurance.AccessFailedCount = 1; aspInsurance.UserName = email; aspInsurance.Role = "Customer"; dbVet.AspNetUsers.Add(aspInsurance); dbVet.SaveChanges(); //register role IdentityUserRole roleInsurance = new IdentityUserRole(); roleInsurance.RoleId = "Customer"; roleInsurance.UserId = idInsurance.ToString(); managerInsurance.AddToRoleAsync(roleInsurance.UserId, roleInsurance.RoleId); VetModels.CustomerProfile cpInsurance = new VetModels.CustomerProfile(); cpInsurance.ApplicationUserId = idInsurance.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; //cpInsurance.Address = "-"; //cpInsurance.Cnic = "-"; //cpInsurance.IssuedDateCnic = "-"; //cpInsurance.Gender = " "; cpInsurance.OpenId = param.OpenId; dbVet.CustomerProfiles.Add(cpInsurance); dbVet.SaveChanges(); VetModels.Productsubscription ps = new VetModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ps.RecUniqueid = ""; ps.OpenId = param.OpenId; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbVet.Productsubscriptions.Add(ps); dbVet.SaveChanges(); VetModels.RecursiveCharging rc = new VetModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbVet.RecursiveChargings.Add(rc); dbVet.SaveChanges(); var service = "Vet"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Vet"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else { var checksubid = dbVet.Productsubscriptions.Where(t => t.ProductId == packages.Id && t.Status == "Active" && t.CustomerId == usercheckInsurance.Id && t.ExpiryDate < PakistanTIme) .FirstOrDefault(); if (checksubid != null) { result.Message = "Fail! already subscribe to same package"; result.ResponseCode = "0001"; result.TransectionID = "-"; result.PaymentMode = "-"; return result; } var profilecheckInsurance = dbVet.CustomerProfiles.Where(t => t.ApplicationUserId == usercheckInsurance.Id).FirstOrDefault(); if (profilecheckInsurance == null) { VetModels.CustomerProfile cpInsurance = new VetModels.CustomerProfile(); cpInsurance.ApplicationUserId = usercheckInsurance.Id.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; cpInsurance.RegDatetime = PakistanTIme; cpInsurance.OpenId = param.OpenId; dbVet.CustomerProfiles.Add(cpInsurance); dbVet.SaveChanges(); VetModels.Productsubscription ps = new VetModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ps.RecUniqueid = ""; ps.OpenId = param.OpenId; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbVet.Productsubscriptions.Add(ps); dbVet.SaveChanges(); int psid = ps.Id; VetModels.TransactionDetail td = new VetModels.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbVet.TransactionDetails.Add(td); dbVet.SaveChanges(); VetModels.RecursiveCharging rc = new VetModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbVet.RecursiveChargings.Add(rc); dbVet.SaveChanges(); var service = "Vet"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Vet"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else { if (profilecheckInsurance.OpenId == null) { profilecheckInsurance.OpenId = param.OpenId; dbVet.CustomerProfiles.Update(profilecheckInsurance); dbVet.SaveChanges(); } VetModels.Productsubscription ps = new VetModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ps.RecUniqueid = ""; ps.OpenId = param.OpenId; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbVet.Productsubscriptions.Add(ps); dbVet.SaveChanges(); int psid = ps.Id; VetModels.TransactionDetail td = new VetModels.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbVet.TransactionDetails.Add(td); dbVet.SaveChanges(); VetModels.RecursiveCharging rc = new VetModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbVet.RecursiveChargings.Add(rc); dbVet.SaveChanges(); var service = "Vet"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Vet"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } #endregion return result; } catch (Exception ex) { result.Message = "Fail!. Please contact the Webdoc Tech team" + ex.ToString(); result.ResponseCode = "0010"; return result; } } #endregion #region Agri Activation [HttpPost, Route("MiniAppPackageActivationAgri")] public async Task MiniAppPackageActivationAgri([FromBody] RegisterServiceParamsMiniApp param) { ActivatePackageResultMiniApp result = new ActivatePackageResultMiniApp(); try { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTIme = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); var packages = dbAgri.Products.Where(r => r.CompanyName == "MiniApp" && r.Id == param.PackageId) .FirstOrDefault(); if (packages == null) { result.Message = "Fail!. Invlaid Package Id"; result.ResponseCode = "0001"; return result; } var email = param.MobileNumber + "@kashtkaar.com.pk"; PasswordHasher h = new PasswordHasher(); var pass = h.HashPassword("1234"); int duration = Convert.ToInt32(packages.Duration.Split(' ')[0]); #region Insurance Entries var usercheckInsurance = dbAgri.AspNetUsers.Where(r => r.Email == email) .FirstOrDefault(); if (usercheckInsurance == null) { var idInsurance = Guid.NewGuid(); var securitystampInsurance = Guid.NewGuid(); UserStore userStoreInsurance = new UserStore(); userStoreInsurance.Context.Database.Connection.ConnectionString = "data source=14.192.148.12,1433;initial catalog=KhushalInsurance;user id=sa;password=Admin@6464"; UserManager managerInsurance = new UserManager(userStoreInsurance); AgriModels.AspNetUser aspInsurance = new AgriModels.AspNetUser(); aspInsurance.Email = email; aspInsurance.Id = idInsurance.ToString(); aspInsurance.LockoutEnabled = true; aspInsurance.EmailConfirmed = false; aspInsurance.PasswordHash = pass; aspInsurance.SecurityStamp = securitystampInsurance.ToString(); aspInsurance.PhoneNumber = "0"; aspInsurance.PhoneNumberConfirmed = false; aspInsurance.TwoFactorEnabled = false; aspInsurance.AccessFailedCount = 1; aspInsurance.UserName = email; aspInsurance.Role = "Customer"; dbAgri.AspNetUsers.Add(aspInsurance); dbAgri.SaveChanges(); //register role IdentityUserRole roleInsurance = new IdentityUserRole(); roleInsurance.RoleId = "Customer"; roleInsurance.UserId = idInsurance.ToString(); managerInsurance.AddToRoleAsync(roleInsurance.UserId, roleInsurance.RoleId); AgriModels.CustomerProfile cpInsurance = new AgriModels.CustomerProfile(); cpInsurance.ApplicationUserId = idInsurance.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; //cpInsurance.Cnic = "-"; //cpInsurance.Gender = ""; cpInsurance.OpenId = param.OpenId; dbAgri.CustomerProfiles.Add(cpInsurance); dbAgri.SaveChanges(); AgriModels.Productsubscription ps = new AgriModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = idInsurance.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ; ps.OpenId = param.OpenId; ps.RecUniqueid = ""; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbAgri.Productsubscriptions.Add(ps); dbAgri.SaveChanges(); int psid = ps.Id; AgriModels.TransactionDetail td = new AgriModels.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbAgri.TransactionDetails.Add(td); dbAgri.SaveChanges(); AgriModels.RecursiveCharging rc = new AgriModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbAgri.RecursiveChargings.Add(rc); dbAgri.SaveChanges(); var service = "Agri"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Agri"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else { var checksubid = dbAgri.Productsubscriptions.Where(t => t.ProductId == packages.Id && t.Status == "Active" && t.CustomerId == usercheckInsurance.Id && t.ExpiryDate < PakistanTIme ) .FirstOrDefault(); if (checksubid != null) { result.Message = "Fail! already subscribe to same package"; result.ResponseCode = "0001"; result.TransectionID = "-"; result.PaymentMode = "-"; return result; } var profilecheckInsurance = dbAgri.CustomerProfiles.Where(t => t.ApplicationUserId == usercheckInsurance.Id) .FirstOrDefault(); if (profilecheckInsurance == null) { AgriModels.CustomerProfile cpInsurance = new AgriModels.CustomerProfile(); cpInsurance.ApplicationUserId = usercheckInsurance.Id.ToString(); cpInsurance.Name = param.Name; cpInsurance.MobileNumber = param.MobileNumber; cpInsurance.Cnic = "-"; cpInsurance.Gender = "-"; cpInsurance.OpenId = param.OpenId; dbAgri.CustomerProfiles.Add(cpInsurance); dbAgri.SaveChanges(); AgriModels.Productsubscription ps = new AgriModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ; ps.OpenId = param.OpenId; ps.RecUniqueid = ""; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbAgri.Productsubscriptions.Add(ps); dbAgri.SaveChanges(); int psid = ps.Id; AgriModels.TransactionDetail td = new AgriModels.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbAgri.TransactionDetails.Add(td); dbAgri.SaveChanges(); AgriModels.RecursiveCharging rc = new AgriModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbAgri.RecursiveChargings.Add(rc); dbAgri.SaveChanges(); var service = "Agri"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Agri"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else { if (profilecheckInsurance.OpenId == null) { profilecheckInsurance.OpenId = param.OpenId; dbAgri.CustomerProfiles.Update(profilecheckInsurance); dbAgri.SaveChanges(); } AgriModels.Productsubscription ps = new AgriModels.Productsubscription(); ps.ProductId = packages.Id; ps.CustomerId = usercheckInsurance.Id.ToString(); ps.ActiveDate = PakistanTIme; ps.ExpiryDate = PakistanTIme.AddDays(duration); ps.Status = "Active"; ps.PolicyNo = "WD-" + PakistanTIme.ToString("yyyyMMddhhmmss"); ; ps.OpenId = param.OpenId; ps.RecUniqueid = ""; ps.BuyPkgDate = PakistanTIme; ps.UnSubDate = PakistanTIme; dbAgri.Productsubscriptions.Add(ps); dbAgri.SaveChanges(); int psid = ps.Id; AgriModels.TransactionDetail td = new AgriModels.TransactionDetail(); td.Psid = psid; td.BankName = "EasyPaise"; td.TransactionId = param.TransactionId; td.PaymentMode = "Wallet"; td.OrderId = param.OrderId; td.Remarks = ""; td.Coverage = param.Coverage; td.TransactionStatus = param.TransactionStatus; td.Date = PakistanTIme; dbAgri.TransactionDetails.Add(td); dbAgri.SaveChanges(); AgriModels.RecursiveCharging rc = new AgriModels.RecursiveCharging(); rc.ProductsubscriptionId = ps.Id; rc.Amount = Convert.ToString(packages.Price); rc.Package = Convert.ToString(packages.Id); rc.CustomerId = ps.CustomerId; rc.Status = "Pending"; rc.Remarks = ""; rc.Type = "Initial"; rc.RecTransectionId = param.TransactionId; rc.OpenId = param.OpenId; rc.NextChargeDate = PakistanTIme.AddDays(duration); dbAgri.RecursiveChargings.Add(rc); dbAgri.SaveChanges(); var service = "Agri"; var recursiveAmount = Convert.ToString(packages.Price); var openId = param.OpenId; var recursivePaymentDate = PakistanTIme.AddDays(duration); //Next chage date var rcid = rc.Id; string recursivePaymentDateString = recursivePaymentDate.ToString("yyyy-MM-dd"); var OPTRecursives = await OPTRecursive(recursiveAmount, openId, service, recursivePaymentDateString, rcid, "Agri"); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = "WD" + PakistanTIme.ToString("yyyyMMddhhmmss"); result.PaymentMode = "MiniApp"; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } #endregion } catch (Exception ex) { result.Message = "Fail!. Please contact the Webdoc Tech Team" + ex.ToString(); result.ResponseCode = "0010"; } return result; } #endregion [HttpGet, Route("GetMyActivePackages")] public GetMyPackagesResponse GetMyActivePackages(string OpenId) { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); GetMyPackagesResponse result = new GetMyPackagesResponse(); result.packages = new List(); try { //var uid = dbInsurance.AspNetUsers.Where(i => i.Email == OpenId).FirstOrDefault(); // Khushal Insurance var Insurancecustomerpkg = dbInsurance.Productsubscriptions.Include(t => t.Product) .Include(t => t.Customer) .Where(i => i.OpenId == OpenId && i.ExpiryDate > PakistanTime /*&& i.Status != "Unsub"*/) .OrderByDescending(i => i.ActiveDate) .ToList(); if (Insurancecustomerpkg.Count > 0) { foreach (var subscribepkg in Insurancecustomerpkg) { ActivePacakgeDetails temp = new ActivePacakgeDetails(); temp.ActivePackage.Serivcename = "Insurance"; temp.Category = subscribepkg.Product.Category; temp.ActivePackage.ProductId = subscribepkg.ProductId; temp.ActivePackage.ExpiryDate = subscribepkg.ExpiryDate.ToString("dd MMM yyyy"); temp.ActivePackage.ProductName = subscribepkg.Product.ProductName; temp.ActivePackage.Status = subscribepkg.Status; temp.ActivePackage.ProductPrice = subscribepkg.Product.Price.ToString(); temp.ActivePackage.ActivateDate = subscribepkg.ActiveDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.Duration = subscribepkg.Product.Duration; result.packages.Add(temp); } } var Healthcustomerpkg = dbHealth.WeeklySubscriptions.Include(t => t.InsuranceProduct) .Where(i => i.ExternalUniqueId == OpenId && i.ExpiryDate > PakistanTime /*&& i.Status != "Unsub"*/) .OrderByDescending(i => i.ActiveDate) .ToList(); if (Healthcustomerpkg.Count > 0) { foreach (var pkg in Healthcustomerpkg) { ActivePacakgeDetails temp = new ActivePacakgeDetails(); temp.ActivePackage.Serivcename = "WebDoc"; temp.ActivePackage.ProductId = pkg.InsuranceProductId; temp.Category = "Call A Doc"; temp.ActivePackage.ProductName = pkg.InsuranceProduct.Description; temp.ActivePackage.ProductPrice = pkg.InsuranceProduct.Price.ToString(); temp.ActivePackage.ActivateDate = pkg.ActiveDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.ExpiryDate = pkg.ExpiryDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.Duration = pkg.InsuranceProduct.Duration; result.packages.Add(temp); } } // Vet //var VetId = rsadata.AspNetUsers.Where(i => i.Email == OpenId).FirstOrDefault(); var VetId = dbVet.Productsubscriptions.Include(c => c.Customer) .Include(c => c.Product) .Where(c => c.OpenId == OpenId && c.ExpiryDate > PakistanTime /*&& c.Status != "Unsub"*/) .OrderByDescending(i => i.ActiveDate) .ToList(); if (VetId.Count > 0) { foreach (var pkg in VetId) { ActivePacakgeDetails temp = new ActivePacakgeDetails(); temp.ActivePackage.ProductId = pkg.ProductId; temp.Category = pkg.Product.CompanyName; temp.ActivePackage.Serivcename = "Vet"; temp.ActivePackage.ProductName = pkg.Product.ProductName; temp.ActivePackage.Status = pkg.Status; temp.ActivePackage.ProductPrice = pkg.Product.Price.ToString(); temp.ActivePackage.ActivateDate = pkg.ActiveDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.ExpiryDate = pkg.ExpiryDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.Duration = pkg.Product.Duration; result.packages.Add(temp); } } // Agri //var AgriId = rsadata.AspNetUsers.Where(i => i.Email == OpenId).FirstOrDefault(); var AgriId = dbAgri.Productsubscriptions.Include(c => c.Customer) .Include(c => c.Product) .Where(c => c.OpenId == OpenId && c.ExpiryDate > PakistanTime /*&& c.Status != "Unsub"*/) .OrderByDescending(i => i.ActiveDate) .ToList(); if (AgriId.Count > 0) { foreach (var pkg in AgriId) { ActivePacakgeDetails temp = new ActivePacakgeDetails(); temp.ActivePackage.ProductId = pkg.ProductId; temp.Category = pkg.Product.CompanyName; temp.ActivePackage.Serivcename = "Agri"; temp.ActivePackage.ProductName = pkg.Product.ProductName; temp.ActivePackage.Status = pkg.Status; temp.ActivePackage.ProductPrice = pkg.Product.Price.ToString(); temp.ActivePackage.ActivateDate = pkg.ActiveDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.ExpiryDate = pkg.ExpiryDate.ToString("dd-MMM-yyyy"); temp.ActivePackage.Duration = pkg.Product.Duration; result.packages.Add(temp); } } if (result.packages.Count > 0) { result.Message = "Success"; result.ResponseCode = "0000"; } else { result.Message = "Fail! No Package Found Against the User"; result.ResponseCode = "0001"; } return result; } catch (Exception ex) { result.Message = "Fail! Kindly contact to Webdoc at support@webdoc.com.pk with the screenshot. Error: " + ex.Message; result.ResponseCode = "0010"; return result; } } [HttpPost, Route("UnsubServices")] public async Task UnsubServices([FromBody] PostUnsub param) { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); ActivatePackageResultMiniApp result = new ActivatePackageResultMiniApp(); var packages = dbInsurance.Products.Where(r => r.CompanyName == "miniapp" && r.Id == param.pid) .FirstOrDefault(); var apikey = packages.Category; try { if (param.Service == "Insurance") { var User = dbInsurance.Productsubscriptions.Where(c => c.OpenId == param.OpenId && c.ProductId == param.pid && c.Status == "Active") .FirstOrDefault(); if (User == null) { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; result.Message = "Fail! no Active Subscriptions"; return result; } User.Status = "Unsub"; dbInsurance.SaveChanges(); if (User.ProductId == 1462 || User.ProductId == 1465) { result.Message = "Sucessfully Unsubcribe"; result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; } if (User.ProductId != 1462 && User.ProductId != 1465) { var service = "Insurance"; var rcid = User.Id; var recursiveId = User.RecUniqueid; var OPTRecursives = await OPTOut(recursiveId, service, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } } else if (param.Service == "Agri") { var User = dbAgri.Productsubscriptions.Where(c => c.OpenId == param.OpenId && c.ProductId == param.pid && c.Status == "Active").FirstOrDefault(); if (User == null) { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; result.Message = "Fail! no Active Subscriptions"; return result; } User.Status = "Unsub"; dbAgri.SaveChanges(); var service = "Agri"; var rcid = User.Id; var recursiveId = User.RecUniqueid; var OPTRecursives = await OPTOut(recursiveId, service, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else if (param.Service == "Vet") { var User = dbVet.Productsubscriptions.Where(c => c.OpenId == param.OpenId && c.ProductId == param.pid && c.Status == "Active").FirstOrDefault(); if (User == null) { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; result.Message = "Fail! no Active Subscriptions"; return result; } User.Status = "Unsub"; dbVet.SaveChanges(); var service = "Vet"; var rcid = User.Id; var recursiveId = User.RecUniqueid; var OPTRecursives = await OPTOut(recursiveId, service, rcid, apikey); result.Message = OPTRecursives.RecursiveMessage; if (OPTRecursives.Result.ResultCode == "SUCCESS") { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; } else { result.ResponseCode = "0001"; result.TransectionID = ""; result.PaymentMode = ""; } } else if (param.Service == "WebDoc") { var User = dbHealth.WeeklySubscriptions.Where(c => c.PatientProfile.EmployeeCode == param.OpenId && c.InsuranceProductId == param.pid && c.Status == "Active").FirstOrDefault(); if (User == null) { result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; result.Message = "Fail! no Active Subscriptions"; return result; } User.Status = "Unsub"; dbHealth.SaveChanges(); result.ResponseCode = "0000"; result.TransectionID = ""; result.PaymentMode = ""; result.Message = "Success"; //var service = "WebDoc"; //var rcid = User.Id; //var recursiveId = ""; //var OPTRecursives = await OPTOut(recursiveId, service, rcid); //result.Message = OPTRecursives.RecursiveMessage; //if (OPTRecursives.Result.ResultCode == "SUCCESS") //{ // result.ResponseCode = "0000"; // result.TransectionID = ""; // result.PaymentMode = ""; //} //else //{ // result.ResponseCode = "0001"; // result.TransectionID = ""; // result.PaymentMode = ""; //} } else { result.Message = "User Not Found"; result.ResponseCode = "0010"; } } catch (Exception ex) { result.Message = "Fail!. Please contact the Webdoc Tech team" + ex.ToString(); result.ResponseCode = "0010"; } return result; } [HttpGet, Route("CheckCategoryPackages")] public CheckCategoryPackagesResult CheckCategoryPackages(int id, string customerNumber, string service) { string zoneId = "Pakistan Standard Time"; TimeZoneInfo zone = TimeZoneInfo.FindSystemTimeZoneById(zoneId); DateTime PakistanTIme = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, zone); CheckCategoryPackagesResult result = new CheckCategoryPackagesResult(); if (service == "insurance") { var email = customerNumber + "@webdoc.com.pk"; var temp = dbInsurance.AspNetUsers.Where(t => t.Email == email).FirstOrDefault(); if (temp != null) { var checkpkg = dbInsurance.Productsubscriptions .Include(p => p.Product) .Include(t => t.TransactionDetails) .Where(p => p.Product.CategoryId == id && p.Status == "Active" && p.CustomerId == temp.Id && p.ExpiryDate.Date > PakistanTIme.Date) .OrderByDescending(p => p.ExpiryDate) .FirstOrDefault(); if (checkpkg == null) { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } else { var rc = dbInsurance.RecursiveChargings.Where(i => i.ProductsubscriptionId == checkpkg.Id).FirstOrDefault(); if (rc == null) { result.Message = "Fail!. No Recursive Charging found"; result.ResponseCode = "0001"; } result.Features = checkpkg.Product.Features; result.SubscriberId = checkpkg.Id; result.PName = checkpkg.Product.ProductName; result.PkgPrice = "Rs." + Convert.ToDouble(rc.Amount); result.pid = checkpkg.Product.Id; result.Status = checkpkg.Status; result.PolicyNo = checkpkg.PolicyNo; result.ActivateDate = checkpkg.ActiveDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); result.ExpiryDate = checkpkg.ExpiryDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); result.Coverage = checkpkg.TransactionDetails.FirstOrDefault().Coverage; result.PolicyUserId = checkpkg.PolicyUserId; result.PolicySubscriptionID = checkpkg.PolicySubscriptionId; result.Message = "Success"; result.ResponseCode = "0000"; } } else { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } return result; } else if (service == "agri") { var email = customerNumber + "@kashtkaar.com.pk"; var temp = dbAgri.AspNetUsers.Where(t => t.Email == email).FirstOrDefault(); if (temp != null) { var checkpkg = dbAgri.Productsubscriptions .Include(p => p.Product) .Where(p => p.Product.CategoryId == id && p.Status == "Active" && p.CustomerId == temp.Id && p.ExpiryDate.Date > PakistanTIme.Date) .OrderByDescending(p => p.ExpiryDate) .FirstOrDefault(); if (checkpkg == null) { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } else { result.Message = "Success"; result.ResponseCode = "0000"; result.Features = checkpkg.Product.Features; result.SubscriberId = checkpkg.Id; result.Coverage = checkpkg.Product.Coverage.ToString(); result.PName = checkpkg.Product.ProductName; result.Status = checkpkg.Status; result.PolicyNo = checkpkg.PolicyNo; result.ActivateDate = checkpkg.ActiveDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); result.ExpiryDate = checkpkg.ExpiryDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); } } else { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } return result; } else if (service == "vets") { var email = customerNumber + "@vetdoctor.com.pk"; var temp = dbVet.AspNetUsers.Where(t => t.Email == email).FirstOrDefault(); if (temp != null) { var checkpkg = dbVet.Productsubscriptions .Include(p => p.Product) .Where(p => p.Product.CategoryId == id && p.Status == "Active" && p.CustomerId == temp.Id && p.ExpiryDate.Date > PakistanTIme.Date) .OrderByDescending(p => p.ExpiryDate) .FirstOrDefault(); if (checkpkg == null) { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } else { result.Message = "Success"; result.ResponseCode = "0000"; result.Features = checkpkg.Product.Features; result.SubscriberId = checkpkg.Id; result.Coverage = checkpkg.Product.Coverage.ToString(); result.PName = checkpkg.Product.ProductName; result.Status = checkpkg.Status; result.PolicyNo = checkpkg.PolicyNo; result.ActivateDate = checkpkg.ActiveDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); result.ExpiryDate = checkpkg.ExpiryDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); } } else { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } return result; } else if (service == "Health") { var email = customerNumber + "@webdoc.com.pk"; var temp = dbHealth.AspNetUsers.Where(t => t.Email == email).FirstOrDefault(); if (temp != null) { var checkpkg = dbHealth.WeeklySubscriptions .Include(p => p.InsuranceProduct) .Where(p => p.Status == "Active" && p.PatientProfileId == temp.Id && p.ExpiryDate.Date > PakistanTIme.Date) .OrderByDescending(p => p.ExpiryDate) .FirstOrDefault(); if (checkpkg == null) { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } else { result.Message = "Success"; result.ResponseCode = "0000"; result.Features = checkpkg.InsuranceProduct.Addonfeatures; result.SubscriberId = checkpkg.Id; result.Coverage = "10000"; result.PName = checkpkg.InsuranceProduct.Description; result.Status = checkpkg.Status; result.PolicyNo = "WD-12358461"; result.ActivateDate = checkpkg.ActiveDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); result.ExpiryDate = checkpkg.ExpiryDate.ToString("dd-MMM-yyyy hh:mm:ss tt"); } } else { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; } return result; } else { result.Message = "Fail!. No package found"; result.ResponseCode = "0001"; return result; } }