private void PayButton_Click(object sender, RoutedEventArgs e)
{
Entity.Payment payment = new Entity.Payment(nameTextBlock.Text, Convert.ToDouble(salaryTextBlock.Text) + Convert.ToDouble(BonusTextBox.Text), Convert.ToDateTime(payingDate.Text), "Paid");
PaymentService paymentService = new PaymentService();
paymentService.AddPayment(payment);
LoadData();
}
private async Task <Payment> CreatePayment(Entity.Payment payment)
{
var conversion1 = Conversions.Conversion1;
var beneficiary1 = Beneficiaries.Beneficiary1;
var payment1 = Payments.Payment1;
Conversion conversion = await client.CreateConversionAsync(conversion1);
Beneficiary beneficiary = await client.CreateBeneficiaryAsync(beneficiary1);
payment1.ConversionId = conversion.Id;
payment1.BeneficiaryId = beneficiary.Id;
return(await client.CreatePaymentAsync(payment1, Payments.Payer1));
}
public void InsertErrorTestMethod()
{
IResponseBusiness <Entity.Payment> valueReturned = null;
IDataContract <Entity.Payment> paymentBusiness = new Business.Payment(new Entity.User());
Entity.Payment payment = new Entity.Payment()
{
Date = DateTime.Now,
Description = "Prueba",
PaymentType = (int)PaymentTypes.Income,
Value = 10,
PaymentMethodDetail = new Entity.PaymentMethodDetail(),
User = new Entity.User()
};
valueReturned = paymentBusiness.Insert(payment);
Assert.IsTrue(valueReturned.IsError);
}
private void LoadData()
{
List <Entity.Payment> paymentList = new List <Entity.Payment>();
String query = "select OPERATORNAME,SALARY,PAYMENTDATE,PAYMENTSTATUS from Payment";
SqlDataReader reader = DataAccess.GetData(query);
if (reader.HasRows)
{
while (reader.Read())
{
Entity.Payment payment = new Entity.Payment();
payment.OperatorName = reader.GetString(0);
payment.OperatorSalary = reader.GetDouble(1);
payment.PaymentDate = reader.GetDateTime(2);
payment.PaymentStatus = reader.GetString(3);
paymentList.Add(payment);
}
}
paymentDataGrid.ItemsSource = paymentList;
}
public static Entity.Payment GetMemberDetailsByMemberId(int MemberId)
{
using (DataManager oDm = new DataManager())
{
oDm.CommandType = CommandType.StoredProcedure;
oDm.Add("@pMemberId", SqlDbType.Int, MemberId);
SqlDataReader dr = oDm.ExecuteReader("MemberDetails_GetById");
Entity.Payment pm = new Entity.Payment();
if (dr.HasRows)
{
while (dr.Read())
{
pm.MemberId = MemberId;
pm.FName = (dr["MemberName"] == DBNull.Value) ? "" : dr["MemberName"].ToString();
pm.Email = (dr["Email"] == DBNull.Value) ? "" : dr["Email"].ToString();
pm.Mobile = (dr["MobileNo"] == DBNull.Value) ? "" : dr["MobileNo"].ToString();
}
}
return(pm);
}
}
public void LoadExpense()
{
if (fromDate.SelectedDate != null && toDate.SelectedDate != null)
{
Double Profit = 0;
Double Loss = 0;
Double TotalEarn = 0;
Double TotalExpense = 0;
List <Expense> expenseList = new List <Expense>();
List <BillingOperation> earningList = new List <BillingOperation>();
List <Entity.Payment> paymentList = new List <Entity.Payment>();
String Query = "Select CATEGORY,DESCRIPTION,AMOUNT,DATE from Expense where DATE between '" + fromDate.SelectedDate.Value + "'AND '" + toDate.SelectedDate.Value + "'";
SqlDataReader reader = DataAccess.GetData(Query);
if (reader.HasRows)
{
while (reader.Read())
{
Expense ex = new Expense();
ex.ExpenseCategory = reader.GetString(0);
ex.ExpenseDescription = reader.GetString(1);
ex.ExpenseAmount = reader.GetDouble(2);
ex.ExpenseDate = reader.GetDateTime(3);
expenseList.Add(ex);
TotalExpense = TotalExpense + reader.GetDouble(2);
//MessageBox.Show(TotalExpense.ToString());
}
}
expenseDataGrid.ItemsSource = expenseList;
String Query1 = "Select BILLINGNO, BILLINGDATE, TOTAL from Billing where BILLINGDATE between '" + fromDate.SelectedDate.Value + "'AND '" + toDate.SelectedDate.Value + "'";
SqlDataReader reader1 = DataAccess.GetData(Query1);
if (reader1.HasRows)
{
while (reader1.Read())
{
BillingOperation bl = new BillingOperation();
bl.BillingNo = reader1.GetString(0);
bl.BillingDate = reader1.GetDateTime(1);
bl.Total = reader1.GetDouble(2);
earningList.Add(bl);
TotalEarn = TotalEarn + reader1.GetDouble(2);
//MessageBox.Show(TotalExpense.ToString());
}
}
earningDataGrid.ItemsSource = earningList;
String Query2 = "Select OPERATORNAME, PAYMENTDATE, PAYMENTSTATUS, SALARY from Payment where PAYMENTDATE between '" + fromDate.SelectedDate.Value + "'AND '" + toDate.SelectedDate.Value + "'";
SqlDataReader reader2 = DataAccess.GetData(Query2);
if (reader2.HasRows)
{
while (reader2.Read())
{
Entity.Payment payment = new Entity.Payment();
payment.OperatorName = reader2.GetString(0);
payment.PaymentDate = reader2.GetDateTime(1);
payment.PaymentStatus = reader2.GetString(2);
payment.OperatorSalary = reader2.GetDouble(3);
paymentList.Add(payment);
TotalExpense = TotalExpense + reader2.GetDouble(3);
//MessageBox.Show(TotalExpense.ToString());
}
}
paymentDataGrid.ItemsSource = paymentList;
totalEarnTextBlock.Text = TotalEarn.ToString();
totalExTexBlock.Text = TotalExpense.ToString();
Profit = TotalEarn - TotalExpense;
MessageBox.Show(Profit.ToString());
if (Profit > 0)
{
profitTextBlock.Text = Profit.ToString();
}
else if (Profit == 0)
{
lossTextBlock.Text = "No Loss";
profitTextBlock.Text = "No Profit";
}
else
{
Loss = TotalExpense - TotalEarn;
lossTextBlock.Text = Loss.ToString();
}
}
}
public int AddPayment(Entity.Payment payment)
{
String query = "insert into Payment (OPERATORNAME,SALARY,PAYMENTDATE,PAYMENTSTATUS) values ('" + payment.OperatorName + "','" + payment.OperatorSalary + "','" + payment.PaymentDate + "','" + payment.PaymentStatus + "') ";
return(DataAccess.ExecuteQuery(query));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["MemberId"] != null && Request.QueryString["MemberId"].ToString().Trim().Length > 0 && Request.QueryString["TransactionId"] != null && Request.QueryString["TransactionId"].ToString().Trim().Length > 0)
{
Entity.Payment epm = new Entity.Payment();
BusinessLayer.Payment bpm = new BusinessLayer.Payment();
epm.MemberId = Convert.ToInt32(Request.QueryString["MemberId"]);
epm = bpm.GetMemberDetails(epm.MemberId);
epm.TransactionId = Request.QueryString["TransactionId"].ToString();
epm.Amount = bpm.GetPaymentDetails(Convert.ToInt32(epm.TransactionId));
epm.MerchantKey = "LZgpuu";
epm.MerchantSalt = "pUrqUKy1";
epm.ProductInfo = "Subscription Fees";
epm.Hash = "";
epm.udf5 = "BOLT_KIT_ASP.NET";
//string surl = ((HttpContext.Current.Request.ServerVariables["HTTPS"] != "" && HttpContext.Current.Request.ServerVariables["HTTP_HOST"] != "off") || HttpContext.Current.Request.ServerVariables["SERVER_PORT"] == "443") ? "https://" : "http://";
string surl = "http://";
surl += HttpContext.Current.Request.ServerVariables["HTTP_HOST"]
//+
//HttpContext.Current.Request.ServerVariables["REQUEST_URI"]
+ "/Response.aspx";
Session.Add("surl", surl);
Random r = new Random();
string txnid = "Txn" + r.Next(100, 9999);
Session.Add("txnid", epm.TransactionId);
//epm.TransactionId = txnid;
epm.SUrl = surl;
byte[] hash;
//string postData = new System.IO.StreamReader(Request.InputStream).ReadToEnd();
//dynamic data = JsonConvert.DeserializeObject(postData);
string d = epm.MerchantKey + "|" + epm.TransactionId + "|" + epm.Amount + "|" + epm.ProductInfo + "|" + epm.FName + "|" + epm.Email + "|||||" + epm.udf5 + "||||||" + epm.MerchantSalt;
var datab = Encoding.UTF8.GetBytes(d);
using (SHA512 shaM = new SHA512Managed())
{
hash = shaM.ComputeHash(datab);
}
StringBuilder result = new StringBuilder();
for (int i = 0; i < hash.Length; i++)
{
result = result.Append(hash[i].ToString("X2").ToLower());
}
epm.Hash = result.ToString();
Session.Add("FName", epm.FName);
Session.Add("Email", epm.Email);
Session.Add("Mobile", epm.Mobile);
Session.Add("Amount", epm.Amount);
Session.Add("MerchantKey", epm.MerchantKey);
Session.Add("MerchantSalt", epm.MerchantSalt);
Session.Add("ProductInfo", epm.ProductInfo);
Session.Add("Hash", epm.Hash);
//Session.Add("Hash", "7e93aacf9f953177c69bcd4e98f5065e31b302a39ee74627d410aca92de37a41a320456170fb059e37e8562308bd994013a9977297c2127ece8966c9e9b138d4");
}
}
}
