public async Task InsertChargeAsync(ChargeDTO charge)
{
var gateway = _gatewayFactory.CreateChargeTableGateway();
int id = await gateway.InsertChargeAsync(charge);
charge.Id = id;
}
public async Task UpdateChargeAsync(int chargeId, ChargeDTO chargeDTO)
{
var gateway = _gatewayFactory.CreateChargeTableGateway();
chargeDTO.Id = chargeId;
await gateway.UpdateChargeAsync(chargeDTO);
}
public string SaveCharge(ChargeModels chargeModel)
{
ChargeDTO charge = new ChargeDTO();
MessageDTO message = new MessageDTO();
charge.Company = new CompanyDTO {
CompanyId = Convert.ToInt32(chargeModel.CompanyId)
};
charge.ChargeDescription = chargeModel.ChargeDescription;
charge.ChargeId = Convert.ToInt32(chargeModel.Id);
charge.ChargeStatus = chargeModel.ChargeStatus;
charge.User = new UserDTO {
UserId = Convert.ToInt32(chargeModel.UserId)
};
if (String.Compare(chargeModel.Operation, "add", StringComparison.Ordinal) == 0)
{
message = business.SaveCharge(charge, "I");
}
else if (String.Compare(chargeModel.Operation, "edit", StringComparison.Ordinal) == 0)
{
message = business.SaveCharge(charge, "U");
}
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
public async Task <IEnumerable <ChargeDTO> > GetChargesAsync(int buildingId)
{
var result = new List <ChargeDTO>();
using (var connecion = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpGetCharges]";
cmd.Parameters.AddWithValue("@buildingId", buildingId);
cmd.Connection = connecion;
cmd.Connection.Open();
using (var dataReader = await cmd.ExecuteReaderAsync())
{
while (await dataReader.ReadAsync())
{
var charge = new ChargeDTO();
charge.Id = Convert.ToInt32(dataReader["ChargeID"]);
charge.BuildingId = buildingId;
charge.From = Convert.ToDateTime(dataReader["From"]);
charge.To = Convert.ToDateTime(dataReader["To"]);
result.Add(charge);
}
}
}
}
return(result);
}
public async Task <Charge> Charge(ChargeDTO charge)
{
var idClaim = _httpContextAccessor.HttpContext.User.FindFirst(ClaimTypes.NameIdentifier).Value;
if (!long.TryParse(idClaim, out var ownerId))
{
throw new UnauthorizedAccessException();
}
var ownerUser = await _userRepository.GetByIdAsync(ownerId);
var customers = new CustomerService();
var charges = new Stripe.ChargeService();
var customer = await customers.CreateAsync(new CustomerCreateOptions
{
Email = ownerUser.Email,
SourceToken = charge.Token
});
var newCharge = await charges.CreateAsync(new ChargeCreateOptions
{
Amount = charge.Value,
Description = "Test charge",
Currency = charge.Currency,
CustomerId = customer.Id
});
return(newCharge);
}
public async Task <ActionResult> AddCharge([FromBody] ChargeDTO request)
{
request.CashierId = int.Parse(_applicationUser.GetUserName());
request.CardId = JsonConvert.DeserializeObject <CardDTO>(CryptoMethods.DecryptString(request.CardToken)).Id;
var charge = await _chargeAppService.AddCharge(request);
return(Ok(charge));
}
public static ChargeResponseBuilding ToModel(this ChargeDTO charge)
{
var model = new ChargeResponseBuilding();
model.ChargeId = charge.Id;
model.BuildingId = charge.BuildingId;
model.From = charge.From;
model.To = charge.To;
return(model);
}
public static ChargeDTO ToDTO(this CreateChargeRequest chargeRequest)
{
var dto = new ChargeDTO
{
BuildingId = chargeRequest.BuildingId,
From = chargeRequest.From,
To = chargeRequest.To
};
return(dto);
}
/// <summary>
///
/// </summary>
/// <param name="whereClause"></param>
/// <param name="dataTable"></param>
/// <returns></returns>
public List <ChargeDTO> GetCharges(Dictionary <string, string> whereClause, ref DataTable dataTable)
{
DataSet dataSet = new DataSet();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
var charges = new List <ChargeDTO>();
int companyId = Convert.ToInt32(whereClause["companyId"]);
int pageSize = Convert.ToInt32(whereClause["pageSize"]);
int pageNumber = Convert.ToInt32(whereClause["pageNumber"]);
string sortColumn = whereClause["sortColumn"].ToString();
string sortOrder = whereClause["sortOrder"].ToString();
try
{
//Todos los registros
object[] parameters = new object[] { companyId, pageSize, pageNumber, sortColumn, sortOrder };
connector.FillDataSet(dataSet, CommandType.StoredProcedure, "GetCharges", parameters);
if (dataSet.Tables[1].Rows.Count > 0)
{
dataTable = dataSet.Tables[0];
foreach (DataRow row in dataSet.Tables[1].Rows)
{
ChargeDTO charge = new ChargeDTO
{
Company = new CompanyDTO {
CompanyId = Convert.ToInt32(row["COMPANY_ID"])
},
ChargeDescription = row["CHARGE_DESCRIPTION"].ToString(),
ChargeId = Convert.ToInt32(row["CHARGE_ID"]),
ChargeStatus = row["CHARGE_STATUS"].ToString()
};
charges.Add(charge);
}
}
else
{
charges = null;
}
}
catch (Exception exception)
{
charges = null;
}
finally
{
connector.Dispose();
}
return(charges);
}
public async Task <ChargeDTO> AddCharge(ChargeDTO chargeDTO)
{
var charge = new Charge(
chargeDTO.CashierId,
chargeDTO.CardId,
chargeDTO.ChargeType,
new Money(chargeDTO.Amount.Currency, chargeDTO.Amount.Value),
_resources.GetStringResource(LocalizationKeys.Application.messages_CreateChargeDisplayName),
chargeDTO.Description
);
_chargeRepository.Add(charge);
await _chargeRepository.UnitOfWork.CommitAsync();
//TODO enviar push notification a contacto indicando que tiene un cobro pendiente
return(charge.ProjectedAs <ChargeDTO>());
}
public async Task <IActionResult> Charge(ChargeDTO model)
{
try
{
await _chargeService.Charge(model);
return(Ok());
}
catch (UnauthorizedAccessException)
{
return(Unauthorized());
}
catch (Exception e)
{
return(BadRequest(new { e.Message }));
}
}
private void btnClean_Click(object sender, RoutedEventArgs e)
{
if (mObjSelectedChargeDTO != null && !string.IsNullOrEmpty(txtFileToImport.Text))
{
UndoRelation();
mObjSelectedChargeDTO = null;
}
//if (!string.IsNullOrEmpty(txtFileToImport.Text))
//{
// SetControlsFileSellers(txtFileToImport.Text);
//}
//if (mObjAuction != null)
//{
// SetControlsAuctionSellers(mObjAuction);
//}
}
public async Task UpdateChargeAsync(ChargeDTO charge)
{
using (var connection = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpChargeUpdate]";
cmd.Parameters.AddWithValue("@chargeId", charge.Id);
cmd.Parameters.AddWithValue("@buildingId", charge.BuildingId);
cmd.Parameters.AddWithValue("@from", charge.From);
cmd.Parameters.AddWithValue("@to", charge.To);
cmd.Connection = connection;
cmd.Connection.Open();
await cmd.ExecuteNonQueryAsync();
}
}
}
//string connectionString = ConfigurationManager.ConnectionStrings["ConnectionTA"].ToString();
#endregion
#region Charge
/// <summary>
///
/// </summary>
/// <param name="charge"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveCharge(ChargeDTO charge, string operation)
{
DataTable dataTable = new DataTable();
IUniversalConnector connector = new UniversalConnectorImpl(ServerEnumType.SqlServer, connectionString);
MessageDTO message = new MessageDTO();
try
{
connector.BeginTransaction();
//Todos los registros
object[] parameters = new object[] { charge.ChargeId, charge.Company.CompanyId,
charge.User.UserId, charge.ChargeDescription,
charge.ChargeStatus, operation };
//connector.ExecuteNonQuery(CommandType.StoredProcedure, "SaveCharge", parameters);
dataTable = connector.ExecuteDataTable(CommandType.StoredProcedure, "SaveCharge", parameters);
foreach (DataRow row in dataTable.Rows)
{
message.ErrorCode = row["ERROR_NUMBER"].ToString();
message.ErrorMessage = row["ERROR_DESCRIPTION"].ToString();
}
if (message.ErrorCode == "0")
{
connector.Commit();
}
else
{
connector.RollBack();
}
}
catch (Exception exception)
{
message.ErrorCode = "-1";
message.ErrorMessage = exception.ToString();
connector.RollBack();
}
finally
{
connector.Dispose();
}
return(message);
}
public ActionResult Create(ChargeDTO chargeDTO)
{
// Set your secret key: remember to change this to your live secret key in production
// See your keys here: https://dashboard.stripe.com/account/apikeys
StripeConfiguration.ApiKey = "sk_test_qtxcZhc7axpT1Rsh1jIaanrq00gJmUHsE1";
// Token is created using Checkout or Elements!
// Get the payment token submitted by the form:
//var token = model.Token; // Using ASP.NET MVC
var customerOptions = new CustomerCreateOptions
{
Description = chargeDTO.name,
Name = chargeDTO.name,
Source = chargeDTO.stripeToken,
Email = chargeDTO.email,
Metadata = new Dictionary <string, string>()
{
{ "Phone Number", chargeDTO.phone },
{ "Street", chargeDTO.street }
}
};
var customerService = new CustomerService();
Customer customer = customerService.Create(customerOptions);
var options = new ChargeCreateOptions
{
Amount = chargeDTO.price * 100,
Currency = "eur",
Description = "Charge for " + customer.Email,
//Source = chargeDTO.stripeToken,
Customer = customer.Id
};
var service = new ChargeService();
Charge charge = service.Create(options);
var model = new ChargeViewModel();
model.ChargeId = charge.Id;
Session["userPhones"] = null;
return(View("OrderStatus", model));
}
public string DeleteCharge(int chargeId, int companyId, int userId)
{
ChargeDTO charge = new ChargeDTO();
MessageDTO message = new MessageDTO();
charge.Company = new CompanyDTO {
CompanyId = companyId
};
charge.ChargeDescription = "";
charge.ChargeId = chargeId;
charge.ChargeStatus = "";
charge.User = new UserDTO {
UserId = userId
};
message = business.SaveCharge(charge, "D");
JavaScriptSerializer oSerializer = new JavaScriptSerializer();
string sJSON = oSerializer.Serialize(message);
return(sJSON);
}
public async Task <int> InsertChargeAsync(ChargeDTO charge)
{
int id = 0;
using (var connection = new SqlConnection(_connectionString))
{
using (var cmd = new SqlCommand())
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "[dbo].[SpCreateCharge]";
cmd.Parameters.AddWithValue("@buildingId", charge.BuildingId);
cmd.Parameters.AddWithValue("@from", charge.From);
cmd.Parameters.AddWithValue("@to", charge.To);
cmd.Connection = connection;
cmd.Connection.Open();
var result = await cmd.ExecuteScalarAsync();
id = Convert.ToInt32(result);
}
}
return(id);
}
private void btnRelate_Click(object sender, RoutedEventArgs e)
{
ChargeDTO lObjAuctionSeller = dgAuctionUnrelatedSellers.SelectedItem as ChargeDTO;
ChargeDTO lObjFileSeller = dgFileUnrelatedSellers.SelectedItem as ChargeDTO;
if (lObjAuctionSeller == null)
{
this.ShowMessage("Error", "Favor de seleccionar un vendedor no relacionado en la Subasta.");
return;
}
if (lObjFileSeller == null)
{
this.ShowMessage("Error", "Favor de seleccionar un vendedor no relacionado en el Archivo.");
return;
}
mLstObjRelatedSellers.Add(new ChargeDTO()
{
SellerId = lObjAuctionSeller.SellerId,
SellerCode = lObjAuctionSeller.SellerCode,
SellerName = lObjAuctionSeller.SellerName,
Amount = lObjFileSeller.Amount
});
mLstObjAuctionSellers.Remove(mLstObjAuctionSellers.First(x => x.Equals(lObjAuctionSeller)));
mLstObjFileSellers.Remove(mLstObjFileSellers.First(x => x.Equals(lObjFileSeller)));
dgAuctionUnrelatedSellers.ItemsSource = null;
dgFileUnrelatedSellers.ItemsSource = null;
dgRelatedSellers.ItemsSource = null;
dgAuctionUnrelatedSellers.ItemsSource = mLstObjAuctionSellers;
dgFileUnrelatedSellers.ItemsSource = mLstObjFileSellers;
dgRelatedSellers.ItemsSource = mLstObjRelatedSellers;
}
public IActionResult CreateSubscription(ChargeDTO chargeDto)
{
try
{
StripeConfiguration.ApiKey = "sk_test_51GxEfiHhYK7K9XttqUpv12yjajZLs01TY95VhvzVfPEb5Ed8GaF3GFUV2iuhFZGkBgHoNib4iHBDlpALqWPplth6008EdMnnaw";
int planNo = chargeDto.Plan;
string planName = "";
DateTime dateTimeNow = DateTime.Now;
//Create customer
var customerOptions = new CustomerCreateOptions
{
Description = chargeDto.CardName,
Source = chargeDto.StripeToken,
Email = chargeDto.Email,
Metadata = new Dictionary <string, string>()
{
{ "Phone Number", chargeDto.Phone }
}
};
var customerService = new CustomerService();
Customer customer = customerService.Create(customerOptions);
//Create subscription
string plan = "";
//Standard plan
if (planNo == 1)
{
plan = "price_1H9njJHhYK7K9XttfEulEs63";
planName = "Standard plan";
}
//Premium plan
else if (planNo == 2)
{
plan = "price_1H9nnZHhYK7K9XttJdGEg31G";
planName = "Premium plan";
}
var options = new SubscriptionCreateOptions
{
Customer = customer.Id,
Items = new List <SubscriptionItemOptions>
{
new SubscriptionItemOptions
{
Price = plan,
},
},
};
var service = new SubscriptionService();
Subscription subscription = service.Create(options);
// DynamoDb
AddUser(chargeDto.Email, planName, dateTimeNow.ToString(), chargeDto.CardName, chargeDto.Password, chargeDto.Phone, "Registered");
// Cognito
SignUpUser(chargeDto.Email, chargeDto.Password, customer.Id).Wait();
return(Redirect("/Home/Index?Msg=Success"));
}
catch (Exception ex)
{
return(Redirect("/Home/Register?Msg=" + ex.Message));
}
}
private void dgRelatedSellers_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
mObjSelectedChargeDTO = (ChargeDTO)dgRelatedSellers.CurrentItem;
}
/// <summary>
///
/// </summary>
/// <param name="charge"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveCharge(ChargeDTO charge, string operation)
{
return(chargeDao.SaveCharge(charge, operation));
}
/// <summary>
///
/// </summary>
/// <param name="charge"></param>
/// <param name="operation"></param>
/// <returns></returns>
public MessageDTO SaveCharge(ChargeDTO charge, string operation)
{
return(dataAccess.SaveCharge(charge, operation));
}
public async Task <ActionResult> MockCharge(ChargeDTO request)
{
var consumption = await _chargeAppService.AddCharge(request);
return(Ok(consumption));
}
public ActionResult Create(ChargeDTO chargeDTO, int ID)
{
double price = 0;
StringBuilder sb = new StringBuilder();
StripeConfiguration.ApiKey = "sk_test_51HHZalIRpf7rAmeBgc0q7aD4yiOcIaPjGCZ60FvMO4Yje4RnstURkwhMYOILHmZJwYHTzhq02OdsQDs1oP3ERsIS00k3aejALI";
var x = c.Packages.Where(e => e.ID == ID);
foreach (var item in x)
{
price = item.Price * 4.3478;
sb.AppendFormat("NT Travel Guide xin cảm ơn quý khách đã sử dụng dịch vụ của chúng tôi. " +
"Quý khách đã thanh toán thành công. Xin vui lòng kiểm tra lại các thông tin sau: \n" +
"Điểm đến: {0}\n" +
"Ngày xuất phát: {3}-{2}-{1}\n" +
"Chuyến đi trong vòng: {4}\n" +
"Mã vé: NT{5}\n\n" +
"Trân trọng,\nNT Travel Guide\n" +
"Nếu những thông tin trên có sai sót hoặc quý khách có thắc mắc về chuyến đi, xin phản hồi lại email này.\n" +
"\nHoặc gọi vào hotline: 028-38364748 để được hỗ trợ tốt nhất.\nXin chân thành cảm ơn.", item.Destination, item.Depart.Year, item.Depart.Month, item.Depart.Day, item.Offer, item.ID);
}
var customerOptions = new CustomerCreateOptions
{
Description = chargeDTO.CardName,
Source = chargeDTO.StripeToken,
Email = chargeDTO.Email,
Metadata = new Dictionary <String, String>()
{
{ "Phone Number", chargeDTO.Phone }
}
};
var customerService = new CustomerService();
Customer customer = customerService.Create(customerOptions);
var options = new ChargeCreateOptions
{
Amount = (long)price,
Currency = "usd",
Description = "Charge for [email protected]",
Customer = customer.Id
};
var service = new ChargeService();
Charge charge = service.Create(options);
var model = new ChargeViewModel();
model.ChargeId = charge.Id;
model.Name = customer.Name;
model.Email = customer.Email;
// Send mail for client
MailMessage mail = new MailMessage();
mail.From = new System.Net.Mail.MailAddress("*****@*****.**");
mail.Subject = "[MAIL XÁC NHẬN]";
SmtpClient smtp = new SmtpClient();
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new NetworkCredential(mail.From.ToString(), "daylamatkhaumanhduocchua?");
smtp.Host = "smtp.gmail.com";
// Recipient address
mail.To.Add(new MailAddress(customer.Email));
// Formatted mail body;
string st = "Xin chào anh/chị " + customer.Description + ", \n" + sb;
mail.Body = st;
smtp.Send(mail);
return(View("OrderStatus", model));
}
