Пример #1
0
        //Güncelleme İşlemi
        //[System.Web.Http.HttpPost]
        public HttpResponseMessage Tamamlandi(int?id, int?durumId, int?aktiviteTipiId, string aciklama, string ss)
        {
            Aktivite item = ce.Aktivite.First(f => f.Id == id);

            AktiviteDurumu ad = ce.AktiviteDurumu.Where(x => x.AktiviteTipiId == aktiviteTipiId && x.Aciklama == "Tamamlandı").SingleOrDefault <AktiviteDurumu>();

            //item.FirstName = student.FirstName;
            //item.LastName = student.LastName;
            //item.Age = student.Age;
            //item.Gender = student.Gender;
            //item.Aciklama = item.Aciklama + " " + aciklama;
            if (ad != null)
            {
                item.AktiviteDurumuId = ad.Id;
            }
            item.OperasyondaMi = true;

            ActiviteAciklamalari ac = new ActiviteAciklamalari();

            ac.Aciklama   = aciklama;
            ac.AktiviteId = id;
            ac.CreateUser = item.PersonelId;
            ac.PersonelId = item.PersonelId;
            ac.CreateDate = DateTime.Now;
            ac.Tarih      = DateTime.Now;
            ce.ActiviteAciklamalari.Add(ac);
            ce.SaveChanges();

            return(Request.CreateErrorResponse(HttpStatusCode.OK, " durumId:" + durumId + " id:" + id));
        }
Пример #2
0
        //Silme İşlemi
        public void Delete(int id)
        {
            Aktivite item = ce.Aktivite.First(f => f.Id == id);

            ce.Aktivite.Remove(item);
            ce.SaveChanges();
        }
Пример #3
0
        //Güncelleme İşlemi
        // [System.Web.Http.HttpPost]
        public HttpResponseMessage Tamamlandi(int?id, int?durumId, int?aktiviteTipiId, string aciklama, string ss)
        {
            Aktivite item = ce.Aktivite.First(f => f.Id == id);

            AktiviteDurumu ad = ce.AktiviteDurumu.Where(x => x.AktiviteTipiId == aktiviteTipiId && x.Aciklama == "Tamamlandı").SingleOrDefault <AktiviteDurumu>();

            //item.FirstName = student.FirstName;
            //item.LastName = student.LastName;
            //item.Age = student.Age;
            //item.Gender = student.Gender;
            item.Aciklama = item.Aciklama + " " + aciklama;
            if (ad != null)
            {
                item.AktiviteDurumuId = ad.Id;
            }
            item.OperasyondaMi = true;
            ce.SaveChanges();
            return(null);
        }
Пример #4
0
        //Güncelleme İşlemi
        //[System.Web.Http.HttpPost]
        public HttpResponseMessage iptal(int?id, int?durumId, int?aktiviteTipiId, string aciklama, string iptal)
        {
            Aktivite item = ce.Aktivite.First(f => f.Id == id);

            AktiviteDurumu ad = ce.AktiviteDurumu.Where(x => x.AktiviteTipiId == aktiviteTipiId && x.Aciklama == "Beklemede").SingleOrDefault <AktiviteDurumu>();

            //item.FirstName = student.FirstName;
            //item.LastName = student.LastName;
            //item.Age = student.Age;
            //item.Gender = student.Gender;
            item.PersonelId = 23;
            item.Aciklama   = item.Aciklama + " " + aciklama;
            if (ad != null)
            {
                item.AktiviteDurumuId = ad.Id;
            }
            ce.SaveChanges();
            return(Request.CreateErrorResponse(HttpStatusCode.OK, " durumId:" + durumId + " id:" + id));
        }
Пример #5
0
 // ekleme
 public void Post(Aktivite aktivite)
 {
     ce.Aktivite.Add(aktivite);
     ce.SaveChanges();
 }
Пример #6
0
 // ekleme
 public void Post(Aktivite aktivite)
 {
 }
        public Ticket TicketMethod(int UserId, int ParrentId)
        {
            var Layer = EmptorDB.Database.SqlQuery <TicketItemList>(@"
            SELECT DISTINCT
            CT.ID AS EMPTOR_ID,
            CT.IDDESC AS 'EMPTOR_IDDESC',
            C.FULLNAME AS ILGILI_FIRMA_ADI,
            TY.DESCRIPTION_TR AS SERVIS_TIPI,
            CT.NAME AS SERVIS_TANIMI,
            CT.NOTES AS OZET_BILGI,
            CT.SOLUTIONEXPLANATION AS 'COZUM_ACIKLAMASI',
            TS.DESCRIPTION_TR AS KAYIT_DURUMU,
            USR.FULLNAME AS ANA_SORUMLU,
            TSB.DESCRIPTION_TR AS SAHA_ALT_STATUSU,
            OND.DESCRIPTION_TR AS ONE_SEVIYE_SAHA_ALT_STATUSU,
            TA.DESCRIPTION_TR AS SERVIS_ALANI,
            TAA.DESCRIPTION_TR AS SERVIS_ALT_ALANI,
            CTCC.NAME AS KOSUL,
            CT.C_MAXINTERVENTIONDATE AS SLA_MUDEHALE_TARIHI,
            CT.C_MAXSOLUTIONDATE AS SLA_COZUM_TARIHI,
            CASE  WHEN CT.C_MAXINTERVENTIONDATE > CT.C_INTERVENTIONDATE   THEN CONVERT(bit,1) ELSE CONVERT(bit,0) END AS SLA_MUDEHALE,
            CASE  WHEN CT.C_MAXSOLUTIONDATE > CT.C_SOLUTIONDATE   THEN CONVERT(bit,1) ELSE CONVERT(bit,0) END AS SLA_COZUM,
            CASE  WHEN (SELECT CONVERT(int,COUNT(*)) FROM CRMTBL_ACTIVITY AS TA WHERE 1 = 1 AND TA.TICKETID = CT.ID) > 0   THEN CONVERT(bit,1) ELSE CONVERT(bit,0) END AS AKTITE_VARMI,
            CASE  WHEN (SELECT CONVERT(int,COUNT(*)) FROM PROTBL_INVENTORYTRANSACTIONDETAIL AS EN WITH(NOLOCK) WHERE 1 = 1 AND EN.TICKETID=CT.ID) > 0   THEN CONVERT(bit,1) ELSE CONVERT(bit,0) END AS ENVANTER_HARKETI_VARMI,
            (SELECT CONVERT(int,COUNT(*)) FROM CRMTBL_ACTIVITY AS TA WHERE 1 = 1 AND TA.TICKETID = CT.ID) AS AKTIVITE_SAYISI,
            (SELECT CONVERT(int,COUNT(*)) FROM PROTBL_INVENTORYTRANSACTIONDETAIL AS EN WITH(NOLOCK) WHERE 1 = 1 AND EN.TICKETID=CT.ID) AS ENVANTER_SAYISI
            FROM CRMTBL_TICKET AS CT 
            INNER JOIN CRMTBL_CUSTOMER AS C WITH(NOLOCK) ON C.ID = CT.C_CONCERNEDACCOUNTID
            INNER JOIN CRMTBL_TICKETTYPE AS TY WITH(NOLOCK) ON TY.ID = CT.TICKETTYPEID
            INNER JOIN CRMTBL_TICKETSTATUS AS TS WITH(NOLOCK) ON TS.ID = CT.TICKETSTATUSID
            INNER JOIN BIZTBL_USER AS USR WITH(NOLOCK) ON USR.ID = CT.RESPONSIBLEUSERID
            INNER JOIN PROTBL_TICKETSTATUSSUB AS TSB WITH(NOLOCK) ON TSB.ID = CT.C_TICKETSTATUSSUBID
            LEFT OUTER JOIN PROTBL_TICKETSTATUSSUB_LEVELONE AS OND WITH(NOLOCK) ON OND.ID = CT.C_TICKETSTATUSSUBID_LEVELONE
            LEFT OUTER JOIN PROTBL_TICKETAREA AS TA WITH(NOLOCK) ON TA.ID = CT.C_TICKETAREAID
            LEFT OUTER JOIN PROTBL_TICKETAREASUB AS TAA WITH(NOLOCK) ON TAA.ID = CT.C_TICKETSUBAREAID
            INNER JOIN CRMTBL_CONTRACTCONDITION AS CTCC WITH(NOLOCK) ON CTCC.ID = CT.CONTRACTCONDITIONID
            LEFT OUTER JOIN CRMTBL_ACTIVITY AS CTA WITH(NOLOCK) ON CTA.TICKETID = CT.ID
            LEFT OUTER JOIN PROTBL_TICKETATTACHMENT AS TAT WITH(NOLOCK) ON TAT.TICKETID = CT.ID
            LEFT OUTER JOIN PROTBL_INVENTORYTRANSACTIONDETAIL AS INV WITH(NOLOCK) ON INV.TICKETID = CT.ID
            WHERE 1 = 1
            AND CT.ACTIVE = 1
            AND CT.RESPONSIBLEUSERID=" + UserId + @"
            AND CT.TICKETSTATUSID=1
            AND CT.C_TICKETSTATUSSUBID IN (4,6,93)
            AND (CT.C_TICKETAREAID IS NOT NULL AND CT.C_TICKETSUBAREAID IS NOT NULL)
            AND (CTCC.ID IS NOT NULL)
            AND (CTA.ID IS NOT NULL)
            AND (CT.SOLUTIONEXPLANATION IS NOT NULL)
            --AND (TAT.ID IS NOT NULL)
            AND (CTCC.NAME IS NOT NULL)
            AND (INV.TICKETID IS NULL)
            AND (C.DEFPARENTCUSTOMERID = " + ParrentId + @")
            ORDER BY CT.ID DESC
            ").ToArray();
            List <TicketItemList> ticketItemLists = new List <TicketItemList>();

            foreach (var item in Layer)
            {
                var EmptorAktivite = EmptorDB.Database.SqlQuery <Aktivite>(@"
                SELECT DISTINCT
                U.FULLNAME,
                U.EMAIL,
                --P.DESCRIPTION_TR,
                CTA.STARTDATE,
                CTA.ENDDATE,
                CTA.RESPONSIBLEUSERID,
                AKTYPE.ID AS AKTIVITE_TYPE_ID,
				AKTYPE.DESCRIPTION_TR AS AKTIVITE_TYPE,
                CTA.DESCRIPTION,
                CTA.CREATE_USER_ID,
                CTA.CREATE_USER_TIME,
                CONVERT(bit,CTA.IsTerminal) AS TERMINAL
                FROM CRMTBL_ACTIVITY AS CTA
                INNER JOIN BIZTBL_USER AS U WITH(NOLOCK) ON U.ID = CTA.CREATE_USER_ID
                INNER JOIN CRMTBL_ACTIVITYTYPE AS AKTYPE WITH(NOLOCK) ON AKTYPE.ID = CTA.ACTIVITYTYPEID
                WHERE 1 = 1
                AND CTA.ACTIVE=1 AND CTA.TICKETID=" + item.EMPTOR_ID + "").ToArray();


                List <Aktivite> aktivites = new List <Aktivite>();

                foreach (var EItem in EmptorAktivite)
                {
                    DateTime AktiviteGirisTarihi     = EItem.CREATE_USER_TIME;
                    DateTime AktiviteBaslangicTarihi = EItem.STARTDATE;
                    DateTime AktiviteBitisTarihi     = EItem.ENDDATE;



                    Aktivite aktivite = new Aktivite()
                    {
                        FULLNAME          = EItem.FULLNAME,
                        EMAIL             = EItem.EMAIL,
                        DESCRIPTION       = EItem.DESCRIPTION,
                        STARTDATE         = EItem.STARTDATE,
                        ENDDATE           = EItem.ENDDATE,
                        RESPONSIBLEUSERID = EItem.RESPONSIBLEUSERID,
                        AKTIVITE_TYPE_ID  = EItem.AKTIVITE_TYPE_ID,
                        AKTIVITE_TYPE     = EItem.AKTIVITE_TYPE,
                        CREATE_USER_ID    = EItem.CREATE_USER_ID,
                        CREATE_USER_TIME  = EItem.CREATE_USER_TIME,
                        TERMINAL          = EItem.TERMINAL
                    };

                    aktivites.Add(aktivite);
                }



                TicketItemList ticketItemList = new TicketItemList()
                {
                    EMPTOR_ID                   = item.EMPTOR_ID,
                    EMPTOR_IDDESC               = item.EMPTOR_IDDESC,
                    ILGILI_FIRMA_ADI            = item.ILGILI_FIRMA_ADI,
                    SERVIS_TIPI                 = item.SERVIS_TIPI,
                    SERVIS_TANIMI               = item.SERVIS_TANIMI,
                    OZET_BILGI                  = item.OZET_BILGI,
                    COZUM_ACIKLAMASI            = item.COZUM_ACIKLAMASI,
                    KAYIT_DURUMU                = item.KAYIT_DURUMU,
                    ANA_SORUMLU                 = item.ANA_SORUMLU,
                    SAHA_ALT_STATUSU            = item.SAHA_ALT_STATUSU,
                    ONE_SEVIYE_SAHA_ALT_STATUSU = item.ONE_SEVIYE_SAHA_ALT_STATUSU,
                    SERVIS_ALANI                = item.SERVIS_ALANI,
                    SERVIS_ALT_ALANI            = item.SERVIS_ALT_ALANI,
                    KOSUL = item.KOSUL,
                    SLA_MUDEHALE_TARIHI    = item.SLA_MUDEHALE_TARIHI,
                    SLA_COZUM_TARIHI       = item.SLA_COZUM_TARIHI,
                    SLA_MUDEHALE           = item.SLA_MUDEHALE,
                    SLA_COZUM              = item.SLA_COZUM,
                    AKTITE_VARMI           = item.AKTITE_VARMI,
                    ENVANTER_HARKETI_VARMI = item.ENVANTER_HARKETI_VARMI,
                    AKTIVITE_SAYISI        = item.AKTIVITE_SAYISI,
                    ENVANTER_SAYISI        = item.ENVANTER_SAYISI,
                    Activites              = aktivites
                };
                ticketItemLists.Add(ticketItemList);
            }

            Ticket Baris = new Ticket()
            {
                IsCode  = true,
                Message = "Kayıtlar başarıyla listelenmiştir.",
                Items   = ticketItemLists
            };

            return(Baris);
        }