public bool AddPaymentByIncoming(Payment pay, string TransType)
{
using (var trans = ent.Database.BeginTransaction())
{
bool sonuc = false;
try
{
ent.Payments.Add(pay);
ent.SaveChanges();
GuestTransaction gt = new GuestTransaction();
gt.Date = pay.Date;
gt.TransType = TransType;
gt.Debt = 0;
gt.Credit = pay.Incoming;
gt.GuestId = pay.GuestId;
gt.Status = true;
gt.Description = pay.Description;
ent.GuestTransactions.Add(gt);
ent.SaveChanges();
trans.Commit();
sonuc = true;
}
catch (Exception)
{
trans.Rollback();
}
return(sonuc);
}
}
public bool CancelReservations(int ID)
{
using (var trans = ent.Database.BeginTransaction())
{
bool sonuc = false;
try
{
Sale sa = (from s in ent.Sales
where s.GuestId == ID && s.Deleted == false
orderby s.Id descending
select s).FirstOrDefault();
sa.Deleted = true;
sa.TotalPrice = 0;
ent.SaveChanges();
GuestTransaction gt = (from g in ent.GuestTransactions
where g.Id == ID && g.TransType == "Konaklama Ücreti"
orderby g.Id descending
select g).FirstOrDefault();
gt.Status = false;
gt.Debt = 0;
ent.SaveChanges();
trans.Commit();
sonuc = true;
}
catch (Exception ex)
{
string hata = ex.Message;
trans.Rollback();
}
return(sonuc);
}
}
public bool AddExtraAndGTrans(ExtraTransactions Ex, int GId)
{
using (var trans = ent.Database.BeginTransaction())
{
bool Sonuc = false;
try
{
ent.ExtraTransactions.Add(Ex);
ent.SaveChanges();
GuestTransaction g = new GuestTransaction();
g.Date = Ex.TransactionDate;
g.TransType = "Extra Ücreti";
g.Debt = Ex.Sum;
g.Credit = 0;
g.GuestId = Ex.GuestId;
g.Status = true;
g.Description = "";
ent.GuestTransactions.Add(g);
ent.SaveChanges();
trans.Commit();
Sonuc = true;
}
catch (Exception ex)
{
trans.Rollback();
string hata = ex.Message;
}
return(Sonuc);
}
}
public async Task <ActionResult <GuestTransaction> > PostGuestTransaction(TransactionRequest request)
{
Dictionary <string, Object> data = new Dictionary <string, object>();
data.Add("status", "SUCCESS");
data.Add("data", null);
if (request.PaymentCard == null || request.PaymentCard.Equals("") ||
request.FirstName == null || request.FirstName.Equals("") ||
request.LastName == null || request.LastName.Equals("") ||
request.PhoneNumber == null || request.PhoneNumber.Equals("")
)
{
data.Remove("status");
data.Add("status", "WARNING");
data.Add("message", "Field not null ! !");
return(BadRequest(data));
}
bool paymentCardRegex = Regex.Match(request.PaymentCard, @"^[0-9]+$").Success;
bool phoneRegex = Regex.Match(request.PhoneNumber, @"(\+[0-9]{2}|\+[0-9]{2}\(0\)|\(\+[0-9]{2}\)\(0\)|00[0-9]{2}|0)([0-9]{9}|[0-9\-\s]{9,18})").Success;
if (paymentCardRegex == false)
{
data.Remove("status");
data.Add("status", "WARNING");
data.Add("message", "Payment card must be a number ! !");
return(BadRequest(data));
}
if (phoneRegex == false)
{
data.Remove("status");
data.Add("status", "WARNING");
data.Add("message", "Phone number must be a number ! !");
return(BadRequest(data));
}
var plan = _context.Plans.Find(request.PlanId);
var transaction = new GuestTransaction
{
PlanId = plan.Id,
FirstName = request.FirstName,
LastName = request.LastName,
PhoneNumber = request.PhoneNumber,
Simtype = "Prepay",
PaymentCard = request.PaymentCard,
CreatedDate = DateTime.Now,
};
_context.GuestTransactions.Add(transaction);
await _context.SaveChangesAsync();
data.Remove("data");
data.Add("message", "Add new data is success ! !");
data.Add("data", transaction);
return(Ok(data));
}
//private void btnOdaSec_Click(object sender, EventArgs e)
//{
// frmOdaSec frm = new frmOdaSec();
// frm.ShowDialog();
// txtOdaNo.Text = OdaNo;
// txtGirisTarihi.Text = Giris.ToShortDateString();
// txtCikisTarihi.Text = Cikis.ToShortDateString();
// TimeSpan fark = Cikis - Giris;
// int gunsayisi = fark.Days;
// decimal OdaFiyat = Rp.GetRoomPrice(OdaNo);
// txtToplamTutar.Text = ((gunsayisi + 1) * OdaFiyat).ToString();
//}
private void btnOnayla_Click(object sender, EventArgs e)
{
//if (txtAdi.Text.Trim() == "" || txtSoyadi.Text == "" || txtTc.Text == "")
//{
// MessageBox.Show("Zorunlu alanlar girilmedi.", "Dikkat Eksik Bilgi!");
//}
Sale sa = new Sale();
sa.RoomId = Rp.GetRoomId(OdaNo);
sa.CheckIn = Giris;
sa.CheckOut = Cikis;
sa.NoOfGuests = 1;
sa.TotalPrice = ToplamTutar;
sa.PersonnelId = General.PersonelId;
sa.GuestId = Gid;
if (Giris.Date == DateTime.Now.Date)
{
sa.Status = true;
}
else
{
sa.Status = false;
}
Sp.AddSales(sa);
GuestTransaction gtrans = new GuestTransaction();
gtrans.Date = DateTime.Now;
/*if (Giris.Date == DateTime.Now.Date)*/ gtrans.TransType = "Konaklama Ücreti";
//else { gtrans.TransType = "Rezervasyon Ücreti"; }
gtrans.Debt = ToplamTutar;
gtrans.Credit = 0;
gtrans.GuestId = Gid;
gtrans.Status = true;
if (Giris.Date == DateTime.Now.Date)
{
gtrans.Description = "Konaklama Açılış";
}
else
{
gtrans.Description = "Rezervasyon";
}
if (Gtp.AddGTrans(gtrans))
{
MessageBox.Show("Kayıt yapıldı");
}
else
{
MessageBox.Show("Kayıt yapılmadı");
}
}
public bool AddGTrans(GuestTransaction gt)
{
bool Sonuc = false;
ent.GuestTransactions.Add(gt);
try
{
ent.SaveChanges();
Sonuc = true;
}
catch (Exception ex)
{
string hata = ex.Message;
}
return(Sonuc);
}
public bool EarlyCheckOut(int GId, int RId, decimal GerekliOdeme)
{
using (var trans = ent.Database.BeginTransaction())
{
bool sonuc = false;
try
{
List <Guest> glist = ent.Guests.Where(x => x.RoomId == RId && x.Status == true).ToList();
foreach (Guest ig in glist)
{
ig.Status = false;
}
ent.SaveChanges();
GuestTransaction gs = ent.GuestTransactions.Where(x => x.GuestId == GId && x.Status == true).FirstOrDefault();
gs.Debt = GerekliOdeme;
ent.SaveChanges();
List <GuestTransaction> gt = ent.GuestTransactions.Where(x => x.GuestId == GId && x.Status == true).ToList();
foreach (GuestTransaction item in gt)
{
item.Status = false;
}
ent.SaveChanges();
Sale sa = ent.Sales.Where(x => x.GuestId == GId).FirstOrDefault();
sa.Status = false;
sa.TotalPrice = GerekliOdeme;
sa.CheckOut = DateTime.Now;
ent.SaveChanges();
List <ExtraTransactions> et = ent.ExtraTransactions.Where(x => x.GuestId == GId).ToList();
foreach (ExtraTransactions item in et)
{
item.Status = false;
}
ent.SaveChanges();
trans.Commit();
sonuc = true;
}
catch (Exception)
{
trans.Rollback();
}
return(sonuc);
}
}
public bool DeleteGTrans(GuestTransaction gt)
{
throw new NotImplementedException();
}
private void btnOnayla_Click(object sender, EventArgs e)
{
if (txtAdi.Text.Trim() == "" || txtSoyadi.Text == "" || txtTc.Text == "")
{
MessageBox.Show("Zorunlu alanlar girilmedi.", "Dikkat Eksik Bilgi!");
}
Guest gue = new Guest();
gue.FirstName = txtAdi.Text;
gue.LastName = txtSoyadi.Text;
gue.IdentificationNo = txtTc.Text;
gue.RoomId = Rp.GetRoomId(OdaNo);
gue.Adress = txtAdres.Text;
gue.Gender = cbCinsiyet.SelectedItem.ToString();
gue.Birthday = dtpDogumTarihi.Value;
gue.ContactNo = txtTelefon.Text;
gue.Email = txtEmail.Text;
if (Giris.Date == DateTime.Now.Date)
{
gue.Status = true;
}
else
{
gue.Status = false;
}
if (Gp.AddGuest(gue))
{
Guest gst = Gp.GetGuest();
Sale sa = new Sale();
sa.RoomId = gst.RoomId;
sa.CheckIn = Giris;
sa.CheckOut = Cikis;
sa.NoOfGuests = Convert.ToInt32(cbMisafirSayisi.SelectedItem.ToString());
try
{
sa.TotalPrice = ToplamTutar;
}
catch (FormatException)
{
throw;
}
if (Giris.Date == DateTime.Now.Date)
{
sa.Status = true;
}
else
{
sa.Status = false;
}
sa.PersonnelId = General.PersonelId;
sa.GuestId = gst.Id;
if (Sp.AddSales(sa))
{
GuestTransaction Gtr = new GuestTransaction();
Gtr.Date = DateTime.Now;
/*if (Giris.Date == DateTime.Now.Date)*/
Gtr.TransType = "Konaklama Ücreti";
//else { gtrans.TransType = "Rezervasyon Ücreti"; }
try
{
Gtr.Debt = ToplamTutar;
}
catch (FormatException)
{
throw;
}
Gtr.Credit = 0;
Gtr.GuestId = gst.Id;
Gtr.Status = true;
if (Giris.Date == DateTime.Now.Date)
{
Gtr.Description = "Konaklama Açılış";
}
else
{
Gtr.Description = "Rezervasyon";
}
if (GTrans.AddGTrans(Gtr))
{
MessageBox.Show("Kayıt yapıldı");
}
else
{
MessageBox.Show("Misafir harekeleri oluşturulamadı");
}
}
else
{
MessageBox.Show("Satış Yapılamadı");
}
}
else
{
MessageBox.Show("Yapılmadı");
}
}
