private void generateQRcode(Model.Entities.Request request)
{
string code;
string title = "Express Printing Shop";
string paymentID = request.Payment.PaymentID;
code = title + System.Environment.NewLine;
code += "------------------------------------" + System.Environment.NewLine;
code += "Payment ID :" + paymentID + System.Environment.NewLine;
code += "Payment Date :" + request.Payment.PaymentDateTime + System.Environment.NewLine;
code += "Payment Amount :" + request.Payment.PaymentAmount + System.Environment.NewLine;
QRCodeGenerator qrGenerator = new QRCodeGenerator();
QRCodeGenerator.QRCode qrCode = qrGenerator.CreateQrCode(code, QRCodeGenerator.ECCLevel.Q);
System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image();
imgBarCode.Height = 300;
imgBarCode.Width = 300;
using (Bitmap bitMap = qrCode.GetGraphic(20))
{
using (MemoryStream ms = new MemoryStream())
{
bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
byte[] byteImage = ms.ToArray();
imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage);
string result = Convert.ToBase64String(byteImage, 0, byteImage.Length);;
CreateImage(result.ToString(), paymentID);
}
// plQRCode.Controls.Add(imgBarCode);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Model.Entities.Request request = (Model.Entities.Request)Session["request"];
Package newpackage = (Package)Session["package"];
decimal receivepage = Convert.ToDecimal((int)Session["totalpage"]);
int normalcountFile = (int)Session["normalcount"];
decimal amountOFpage = 0;
decimal finalAmount = 0;
int countfile = 0;
decimal totalPackagePrice = 0;
//calculate the totalamountofpage
amountOFpage = newpackage.PrintingPrice * receivepage * request.RequestLists[0].DocumentList[0].DocumentQuantity;
//calculate the countfile with package price
countfile = (int)Session["countthepackageitem"];
totalPackagePrice = newpackage.PackagePrice * countfile;
//calculate final amount
finalAmount = amountOFpage + totalPackagePrice;
//getitem
string allFileName = (string)Session["allfilename"];
string detail;
detail = "Order Detail" + "<br />";
detail += "------------------" + "<br />";
detail += "Number of File = " + normalcountFile + "<br />";
detail += "Number of Page = " + receivepage + "<br />";
detail += "Number of set = " + request.RequestLists[0].DocumentList[0].DocumentQuantity + "<br />";
//detail += "Document Color =" + request.RequestLists[0].DocumentList[0].DocumentColor + "<br/>";
detail += "Document Side = " + request.RequestLists[0].DocumentList[0].DocumentBothSide + "<br/>";
detail += "Document Name = " + allFileName + "<br />";
detail += "Document Total price = " + amountOFpage + "<br />";
string detail1;
detail1 = "Package = " + newpackage.PackageName + "<br />";
detail1 += "Package Price = " + totalPackagePrice + "<br />";
detail1 += "Total Amount = " + finalAmount + "<br />";
detail1 += "<br/>";
Label1.Text = detail1;
lblreceipt.Text = detail;
txtpaymentTotal.Text = Convert.ToString(finalAmount);
}
}
private List <Request> getRequestList(string status, string status2, string companyID, string orderBy)
{
List <Request> requestList = new List <Request>();
DataTable requestResult = null;
try
{
using (SqlConnection conPrintDB = new SqlConnection(ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString))
{
//removed "rl.RequestStatus = @status AND" to get all data display at table for testing purpose
string strSelect = "SELECT * FROM Requestlist rl, Request r WHERE rl.RequestID = r.RequestID AND (rl.RequestStatus = @status OR rl.RequestStatus = @status2) AND r.CompanyID = @companyID" + getOrderByString(orderBy);
using (SqlCommand cmdSelect = new SqlCommand(strSelect, conPrintDB))
{
cmdSelect.Parameters.AddWithValue("@status", status);
cmdSelect.Parameters.AddWithValue("@status2", status2);
cmdSelect.Parameters.AddWithValue("@companyID", companyID);
using (SqlDataAdapter da = new SqlDataAdapter(cmdSelect))
{
requestResult = new DataTable();
da.Fill(requestResult);
}
for (int i = 0; i < requestResult.Rows.Count; i++)
{
Requestlist newRequestlist = new Requestlist((string)requestResult.Rows[i]["RequestlistID"], (string)requestResult.Rows[i]["RequestItemID"], (string)requestResult.Rows[i]["RequestStatus"], (string)requestResult.Rows[i]["RequestType"], getDocumentList((string)requestResult.Rows[i]["RequestlistID"]));
List <Requestlist> requestlistArray = new List <Requestlist>();
newRequestlist.Package = Package.getPackage(newRequestlist.RequestItemID);
requestlistArray.Add(newRequestlist);
string paymentID = requestResult.Rows[i]["PaymentID"].ToString();
Request request = new Model.Entities.Request((string)requestResult.Rows[i]["RequestID"], Convert.ToDateTime(requestResult.Rows[i]["RequestDateTime"]), Convert.ToDateTime(requestResult.Rows[i]["DueDateTime"]), paymentID.Equals("")? null: new Payment(), (string)requestResult.Rows[i]["CompanyID"], (string)requestResult.Rows[i]["CustomerID"], requestlistArray);
requestList.Add(request);
}
}
}
return(requestList);
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
String Paypal = "Paypal";
decimal amountpaypal = (decimal)(Session["amount"]);
decimal totalamount = Convert.ToDecimal(amountpaypal);
Model.Entities.Request request = (Model.Entities.Request)Session["request"];
SqlConnection conTaxi;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conTaxi = new SqlConnection(connStr);
conTaxi.Open();
string strInsert;
SqlCommand cmdInsert;
strInsert = "Insert Into Payment (PaymentType, PaymentAmount, PaymentDateTime) Values (@PaymentType, @PaymentAmount, @PaymentDateTime);SELECT MAX(PaymentID) from Payment where PaymentAmount=@PaymentAmount";
cmdInsert = new SqlCommand(strInsert, conTaxi);
cmdInsert.Parameters.AddWithValue("@PaymentType", Paypal);
cmdInsert.Parameters.AddWithValue("@PaymentAmount", totalamount);
cmdInsert.Parameters.AddWithValue("@PaymentDateTime", DateTime.Now);
var getPaymentID = cmdInsert.ExecuteScalar();
if (getPaymentID != null)
{
Response.Write("<script>alert('PayPal Successful');</script>");
}
else
{
Response.Write("<script>alert('Upload Failed');</script>");
}
PrintingRequestHub.refreshTable();
}
private Request PopulateDataToObject()
{
List <Documentlist> documentlist = createDocumentList();
List <Requestlist> requestlist = new List <Requestlist>();
Requestlist newRequestlist = new Requestlist(ddlPackage.SelectedValue, Requestlist.STATUS_PENDING, rbtRequestType.SelectedValue, documentlist);
requestlist.Add(newRequestlist);
string companyID = Request.QueryString["CompanyID"];
string CustomerID = ClassHashing.basicDecryption((string)ViewState["UserID"]);
DateTime currentDate = DateTime.Now;
DateTime DueDate = Convert.ToDateTime(txtDueDate.Text);
Request request = new Model.Entities.Request(currentDate, DueDate, null, companyID, CustomerID, requestlist);
return(request);
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
Model.Entities.Request request = (Model.Entities.Request)Session["request"];
Package newpackage = (Package)Session["package"];
int receivepage = (int)Session["totalpage"];
decimal amountOFpage = 0;
decimal finalAmount = 0;
int countfile = 0;
decimal totalPackagePrice = 0;
//calculate the totalamountofpage
amountOFpage = newpackage.PrintingPrice * receivepage * request.RequestLists[0].DocumentList[0].DocumentQuantity;
//calculate the countfile with package price
countfile = (int)Session["countthepackageitem"];
totalPackagePrice = newpackage.PackagePrice * countfile;
//calculate final amount
finalAmount = amountOFpage + totalPackagePrice;
//getitem
string allFileName = (string)Session["allfilename"];
string Server_URL = "https://www.sandbox.paypal.com/cgi-bin/webscr?";
//Assigning Cmd Path as Statically to Parameter
string cmd = "_xclick";
//Assigning business Id as Statically to Parameter
string business = "*****@*****.**";// Enter your business account here
//Assigning item name as Statically to Parameter
string item_name = allFileName;
//Passing Amount as Statically to parameter
decimal amount = finalAmount;//Convert.ToDouble(txtpaymentTotal.Text);
//Passing Currency as Statically to parameter
string currency_code = "MYR";
string redirect = "";
//Pass your Server_Url,cmd,business,item_name,amount,currency_code variable.
redirect += Server_URL;
redirect += "cmd=" + cmd;
redirect += "&business=" + business;
redirect += "&first_name=" + "Name";
redirect += "&item_name=" + item_name;
redirect += "&amount=" + amount;
redirect += "&quantity=1";
redirect += "¤cy_code=" + currency_code;
string successURL = ConfigurationManager.AppSettings["SuccessURL"].ToString();
redirect += "&return=" + successURL;
redirect += "&cancel_return=" + ConfigurationManager.AppSettings["FailedURL"].ToString();
Session["amount"] = amount;
Response.Redirect(redirect);
}
private void insertNewRequest(Model.Entities.Request request)
{
SqlConnection conPrintDB;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conPrintDB = new SqlConnection(connStr);
conPrintDB.Open();
string strInsert;
SqlCommand cmdInsert;
//request
strInsert = "Insert Into Request (RequestDateTime, DueDateTime, PaymentID, CompanyID, CustomerID) Values (@requestDateTime, @dueDateTime, @paymentID, @companyID, @customerID);SELECT MAX(RequestID) from Request where CustomerID=@customerID AND RequestDateTime = @requestDateTime;";
cmdInsert = new SqlCommand(strInsert, conPrintDB);
cmdInsert.Parameters.AddWithValue("@requestDateTime", DateTime.Now);
cmdInsert.Parameters.AddWithValue("@dueDateTime", request.DueDateTime);
cmdInsert.Parameters.AddWithValue("@paymentID", request.Payment.PaymentID);
cmdInsert.Parameters.AddWithValue("@companyID", request.CompanyID);
cmdInsert.Parameters.AddWithValue("@customerID", request.CustomerID);
var requestID = cmdInsert.ExecuteScalar();
request.RequestID = (string)requestID;
//Requestlist
strInsert = "Insert Into Requestlist (RequestID, RequestItemID, RequestStatus, RequestType) Values (@RequestID, @RequestItemID, @RequestStatus, @RequestType);SELECT MAX(RequestlistID) from Requestlist where RequestID=@RequestID AND RequestItemID=@RequestItemID";
cmdInsert = new SqlCommand(strInsert, conPrintDB);
cmdInsert.Parameters.AddWithValue("@RequestID", request.RequestID);
cmdInsert.Parameters.AddWithValue("@RequestItemID", request.RequestLists[0].RequestItemID);
cmdInsert.Parameters.AddWithValue("@RequestStatus", request.RequestLists[0].RequestStatus);
cmdInsert.Parameters.AddWithValue("@RequestType", request.RequestLists[0].RequestType);
var requestlistID = cmdInsert.ExecuteScalar();
request.RequestLists[0].RequestlistID = (string)requestlistID;
//documentlist
strInsert = "Insert Into Documentlist (RequestlistID, DocumentID, Sequences, DocumentColor, DocumentBothSide, DocumentPaperType, DocumentQuantity, DocumentDescription) Values (@RequestlistID, @DocumentID, @Sequences, @DocumentColor, @DocumentBothSide, @DocumentPaperType, @DocumentQuantity, @DocumentDescription)";
cmdInsert = new SqlCommand(strInsert, conPrintDB);
foreach (Model.Entities.Documentlist documentlist in request.RequestLists[0].DocumentList)
{
insertDocument(documentlist.Document, conPrintDB); //insert document contain in documentlist
cmdInsert.Parameters.Clear(); //clear parameter before loop
cmdInsert.Parameters.AddWithValue("@RequestlistID", request.RequestLists[0].RequestlistID);
cmdInsert.Parameters.AddWithValue("@DocumentID", documentlist.Document.DocumentID);
cmdInsert.Parameters.AddWithValue("@Sequences", documentlist.Sequences);
cmdInsert.Parameters.AddWithValue("@DocumentColor", documentlist.DocumentColor);
cmdInsert.Parameters.AddWithValue("@DocumentBothSide", documentlist.DocumentBothSide);
cmdInsert.Parameters.AddWithValue("@DocumentPaperType", documentlist.DocumentPaperType);
cmdInsert.Parameters.AddWithValue("@DocumentQuantity", documentlist.DocumentQuantity);
cmdInsert.Parameters.AddWithValue("@DocumentDescription", documentlist.DocumentDescription);
cmdInsert.ExecuteNonQuery();
}
conPrintDB.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtCardName.Text == "" || txtCardNumber.Text == "" || txtCCV.Text == "" || txtExpiryYear.Text == "" || txtExpitymonth.Text == "")
{
Response.Write("<script>alert('Please fill in credit card detail!');</script>");
}
else
{
DateTime currentDate = DateTime.Now;
Decimal totalPayment = Convert.ToDecimal(txtpaymentTotal.Text);
string type = "Credir Card";
Model.Entities.Payment newpayment = new Model.Entities.Payment(type, totalPayment, currentDate);
Model.Entities.Request request = (Model.Entities.Request)Session["request"];
//request.RequestLists[0].RequestItemID[0]
request.Payment = newpayment;
SqlConnection conTaxi;
string connStr = ConfigurationManager.ConnectionStrings["printDBServer"].ConnectionString;
conTaxi = new SqlConnection(connStr);
conTaxi.Open();
string strInsert;
SqlCommand cmdInsert;
strInsert = "Insert Into Payment (PaymentType, PaymentAmount, PaymentDateTime) Values (@PaymentType, @PaymentAmount, @PaymentDateTime);SELECT MAX(PaymentID) from Payment where PaymentAmount=@PaymentAmount";
cmdInsert = new SqlCommand(strInsert, conTaxi);
Decimal totalamount = Convert.ToDecimal(txtpaymentTotal.Text);
cmdInsert.Parameters.AddWithValue("@PaymentType", request.Payment.PaymentType);
cmdInsert.Parameters.AddWithValue("@PaymentAmount", request.Payment.PaymentAmount);
cmdInsert.Parameters.AddWithValue("@PaymentDateTime", request.Payment.PaymentDateTime);
var getPaymentID = cmdInsert.ExecuteScalar();
if (getPaymentID != null)
{
request.Payment.PaymentID = (string)getPaymentID;
insertNewRequest(request);
generateQRcode(request);
Response.Write("<script>alert('Successful payment');</script>");
}
else
{
Response.Write("<script>alert('Upload Failed');</script>");
}
/*Close database connection*/
conTaxi.Close();
Response.Write("<script>alert('Successful payment');</script>");
PrintingRequestHub.refreshTable();
Response.Redirect("~/masterPageTest.aspx");
}
}
protected void btncashlink_Click(object sender, ImageClickEventArgs e)
{
Model.Entities.Request request = (Model.Entities.Request)Session["request"];
generateQRcode(request);
}
