public async Task <IActionResult> Create([Bind("DataKthimit,Klienti_id,Libra_id,")] Huazimi huazimi)
{
try {
if (ModelState.IsValid)
{
huazimi.DataPritjes = DateTime.Now.AddMonths(1);
huazimi.Aktiv = true;
_context.Huazimi.Add(huazimi);
Libra libri = _context.Libra.Where(t => t.id == huazimi.Libra_id).First();
libri.E_Lire = false;
libri.huazime++;
_context.Libra.Update(libri);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
catch (DbUpdateException /* ex */)
{
//Log the error (uncomment ex variable name and write a log.
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists " +
"see your system administrator.");
}
return(View(huazimi));
}
public IActionResult Kthe(int id)
{
Huazimi huazimi = _context.Huazimi.Where(t => t.id == id).First();
huazimi.DataKthimit = DateTime.Now;
huazimi.Aktiv = false;
_context.Huazimi.Update(huazimi);
_context.SaveChanges();
Libra libri = _context.Libra.Where(t => t.id == huazimi.Libra_id).First();
libri.E_Lire = true;
_context.Libra.Update(libri);
_context.SaveChanges();
var rez = _context.Rezervimi.Where(r => r.Aktiv == true).ToList();
foreach (Rezervimi r in rez)
{
if (huazimi.Libra_id == r.Libra_id)
{
var klienti = _context.Klienti.Where(k => k.id == r.Klienti_id).First();
var libra = _context.Libra.Where(k => k.id == r.Libra_id).First();
MailMessage mail = new MailMessage("*****@*****.**", klienti.Email);
mail.Subject = "Rezervimi I Librit " + libra.Titulli;
mail.Body = "Pershendetje , Ju informojme se librin " + libra.Titulli + " qe keni rezervuar tashme eshte i lire dhe mund te vini ta merrni Librin";
SmtpClient smtpClient = new SmtpClient("smtp.gmail.com", 587);
smtpClient.Credentials = new System.Net.NetworkCredential()
{
UserName = "******",
Password = "******"
};
smtpClient.EnableSsl = true;
smtpClient.Send(mail);
r.Aktiv = false;
_context.Rezervimi.Update(r);
_context.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public ActionResult Index(int?h = 0)
{
MbushKombot();
Huazimi modeli = new Huazimi();
Session["Rasti"] = 0;
Session["PerdoruesiID"] = 2;
if (h == 0)
{
Session["Rasti"] = 1;
modeli.DataHuazimit = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
modeli.DataKthimit = DateTime.Today;
modeli.Sasia = 1;
}
else
{
Session["Rasti"] = 2;
}
return(View(modeli));
}
public JsonResult RegjistroHuazimin(Huazimi model)
{
try
{
if (ModelState.IsValid)
{
var validimiStokut = db.tblLibri.Where(x => x.LibriID == model.LibriID).FirstOrDefault();
if (int.Parse(Session["Rasti"].ToString()) == 1)
{
if (validimiStokut.Sasia >= model.Sasia)
{
tblHuazimi objHuazimi = new tblHuazimi();
objHuazimi.LibriID = model.LibriID;
objHuazimi.PerdoruesiID = int.Parse(Session["PerdoruesiID"].ToString());
objHuazimi.PerdoruesiIDLexuesi = model.PerdoruesiIDLexuesi;
objHuazimi.Sasia = model.Sasia;
objHuazimi.Shenime = model.Shenime;
objHuazimi.DataHuazimit = model.DataHuazimit;
objHuazimi.DataKthimit = model.DataKthimit;
obj._HuazimiRepository.Insert(objHuazimi);
obj.Save();
obj.Dispose();
int Stoku = int.Parse(validimiStokut.Sasia.ToString()) - int.Parse(model.Sasia.ToString());
var updateStoku = db.tblLibri.Where(x => x.LibriID == model.LibriID).FirstOrDefault();
updateStoku.Sasia = Stoku;
db.SaveChanges();
//tblLibri objLibri = new tblLibri();
//objLibri.Sasia = int.Parse(Stoku.ToString());
//obj._BookRepository.Update(objLibri);
//obj.Save();
//obj.Dispose();
}
else
{
return(Json(new { success = false, message = "Nuk ka sasi te mjafut" }));
}
}
else
{
if (validimiStokut.Sasia >= model.Sasia)
{
tblHuazimi objHuazimi = new tblHuazimi();
objHuazimi.LibriID = model.LibriID;
objHuazimi.PerdoruesiID = int.Parse(Session["PerdoruesiID"].ToString());
objHuazimi.PerdoruesiIDLexuesi = model.PerdoruesiIDLexuesi;
objHuazimi.Sasia = model.Sasia;
objHuazimi.Shenime = model.Shenime;
objHuazimi.DataHuazimit = model.DataHuazimit;
objHuazimi.DataKthimit = model.DataKthimit;
obj._HuazimiRepository.Update(objHuazimi);
obj.Save();
obj.Dispose();
}
else
{
return(Json(new { success = false, message = "Nuk ka sasi te mjaftuar" }));
}
}
}
else
{
return(Json(new
{
success = false,
errors = ModelState.ToDictionary(
kvp => kvp.Key,
kvp => kvp.Value.Errors.Select(e => e.ErrorMessage).ToArray()
),
message = ""
}));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.InnerException.Message }));
}
return(Json(new { success = true, LibriID = 0 }));
}
