public HttpResponseMessage insertPersonel(DTOpersonel request)
{
var user = KOCAuthorizeAttribute.getCurrentUser();
using (var db = new CRMEntities())
{
var errormessage = new DTOResponseError {
errorCode = 1, errorMessage = "İşlem Başarılı"
};
var p = new personel
{
personelname = request.personelname,
category = (int)request.category,
mobile = request.mobile,
email = request.email,
password = request.password,
notes = request.notes,
roles = (int)request.category,
creationdate = DateTime.Now,
lastupdated = DateTime.Now,
deleted = false,
updatedby = user.userId
};
db.personel.Add(p);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, errormessage, "application/json"));
}
}
public ActionResult Create(PersonelViewModel personelView)
{
ModelState.Remove("ModifiedUsername");
ModelState.Remove("CreatedOn");
if (ModelState.IsValid)
{
personel result = new personel()
{
ad = personelView.ad,
soyad = personelView.soyad,
sicilNo = personelView.sicilNo,
tcKimlik = personelView.tcKimlik,
telefon = personelView.telefon,
dahili = personelView.dahili,
eposta = personelView.eposta,
meslegi = personelView.meslegi,
unvani = personelView.unvani,
adres = personelView.adres,
kanGrubu = personelView.kanGrubu,
kullanici_adi = personelView.kullaniciAdi,
sifre = personelView.sifre,
yakininAdSoyadi = personelView.yakininAdSoyadi,
yakininTelefon = personelView.yakininTelefon,
baskanlikId = personelView.BaskanlikId,
mudurlukId = personelView.MudurlukId,
seflikId = personelView.SeflikId,
};
personelManager.Insert(result);
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult yenipersonelgir(personel yenipersonel, HttpPostedFileBase gelendosya)
{
if (ModelState.IsValid && gelendosya != null)
{
string dosyaismial = gelendosya.FileName;
if (dosyaismial.EndsWith("jpg") || dosyaismial.EndsWith("png"))
{
yenipersonel.resimismi = dosyaismial;
db.personeller.Add(yenipersonel);
db.SaveChanges();
gelendosya.SaveAs(Server.MapPath("~/img/" + dosyaismial));
ViewBag.mesaj = "Kayıt Başarılı";
return(RedirectToAction("yenipersonelList"));
}
else
{
ViewBag.mesaj = "Lütfen uygun dosya formatı seçiniz!";
return(View());
}
}
else
{
ViewBag.mesaj = "Kayıt Başarısız";
return(View(yenipersonel));
}
}
public ActionResult Kaydet(personel personel)
{
if (!ModelState.IsValid)
{
var model = new PersonelFromViewModel()
{
Departmanlar = db.Departman.ToList(),
Personel = personel
};
return(View("PersonelForm", model));
}
if (personel.p_no == 0)
{
db.personel.Add(personel);
}
else
{
if (personel == null)
{
return(HttpNotFound());
}
else
{
db.Entry(personel).State = System.Data.Entity.EntityState.Modified;
}
}
db.SaveChanges();
return(RedirectToAction("PersonelList"));
}
public ActionResult Update(personel personel)
{
ModelState.Remove("CreatedOn");
ModelState.Remove("ModifiedOn");
ModelState.Remove("ModifiedUsername");
if (ModelState.IsValid)
{
personel per = personelManager.Find(x => x.Id == personel.Id);
if (per != null)
{
per.Id = personel.Id;
per.ad = personel.ad;
per.soyad = personel.soyad;
per.sicilNo = personel.sicilNo;
per.tcKimlik = personel.tcKimlik;
per.telefon = personel.telefon;
per.dahili = personel.dahili;
per.eposta = personel.eposta;
per.meslegi = personel.meslegi;
per.unvani = personel.unvani;
per.adres = personel.adres;
per.kanGrubu = personel.kanGrubu;
per.kullanici_adi = personel.kullanici_adi;
per.sifre = personel.sifre;
per.yakininAdSoyadi = personel.yakininAdSoyadi;
per.yakininTelefon = personel.yakininTelefon;
}
;
personelManager.Update(per);
return(RedirectToAction("Index"));
}
return(View());
}
public DrVePersonelItem(personel var) : this()
{
materialLabel3.Text = var.birey.ad + " " + var.birey.soyad;
materialLabel4.Text = var.birey.tckimlikno.ToString();
pictureBox1.Image = Resources.person2;
activeTCNO = var.tckimlikno.ToString();
}
public ActionResult PersonelKaydet(personel personel)
{
if (@personel.id == 0)
{
baglanti.Open();
string query = "Insert into personel(Departmanid,Ad,Soyad,Yas,Maas,Dtarihi,Cinsiyet,MedeniHal) values" +
" (" + @personel.Departmanid + ",'" + @personel.Ad + "','" + @personel.Soyad + "'," + @personel.Yas + "," + @personel.Maas + ",'" + @personel.Dtarihi + "','" + @personel.Cinsiyet + "','" + @personel.MedeniHal + "')";
MySqlCommand cmd = new MySqlCommand(query, baglanti);
cmd.ExecuteNonQuery();
baglanti.Close();
}
else
{
baglanti.Open();
MySqlCommand cmd = new MySqlCommand("Update personel set Departmanid=" + @personel.Departmanid + ",Ad='" + personel.Ad + "'," +
"Soyad='" + personel.Soyad + "',Yas=" + @personel.Yas + ",Maas=" + personel.Maas + ",Dtarihi='" + personel.Dtarihi + "'" +
" , Cinsiyet='" + personel.Cinsiyet + "', MedeniHal='" + personel.MedeniHal + "' where id=" + personel.id + "", baglanti);
MySqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
personel.Departmanid = Convert.ToInt32(rd["Departmanid"]);
personel.Ad = rd["Ad"].ToString();
personel.Soyad = rd["Soyad"].ToString();
personel.Yas = Convert.ToInt32(rd["Yas"]);
personel.Maas = Convert.ToInt32(rd["Maas"]);
personel.Dtarihi = rd["Dtarihi"].ToString();
personel.Cinsiyet = rd["Cinsiyet"].ToString();
personel.MedeniHal = rd["MedeniHal"].ToString();
}
baglanti.Close();
}
return(RedirectToAction("Personel", "Home"));
}
public void personelOku()
{
foreach (personel p in new personelService().personelOku())
{
cbxPersonel.Items.Add(p);
}
personel per = ((personel)cbxPersonel.SelectedItem);
}
public List <PersonelTip> PersonelSil(int personelID)
{
personel cikis = _ent.personel.Find(personelID);
_ent.personel.Remove(cikis);
_ent.SaveChanges();
return(PersonelleriGetir());
}
public override global::System.Data.DataSet Clone()
{
personel cln = ((personel)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public ActionResult DeleteConfirmed(int id)
{
personel personel = db.personel.Find(id);
db.personel.Remove(personel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public personelguncellemeform(personel gPer)
{
InitializeComponent();
textBox1.Text = gPer.Ad;
textBox2.Text = gPer.Tel;
textBox3.Text = gPer.Adres;
}
private void Form1_Load(object sender, EventArgs e)
{
universite y = new universite();
y.metod1();
y.metod2();
personel p = new personel("faruk");
personel n = new personel();
}
public ActionResult Edit([Bind(Include = "pers_id,Ad,Soyad,Mail,Gsm,KullanıcıAdı,Sifre")] personel personel)
{
if (ModelState.IsValid)
{
db.Entry(personel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(personel));
}
//
// GET: /personel/Details/5
public ActionResult Details(int id = 0)
{
personel personel = db.personel.Find(id);
if (personel == null)
{
return(HttpNotFound());
}
return(View(personel));
}
public ActionResult DeleteConfirmed(int id)
{
personel personel = personelManager.Find(x => x.Id == id);
if (personel != null)
{
personelManager.Delete(personel);
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "pers_id,Ad,Soyad,Mail,Gsm,KullanıcıAdı,Sifre")] personel personel)
{
if (ModelState.IsValid)
{
db.personel.Add(personel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(personel));
}
void guncelle(personel gPer)
{
label1.Text = gPer.Id.ToString();
txbPersonelAdi.Text = gPer.PersonelAd;
txbPersonelSoyadi.Text = gPer.PersonelSoyad;
dtpPersonelDogumTarihi.Value = DateTime.Parse(gPer.PersonelDogumTarihi);
cbxPersonel.SelectedIndex = gPer.PersonelBirim;
cbxDogumYeri.Text = gPer.PersonelDogumYeri;
txbPersonelUnvan.Text = gPer.PersonelUnvan;
txbPersonelMaas.Text = gPer.PersonelMaas;
}
static void Main()
{
int t;
//int y = 0;
//personel[] personeller_dizisi = new personel[9999];
List <personel> personeller_dizisi = new List <personel>();
personel person = new personel();
while (true)
{
Console.WriteLine("lutfen işlem seçiniz:");
Console.WriteLine("1->kişi ekle");
Console.WriteLine("2->kişi bilgisi görüntüle");
t = Convert.ToInt32(Console.ReadLine());
switch (t)
{
case 1:
{
Console.WriteLine("kaydedilecek kişinin adı:");
person.ad = Convert.ToString(Console.ReadLine());
Console.WriteLine("kaydedilecek kişinin soyadı:");
person.soyad = Convert.ToString(Console.ReadLine());
Console.WriteLine("kaydedilecek kişinin maası:");
person.maas = Convert.ToInt32(Console.ReadLine());
personeller_dizisi.Add(person);
//personeller_dizisi[y] = person;
//y++;
break;
}
case 2:
{
Console.WriteLine("aranan kişinin ismini girin:");
string f;
f = Convert.ToString(Console.ReadLine());
for (int e = 0; /*e< personeller_dizisi.Length; */ e < personeller_dizisi.Count; e++)
{
if (f == personeller_dizisi[e].ad)
{
Console.WriteLine("{0},{1},{2}", personeller_dizisi[e].ad, personeller_dizisi[e].soyad, personeller_dizisi[e].maas.ToString());
}
}
break;
}
}
}
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
personel ds = new personel();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
public HttpResponseMessage getPersonel()
{
using (var db = new CRMEntities())
{
var atanmamis = new personel {
personelid = 0, personelname = "Atanmamış"
};
var res = db.personel.Where(p => p.deleted == false).OrderBy(p => p.personelname).ToList();
res.Insert(0, atanmamis);
return(Request.CreateResponse(HttpStatusCode.OK, res.Select(s => s.toDTO()).ToList(), "application/json"));
}
}
public int PersonelGiris(string pka, string psifre)
{
personel d = _ent.personel.FirstOrDefault(p => p.pkad == pka && p.psfire == psifre);
if (d == null)
{
return(0);
}
else
{
return(d.personelID);
}
}
public IActionResult Duzenle(int id)
{
personel p = _context
.personeller
.Where(x => x.personelNo == id)
.FirstOrDefault();
ViewBag.cinsiyetler =
new SelectList(_context.cinsiyetler.ToList(),
"cinsiyetId", "cinsiyetAdi");
return(View(p));
}
public int PersonelGiris(string kap, string sifre)
{
personel p = _ent.personel.FirstOrDefault(t => t.personelKA == kap && t.personelSifre == sifre);
if (p == null)
{
return(0);
}
else
{
return(p.personelID);
}
}
public string GetCurrentUsername()
{
personel user = CurrentSession.User;
if (user != null)
{
return(user.kullanici_adi);
}
else
{
return("system");
}
}
//
// GET: /personel/Edit/5
public ActionResult Edit(int id = 0)
{
personel personel = db.personel.Find(id);
if (personel == null)
{
return(HttpNotFound());
}
ViewBag.birim_no = new SelectList(db.birim, "birim_no", "birim_ad", personel.birim_no);
ViewBag.dogum_yeri = new SelectList(db.ilce, "ilce_no", "ilce_ad", personel.dogum_yeri);
ViewBag.unvan_no = new SelectList(db.unvan, "unvan_no", "unvan_ad", personel.unvan_no);
return(View(personel));
}
public ActionResult Edit(personel personel)
{
if (ModelState.IsValid)
{
db.Entry(personel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.birim_no = new SelectList(db.birim, "birim_no", "birim_ad", personel.birim_no);
ViewBag.dogum_yeri = new SelectList(db.ilce, "ilce_no", "ilce_ad", personel.dogum_yeri);
ViewBag.unvan_no = new SelectList(db.unvan, "unvan_no", "unvan_ad", personel.unvan_no);
return(View(personel));
}
public ActionResult PersonelKaydetIslem(personel model)
{
var tipKaydetSonuc = _personelService.PersonelKaydet(model);
if (tipKaydetSonuc == true)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult PesonelSil(personel model)
{
var silSonuc = _personelService.PersonelSil(model);
if (silSonuc == true)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
// GET: personel/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
personel personel = db.personel.Find(id);
if (personel == null)
{
return(HttpNotFound());
}
return(View(personel));
}
