public ActionResult DetayList(int id)
{
PersonelRepository personelRepository = new PersonelRepository();
PersonelViewModel model = new PersonelViewModel();
Personell personel = personelRepository.FirstOrDefault(x => x.PersonellId == id);
DepartmanEnum departmanEnum = (DepartmanEnum)personel.Departman;
model.DepartmanAd = EnumerationHelper.GetDescription <DepartmanEnum>(departmanEnum);
model.Ad = personel.Ad;
model.Soyad = personel.Soyad;
model.Departman = personel.Departman.Value;
model.İzinGunu = personel.İzinGunu.Value;
model.PersonellId = id;
return(View(model));
}
public HttpResponseMessage Personel_Genel(Personel_Model per)
{
AcekaResult acekaResult = null;
personelRepository = new PersonelRepository();
if (per != null && per.carikart_id == 0)
{
per.carikart_turu_id = 2;
per.carikart_tipi_id = 21;
acekaResult = CrudRepository <Personel_Model> .Insert(per, "carikart", new string[] { "degistiren_tarih", "carikart_tipi_adi", "carikart_id", "carikart_turu_adi" });
if (acekaResult != null && acekaResult.ErrorInfo == null)
{
//var person = personelRepository.Getir(acekaResult.RetVal.acekaToLong());
long carikartId = acekaResult.RetVal.acekaToLong();
if (per.muh_masraf != null && per.muh_masraf.carikart_id == 0)
{
per.muh_masraf.carikart_id = acekaResult.RetVal.acekaToLong();
var muhmasraf = CrudRepository <carikart_muhasebe_personel_Model> .Insert(per.muh_masraf, "carikart_muhasebe", new string[] { "sirket_adi", "muh_kod_adi", "masraf_merkezi_adi", "masraf_merkezi_id", "degistiren_tarih", "masraf_merkezi_id" });
}
if (per.iletisim != null && per.iletisim.carikart_id == 0)
{
per.iletisim.carikart_id = carikartId;
PersonelIletisimPost(per.iletisim);
}
if (per.parametre != null && per.parametre.carikart_id == 0)
{
per.parametre.carikart_id = carikartId;
PersonelParametreinsert(per.parametre);
}
return(Request.CreateResponse(HttpStatusCode.OK, new Models.AnonymousModels.Successful {
message = "successful", ret_val = carikartId.ToString()
}));
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, acekaResult.ErrorInfo.Message));
}
}
else
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError, acekaResult.ErrorInfo.Message));
}
}
public HttpResponseMessage PersonelIletisimGetir(long carikart_id)
{
personelRepository = new PersonelRepository();
var o = personelRepository.PersonelAdresBul(carikart_id);
if (o != null)
{
var adres = new
{
carikart_adres_id = o.carikart_adres_id,
degistiren_carikart_id = o.degistiren_carikart_id,
degistiren_tarih = o.degistiren_tarih,
kayit_silindi = o.kayit_silindi,
statu = o.statu,
adres_tipi_id = o.adres_tipi_id,
carikart_id = o.carikart_id,
postakodu = o.postakodu,
ulke_id = o.ulke_id,
sehir_id = o.sehir_id,
ilce_id = o.ilce_id,
semt_id = o.semt_id,
tel1 = o.tel1,
tel2 = o.tel2,
fax = o.fax,
email = o.email,
websitesi = o.websitesi,
yetkili_ad_soyad = o.yetkili_ad_soyad,
yetkili_tel = o.yetkili_tel,
adres = o.adres,
};
return(Request.CreateResponse(HttpStatusCode.OK, adres));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage PersonelParametreDepartmanGetir()
{
personelRepository = new PersonelRepository();
parametre = personelRepository.PersonelParametreleri();
if (parametre != null)
{
var ozet = parametre.Where(o => o.parametre_grup_id == "PRDEPART").Select(o => new
{
parametre_id = o.parametre_id,
parametre_adi = o.parametre_adi,
});
return(Request.CreateResponse(HttpStatusCode.OK, ozet));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage PersonelCalismaYerleriGetir()
{
personelRepository = new PersonelRepository();
personeller = personelRepository.PersonelCalismaYerleri();
if (personeller != null)
{
var ozet = personeller.Select(o => new
{
carikart_id = o.carikart_id,
cari_unvan = o.cari_unvan,
});
return(Request.CreateResponse(HttpStatusCode.OK, ozet));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage PersonelTipleriniGetir()
{
personelRepository = new PersonelRepository();
caritip = personelRepository.CarikartTipleriniGetir();
if (caritip != null)
{
var ozet = caritip.Select(o => new
{
personel_tipi_id = o.carikart_tipi_id,
personel_tipi_adi = o.carikart_tipi_adi,
});
return(Request.CreateResponse(HttpStatusCode.OK, ozet));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage PersonelParametreAnaGrup(int kaynak_1_parametre_id = 0)
{
personelRepository = new PersonelRepository();
personelparametre = personelRepository.PersonelRaporParametreleri(kaynak_1_parametre_id);
if (personelparametre != null)
{
var ozet = personelparametre.Select(o => new
{
parametre_id = o.parametre_id,
parametre_adi = o.tanim,
parametre = o.parametre,
kaynak_1_parametre_id = o.kaynak_1_parametre_id,
});
return(Request.CreateResponse(HttpStatusCode.OK, ozet));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage Personel_CalismaYerleri(long carikart_id)
{
personelRepository = new PersonelRepository();
personel_calisma_yerleri = personelRepository.Personel_Calisma_Yerleri_Getir(carikart_id);
if (personel_calisma_yerleri != null)
{
var per = personel_calisma_yerleri.Select(o => new
{
carikart_id = o.carikart_id,
stokyeri_carikart_id = o.stokyeri_carikart_id,
stokyeri_carikart_adi = o.stokyeri_carikart_adi,
departman_id = o.departman_id,
departman_adi = o.departman_adi,
gorev_id = o.gorev_id,
gorev_adi = o.gorev_adi,
});
/*
* departmanlar = o.departmanlar.Select(d => new
* {
* departman_id = d.parametre_id,
* departman_adi = d.parametre_adi,
* })
* gorevler = o.gorevler.Select(g => new
* {
* gorev_id = g.parametre_id,
* gorev_adi = g.parametre_adi,
* }),
*/
return(Request.CreateResponse(HttpStatusCode.OK, per));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public HttpResponseMessage PersonelAraOzet(long carikart_id = 0, string cari_unvan = "", string ozel_kod = "", int carikart_tipi_id = 0, string statu = "")
{
personelRepository = new PersonelRepository();
personeller = personelRepository.Bul(carikart_id, cari_unvan, ozel_kod, carikart_tipi_id, statu);
if (personeller != null)
{
var person = personeller.Select(s => new
{
tanim = s.cari_unvan,
personel_no = s.carikart_id,
personel_kod = s.ozel_kod,
statu = s.statu_adi,
personeltipi = s.carikart_tipi_adi
////,dogumtarihi = s.personel_kimlik.dogum_tarihi
});
return(Request.CreateResponse(person));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NoContent, new Models.AnonymousModels.NotFound {
message = "No Record"
}));
}
}
public ActionResult List(List <PersonelViewModel> list)
{
PersonelRepository repository = new PersonelRepository();
List <PersonelViewModel> _list = new List <PersonelViewModel>();
list = _list.ToList();
IQueryable <Personell> personel = repository.GetAll();
foreach (var item in personel)
{
DepartmanEnum departmanEnum = (DepartmanEnum)item.Departman;
PersonelViewModel model = new PersonelViewModel()
{
PersonellId = item.PersonellId,
Ad = item.Ad,
Soyad = item.Soyad,
İzinGunu = item.İzinGunu.Value,
Departman = item.Departman.Value,
DepartmanAd = EnumerationHelper.GetDescription <DepartmanEnum>(departmanEnum)
}; list.Add(model);
}
return(View(list));
}
public IActionResult Create(Kisi kisi)
{
PersonelRepository.Add(kisi);
return(View("Index"));
}
public PersonelService()
{
_personelRepository = new PersonelRepository();
}
public UnitOfWork(DatabaseContext databaseContext)
{
_databaseContext = databaseContext;
DepartmentRepository = new DepartmentRepository(_databaseContext);
PersonelRepository = new PersonelRepository(_databaseContext);
}
public HttpResponseMessage Personel_GenelPut(Personel_Model personel)
{
AcekaResult acekaResult = null;
if (personel != null)
{
if (personel.carikart_id > 0)
{
Dictionary <string, object> fields = new Dictionary <string, object>();
fields.Add("carikart_id", personel.carikart_id);
fields.Add("degistiren_carikart_id", Tools.PersonelId);
fields.Add("statu", personel.statu);
fields.Add("cari_unvan", personel.cari_unvan);
fields.Add("ozel_kod", personel.ozel_kod);
fields.Add("giz_kullanici_adi", personel.giz_kullanici_adi);
fields.Add("giz_kullanici_sifre", personel.giz_kullanici_sifre);
// fields.Add("statu", personel.statu);
if (personel.sube_carikart_id > 0)
{
fields.Add("sube_carikart_id", personel.sube_carikart_id);
}
acekaResult = CrudRepository.Update("carikart", "carikart_id", fields);
if (acekaResult != null && acekaResult.RetVal != null)
{
personelRepository = new PersonelRepository();
var person = personelRepository.Getir(personel.carikart_id);
if (person != null)
{
if (person.muh_masraf.carikart_id_m > 0 && (personel.muh_masraf != null && personel.muh_masraf.muh_kod != null && personel.muh_masraf.muh_kod.ToString().Length > 0))
{
person.muh_masraf.carikart_id_m = person.carikart_id;
Dictionary <string, object> fields_muh = new Dictionary <string, object>();
if (personel.muh_masraf.sirket_id > 0)
{
fields_muh.Add("sirket_id", personel.muh_masraf.sirket_id);
}
if (personel.muh_masraf.sene > 0)
{
fields_muh.Add("sene", personel.muh_masraf.sene);
}
fields_muh.Add("carikart_id", personel.carikart_id);
fields_muh.Add("degistiren_carikart_id", personel.degistiren_carikart_id);
fields_muh.Add("muh_kod", personel.muh_masraf.muh_kod);
AcekaResult acekaResult2 = null;
acekaResult2 = CrudRepository.Update("carikart_muhasebe", "carikart_id", fields_muh);
}
else if (personel.muh_masraf != null && personel.muh_masraf.muh_kod != null && personel.muh_masraf.muh_kod.ToString().Length > 0)
{
personel.muh_masraf.carikart_id = person.carikart_id;
string[] not_include2 = { "sirket_adi", "muh_kod_adi", "masraf_merkezi_adi", "sene", "masraf_merkezi_id", "degistiren_tarih", "masraf_merkezi_id" };
AcekaResult acekaResult2 = null;
acekaResult2 = CrudRepository <carikart_muhasebe_personel_Model> .Insert(personel.muh_masraf, "carikart_muhasebe", not_include2);
}
if (personel.parametre != null)
{
personel.parametre.carikart_id = person.carikart_id;
PersonelParametreput(personel.parametre);
}
if (personel.iletisim != null)
{
//personelRepository = new PersonelRepository();
//var o = personelRepository.PersonelAdresBul(person.carikart_id);
var o = personel.iletisim.carikart_adres_id;
personel.iletisim.carikart_id = person.carikart_id;
//if (o.carikart_adres_id > 0)
if (personel.iletisim.carikart_adres_id > 0)
{
personel.iletisim.carikart_adres_id = personel.iletisim.carikart_adres_id;;
PersonelIletisimPut(personel.iletisim);
}
else
{
PersonelIletisimPost(personel.iletisim);
}
//var pSonuc = PersonelIletisimGetir(personel.carikart_id);
// personel.iletisim.carikart_id = person.carikart_id;
// if(pSonuc != null && pSonuc.IsSuccessStatusCode)
// {
// var ii = ((HttpResponseMessage)pSonuc.Content).TryGetContentValue("carikart_adres_id");
// PersonelIletisimPut(personel.iletisim);
// }
// else
// {
// PersonelIletisimPost(personel.iletisim);
// }
}
}
}
return(Request.CreateResponse(HttpStatusCode.OK, new Models.AnonymousModels.Successful {
message = "successful"
}));
}
}
return(null);
}
public UnitOfWork(GenericRepositoryAndUnitOfWorkPatternDbContext dbContext)
{
_dbContext = dbContext;
ProjeRepository = new ProjeRepository(_dbContext);
PersonelRepository = new PersonelRepository(_dbContext);
}
public UnitOfWork(UOWContext context)
{
_UOWContext = context;
DepartmentRepository = new DepartmentRepository(_UOWContext);
PersonelRepository = new PersonelRepository(_UOWContext);
}
public IList <Personel> PersonelAra(long carikart_id = 0, string cari_unvan = "", string ozel_kod = "", int carikart_tipi_id = 0, string statu = "")
{
personelRepository = new PersonelRepository();
personeller = personelRepository.Bul(carikart_id, cari_unvan, ozel_kod, carikart_tipi_id, statu);
return(personeller);
}
public UnitOfWork(PersonelContext context)
{
_personelContext = context;
DepartmentRepository = new DepartmentsRepository(_personelContext);
PersonelRepository = new PersonelRepository(_personelContext);
}
public PersonelController(PersonelRepository personelRep)
{
_personelRep = personelRep;
}
public UnitOfWork(GenericContext genericContext)
{
_genericContext = genericContext;
departmentRepository = new DepartmentRepository(_genericContext);
personelRepository = new PersonelRepository(_genericContext);
}
