public ActionResult user_detail(int id)
{
Gabungan gabungan = new Gabungan();
gabungan.tblPembeli = db.pembeli.Find(id);
gabungan.tblDetailTiket = db.detil_pesan_tiket.Find(id);
gabungan.tblValidasi = db.pembeli_validasi.Find(id);
int pajak_berangkatId =
gabungan.tblDetailTiket.bandara_berangkat;
int pajak_tujuanId =
gabungan.tblDetailTiket.bandara_tujuan;
var hargaBerangkat =
db.pajak_bandara.Find(pajak_berangkatId);
var hargaTujuan = db.pajak_bandara.Find(pajak_tujuanId);
gabungan.rp_bandara_berangkat = ConvertCurrency.
ToRupiah(hargaBerangkat.pajak);
gabungan.rp_bandara_tujuan = ConvertCurrency.
ToRupiah(hargaTujuan.pajak);
gabungan.rp_harga_tiket = ConvertCurrency.
ToRupiah(gabungan.tblDetailTiket.harga_tiket);
gabungan.rp_total_transfer = ConvertCurrency.
ToRupiah(gabungan.tblDetailTiket.total_transfer);
gabungan.nm_bandara_berangkat =
hargaBerangkat.nm_bandara;
gabungan.nm_bandara_tujuan = hargaTujuan.nm_bandara;
return(View(gabungan));
}
public ActionResult user_detail(int id, Gabungan gabungan)
{
var user = db.pembeli.FirstOrDefault(u => u.id_pembeli == id);
user.nm_pembeli = gabungan.tblPembeli.nm_pembeli;
user.email_pembeli = gabungan.tblPembeli.email_pembeli;
user.hp_pembeli = gabungan.tblPembeli.hp_pembeli;
user.password = gabungan.tblPembeli.password;
db.SaveChanges();
decimal UnformatRpTotalTf = ConvertCurrency.ToAngka(gabungan.rp_total_transfer);
decimal TotalTf = gabungan.tblDetailTiket.total_transfer;
if (UnformatRpTotalTf == TotalTf)
{
var userDetail = db.detil_pesan_tiket.FirstOrDefault(u => u.id_pembeli == id);
userDetail.total_transfer = 0;
// it's means, number 1 has been paid, so 0 is otherwise
userDetail.status = 0;
}
else
{
var userDetail = db.detil_pesan_tiket.FirstOrDefault(u => u.id_pembeli == id);
userDetail.total_transfer = UnformatRpTotalTf;
// it's means, number 1 has been paid, so 0 is otherwise
userDetail.status = 1;
}
db.SaveChanges();
return(RedirectToAction("semua_pembeli", "Admin"));
}
public void RecordPayment(
Money paid,
ConvertCurrency convertCurrency,
string paidBy,
DateTimeOffset paidAt
)
{
EnsureExists();
var localPaid = State.Price.IsSameCurrency(paid)
? paid
: convertCurrency(paid, State.Price.Currency);
var outstanding = State.Outstanding - localPaid;
Apply(
new BookingPaid(
State.Id,
paid.Amount,
paid.Currency,
outstanding.Amount == 0,
outstanding.Amount,
paidBy,
paidAt
)
);
}
public ActionResult dashboard_admin()
{
Statistik statistik = new Statistik();
statistik.total_user = db.detil_pesan_tiket.Count(); statistik.user_lunas = db.detil_pesan_tiket.Where(u
=> u.total_transfer != 0).Count();
statistik.user_belum_lunas = db.detil_pesan_tiket.Where(u
=> u.total_transfer == 0).Count();
var checkPembeli = db.detil_pesan_tiket;
// cek pembeli ada atau engga
if (checkPembeli.Count() == 0)
{
// biarkan kosong.
}
else
{
statistik.uang_estimasi = ConvertCurrency.ToRupiah(db.detil_pesan_tiket.Select(u
=> u.harga_tiket).Sum());
statistik.uang_diterima = ConvertCurrency.ToRupiah(db.detil_pesan_tiket.Select(u
=> u.total_transfer).Sum());
decimal estimasi = db.detil_pesan_tiket.Select(u
=> u.harga_tiket).Sum();
decimal uangDiterima = db.detil_pesan_tiket.Select(u
=> u.total_transfer).Sum(); statistik.selisiPendapatan = ConvertCurrency.ToRupiah(estimasi - uangDiterima);
}
statistik.user_validasi = db.pembeli_validasi.Where(u
=> u.uang_transfer_validasi != null).Count();
return(View(statistik));
}
public ActionResult validasi_tiket()
{
Gabungan gabungan = new Gabungan();
int idUser = (int)Session["id"];
//Gabungan. student = db.Students.Find(id);
gabungan.tblPembeli = db.pembeli.Find(idUser);
gabungan.tblDetailTiket =
db.detil_pesan_tiket.Find(idUser);
gabungan.tblValidasi = db.pembeli_validasi.Find(idUser);
gabungan.rp_harga_tiket = ConvertCurrency.ToRupiah
(gabungan.tblDetailTiket.harga_tiket);
int pajak_berangkatId =
gabungan.tblDetailTiket.bandara_berangkat;
int pajak_tujuanId =
gabungan.tblDetailTiket.bandara_tujuan;
var hargaBerangkat =
db.pajak_bandara.Find(pajak_berangkatId);
var hargaTujuan = db.pajak_bandara.Find(pajak_tujuanId);
gabungan.rp_bandara_berangkat =
ConvertCurrency.ToRupiah(hargaBerangkat.pajak);
gabungan.rp_bandara_tujuan =
ConvertCurrency.ToRupiah(hargaTujuan.pajak);
gabungan.nm_bandara_berangkat =
hargaBerangkat.nm_bandara;
gabungan.nm_bandara_tujuan = hargaBerangkat.nm_bandara;
return(View(gabungan));
}
public void InvalidInput_Throws()
{
var convertCurrency = new ConvertCurrency();
Action act = () => convertCurrency.ConvertCurrencyToEnglish("AD45");
act.ShouldThrow <ApplicationException>();
}
public void CurrencyTestSuccess()
{
var convertCurrency = new ConvertCurrency();
var result = convertCurrency.ConvertCurrencyToEnglish("$127.45");
result.Should().Be("One hundred and twenty-seven dollars and forty-five cents");
}
public void CurrencyTestCentsSuccess()
{
var convertCurrency = new ConvertCurrency();
var result = convertCurrency.ConvertCurrencyToEnglish("$0.45");
result.Should().Be("Forty-five cents");
}
public JsonResult HargaBandara(int id)
{
var dataPajak = db.pajak_bandara.SingleOrDefault(u => u.id_bandara == id);
string harga = ConvertCurrency.ToRupiah(dataPajak.pajak);
return(Json(new { harga = harga }, JsonRequestBehavior.AllowGet));
}
private static void Main(string[] args)
{
var convertCurrency = new ConvertCurrency();
Console.WriteLine(convertCurrency.ConvertCurrencyToEnglish("$1.45"));
Console.ReadLine();
}
public ActionResult daftar(Gabungan gabungan)
{
if (gabungan.tblPembeli.password != gabungan.password_conf)
{
ViewBag.passTidakSama = "has-error";
ViewBag.errorMessage = "Password Konfirmasi Tidak Sama."; return(View());
}
string hashPass = PBKDF2Encription.HashPassword(gabungan.tblPembeli.password);
// table Pembeli
var dbPembeli = new pembeli
{
nm_pembeli = gabungan.tblPembeli.nm_pembeli,
email_pembeli = gabungan.tblPembeli.email_pembeli,
password = hashPass,
hp_pembeli = gabungan.tblPembeli.hp_pembeli,
gd_pembeli = gabungan.tblPembeli.gd_pembeli
};
db.pembelis.Add(dbPembeli); db.SaveChanges();
//table tgl Order
tgl_pesan tgl_table = new tgl_pesan(); tgl_table.tgl_order = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");
var dbTglPesan = new tgl_pesan
{
nm_pembeli = gabungan.tblPembeli.nm_pembeli,
tgl_order = tgl_table.tgl_order
};
db.tgl_pesan.Add(dbTglPesan); db.SaveChanges();
// table Detail Pembeli
var dbPembeliDetail = new detil_pesan_tiket
{
nm_pembeli = gabungan.tblPembeli.nm_pembeli,
harga_tiket = ConvertCurrency.ToAngka(gabungan.rp_harga_tiket),
total_transfer = gabungan.tblDetailTiket.total_transfer,
pilihan_bank = gabungan.tblDetailTiket.pilihan_bank,
bandara_berangkat = gabungan.tblDetailTiket.bandara_berangkat,
bandara_tujuan = gabungan.tblDetailTiket.bandara_tujuan,
status = gabungan.tblDetailTiket.status
};
db.detil_pesan_tiket.Add(dbPembeliDetail); db.SaveChanges();
// table Validasi Pembeli
var dbValidasi = new pembeli_validasi
{
nm_pembeli = gabungan.tblPembeli.nm_pembeli,
email_pembeli = gabungan.tblPembeli.email_pembeli,
hp_pembeli = gabungan.tblPembeli.hp_pembeli,
uang_transfer_validasi = null,
pilihan_bank = null
};
db.pembeli_validasi.Add(dbValidasi); db.SaveChanges();
return(RedirectToAction("login_user", "Home"));
}
/// <summary>
/// It expects input as (INR) i.e the currency to whic user wants to convert
/// </summary>
/// <param name="toCurrency"></param>
/// <returns></returns>
public Money Convert(string toCurrency)
{
if (string.IsNullOrWhiteSpace(toCurrency) || toCurrency.Length != 3 || Regex.IsMatch(toCurrency, @"^[a-zA-Z]+$") == false)
{
throw new System.Exception(Resource.InvalidCurrency);
}
var convert = new ConvertCurrency();
var exchangerate = convert.Convert(this.Currency, toCurrency);
var totalAmount = exchangerate * this.Amount;
if (double.IsPositiveInfinity(totalAmount) || totalAmount > double.MaxValue)
{
throw new System.Exception(Resource.OutOfRange);
}
return(new Money(totalAmount, toCurrency));
}
public void ApplyDiscount(
Money discount,
ConvertCurrency convertCurrency
)
{
EnsureExists();
var localDiscountAmount = State.Price.IsSameCurrency(discount)
? discount
: convertCurrency(discount, State.Price.Currency);
var outstanding = State.Outstanding - localDiscountAmount;
Apply(
new DiscountApplied(
State.Id,
discount.Amount,
discount.Currency,
outstanding.Amount,
outstanding.Amount == 0
)
);
}
public BookingsCommandService(IAggregateStore store, IsRoomAvailable isRoomAvailable, ConvertCurrency convertCurrency) : base(store)
{
OnNew <BookingCommands.Book>(
(booking, cmd) =>
booking.BookRoom(
new BookingId(cmd.BookingId),
cmd.GuestId,
new RoomId(cmd.RoomId),
new StayPeriod(cmd.From, cmd.To),
new Money(cmd.Price, cmd.Currency),
cmd.BookedBy,
cmd.BookedAt,
isRoomAvailable
)
);
OnExisting <BookingCommands.RecordPayment>(
cmd => new BookingId(cmd.BookingId),
(booking, cmd) => booking.RecordPayment(
new Money(cmd.Amount, cmd.Currency),
convertCurrency,
cmd.PaidBy,
cmd.PaidAt
)
);
OnExisting <BookingCommands.ApplyDiscount>(
cmd => new BookingId(cmd.BookingId),
(booking, cmd) => booking.ApplyDiscount(
new Money(cmd.Amount, cmd.Currency),
convertCurrency
)
);
}
protected void btnGetPdf_Click(object sender, EventArgs e)
{
using (MemoryStream ms = new MemoryStream())
{
Paragraph paragraph;
iTextSharp.text.Font fdefault = FontFactory.GetFont("Arial", 17, iTextSharp.text.Font.NORMAL, BaseColor.BLUE);
Document doc = new Document(PageSize.A4);
try
{
var writer = PdfWriter.GetInstance(doc, ms);
doc.Open();
var logo = iTextSharp.text.Image.GetInstance(Server.MapPath("~/Images/logoBGSB.jpg"));
logo.SetAbsolutePosition(50, 730);
logo.ScaleAbsoluteHeight(75);
logo.ScaleAbsoluteWidth(70);
doc.Add(logo);
string SoET = "School of Engineering Technology";
paragraph = new Paragraph(SoET, fdefault);
paragraph.IndentationLeft = 150;
paragraph.SpacingAfter = 10;
doc.Add(paragraph);
string Bgsbu = "Baba Ghulam Shah Badshah University";
paragraph = new Paragraph(Bgsbu, fdefault);
paragraph.IndentationLeft = 135;
paragraph.SpacingAfter = 10;
paragraph.SpacingBefore = -10;
doc.Add(paragraph);
string Rjri = "Rajouri, Jammu and Kashmir (185234).";
paragraph = new Paragraph(Rjri, fdefault);
paragraph.IndentationLeft = 137;
paragraph.SpacingAfter = 10;
paragraph.SpacingBefore = -10;
doc.Add(paragraph);
Paragraph LineSeparator = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));
paragraph.SpacingAfter = 60;
doc.Add(LineSeparator);
PdfPTable table2 = new PdfPTable(2);
table2.SpacingBefore = 20;
table2.WidthPercentage = 80;
table2.SpacingAfter = 10;
PdfPCell cell1 = new PdfPCell();
cell1.AddElement(new Paragraph("Fee Reciept", FontFactory.GetFont("Arial", 12, Font.NORMAL)));
cell1.VerticalAlignment = Element.ALIGN_CENTER;
PdfPCell cell2 = new PdfPCell();
cell2.AddElement(new Paragraph("Student Copy", FontFactory.GetFont("Arial", 12, Font.NORMAL)));
cell1.VerticalAlignment = Element.ALIGN_CENTER;
table2.AddCell(cell1);
table2.AddCell(cell2);
doc.Add(table2);
Paragraph LineSeparator3 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));
paragraph.SpacingAfter = 60;
doc.Add(LineSeparator3);
PdfPTable table1 = new PdfPTable(2);
table1.WidthPercentage = 90;
table1.SpacingBefore = 40;
PdfPCell cell11 = new PdfPCell();
cell11.AddElement(new Paragraph("Name : " + lblSttudentName.Text));
cell11.AddElement(new Paragraph("Department : " + lblDepartmentName.Text));
cell11.AddElement(new Paragraph("Roll no : " + lblRollno.Text));
cell11.AddElement(new Paragraph("Semester : " + ddlSemester.Text));
cell11.VerticalAlignment = Element.ALIGN_LEFT;
PdfPCell cell12 = new PdfPCell();
cell12.AddElement(new Paragraph("Reciept no : " + lbltemp3.Text));
cell12.AddElement(new Paragraph("Date Paid : " + lblDatePaid.Text));
cell12.AddElement(new Paragraph("Session : " + ddlSessionName.Text));
cell12.VerticalAlignment = Element.ALIGN_RIGHT;
table1.SpacingAfter = 18;
table1.AddCell(cell11);
table1.AddCell(cell12);
doc.Add(table1);
paragraph = new Paragraph("Recieved with thanks a sum of rupees " + lblAmount.Text + "( " + ConvertCurrency.ConvertNumbertoWords((long)Convert.ToDouble(lblAmount.Text)) + " )" + " from " + lblSttudentName.Text + " on account of " + ddlFeeType.Text + ".");
paragraph.IndentationLeft = 30f;
paragraph.SpacingBefore = 20;
paragraph.SpacingAfter = 30;
doc.Add(paragraph);
Paragraph LineSeparator5 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 100.0F, BaseColor.BLACK, Element.ALIGN_LEFT, 1)));
paragraph.SpacingAfter = 1;
Paragraph LineSeparator6 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 70.0F, BaseColor.BLACK, Element.ALIGN_CENTER, 1)));
paragraph.SpacingAfter = 1;
Paragraph LineSeparator7 = new Paragraph(new Chunk(new iTextSharp.text.pdf.draw.LineSeparator(0.0F, 40.0F, BaseColor.BLACK, Element.ALIGN_CENTER, 1)));
paragraph.SpacingAfter = 60;
doc.Add(LineSeparator5);
doc.Add(LineSeparator6);
doc.Add(LineSeparator7);
// paragraph = new Paragraph("tution fee" + lblAmount.Text);
//paragraph.IndentationLeft = 100f;
//paragraph.SpacingAfter = 30;
//doc.Add(paragraph);
doc.Close();
Response.ContentType = "pdf/application";
Response.AddHeader("content-disposition", "attachment;filename= " + ddlFeeType.Text + "-" + ddlSemester.Text + "-" + ddlSessionName.Text + ".pdf");
Response.OutputStream.Write(ms.GetBuffer(), 0, ms.GetBuffer().Length);
//////////
}
catch (Exception)
{
}
}
}
