public bool KarsilamaBelgesiGetir(int belgeId, string dosyaKayitDizini = "")
{
try
{
dosyaKayitDizini = dosyaKayitDizini == "" ? System.Environment.GetEnvironmentVariable("TEMP") : dosyaKayitDizini;
if (!Directory.Exists(dosyaKayitDizini))
{
return(false);
}
tblTalepKarsilamaBelgeleri belge = db.GetGeneric <tblTalepKarsilamaBelgeleri>(c => c.Id == belgeId).FirstOrDefault();
if (belge == null)
{
return(false);
}
DosyaServisi.FileOperationServicesClient client = new DosyaServisi.FileOperationServicesClient();
DosyaServisi.SenfoniFiles file = client.GetFile(belge.DosyaTamAdi);
ExtensionMethods.ByteArrayToFile(dosyaKayitDizini + '\\' + file.FileName, file.FileByteArray);
return(true);
}
catch (Exception e)
{
DBEvents.LogException(e, "KarsilamaBelgesiGetir", 0);
return(false);
}
}
public static void HamBarkoduEkle(string barkod, int ambarUstId)
{
vHamKumaslar kumas = new DBEvents().GetGeneric <vHamKumaslar>(c => c.Barkod == barkod).FirstOrDefault();
if (kumas == null)
{
throw new Exception("Barkod hatalı.!");
}
if (kumas.DepoId != 402)
{
throw new Exception("Bu barkod transfer edilmemiş!");
}
tblAmbarAct ambarX = new DBEvents().GetGeneric <tblAmbarAct>().Where(c => c.AmbarUstId == ambarUstId && c.HamBarkodId == kumas.Id && c.DepoId == 402).FirstOrDefault();
if (ambarX == null)
{
throw new Exception("Bu barkod için transfer işlemi yapılmamış!");
}
tblHamKumaslar tblKumas = kumas.ViewToTbl();
tblKumas.DepoId = 400;
if (new DBEvents().UpdateGeneric <tblHamKumaslar>(tblKumas))
{
tblAmbarAct ambarAct = new tblAmbarAct();
ambarAct.AmbarUstId = ambarUstId;
ambarAct.DepoId = 400;
ambarAct.HamBarkodId = tblKumas.Id;
ambarAct.Tarih = DateTime.Now;
bool snc = new DBEvents().SaveGeneric <tblAmbarAct>(ambarAct);
}
}
public bool TalepleriGuncelle(List <vTalepMalzemeler> listTalepler)
{
try
{
bool sonuc = true;
foreach (vTalepMalzemeler item in listTalepler)
{
tblTalepler talep = db.GetGeneric <tblTalepler>(c => c.Id == item.TalepId).FirstOrDefault();
talep.BirimId = item.BirimId;
talep.Detay = item.Detay;
talep.DurumId = item.DurumId;
talep.MalzemeId = item.MalzemeId;
talep.Miktar = item.Miktar;
talep.TalepEdenId = item.TalepEdenId;
talep.Tarih = item.Tarih;
sonuc = db.UpdateGeneric <tblTalepler>(talep);
}
return(sonuc);
}
catch (Exception e)
{
DBEvents.LogException(e, "TalepleriGuncelle", 0);
return(false);
}
}
public static bool TransferEt(List <vHamKumaslarOrmeStok> secilenler, int ambarUstId)
{
bool snc = true;
List <tblAmbarAct> transferKumaslar = new List <tblAmbarAct>();
foreach (vHamKumaslarOrmeStok item in secilenler)
{
tblHamKumaslar ham = new DBEvents().GetGeneric <tblHamKumaslar>(c => c.Id == item.Id).FirstOrDefault();
ham.DepoId = 402;
bool snc3 = new DBEvents().UpdateGeneric <tblHamKumaslar>(ham);
tblAmbarAct ambarAct = new tblAmbarAct();
ambarAct.AmbarUstId = ambarUstId;
ambarAct.HamBarkodId = ham.Id;
ambarAct.Tarih = DateTime.Now;
ambarAct.DepoId = 402;
transferKumaslar.Add(ambarAct);
}
if (new DBEvents().SaveGeneric <tblAmbarAct>(transferKumaslar) == false)
{
snc = false;
throw new Exception("Transfer edilemedi!");
}
return(snc);
}
public static vHamKumaslar HamKumasGetir(int kumasId, bool lotNoGetirilsin = false)
{
vHamKumaslar kumas = new DBEvents().GetGeneric <vHamKumaslar>(c => c.Id == kumasId).FirstOrDefault();
if (lotNoGetirilsin)
{
tblLeventHareket levent = new DBEvents().GetGeneric <tblLeventHareket>(c => c.Id == kumas.HavLeventId).FirstOrDefault();
if (levent == null)
{
levent = new DBEvents().GetGeneric <tblLeventHareket>(c => c.Id == kumas.ZeminUstLeventId).FirstOrDefault();
}
if (levent == null)
{
levent = new DBEvents().GetGeneric <tblLeventHareket>(c => c.Id == kumas.ZeminAltLeventId).FirstOrDefault();
}
if (levent != null)
{
tblMalzemeCikis cikis = new DBEvents().GetGeneric <tblMalzemeCikis>(c => c.SetId == levent.SetId).FirstOrDefault();
if (cikis != null)
{
kumas.LotNo = cikis.LotNo;
}
}
}
return(kumas);
}
public static bool TicariMamulKaydet(vMamulKumaslar ticari)
{
if (ticari == null)
{
return(false);
}
if (string.IsNullOrEmpty(ticari.Durum) || ticari.Durum == "Ticari")
{
tblMamulKumaslar tbl = ticari.ViewToTable();
if (tbl.Id == 0)
{
tblMamulKumaslar kontrol = new DBEvents().GetGeneric <tblMamulKumaslar>(c => c.Barkod == ticari.Barkod).FirstOrDefault();
if (kontrol != null)
{
throw new Exception("Barkod çakışması var..!");
}
tbl.Durum = "Ticari";
tbl.PartiId = null;
tbl.Tarih = DateTime.Today;
tbl.NetMetre = tbl.Metre;
tbl.KalitePuan = tbl.KaliteAdet;
tbl.SevkId = 0;
tbl.SevkEdilebilir = true;
tbl.Parca = "TAM";
return(new DBEvents().SaveGeneric <tblMamulKumaslar>(tbl));
}
else
{
return(new DBEvents().UpdateGeneric <tblMamulKumaslar>(tbl));
}
}
return(false);
}
public static bool HamKumasDuzelt(tblHamKumaslar kumas)
{
List <tblHamHatalari> hatalar = new List <tblHamHatalari>();
if (kumas.Tur == "Ust")
{
hatalar = new DBEvents().GetGeneric <tblHamHatalari>(c => c.UstId == kumas.Id);
}
else if (kumas.Tur == "Alt")
{
hatalar = new DBEvents().GetGeneric <tblHamHatalari>(c => c.AltId == kumas.Id);
}
else
{
hatalar = new DBEvents().GetGeneric <tblHamHatalari>(c => c.AltId == kumas.Id);
}
double?hataMt = 0;
if (hatalar != null)
{
hataMt = Math.Round(hatalar.Sum(s => s.Uzunluk).Value, 2);
}
kumas.NetMetre = kumas.Metre; //- (hataMt.HasValue ? hataMt.Value : 0); Feramin bey hamda brüt net farkı istemiyor. 24.06.2015 mail attı.
return(new DBEvents().UpdateGeneric <tblHamKumaslar>(kumas));
}
public static List <vSiparisler> MusteriSiparisleriGetir(int musteriId)
{
List <vSiparisler> list = new DBEvents().GetGeneric <vSiparisler>(c => c.FirmaId == musteriId && c.Durum == "Açık");
//return list.GroupBy(c => c.SozlesmeNo).Select(s => s.First()).ToList();
return(list.OrderBy(o => o.SozlesmeNo).ToList());
}
public static DataTable GetEventsByPage(int siteId, int pageId)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("ItemID", typeof(int));
dataTable.Columns.Add("ModuleID", typeof(int));
dataTable.Columns.Add("ModuleTitle", typeof(string));
dataTable.Columns.Add("Title", typeof(string));
dataTable.Columns.Add("Description", typeof(string));
dataTable.Columns.Add("ViewRoles", typeof(string));
using (IDataReader reader = DBEvents.GetEventsByPage(siteId, pageId))
{
while (reader.Read())
{
DataRow row = dataTable.NewRow();
row["ItemID"] = reader["ItemID"];
row["ModuleID"] = reader["ModuleID"];
row["ModuleTitle"] = reader["ModuleTitle"];
row["Title"] = reader["Title"];
row["Description"] = reader["Description"];
row["ViewRoles"] = reader["ViewRoles"];
dataTable.Rows.Add(row);
}
}
return(dataTable);
}
//Gökhan 29.05.2014
public static double TLKarsiliginiGetir(double tutarDoviz, int dovizId)
{
int dovizTuru = 0;
double deger = 0;
if (dovizId == 128)
{
dovizTuru = 17; //£
}
else if (dovizId == 33)
{
dovizTuru = 1; //$
}
else if (dovizId == 34)
{
dovizTuru = 20; //€
}
else
{
dovizTuru = 0; //TL
}
DBEvents db = new DBEvents();
double kur = db.GetGenericWithSQLQuery <vDovizKarsiliginiHesapla>("select dbo.GetirDovizKuru({0}) AS tutarDoviz", new object[] { dovizTuru }).FirstOrDefault().tutarDoviz;
if (kur != 0 && kur != null)
{
deger = tutarDoviz * kur;
}
return(deger);
}
private bool Update()
{
this.lastModUtc = DateTime.UtcNow;
bool result = DBEvents.UpdateCalendarEvent(
this.itemID,
this.moduleID,
this.title,
this.description,
this.imageName,
this.eventDate,
this.startTime,
this.endTime,
this.location,
this.requiresTicket,
this.ticketPrice,
this.lastModUtc,
this.lastModUserGuid);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
OnContentChanged(e);
}
return(result);
}
public static bool TezgahAtkiGirisiEkle(vTezgahAtkiGiris atkiGiris)
{
tblTezgahAtkiGiris tbl = atkiGiris.ViewToTbl();
bool snc = new DBEvents().SaveGeneric <tblTezgahAtkiGiris>(ref tbl);
return(snc);
}
public static List <vBoyahaneProcessTotal> SiparisinBoyahaneProcessleriniGetir(int siparisId)
{
DBEvents db = new DBEvents();
List <tblMaliyetBoyahaneDetay> boyahaneListe = db.GetGeneric <tblMaliyetBoyahaneDetay>(c => c.SiparisId == siparisId).ToList();
List <vBoyahaneProcessTotal> processListe = new List <vBoyahaneProcessTotal>();
var detay = boyahaneListe.Select(c => new
{
Process = c.Process,
CalismaDk = c.ProcessCalismaDk,
SatirToplami = c.SatirToplami,
Sira = c.Sira
}).ToList();
var groupSnc = detay.GroupBy(g => new { g.Process, g.Sira }).Select(c => new
{
Process = c.Key.Process,
CalismaDk = c.Sum(x => x.CalismaDk),
SatirToplami = c.Sum(x => x.SatirToplami),
Sira = c.Key.Sira
}).ToList();
foreach (var item in groupSnc)
{
vBoyahaneProcessTotal total = new vBoyahaneProcessTotal();
total.CalismaDk = (double)item.CalismaDk;
total.Process = item.Process;
total.SatirToplami = (double)item.SatirToplami;
total.Sira = (int)item.Sira;
processListe.Add(total);
}
return(processListe.OrderBy(o => o.Sira).ToList());
}
public bool TalepDurumlariGuncelle(List <vTalepKarsilamaAct> listvTalepler, int yeniDurumId)
{
bool sonuc = true;
try
{
foreach (vTalepKarsilamaAct item in listvTalepler)
{
tblTalepler talep = db.GetGeneric <tblTalepler>(c => c.Id == item.TalepId).FirstOrDefault();
talep.DurumId = yeniDurumId;
if (!db.UpdateGeneric <tblTalepler>(talep))
{
sonuc = false;
}
}
}
catch (Exception e)
{
DBEvents.LogException(e, "TalepDurumlariGuncelle", 0);
sonuc = false;
}
return(sonuc);
}
public static bool KafesKartlariniKaydet(tblAyarlar item)
{
item.BaglantiId = 247;
DBEvents db = new DBEvents();
return(db.SaveGeneric <tblAyarlar>(item));
}
public static List <vSiparisler> MusterileriGetir()
{
List <vSiparisler> list = new DBEvents().GetGeneric <vSiparisler>(c => c.Durum == "Açık" && c.BaglantiId != 3);//&& c.BaglantiId != 4);
if (list == null)
{
return(null);
}
return(list.GroupBy(c => c.FirmaId).Select(s => s.First()).OrderBy(o => o.FirmaAdi).ToList());
}
public static void AmbarUstFisiOlustur()
{
tblAmbar ambarFisi = new tblAmbar();
ambarFisi.FirmaId = 1432;
ambarFisi.LogoAktarildiMi = false;
ambarFisi.Tarih = DateTime.Now;
bool snc = new DBEvents().SaveGeneric <tblAmbar>(ambarFisi);
}
public static bool KafesKartniSil(tblAyarlar item)
{
if (item.BaglantiId != 247)
{
item.BaglantiId = 247;
}
DBEvents db = new DBEvents();
return(db.DeleteGeneric <tblAyarlar>(item));
}
public static bool UstBelgeSilinebilirMi(int ambarUstId)
{
bool snc = true;
tblAmbarAct altKayitlar = new DBEvents().GetGeneric <tblAmbarAct>().Where(c => c.AmbarUstId == ambarUstId).FirstOrDefault();
if (altKayitlar == null)
{
snc = false; // silinebilir. Hiç kayıt yok.
}
return(snc);
}
public static bool TicariMamulSil(vMamulKumaslar ticari)
{
if (ticari == null || ticari.Durum != "Ticari")
{
return(false);
}
tblMamulKumaslar tbl = new DBEvents().GetGeneric <tblMamulKumaslar>(c => c.Id == ticari.Id).FirstOrDefault();
return(new DBEvents().DeleteGeneric <tblMamulKumaslar>(tbl));
}
public static bool KafesKartlariniKaydet(List <tblAyarlar> list)
{
foreach (var item in list)
{
item.BaglantiId = 247;
}
DBEvents db = new DBEvents();
return(db.SaveGeneric <tblAyarlar>(list));
}
//Gökhan 04.06.2014
public static string SiparisinToplamTutarDovizGetir(double tutar)
{
DBEvents db = new DBEvents();
string s = "";
s = " $: " + db.GetGenericWithSQLQuery <vDovizKarsiliginiHesapla>("EXEC spDovizKarsiliginiHesapla '" + Math.Round(tutar, 0) + "' , '" + 1 + "'", new string[0]).FirstOrDefault().tutarDoviz;
s = s + " €: " + db.GetGenericWithSQLQuery <vDovizKarsiliginiHesapla>("EXEC spDovizKarsiliginiHesapla '" + Math.Round(tutar, 0) + "' , '" + 20 + "'", new string[0]).FirstOrDefault().tutarDoviz;
s = s + " £: " + db.GetGenericWithSQLQuery <vDovizKarsiliginiHesapla>("EXEC spDovizKarsiliginiHesapla '" + Math.Round(tutar, 0) + "' , '" + 17 + "'", new string[0]).FirstOrDefault().tutarDoviz;
s = "TL: " + tutar + s;
return(s);
}
public bool MinStoklariGuncelle(List <tblMalzemeler> list)
{
try
{
return(db.UpdateGeneric <tblMalzemeler>(list));
}
catch (Exception e)
{
DBEvents.LogException(e, "MinStoklariGuncelle", 0);
return(false);
}
}
//Gökhan 07.07.2014
public static double MaliyetBoyahaneToplamGetir(int siparisId)
{
DBEvents db1 = new DBEvents();
List <tblMaliyetBoyahaneDetay> liste1 = db1.GetGeneric <tblMaliyetBoyahaneDetay>(c => c.SiparisId == siparisId).ToList();
double sonuc = 0;
foreach (var item in liste1)
{
sonuc = sonuc + (item.SatirToplami == null ? 0 : Convert.ToDouble(item.SatirToplami.ToString()));
}
return(sonuc);
}
public static bool FasonaSevkEdilmisMi(int partiId)
{
tblMamulKumaslar mamul = new DBEvents().GetGeneric <tblMamulKumaslar>(c => c.PartiId == partiId && c.SevkId > 0).FirstOrDefault();
if (mamul == null)
{
return(false);
}
else
{
return(true);
}
}
public static int TezgahaBagliTipGetir(int tezgahId)
{
tblLeventHareket levent = new DBEvents().GetGeneric <tblLeventHareket>(c => c.Durum == 21 && c.TezgahId == tezgahId).FirstOrDefault();
if (levent == null)
{
return(0);
}
else
{
return(levent.TipId);
}
}
public static List <vSiparisAct> SiparisTipleriGetir(int siparisId)
{
List <vSiparisAct> sipTipleri = new DBEvents().GetGeneric <vSiparisAct>(c => c.SiparisId == siparisId);
foreach (vSiparisAct item in sipTipleri)
{
tblProsesGrup finish = new DBEvents().GetGeneric <tblProsesGrup>(c => c.Id == item.FinishGrupId).FirstOrDefault();
item.FinishAdi = finish == null ? "" : finish.Adi;
List <tblPartiler> partilenenler = new DBEvents().GetGeneric <tblPartiler>(c => c.SiparisActId == item.Id);
item.PartilenenMetre = partilenenler == null ? 0 : partilenenler.Sum(s => s.PartiMetre);
}
return(sipTipleri);
}
public bool Delete()
{
//IndexHelper.RemoveIndexItem(moduleID, itemID);
bool result = DBEvents.DeleteCalendarEvent(itemID);
if (result)
{
ContentChangedEventArgs e = new ContentChangedEventArgs();
e.IsDeleted = true;
OnContentChanged(e);
}
return(result);
}
public static List <vMamulKumaslar> RezerveleriGetir()
{
List <vMamulKumaslar> list = new DBEvents().GetGeneric <vMamulKumaslar>(c => c.RezerveSiparisActId != null && (c.SevkId == null || c.SevkId == 0));
foreach (vMamulKumaslar item in list)
{
vSiparisAct sip = new DBEvents().GetGeneric <vSiparisAct>(c => c.Id == item.RezerveSiparisActId).FirstOrDefault();
if (sip != null)
{
item.RezerveMusterisi = sip.FirmaAdi;
}
}
return(list);
}
public static vMamulKumaslar MamulBarkodSorgula(string barkod)
{
DBEvents db = new DBEvents();
vMamulKumaslar mamul = db.GetGeneric <vMamulKumaslar>(c => c.Barkod == barkod).FirstOrDefault();
if (mamul != null && mamul.SevkSiparisActId.HasValue == true)
{
vSiparisAct sevkEmri = db.GetGeneric <vSiparisAct>(c => c.Id == mamul.SevkSiparisActId.Value).FirstOrDefault();
if (sevkEmri != null)
{
mamul.SevkEmri = sevkEmri.SozlesmeNo + " - " + sevkEmri.FirmaAdi;
}
}
return(mamul);
}
