public static int CreateNewImporter(UvoznikModel uvoznik) { SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; connection.Open(); cmd = new SqlCommand(CREATE_NEW_IMPORTER, connection); cmd.Parameters.AddWithValue("@Naziv", uvoznik.Naziv.Trim()); cmd.Parameters.AddWithValue("@GradID", uvoznik.Grad.PostanskiBrojID); cmd.Parameters.AddWithValue("@Adresa", uvoznik.Adresa); cmd.Parameters.AddWithValue("@JIB", uvoznik.JIB.Trim()); cmd.Parameters.AddWithValue("@PIB", string.IsNullOrEmpty(uvoznik.PIB) ? (object)DBNull.Value : uvoznik.PIB.Trim()); cmd.Parameters.AddWithValue("@KnjigovodstvenaSifra", string.IsNullOrEmpty(uvoznik.KnjigovodstvenaSifra) ? (object)DBNull.Value : uvoznik.KnjigovodstvenaSifra.Trim()); cmd.Parameters.AddWithValue("@Email", string.IsNullOrEmpty(uvoznik.Email) ? (object)DBNull.Value : uvoznik.Email.Trim()); cmd.Parameters.AddWithValue("@Telefon", string.IsNullOrEmpty(uvoznik.Telefon) ? (object)DBNull.Value : uvoznik.Telefon.Trim()); cmd.Parameters.AddWithValue("@OvlastenoLice", string.IsNullOrEmpty(uvoznik.OvlastenoLice) ? (object)DBNull.Value : uvoznik.OvlastenoLice.Trim()); cmd.Parameters.AddWithValue("@Fax", string.IsNullOrEmpty(uvoznik.Fax) ? (object)DBNull.Value : uvoznik.Fax.Trim()); cmd.Parameters.AddWithValue("@Kontakt", string.IsNullOrEmpty(uvoznik.Kontakt) ? (object)DBNull.Value : uvoznik.Kontakt.Trim()); cmd.Parameters.AddWithValue("@OpstinaID", string.IsNullOrEmpty(uvoznik.Opstina.OpstinaID) ? (object)DBNull.Value : uvoznik.Opstina.OpstinaID.Trim()); cmd.CommandTimeout = 60; uvoznik.AutoID = Convert.ToInt32(cmd.ExecuteScalar()); connection.Close(); return(uvoznik.AutoID); }
public static Boolean UpdateImporter(UvoznikModel uvoznik) { Boolean created; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; connection.Open(); cmd = new SqlCommand(UPDATE_IMPORTER, connection); cmd.Parameters.AddWithValue("@AutoID", uvoznik.AutoID); cmd.Parameters.AddWithValue("@Naziv", uvoznik.Naziv.Trim()); cmd.Parameters.AddWithValue("@GradID", uvoznik.Grad.PostanskiBrojID); cmd.Parameters.AddWithValue("@Adresa", uvoznik.Adresa); cmd.Parameters.AddWithValue("@JIB", uvoznik.JIB.Trim()); cmd.Parameters.AddWithValue("@PIB", string.IsNullOrEmpty(uvoznik.PIB) ? (object)DBNull.Value : uvoznik.PIB.Trim()); cmd.Parameters.AddWithValue("@KnjigovodstvenaSifra", string.IsNullOrEmpty(uvoznik.KnjigovodstvenaSifra) ? (object)DBNull.Value : uvoznik.KnjigovodstvenaSifra.Trim()); cmd.Parameters.AddWithValue("@Email", string.IsNullOrEmpty(uvoznik.Email) ? (object)DBNull.Value : uvoznik.Email.Trim()); cmd.Parameters.AddWithValue("@Telefon", string.IsNullOrEmpty(uvoznik.Telefon) ? (object)DBNull.Value : uvoznik.Telefon.Trim()); cmd.Parameters.AddWithValue("@OvlastenoLice", string.IsNullOrEmpty(uvoznik.OvlastenoLice) ? (object)DBNull.Value : uvoznik.OvlastenoLice.Trim()); cmd.Parameters.AddWithValue("@Fax", string.IsNullOrEmpty(uvoznik.Fax) ? (object)DBNull.Value : uvoznik.Fax.Trim()); cmd.Parameters.AddWithValue("@Kontakt", string.IsNullOrEmpty(uvoznik.Kontakt) ? (object)DBNull.Value : uvoznik.Kontakt.Trim()); cmd.Parameters.AddWithValue("@OpstinaID", string.IsNullOrEmpty(uvoznik.Opstina.OpstinaID) ? (object)DBNull.Value : uvoznik.Opstina.OpstinaID.Trim()); cmd.CommandTimeout = 60; created = cmd.ExecuteNonQuery() > 0 ? true : false; connection.Close(); return(created); }
public void SaveUvoznikID([FromBody] UvoznikModel uvoznik) { try { HttpContext.Session.SetInt32("UserApprovalUvoznikID", uvoznik.AutoID); } catch (Exception) { } }
public bool Delete([FromBody] UvoznikModel uvoznik) { try { return(UvoznikDAO.DeleteImporter(uvoznik.AutoID)); } catch (Exception) { return(false); } }
public void SaveUvoznikID([FromBody] UvoznikModel uvoznik) { try { //ReportsController rc = new ReportsController(); //ReportsController.SetReportName("PrijavaZaRegistraciju", "UvoznikID", HttpContext.Session.GetObjectFromJson<KorisnikModel>("LogovaniKorisnik").Uvoznik.AutoID.ToString()); HttpContext.Session.SetString("ReportName", "Homologacija_za_dijelove.Reports.PrijavaZaRegistraciju.repx?UvoznikID=" + HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Uvoznik.AutoID.ToString()); } catch (Exception) { } }
public void ChangeUserStatus([FromBody] UvoznikModel uvoznik) { try { UvoznikDAO.UpdateStatus(uvoznik); KorisnikDAO.UpdateStatus(uvoznik); if (uvoznik.UserAktivan != 0 && uvoznik.UserAktivan != 3) { SendMail(uvoznik.Email); } } catch (Exception) { } }
public ActionResult Create(UvoznikModel importer) { try { if (string.IsNullOrEmpty(HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id)) { return(View("~/Views/Login/Index.cshtml")); } importer.AutoID = UvoznikDAO.CreateNewImporter(importer); OvlascenaLicaDAO.CreateNewAuthorizedPerson(new OvlascenaLicaModel { Uvoznik = importer, DodatnoOvlascenoLice = importer.OvlastenoLice }); KorisnikModel noviuser = new KorisnikModel { Id = KorisnikDAO.GetUserIdByImporterID(importer.AutoID), Ime = importer.Naziv, Prezime = importer.Naziv, Adresa = importer.Adresa, Grad = importer.Grad, Email = importer.Email, Telefon = importer.Telefon, Institucija = new InstitucijaModel { AutoID = 15 //TempObjekat Uvoznici }, GrupaKorisnika = new GrupeKorisnikaModel { AutoID = 4 //GrupaKorisnika Uvoznici }, Opstina = new OpstinaModel { OpstinaID = importer.Opstina.OpstinaID }, Uvoznik = importer, KorisnickoIme = importer.JIB, KorisnickaSifra = importer.TempSifra }; KorisnikDAO.CreateNewUser(noviuser); GlavnaDAO.CreateNewMasterGlavna(noviuser, importer.AutoID); return(RedirectToAction(nameof(Index))); } catch (Exception) { return(View()); } }
public static Boolean UpdateStatus(UvoznikModel uvoznik) { Boolean updated; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; connection.Open(); cmd = new SqlCommand(UPDATE_STATUS, connection); cmd.Parameters.AddWithValue("@UvoznikID", uvoznik.AutoID); cmd.Parameters.AddWithValue("@Aktivan", uvoznik.UserAktivan); cmd.CommandTimeout = 60; updated = cmd.ExecuteNonQuery() > 0 ? true : false; connection.Close(); return(updated); }
public ActionResult UpdatePersonalData(UvoznikModel importer) { try { if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null) { return(View("~/Views/Login/Index.cshtml")); } importer.AutoID = HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Uvoznik.AutoID; //UvoznikDAO.UpdateImporter(importer); UvoznikDAO.UpdatePasswordImporter(HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik").Id, importer.TempSifra); return(RedirectToAction("Index", "Message")); } catch (Exception e) { ViewBag.Message = "Desila se greška! (" + e.Message + ")"; return(View("EditImporterData")); } }
public ActionResult SaveEdit(UvoznikModel uvoznik) { try { if (HttpContext.Session.GetObjectFromJson <KorisnikModel>("LogovaniKorisnik") == null) { return(View("~/Views/Login/Index.cshtml")); } uvoznik.AutoID = Convert.ToInt32(HttpContext.Session.GetInt32("UvoznikAutoID")); UvoznikDAO.UpdateImporter(uvoznik); KorisnikModel noviuser = new KorisnikModel { Id = KorisnikDAO.GetUserIdByImporterID(uvoznik.AutoID), Ime = uvoznik.Naziv, Prezime = uvoznik.Naziv, Adresa = uvoznik.Adresa, Grad = uvoznik.Grad, Email = uvoznik.Email, Telefon = uvoznik.Telefon, Institucija = new InstitucijaModel { AutoID = 15 //TempObjekat Uvoznici }, GrupaKorisnika = new GrupeKorisnikaModel { AutoID = 4 //GrupaKorisnika Uvoznici }, Opstina = new OpstinaModel { OpstinaID = uvoznik.Opstina.OpstinaID }, Uvoznik = uvoznik, KorisnickoIme = uvoznik.JIB, }; KorisnikDAO.UpdateUserFromImporter(noviuser); return(RedirectToAction(nameof(Index))); } catch (Exception) { return(View("Edit")); } }
public static List <UvoznikModel> GetAllImportersForApproval() { List <UvoznikModel> lista = new List <UvoznikModel>(); UvoznikModel model = null; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; SqlDataReader reader = null; connection.Open(); cmd = new SqlCommand(GET_ALL_IMPORTERS_FOR_APPROVAL, connection); cmd.CommandTimeout = 60; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { model = new UvoznikModel(); model.AutoID = reader.GetInt32(0); model.Naziv = reader.GetString(1); model.Grad.PostanskiBrojID = Convert.ToInt32(reader.GetString(2)); model.Grad.Naziv = reader.GetString(3); model.Adresa = reader.GetString(4); model.JIB = reader.GetString(5); if (!reader.IsDBNull(6)) { model.PIB = reader.GetString(6); } model.DatumKreiranjaUTC = reader.GetDateTimeOffset(7).LocalDateTime; if (!reader.IsDBNull(8)) { model.KnjigovodstvenaSifra = reader.GetString(8); } if (!reader.IsDBNull(9)) { model.Email = reader.GetString(9); } if (!reader.IsDBNull(10)) { model.Telefon = reader.GetString(10); } if (!reader.IsDBNull(11)) { model.OvlastenoLice = reader.GetString(11); } if (!reader.IsDBNull(12)) { model.Fax = reader.GetString(12); } if (!reader.IsDBNull(13)) { model.Kontakt = reader.GetString(13); } if (!reader.IsDBNull(14)) { model.Opstina.OpstinaID = reader.GetString(14); } if (!reader.IsDBNull(15)) { model.Opstina.Naziv = reader.GetString(15); } model.UserAktivan = Convert.ToInt32(reader["Aktivan"]); model.SetTempUserStatus(); lista.Add(model); } reader.Close(); } connection.Close(); return(lista); }
public static UvoznikModel GetImporterById(int AutoID) { UvoznikModel model = null; SqlConnection connection = Database.GetConnection(); SqlCommand cmd = null; SqlDataReader reader = null; connection.Open(); cmd = new SqlCommand(GET_IMPORTER_BY_ID, connection); cmd.Parameters.AddWithValue("@AutoID", AutoID); cmd.CommandTimeout = 60; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { model = new UvoznikModel(); model.AutoID = reader.GetInt32(0); model.Naziv = reader.GetString(1); model.Grad.PostanskiBrojID = Convert.ToInt32(reader.GetString(2)); model.Grad.Naziv = reader.GetString(3); model.Adresa = reader.GetString(4); model.JIB = reader.GetString(5); if (!reader.IsDBNull(6)) { model.PIB = reader.GetString(6); } model.DatumKreiranjaUTC = reader.GetDateTimeOffset(7).LocalDateTime; if (!reader.IsDBNull(8)) { model.KnjigovodstvenaSifra = reader.GetString(8); } if (!reader.IsDBNull(9)) { model.Email = reader.GetString(9); } if (!reader.IsDBNull(10)) { model.Telefon = reader.GetString(10); } if (!reader.IsDBNull(11)) { model.OvlastenoLice = reader.GetString(11); } if (!reader.IsDBNull(12)) { model.Fax = reader.GetString(12); } if (!reader.IsDBNull(13)) { model.Kontakt = reader.GetString(13); } if (!reader.IsDBNull(14)) { model.Opstina.OpstinaID = reader.GetString(14); } if (!reader.IsDBNull(15)) { model.Opstina.Naziv = reader.GetString(15); } } reader.Close(); } connection.Close(); return(model); }