protected void btnEkle_Click(object sender, EventArgs e)
{
EFDal ed = new EFDal();
int BolgeKodu = ed.kal_BolgeKoduDon(Context.User.Identity.Name);
int SiradakiFirmaId = ed.FirmaIdMaxDon() + 1;
sfKalDataEntities KalData = new sfKalDataEntities();
firma oFirma = new firma();
oFirma.MUSTNO = int.Parse(txtMustNo.Text.Trim());
oFirma.FIRMAADI = txtFirmaAdi.Text.Trim();
oFirma.ADRESI = txtAdres1.Text.Trim();
oFirma.ADRESII = txtAdres2.Text.Trim();
oFirma.IL_ILCE = txtIlce.Text.Trim();
oFirma.TELEFON = txtTelefon.Text.Trim();
oFirma.FAX = txtFax.Text.Trim();
oFirma.ILGILI = txtIlgili.Text.Trim();
oFirma.EMAIL = txtEmail.Text.Trim();
oFirma.NOTLAR = txtNotlar.Text.Trim();
oFirma.FATADRES = txtFatAdresi.Text.Trim();
oFirma.VERGIDAIRESI = txtVergiDairesi.Text.Trim();
oFirma.VERGINO = txtVergiNo.Text.Trim();
oFirma.BOLGEKODU = (short)BolgeKodu;
oFirma.KAMUFIRMASI = chkKamufirması.Checked;
oFirma.TSEBELGELI = chkTseBelgeli.Checked;
KalData.AddTofirma(oFirma);
firmaChild ofirmaChild = new firmaChild();
ofirmaChild.AnneFirmaFirmaId = int.Parse(Session["ChildFirmaIcingidecekFirmaId"].ToString());
ofirmaChild.ChildFirmaId = SiradakiFirmaId;
KalData.AddTofirmaChild(ofirmaChild);
KalData.SaveChanges();
}
private void TryChangingFirma(firma f)
{
if (isDirty)
{
MessageBoxResult res = MessageBox.Show("Änderungen speichern ?", "Sicherheitsabfrage", MessageBoxButton.YesNoCancel);
switch (res)
{
case MessageBoxResult.Cancel:
{
break;
}
case MessageBoxResult.No:
{
ReloadFirma(f.id);
break;
}
case MessageBoxResult.Yes:
{
SaveData();
SelectCompany(f);
break;
}
default:
break;
}
}
else
{
SelectCompany(f);
}
}
private void button2_Click(object sender, EventArgs e)
{
firma f = new firma();
f.NazwaFirmy = textBox1.Text;
f.NazwaOrganuReprezentacji = textBox2.Text;
f.DataRozpoczeciaDzialalosci = dateTimePicker11.Value;
f.NIP = textBox3.Text;
f.Regon = textBox4.Text;
f.Strona = textBox5.Text;
f.Emailfirmy = textBox7.Text;
f.AdresSiedziby = textBox6.Text;
f.IloscPracownikow = numericUpDown1.Value;
firmy.Add(f);
listView1.Items.Add(f.NazwaFirmy + " " + f.NIP);
textBox1.Text = string.Empty;
textBox2.Text = string.Empty;
textBox3.Text = string.Empty;
textBox4.Text = string.Empty;
textBox5.Text = string.Empty;
textBox6.Text = string.Empty;
textBox7.Text = string.Empty;
numericUpDown1.Value = 0;
dateTimePicker11.Value = DateTime.Now;
}
public KundeChangedEvent(int id, string addionalInfo, firma Firma, SteinbachEntities db)
{
this.id = id;
this.addionalInfo = addionalInfo;
this.db = db;
this.Firma = Firma;
}
public ListboxKategorienViewModel(firma Firma, SteinbachEntities db)
{
_selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e);
this.db = db;
CurrentFirma = Firma;
_AvailableNames = db.firmen.Where(f => f.istFirma == 1).ToList();
}
public void DoAddCustomers()
{
using (SteinbachEntities db = new SteinbachEntities())
{
var projects = (from p in db.projekte select new { p.kundenname }).Distinct();
foreach (var po in projects)
{
var q = from k in db.firmen where k.name.Equals(po.kundenname, StringComparison.CurrentCulture) select k;
if (q.Count() == 0)
{
var f = new firma();
f.name = po.kundenname;
f.created = DateTime.Now;
f.istFirma = 3;
db.firmen.AddObject(f);
}
}
db.SaveChanges();
Console.WriteLine("Done . . . . . .");
}
}
public FirmaDataViewModel(SteinbachEntities db, firma Firma)
{
try
{
this.db = db;
CurrentFirma = Firma;
ListboxKategorien = new ListboxKategorienViewModel(CurrentFirma, db);
ListboxEigenschaften = new ListboxEigenschaftenViewModel(CurrentFirma, db);
Adressen = new ObservableCollection <Firmen_Adressen>(CurrentFirma.Firmen_Adressen);
Telefonnummern = new ObservableCollection <Firmen_Telefon>(CurrentFirma.Firmen_Telefon.OrderBy(o => o.id_Standort));
Mailadressen = new ObservableCollection <Firmen_Mailadressen>(CurrentFirma.Firmen_Mailadressen.OrderBy(o => o.id_Standort));
//Employees = new ObservableCollection<StammFirmen_Kategorien>(db.StammFirmen_Kategorien);
Firmen_KategorienOC = new ObservableCollection <Firmen_Kategorien>(db.Firmen_Kategorien.Where(k => k.id_Firma == CurrentFirma.id));
this.db = db;
this.db.SavingChanges += new EventHandler(db_SavingChanges);
timer = new DispatcherTimer();
timer.Tick += new EventHandler(timer_Tick);
timer.Interval = new TimeSpan(0, 0, 0, 0, 500);
timer.Start();
AdressenExpanded = true;
TelefonnummernExpanded = true;
MailadressenExpanded = true;
ResetPhoneNumberDirty(false);
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex, true);
}
}
public ListboxEigenschaftenViewModel(firma Firma, SteinbachEntities db)
{
_selectedNames.CollectionChanged += (sender, e) => UpdateCollection(sender, e);
this.db = db;
CurrentFirma = Firma;
_AvailableNames = db.AuswahlEintraege.Where(f => f.Gruppe == "TypFirmaEigenschaften").ToList();
}
public FirmaViewModel()
{
db = new SteinbachEntities();
CurrentFirma = db.firmen.Where(f => f.id == 23).SingleOrDefault();
isDirty = true;
//name = "asWorks";
}
private void LoadFirma(int id)
{
this.db = new SteinbachEntities();
CurrentFirma = db.firmen.Where(f => f.id == id).SingleOrDefault();
//CurrentFirma = Firma;
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen);
}
private void lfcFirma_OnFcb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
firma f = (firma)lfcFirma.CBoxSelectedItem;
if (f != null)
{
LoadKontakte(f.id);
}
}
protected void Sil()
{
int FirmaId = int.Parse(txtFirmaID.Text.Trim());
var entt = new sfKalDataEntities();
firma ofirma = (from c in entt.firma where c.FIRMAID == FirmaId select c).First();
ofirma.SILINDI = true;
entt.SaveChanges();
}
public ActionResult FirmaGuncelle(firma f)
{
var frm = db.firma.Find(f.firma_ID);
frm.firma_ismi = f.firma_ismi;
frm.firma_tel = f.firma_tel;
frm.firma_mail = f.firma_mail;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public KundendatenViewModel(SteinbachEntities db, firma Firma)
{
firmenDatenViewModel = new FirmaDataViewModel(db, Firma);
PersonenDatenViewModel = new PersonenDatenViewModel(db, Firma);
FirmenPersonenListeViewModel = new FirmenPersonenListeViewModel(db, Firma);
KommunikationVM = new KommunikationViewModel(Firma.id);
KundenbesuchVM = new KundenbesuchListeViewModel(Firma.id);
this.db = db;
LoadFirmen(string.Empty);
}
private void LoadFirma(int id)
{
this.db = new SteinbachEntities();
CurrentFirma = db.firmen.Where(f => f.id == id).SingleOrDefault();
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
ContentCombobox = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
// VMFirmenTelefon = new ObservableCollection<Firmen_TelefonViewModel>();
//Mapper.CreateMap<Personen_Telefon, Firmen_TelefonViewModel>();
MailadressenExpanded = true;
TelefonnummernExpanded = true;
PersonenExpanded = true;
}
public FirmenPersonenListeViewModel(int id_Firma)
{
db = new SteinbachEntities();
if (id_Firma == 0)
{
CurrentFirma = CommonTools.EntitiesActions.FirmaActions.GetNewFirma(db);
}
else
{
CurrentFirma = db.firmen.Where(f => f.id == id_Firma).SingleOrDefault();
}
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen);
}
public static firma GetNewFirma(SteinbachEntities db)
{
firma i = new firma();
i.istFirma = 3;
i.IstKunde = 1;
i.KdNr = (int)db.firmen.Max(id => id.id) + 10001;
i.name = "Neue Firma - KdNr. : " + i.KdNr.ToString();
i.istVerarbeitet = 1;
i.created = DateTime.Now;
i.AngelegtAm = DateTime.Now;
i.AngelegtVon = Session.User.id;
db.AddTofirmen(i);
return(i);
}
private void Form2_Load(object sender, EventArgs e)
{
string path = "C:\\Users\\Kuba\\Desktop";
if (!Directory.Exists(path + "\\firmy"))
{
Directory.CreateDirectory(path + "\\firmy");
}
if (File.Exists(path + "\\firmy\\ListaFirm.xml"))
{
XmlDocument xDoc1 = new XmlDocument();
xDoc1.Load(path + "\\firmy\\ListaFirm.xml");
foreach (XmlNode xNode in xDoc1.SelectNodes("Osoby/Osoba"))
{
firma f = new firma();
f.NazwaFirmy = xNode.SelectSingleNode("NazwaFirmy").InnerText;
f.NazwaOrganuReprezentacji = xNode.SelectSingleNode("NazwaOrganu").InnerText;
f.DataRozpoczeciaDzialalosci = DateTime.FromFileTime(Convert.ToInt64(xNode.SelectSingleNode("DataRozpoczeciaDzialanosci").InnerText));
f.NIP = xNode.SelectSingleNode("Nip").InnerText;
f.Regon = xNode.SelectSingleNode("Regon").InnerText;
f.Strona = xNode.SelectSingleNode("StronaWWW").InnerText;
f.Emailfirmy = xNode.SelectSingleNode("Email").InnerText;
f.AdresSiedziby = xNode.SelectSingleNode("Adres").InnerText;
f.IloscPracownikow = (Convert.ToInt64(xNode.SelectSingleNode("IloscPracownikow").InnerText));
firmy.Add(f);
listView1.Items.Add(f.NazwaFirmy + " " + f.NIP);
}
}
else
{
XmlTextWriter xW = new XmlTextWriter(path + "\\firmy\\ListaFirm.xml", Encoding.UTF8);
xW.WriteStartElement("Firmy");
xW.WriteEndElement();
xW.Close();
}
}
public PersonenDatenViewModel(int id_Firma)
{
db = new SteinbachEntities();
if (id_Firma == 0)
{
CurrentFirma = CommonTools.EntitiesActions.FirmaActions.GetNewFirma(db);
}
else
{
CurrentFirma = db.firmen.Where(f => f.id == id_Firma).SingleOrDefault();
}
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
ContentCombobox = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
MailadressenExpanded = true;
TelefonnummernExpanded = true;
PersonenExpanded = true;
}
public SI_Vorgaenge CreateNewVorgang(firma Firma)
{
if (Firma == null)
{
throw new ArgumentNullException("Firma kann nicht null sein");
}
if (Firma != null)
{
SI_Vorgaenge vorgang = new SI_Vorgaenge();
db.AddToSI_Vorgaenge(vorgang);
vorgang.Datum = DateTime.Now;
vorgang.firma = Firma;
return(vorgang);
}
return(null);
}
private void SelectCompany(firma fa)
{
try
{
// var f = (firma)e.AddedItems[0];
CurrentFirmaData = fa;
// _events.Publish(new SelectKundenDatenEnabled(false));
//_events.Publish(new KundeChangedEvent(f.id, "", f, db));
EventFirmaChanged();
LoadFirma();
if (CurrentFirmaData != null)
{
SelectedAlleFirmen = CurrentFirmaData;
}
}
catch (Exception ex)
{
CommonTools.Tools.ErrorMethods.ShowErrorMessage(ex, true);
}
}
public PersonenDatenViewModel(SteinbachEntities db, firma Firma)
{
this.db = db;
CurrentFirma = Firma;
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
ContentCombobox = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen.OrderBy(o => o.Nachname));
// VMFirmenTelefon = new ObservableCollection<Firmen_TelefonViewModel>();
VM_FT_Colection = new Firmen_TelefonViewModelCollection();
// Mapper.CreateMap<Personen_Telefon, Firmen_TelefonViewModel>();
MailadressenExpanded = true;
TelefonnummernExpanded = true;
PersonenExpanded = true;
timer = new DispatcherTimer();
timer.Tick += new EventHandler(timer_Tick);
timer.Interval = new TimeSpan(0, 0, 0, 0, 500);
}
public FirmenDatenViewModel(SteinbachEntities db, firma Firma)
{
this.db = db;
CurrentFirma = Firma;
ListboxKategorien = new ListboxKategorienViewModel(CurrentFirma, db);
ListboxEigenschaften = new ListboxEigenschaftenViewModel(CurrentFirma, db);
Adressen = new ObservableCollection <Firmen_Adressen>(CurrentFirma.Firmen_Adressen);
Telefonnummern = new ObservableCollection <Firmen_Telefon>(CurrentFirma.Firmen_Telefon);
Mailadressen = new ObservableCollection <Firmen_Mailadressen>(CurrentFirma.Firmen_Mailadressen);
//Employees = new ObservableCollection<StammFirmen_Kategorien>(db.StammFirmen_Kategorien);
Firmen_KategorienOC = new ObservableCollection <Firmen_Kategorien>(db.Firmen_Kategorien.Where(k => k.id_Firma == CurrentFirma.id));
this.db = db;
this.db.SavingChanges += new EventHandler(db_SavingChanges);
timer = new DispatcherTimer();
timer.Tick += new EventHandler(timer_Tick);
timer.Interval = new TimeSpan(0, 0, 0, 0, 500);
timer.Start();
}
public FirmenPersonenListeViewModel(SteinbachEntities db, firma Firma)
{
this.db = db;
CurrentFirma = Firma;
Personenliste = new ObservableCollection <Firmen_Personen>(CurrentFirma.Firmen_Personen);
}
public ActionResult FirmaEkle(firma f)
{
db.firma.Add(f);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void Guncelle()
{
EFDal ed = new EFDal();
int FirmaId = int.Parse(txtFirmaID.Text.Trim());
//if (int.Parse(txtIl_IlceId.Text) < 1 || int.Parse(txtIl_IlceId.Text) > 5000)
if (txtIlce.Text.Trim() == "")
{
lblFirmaAdi.Text = "İl/İlçe bilgisi seçilmemiş. Listeden bir İl/İlçe bilgisi seçiniz";
}
else
{
var entt = new sfKalDataEntities();
firma ofirma = (from c in entt.firma where c.FIRMAID == FirmaId select c).First();
//ofirma.FIRMAID = int.Parse(txtFirmaID.Text.Trim());
ofirma.MUSTNO = int.Parse(txtMustNo.Text.Trim());
ofirma.FIRMAADI = txtFirmaAdi.Text.Trim();
ofirma.ADRESI = txtAdres1.Text.Trim();
ofirma.ADRESII = txtAdres2.Text.Trim();
ofirma.IL_ILCE = txtIlce.Text.Trim();
ofirma.TELEFON = txtTelefon.Text.Trim();
ofirma.FAX = txtFax.Text.Trim();
ofirma.ILGILI = txtIlgili.Text.Trim();
ofirma.EMAIL = txtEmail.Text.Trim();
ofirma.NOTLAR = txtNotlar.Text.Trim();
ofirma.FATADRES = txtFatAdresi.Text.Trim();
ofirma.VERGIDAIRESI = txtVergiDairesi.Text.Trim();
ofirma.VERGINO = txtVergiNo.Text.Trim();
ofirma.BOLGEKODU = short.Parse(txtBolgeKodu.Text.Trim());
//ofirma.KAMUFIRMASI = chkKamufirması.Checked;
if (chklstKamuOzel.SelectedValue == "1")
{
ofirma.KAMUFIRMASI = true;
}
else
{
ofirma.KAMUFIRMASI = false;
}
ofirma.TSEBELGELI = chkTseBelgeli.Checked;
ofirma.IL_ILCEID = int.Parse(txtIl_IlceId.Text);
try
{
entt.SaveChanges();
lblFirmaAdi.ForeColor = System.Drawing.Color.Green;
lblFirmaAdi.Text = "Güncelleme başarılı";
}
catch (Exception exc)
{
lblFirmaAdi.ForeColor = System.Drawing.Color.Red;
lblFirmaAdi.Text = "Güncelleme başarısız:" + exc.Message;
}
}
if (Request["err"] != null)
{
if (Request["err"].ToString() == "Email")
{
//Yetki tablosuna firma yetkisinin işlenmesi gerekiyor burada
if (ed.DahaOnceYetkilendirmeYapilmismi(FirmaId))//evet yapılmış, bu durumda email adresini guncelle
{
ed.YetkiTablosundaEmailGuncelle(FirmaId, txtEmail.Text);
}
else
{
ed.FirmaCredentialsEkle(FirmaId);
}
}
}
}
public Firmen_PersonenViewModel(SteinbachEntities db, firma Firma)
{
SelectedFirma = Firma;
this.db = db;
}
