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);
}
