public static List <Lenda> List()
{
var lenda = new List <Lenda>();
var conn = DBHelper.GetConnection();
var cmd = new SqlCommand("usp_Lenda_List", conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
var rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var Lenda = new Lenda();
Lenda.LendaID = int.Parse(rdr["LendaID"].ToString());
Lenda.Emertimi = rdr["Emertimi"].ToString();
Lenda.Libri = rdr["Libri"].ToString();
Lenda.CreatedOn = DateTime.Parse(rdr["CreatedOn"].ToString());
Lenda.LastUpdate = string.IsNullOrEmpty(rdr["LastUpdate"].ToString()) == true ? DateTime.Now : DateTime.Parse(rdr["LastUpdated"].ToString());
lenda.Add(Lenda);
}
return(lenda);
}
catch (Exception ex)
{
return(null);
}
finally
{
conn.Close();
}
}
public static bool Update(Lenda lenda, int id)
{
var conn = DBHelper.GetConnection();
try
{
var cmd = new SqlCommand("dbo.usp_Lenda_Edit", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LendaID", id);
cmd.Parameters.AddWithValue("@Emertimi", lenda.Emertimi);
cmd.Parameters.AddWithValue("@Libri", lenda.Libri);
conn.Open();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
}
public static List <Lenda> List()
{
var LstL = new List <Lenda>();
var conn = DBHelper.GetConnection();
var cmd = new SqlCommand("usp_Lenda_GetList", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
try
{
conn.Open();
var rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var lenda = new Lenda();
lenda.Emertimi = rdr["Emertimi"].ToString();
lenda.Id = int.Parse(rdr["Id"].ToString());
lenda.Klasa = rdr["Klasa"].ToString();
LstL.Add(lenda);
}
return(LstL);
}
catch (Exception e)
{
return(null);
}
finally
{
conn.Close();
}
}
public static int Create(Lenda lenda)
{
var conn = DBHelper.GetConnection();
try
{
var cmd = new SqlCommand("usp_Lenda_Insert", conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@prmEmertimi", lenda.Emertimi);
cmd.Parameters.Add("@prmId", SqlDbType.Int).Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
return(Convert.ToInt32(cmd.Parameters["@prmId"].Value));
}
catch (Exception)
{
throw;
}
finally
{
conn.Close();
}
}
public ActionResult Create(Lenda lenda)
{
lenda.CreatedOn = DateTime.Now;
if (LendaDAL.Insert(lenda))
{
return(Redirect("Index"));
}
return(View(lenda));
}
public Boolean shtoLendet(Lenda l)
{
using (DBEntities db = new DBEntities())
{
db.Lendas.Add(l);
db.SaveChanges();
return(true);
}
return(false);
}
public ActionResult Delete(int id, Lenda lenda)
{
try
{
//if (ModelState.IsValid)
//{
LendaDAL.Delete(id);
return(RedirectToAction("Index", lenda));
// }
}
catch (Exception ex)
{
return(View());
}
}
public ActionResult CreateLEnda(Lenda lenda)
{
if (ModelState.IsValid)
{
int lendaId = DAL.DAL_Lenda.Create(lenda);
var klasatCheckec = lenda.KlasatJson.Split(',');
for (int i = 0; i < klasatCheckec.Length - 1; i++)
{
DAL.DAL_Lenda.CreateLendaKlasa(lendaId, int.Parse(klasatCheckec[i]));
}
return(RedirectToAction("ShowLenda"));
}
return(View(lenda));
}
public ActionResult Edit(int id, Lenda collection)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
LendaDAL.Update(collection, id);
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View("Index"));
}
}
//post methoda
//post methoda
public HttpResponseMessage Post([FromBody] Lenda lenda)
{
try
{
using (LendetDbEntities entities = new LendetDbEntities())
{
entities.Lendas.Add(lenda);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, lenda);
message.Headers.Location = new Uri(Request.RequestUri + lenda.id_l.ToString());
return(message);
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public override void regjistroNxenesin(Nxenesi nxenesi, int klasa, int paralelja)
{
foreach (var ditar in ditaret)
{
if (ditar.klasa == klasa)
{
if (ditar.paralelja == paralelja)
{
foreach (var lenda in ditar.lendeteDitarit)
{
Lenda newLenda = new Lenda("");
newLenda.emri = lenda.emri;
newLenda.lendaID = lenda.lendaID;
nxenesi.lendeteNxenesit.Add(newLenda);
}
ditar.nxenesit.Add(nxenesi);
}
}
}
}
public static Lenda Read(int id)
{
var lenda = new Lenda();
var conn = DBHelper.GetConnection();
var cmd = new SqlCommand("usp_Lenda_Read", conn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (id != 0)
{
cmd.Parameters.AddWithValue("@LendaID", id);
conn.Open();
var rdr = cmd.ExecuteReader();
if (rdr.Read())
{
lenda.LendaID = int.Parse(rdr["LendaID"].ToString());
lenda.Emertimi = rdr["Emertimi"].ToString();
lenda.Libri = rdr["Libri"].ToString();
lenda.CreatedOn = DateTime.Parse(rdr["CreatedOn"].ToString());
// lenda.LastUpdate = DateTime.Parse(rdr["LastUpdated"].ToString()) == null ? DateTime.Now : DateTime.Parse(rdr["LastUpdated"].ToString());
}
return(lenda);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
finally
{
conn.Close();
}
}
private void Send_Click(object sender, EventArgs e)
{
Lenda l = new Lenda();
l.Emri_i_lendes = lendaBox.Text;
l.Orë = textBox1.Text;
l.Lloji = bunifuDropdown1.Text[0] + "";
AllChanges ac = new AllChanges();
if (ac.shtoLendet(l))
{
MessageBox.Show("Keni shtuar me sukses");
lendaBox.Text = "";
textBox1.Text = "";
bunifuDropdown1.ResetText();
}
else
{
label5.ForeColor = System.Drawing.Color.Red;
label5.Text = "Shkruaj te dhenat sakte";
}
}
public override void regjistroLenden(Lenda lenda)
{
lendet.Add(lenda);
}
// GET: Lenda/Details/5
public ActionResult Details(int id)
{
Lenda lenda = LendaDAL.Read(id);
return(View("Details", lenda));
}
public static void Main(string[] args)
{
Lenda eu = new Lenda();
}
