public static List <MarkaModel> GetAllBrandsByVrstaHomologacije(int vrstaID, int uvoznikID)
{
List <MarkaModel> marke = new List <MarkaModel>();
MarkaModel marka = null;
SqlConnection connection = Database.GetConnection();
SqlCommand cmd = null;
SqlDataReader reader = null;
connection.Open();
cmd = new SqlCommand(GET_ALL_BRANDS_BY_VRSTA, connection);
cmd.Parameters.AddWithValue("@VrstaID", vrstaID);
cmd.Parameters.AddWithValue("@UvoznikID", uvoznikID);
cmd.CommandTimeout = 60;
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
marka = new MarkaModel();
marka.AutoID = Convert.ToInt32(reader["MarkaID"]);
marka.Naziv = Convert.ToString(reader["Naziv"]);
marke.Add(marka);
}
reader.Close();
}
connection.Close();
return(marke);
}
public void SaveID([FromBody] MarkaModel marka)
{
try
{
HttpContext.Session.SetInt32("MarkaAutoID", marka.AutoID);
}
catch (Exception)
{
}
}
public IActionResult MarkaCreate(MarkaModel marka)
{
var entity = new Marka()
{
adi = marka.adi,
url = marka.url
};
_markaService.Create(entity);
return(Redirect("/admin/marka/list"));
}
// GET: Brand/Delete/5
public bool Delete([FromBody] MarkaModel marka)
{
try
{
return(MarkaDAO.DeleteBrand(marka.AutoID));
}
catch (Exception)
{
}
return(false);
}
public IActionResult MarkaEdit(MarkaModel markamodel)
{
var entity = _markaService.GetById(markamodel.MarkaId);
if (entity == null)
{
return(NotFound());
}
entity.adi = markamodel.adi;
entity.url = markamodel.url;
_markaService.Update(entity);
return(Redirect("/admin/marka/list"));
}
public void CreateBrandPopup([FromBody] MarkaModel marka)
{
try
{
marka.AutoID = MarkaDAO.CreateNewBrand(marka, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
TipDAO.CreateNewType(new TipModel
{
Naziv = "-",
Marka = marka
}, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
}
catch (Exception e)
{
e.StackTrace.ToString();
}
}
public static Boolean UpdateBrand(MarkaModel marka)
{
Boolean update;
SqlConnection connection = Database.GetConnection();
SqlCommand cmd = null;
connection.Open();
cmd = new SqlCommand(UPDATE_BRAND, connection);
cmd.Parameters.AddWithValue("@AutoID", marka.AutoID);
cmd.Parameters.AddWithValue("@Naziv", marka.Naziv.Trim());
cmd.Parameters.AddWithValue("@KomercijalniNaziv", string.IsNullOrEmpty(marka.KomercijalniNaziv) ? (object)DBNull.Value : marka.KomercijalniNaziv.Trim());
cmd.Parameters.AddWithValue("@Opis", string.IsNullOrEmpty(marka.Opis) ? (object)DBNull.Value : marka.Opis.Trim());
cmd.CommandTimeout = 60;
update = cmd.ExecuteNonQuery() > 0 ? true : false;
connection.Close();
return(update);
}
public static int CreateNewBrand(MarkaModel marka, string korisnikID)
{
int AutoID;
SqlConnection connection = Database.GetConnection();
SqlCommand cmd = null;
connection.Open();
cmd = new SqlCommand(CREATE_NEW_BRAND, connection);
cmd.Parameters.AddWithValue("@Naziv", marka.Naziv.Trim());
cmd.Parameters.AddWithValue("@KomercijalniNaziv", string.IsNullOrEmpty(marka.KomercijalniNaziv) ? (object)DBNull.Value : marka.KomercijalniNaziv.Trim());
cmd.Parameters.AddWithValue("@Opis", string.IsNullOrEmpty(marka.Opis) ? (object)DBNull.Value : marka.Opis.Trim());
cmd.Parameters.AddWithValue("@KorisnikID", korisnikID);
cmd.CommandTimeout = 60;
AutoID = Convert.ToInt32(cmd.ExecuteScalar());
connection.Close();
return(AutoID);
}
public static List <MarkaModel> GetAllBrandsByManufacturer(int id)
{
List <MarkaModel> marke = new List <MarkaModel>();
MarkaModel marka = null;
SqlConnection connection = Database.GetConnection();
SqlCommand cmd = null;
SqlDataReader reader = null;
connection.Open();
cmd = new SqlCommand(GET_ALL_BRANDS_BY_MANUFACTURER, connection);
cmd.Parameters.AddWithValue("@ProizvodjacID", id);
cmd.CommandTimeout = 60;
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
marka = new MarkaModel();
marka.AutoID = Convert.ToInt32(reader["AutoID"]);
marka.Naziv = Convert.ToString(reader["Naziv"]);
if (!reader.IsDBNull(2))
{
marka.KomercijalniNaziv = Convert.ToString(reader["KomercijalniNaziv"]);
}
if (!reader.IsDBNull(3))
{
marka.DatumZadnjeIzmjeneUTC = reader.GetDateTimeOffset(3).LocalDateTime;
}
if (!reader.IsDBNull(4))
{
marka.Opis = Convert.ToString(reader["Opis"]);
}
marke.Add(marka);
}
reader.Close();
}
connection.Close();
return(marke);
}
public static MarkaModel GetBrandById(int AutoID)
{
MarkaModel marka = null;
SqlConnection connection = Database.GetConnection();
SqlCommand cmd = null;
SqlDataReader reader = null;
connection.Open();
cmd = new SqlCommand(GET_BRAND_BY_ID, connection);
cmd.Parameters.AddWithValue("@AutoID", AutoID);
cmd.CommandTimeout = 60;
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
marka = new MarkaModel();
marka.AutoID = Convert.ToInt32(reader["AutoID"]);
marka.Naziv = Convert.ToString(reader["Naziv"]);
if (!reader.IsDBNull(2))
{
marka.KomercijalniNaziv = Convert.ToString(reader["KomercijalniNaziv"]);
}
if (!reader.IsDBNull(3))
{
marka.DatumZadnjeIzmjeneUTC = reader.GetDateTimeOffset(3).LocalDateTime;
}
if (!reader.IsDBNull(4))
{
marka.Opis = Convert.ToString(reader["Opis"]);
}
}
reader.Close();
}
connection.Close();
return(marka);
}
public IActionResult MarkaEdit(int?id)
{
if (id == null)
{
return(NotFound());
}
var entity = _markaService.GetByIdWithIlanlar((int)id);
if (entity == null)
{
return(NotFound());
}
var model = new MarkaModel()
{
MarkaId = entity.MarkaId,
adi = entity.adi,
url = entity.url,
Ilanlar = entity.Ilanlar.ToList()
};
return(View(model));
}
public ActionResult EkleMarka(MarkaModel model)
{
string fileName = string.Empty;
if (ModelState.IsValid)
{
//Dosya Kaydetme
if (model.Resim.ContentLength > 0)
{
fileName = model.Resim.FileName;
var path = Path.Combine(Server.MapPath("~" + imageFolderPath), fileName);
model.Resim.SaveAs(path);
}
//Entity F. nesnesi oluşturma
MARKALAR marka = new MARKALAR();
marka.markaAdi = model.markaAdi;
marka.MarkaResimYol = imageFolderPath + fileName;
Db.MARKALAR.Add(marka);
Db.SaveChanges();
}
return(RedirectToAction("markaListele"));
}
public IActionResult RowInsert(string values)
{
try
{
var newBrand = new MarkaModel();
JsonConvert.PopulateObject(values, newBrand);
newBrand.DatumZadnjeIzmjeneUTC = DateTime.Now;
//if (!TryValidateModel(newBrand))
// return BadRequest();
newBrand.AutoID = MarkaDAO.CreateNewBrand(newBrand, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
TipDAO.CreateNewType(new TipModel
{
Naziv = "-",
Marka = newBrand
}, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
}
catch (Exception)
{
}
return(Ok());
}
public ActionResult SaveEdit(MarkaModel marka)
{
try
{
if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null)
{
return(View("~/Views/Login/Index.cshtml"));
}
marka.AutoID = Convert.ToInt32(HttpContext.Session.GetInt32("MarkaAutoID"));
MarkaDAO.UpdateBrand(marka);
//TipDAO.CreateNewType(new TipModel
//{
// Naziv = "-",
// Marka = marka
//});
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
return(RedirectToAction(nameof(Edit)));
}
}
public ActionResult Create(MarkaModel marka)
{
if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null)
{
return(View("~/Views/Login/Index.cshtml"));
}
try
{
marka.AutoID = MarkaDAO.CreateNewBrand(marka, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
TipDAO.CreateNewType(new TipModel
{
Naziv = "-",
Marka = marka
}, HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id);
return(RedirectToAction(nameof(Index)));
}
catch (Exception e)
{
ViewBag.Message = "Unešena marka već postoji!";
return(View());
}
}
