int IBaseEntity.InsertEntity(int?id_sup, int?tip_id, string kodi, string emertimi, string pershkrimi, string emertimiang, string pershkrimiang, int?perdorues_id, int?kategoria, bool?kompleks)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_project(id_sup, tip_id, kodi, emertimi, pershkrimi, emertimiang, pershkrimiang, perdorues_id, kategoria, kompleks);
return(result);
}
}
int IBaseEntity.UpdateEntity_tip_info(int?nrrendor, int?id_sup, bool?considerNull_id_sup, int?tip_id, bool?considerNull_tip_id, string emertimi, bool?considerNull_Emertimi, string pershkrimi, bool?considerNull_pershkrimi, string emertimiang, bool?considerNull_Emertimiang, string pershkrimiang, bool?considerNull_pershkrimiang, int?veti, bool?considerNull_veti, bool?skedar, bool?considerNull_skedar, bool?detyrueshme, bool?considerNull_detyrueshme, double?rradha, bool?considerNull_Rradha, bool?aktiv, bool?considerNull_Aktiv, int?perdorues_id, bool?considerNull_Perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spU_tbl_project_tip_info(nrrendor, id_sup, considerNull_id_sup, tip_id, considerNull_tip_id, emertimi, considerNull_Emertimi, pershkrimi, considerNull_pershkrimi, emertimiang, considerNull_Emertimiang, pershkrimiang, considerNull_pershkrimiang, veti, considerNull_veti, skedar, considerNull_skedar, detyrueshme, considerNull_detyrueshme, rradha, considerNull_Rradha, aktiv, considerNull_Aktiv, perdorues_id, considerNull_Perdorues_id);
return(result);
}
}
int IBaseEntity.UpdateEntity_access(int?task_id, int?perdoruesi_id)
{
using (var context = new taskDb())
{
var result = context.spU_tbl_task_access(task_id, perdoruesi_id);
return(result);
}
}
int IBaseEntity.UpdateEntity_kategori(int?nrrendor, int?id_sup, bool?considerNull_id_sup, int?elcat, bool?considerNull_elcat, string kodi, bool?considerNull_kodi, string emertimi, bool?considerNull_Emertimi, string pershkrimi, bool?considerNull_pershkrimi, string emertimiang, bool?considerNull_Emertimiang, string pershkrimiang, bool?considerNull_pershkrimiang, bool?aktiv, bool?considerNull_Aktiv, int?perdorues_id, bool?considerNull_Perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spU_tbl_project_kategori(nrrendor, id_sup, considerNull_id_sup, elcat, considerNull_elcat, kodi, considerNull_kodi, emertimi, considerNull_Emertimi, pershkrimi, considerNull_pershkrimi, emertimiang, considerNull_Emertimiang, pershkrimiang, considerNull_pershkrimiang, aktiv, considerNull_Aktiv, perdorues_id, considerNull_Perdorues_id);
return(result);
}
}
int IBaseEntity.InsertEntity_tip_info(int?id_sup, int?tip_id, string emertimi, string pershkrimi, string emertimiang, string pershkrimiang, int?veti, bool?detyrueshme, double?rradha, int?db, bool?skedar, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_task_tip_info(id_sup, tip_id, emertimi, pershkrimi, emertimiang, pershkrimiang, veti, detyrueshme, rradha, db, skedar, perdorues_id);
return(result);
}
}
int IBaseEntity.InsertEntity_tip_info_ch(int?id_sup, int?tip_info_id, string emertimi, string pershkrimi, string emertimiang, string pershkrimiang, int?perdorues_id, bool?vA)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_task_tip_info_ch(id_sup, tip_info_id, emertimi, pershkrimi, emertimiang, pershkrimiang, perdorues_id, vA);
return(result);
}
}
int INderBase.spI_tbl_nder_project_analize(int?project_id, int?analize_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_project_analize(project_id, analize_id, perdorues_id);
return(result);
}
}
int IBaseEntity.InsertEntity_info(int?id_sup, int?element_id, int?tip_info_id, string emertimi, string pershkrimi, string emertimiang, string pershkrimiang, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_project_info(id_sup, element_id, tip_info_id, emertimi, pershkrimi, emertimiang, pershkrimiang, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_personel_task(int?personel_id, int?task_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_personel_task(personel_id, task_id, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_personel_teknologji_nivel(int?personel_id, int?teknologji_id, int?nivel_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_personel_teknologji_nivel(personel_id, teknologji_id, nivel_id, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_niveli_skeda(int?niveli_id, int?skeda_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_niveli_skeda(niveli_id, skeda_id, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_klient_project(int?klient_id, int?project_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_klient_project(klient_id, project_id, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_pyetje_personel_nivel_testim_pyetjeinfo(int?pyetje_id, int?pyetje_info_id, int?testim_id, int?personel_id, int?nivel_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_pyetje_personel_nivel_testim_pyetjeinfo(pyetje_id, pyetje_info_id, testim_id, personel_id, nivel_id, perdorues_id);
return(result);
}
}
int INderBase.spI_tbl_nder_project_teknologji(int?project_id, int?teknologji_id, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_nder_project_teknologji(project_id, teknologji_id, perdorues_id);
return(result);
}
}
int IBaseEntity.InsertEntity_tip(int?id_sup, bool?elcat, string kodi, int?kodifillim, int?kodimbarim, int?kodiaktual, string emertimi, string pershkrimi, string emertimiang, string pershkrimiang, double?rradha, int?perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_task_tip(id_sup, elcat, kodi, kodifillim, kodimbarim, kodiaktual, emertimi, pershkrimi, emertimiang, pershkrimiang, rradha, perdorues_id);
return(result);
}
}
int IBaseEntity.InsertEntity_access(string id_gen, int?id_sup, string id_sup_gen, int?id_ndr, string id_ndr_gen, int?project_id, string project_id_gen, int?perdoruesi_id, string perdoruesi_id_gen, bool?aktiv, DateTime?data_krijimit, int?perdorues_id, string perdorues_id_gen)
{
using (var context = new taskDb())
{
var result = context.spI_tbl_project_access(id_gen, id_sup, id_sup_gen, id_ndr, id_ndr_gen, project_id, project_id_gen, perdoruesi_id, perdoruesi_id_gen, aktiv, data_krijimit, perdorues_id, perdorues_id_gen);
return(result);
}
}
int IBaseEntity.UpdateEntity_tip_info_ch(int?nrrendor, int?id_sup, bool?considerNull_id_sup, int?tip_info_id, bool?considerNull_tip_info_id, string emertimi, bool?considerNull_Emertimi, string pershkrimi, bool?considerNull_pershkrimi, string emertimiang, bool?considerNull_Emertimiang, string pershkrimiang, bool?considerNull_pershkrimiang, bool?aktiv, bool?considerNull_Aktiv, int?perdorues_id, bool?considerNull_Perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spU_tbl_project_tip_info_ch(nrrendor, id_sup, considerNull_id_sup, tip_info_id, considerNull_tip_info_id, emertimi, considerNull_Emertimi, pershkrimi, considerNull_pershkrimi, emertimiang, considerNull_Emertimiang, pershkrimiang, considerNull_pershkrimiang, aktiv, considerNull_Aktiv, perdorues_id, considerNull_Perdorues_id);
return(result);
}
}
int IBaseEntity.UpdateEntity_tip(int?nrrendor, int?id_sup, bool?considerNull_id_sup, int?elcat, bool?considerNull_elcat, string kodi, bool?considerNull_kodi, int?kodifillim, bool?considerNull_kodifillim, int?kodiaktual, bool?considerNull_kodiaktual, int?kodimbarim, bool?considerNull_kodimbarim, string emertimi, bool?considerNull_Emertimi, string pershkrimi, bool?considerNull_pershkrimi, string emertimiang, bool?considerNull_Emertimiang, string pershkrimiang, bool?considerNull_pershkrimiang, bool?aktiv, bool?considerNull_Aktiv, int?perdorues_id, bool?considerNull_Perdorues_id)
{
using (var context = new taskDb())
{
var result = context.spU_tbl_pyetje_tip(nrrendor, id_sup, considerNull_id_sup, elcat, considerNull_elcat, kodi, considerNull_kodi, kodifillim, considerNull_kodifillim, kodiaktual, considerNull_kodiaktual, kodimbarim, considerNull_kodimbarim, emertimi, considerNull_Emertimi, pershkrimi, considerNull_pershkrimi, emertimiang, considerNull_Emertimiang, pershkrimiang, considerNull_pershkrimiang, aktiv, considerNull_Aktiv, perdorues_id, considerNull_Perdorues_id);
return(result);
}
}
//Perdorues-----
public PartialViewResult ModifikoPerdorues()
{
PerdoruesViewModel model = new PerdoruesViewModel();
using (var db = new taskDb())
{
model.UsersList = db.AspNetUsers.ToList();
}
return(PartialView("_ModifikoPerdoues", model));
}
public ActionResult OnDemand()
{
List <KategoriView> all = new List <KategoriView>();
using (taskDb dc = new taskDb())
{
all = dc.KategoriView.Where(a => a.ParentId.Equals(-1)).ToList();
}
return(View(all));
}
public ActionResult Index()
{
AdminViewModel model = new AdminViewModel();
using (var context = new taskDb())
{
model.konfigurimet = context.konfigurime.ToList();
}
return(View(model));
}
public ActionResult DeletePerdorues(string id)
{
using (var db = new taskDb())
{
AspNetUsers model = new AspNetUsers();
model.Id = id;
db.Entry(model).State = EntityState.Deleted;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SaveNewTip(TipiViewModel model)
{
bool True = true;
using (var db = new taskDb())
{
db.spI_tbl_Analize_tip(model.SelectedParent, True, model.EntitetTip.kodi, model.EntitetTip.kodifillim, model.EntitetTip.kodimbarim, model.EntitetTip.kodiaktual, model.EntitetTip.emertimi, model.EntitetTip.pershkrimi, model.EntitetTip.emertimiang, model.EntitetTip.pershkrimiang, model.EntitetTip.rradha, model.EntitetTip.perdorues_id);
db.SaveChanges();
int a = db.SelectAllActiveRec_Entitet_tip("tbl_Analize").OrderByDescending(i => i.nrrendor).FirstOrDefault().nrrendor;
db.spI_tbl_nder_Analize_tip_kategori(model.SelectedParent, a, model.SelectedKategoriId, model.EntitetTip.perdorues_id);
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteTip(string id, string table)
{
using (var db = new taskDb())
{
var model = new SelectAllActiveRecBySup_Entitet_tip_Result();
model.aktiv = false;
var True = true;
if (table == "Analize")
{
db.spU_tbl_Analize_tip(Convert.ToInt32(id), model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Niveli")
{
db.spU_tbl_niveli_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Klient")
{
db.spU_tbl_klient_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Personel")
{
db.spU_tbl_personel_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Pyetje")
{
db.spU_tbl_pyetje_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Project")
{
db.spU_tbl_project_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Skeda")
{
db.spU_tbl_skeda_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Task")
{
db.spU_tbl_task_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
else if (table == "Teknologji")
{
db.spU_tbl_teknologjia_tip(model.nrrendor, model.id_sup, True, 1, True, model.kodi, True, model.kodifillim, True, model.kodiaktual, True, model.kodimbarim, True, model.emertimi, True, model.pershkrimi, True, model.emertimiang, True, model.pershkrimiang, True, model.aktiv, True, model.perdorues_id, True);
}
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult DeleteKategori(int id, string table)
{
using (var db = new taskDb())
{
var DeleteAnalize = new SelectAllActiveRec_Entitet_kategori_Result();
DeleteAnalize.aktiv = false;
var True = true;
if (table == "Analize")
{
db.spU_tbl_Analize_kategori(Convert.ToInt32(id), DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Niveli")
{
db.spU_tbl_niveli_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Klient")
{
db.spU_tbl_klient_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Personel")
{
db.spU_tbl_personel_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Pyetje")
{
db.spU_tbl_pyetje_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Project")
{
db.spU_tbl_project_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Skeda")
{
db.spU_tbl_skeda_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Task")
{
db.spU_tbl_task_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
else if (table == "Teknologji")
{
db.spU_tbl_teknologjia_kategori(DeleteAnalize.nrrendor, DeleteAnalize.id_sup, True, 1, True, DeleteAnalize.kodi, True, DeleteAnalize.emertimi, True, DeleteAnalize.pershkrimi, True, DeleteAnalize.emertimiang, True, DeleteAnalize.pershkrimiang, True, DeleteAnalize.aktiv, True, DeleteAnalize.perdorues_id, True);
}
}
return(RedirectToAction("Index"));
}
public ActionResult SaveEditedPerdorues(PerdoruesViewModel model)
{
AspNetRoles roles = new AspNetRoles();
using (var db = new taskDb())
{
db.AspNetUsers.Add(model.Users);
db.Entry(model.Users).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.AspNetRoles.Where(a => a.Id == model.SelectedRole).FirstOrDefault().AspNetUsers.Add(model.Users);
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult EditoPerdorues(string id)
{
Helper hp = new Helper();
PerdoruesViewModel model = new PerdoruesViewModel();
model.UsersRoles = hp.GetRole();
using (var db = new taskDb())
{
model.Users = db.AspNetUsers.Where(i => i.Id.Equals(id)).FirstOrDefault();
if (db.AspNetUsers.Where(i => i.Id.Equals(id)).FirstOrDefault().AspNetRoles.Count() > 0)
{
model.SelectedRole = db.AspNetUsers.Where(i => i.Id.Equals(id)).FirstOrDefault().AspNetRoles.FirstOrDefault().Id;
}
}
return(PartialView("_EditoPerdorues", model));
}
public ActionResult SaveEditedTip(TipiViewModel model)
{
using (var db = new taskDb())
{
var True = true;
if (model.table == "Analize")
{
db.spU_tbl_Analize_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Niveli")
{
db.spU_tbl_niveli_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Klient")
{
db.spU_tbl_klient_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Personel")
{
db.spU_tbl_personel_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Pyetje")
{
db.spU_tbl_pyetje_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Project")
{
db.spU_tbl_project_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Skeda")
{
db.spU_tbl_skeda_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Task")
{
db.spU_tbl_task_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
else if (model.table == "Teknologji")
{
db.spU_tbl_teknologjia_tip(model.EntitetTip.nrrendor, model.EntitetTip.id_sup, True, 1, True, model.EntitetTip.kodi, True, model.EntitetTip.kodifillim, True, model.EntitetTip.kodiaktual, True, model.EntitetTip.kodimbarim, True, model.EntitetTip.emertimi, True, model.EntitetTip.pershkrimi, True, model.EntitetTip.emertimiang, True, model.EntitetTip.pershkrimiang, True, True, True, model.EntitetTip.perdorues_id, True);
}
}
return(RedirectToAction("Index"));
}
public ActionResult SaveNewKategori(KategoriViewModel model)
{
bool True = true;
using (var db = new taskDb())
{
if (model.table == "tbl_Analize")
{
db.spI_tbl_Analize_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Niveli")
{
db.spI_tbl_niveli_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Klient")
{
db.spI_tbl_klient_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Personel")
{
db.spI_tbl_personel_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Pyetje")
{
db.spI_tbl_pyetje_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Project")
{
db.spI_tbl_project_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Skeda")
{
db.spI_tbl_skeda_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Task")
{
db.spI_tbl_task_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
else if (model.table == "tbl_Teknologji")
{
db.spI_tbl_teknologjia_kategori(model.Entitet.id_sup, True, model.Entitet.kodi, model.Entitet.emertimi, model.Entitet.pershkrimi, model.Entitet.emertimiang, model.Entitet.pershkrimiang, model.Entitet.rradha, model.Entitet.perdorues_id);
}
}
return(RedirectToAction("Index"));
}
//Kategori----
public ActionResult ModifikoKategori()
{
KategoriViewModel kategoriViewModel = new KategoriViewModel();
Helper hp = new Helper();
AdminViewModel model = new AdminViewModel();
model.SelectListEntity = hp.GetEntities();
kategoriViewModel.SelectListKategori = hp.GetEntities();
using (var context = new taskDb())
{
model.konfigurimet = context.konfigurime.ToList();
}
return(PartialView("_ModifikoKategori", kategoriViewModel));
}
