Exemplo n.º 1
0
        protected void btn_sil_Click(object sender, EventArgs e)
        {
            try
            {
                MODUL_MAILAYAR mailOnay = new MODUL_MAILAYAR();
                mailOnay = db.MODUL_MAILAYAR.FirstOrDefault(i => i.ID_MODUL == 1);
                MailSend     ms             = new MailSend();
                BILDIRIMLVL1 deleteBILDIRIM = new BILDIRIMLVL1();
                LinkButton   linkbutton     = (LinkButton)sender;                      // get the link button which trigger the event
                GridViewRow  row            = (GridViewRow)linkbutton.NamingContainer; // get the GridViewRow that contains the linkbutton
                                                                                       // get the first cell value of the row
                                                                                       // if you want to get controls in templatefield , just use row.FindControl
                int deleteID = Convert.ToInt32(linkbutton.CommandArgument);

                deleteBILDIRIM                = db.BILDIRIMLVL1.FirstOrDefault(i => i.ID_BILDIRIM == deleteID);
                deleteBILDIRIM.DURUM          = "Pasif";
                deleteBILDIRIM.BILDIRIM_DURUM = "Silinmiş";

                PERSONEL per    = new PERSONEL();
                string   fullad = deleteBILDIRIM.MUDAHIL_PERSONEL;
                string[] parce  = fullad.Split(' ');
                string   ad     = parce[0];

                per = db.PERSONEL.FirstOrDefault(i => i.PERSONEL_AD.ToUpper() == ad.ToUpper());
                string MudahilMail = per.EMAIL;



                if (db.SaveChanges() > 0)
                {
                    string c = "<table width="100%" border="0" cellspacing="0"> <tbody> <tr> <td align="center" valign="top" style="background-color: #f0f0f0; padding: 20px"> <table width="100%" border="0" cellspacing="0" style="box-sizing: border-box;"> <tbody> <tr> <td style="background-color: #4791d2; border-bottom: 2px solid #367fbe; height: 6px;"></td> </tr> <tr> <td style="background-color: #fff; text-align: left; padding: 20px;"> <p style="font-family: Tahoma; font-size: 12px"> Sayın " + deleteBILDIRIM.MUDAHIL_PERSONEL + " ",<br /> Seviye 1 İSG Bildiriminde Müdahil Personel Olarak Atandığınız Bildirim Silinmiştir. <br/> <br/>Silinen bildirimin detaylarını aşağıdaki tablodan inceleyebilirsiniz. </p> <table style="width: 100%; border-width: 1px; border-style: solid; border-collapse: collapse; font-size: 10pt; font-family: Tahoma;" bordercolor="black"> <tbody> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Tarih ve Saat</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.TARIHSAAT + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Lokasyon</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.LOKASYON + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Birim</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.BIRIM + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Kategori</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.KATEGORI + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Vardiya</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlVardiya.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Bildiren Personel</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.PERSONEL_AD + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Bildirim Metni</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + deleteBILDIRIM.ACIKLAMA + "</td> </tr> </tbody> </table> </td> </tr> <tr> <td style="background-color: #4791d2; border-top: 2px solid #367fbe; height: 6px;"></td> </tr> </tbody> </table> </td> </tr> </tbody> </table>";

                    if (ms.MailGonder(mailOnay.SILME_KAYIT, MudahilMail, "Bildirim Silimi", HttpUtility.HtmlDecode(c).ToString()))
                    {
                        ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Bildirim silindi! Bilgilendirme Maili Gönderildi','succsess');", true);
                    }



                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Bildirim silindi','succsess');", true);


                    bind();
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "Myfunction('iş Tanımı silme işlemi sırasında Hata oluştu','fail');", true);
                    grdBILDIRIM.DataBind();
                }
            }
            catch (Exception)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Hay Aksi!  Beklenmedik bir hata oluştu :(','fail');", true);
            }
        }
Exemplo n.º 2
0
        protected void btnUygunsuzlukSave_Click(object sender, EventArgs e)
        {
            try
            {
                UYGUNSUZLUK yeniUyg = new UYGUNSUZLUK();
                yeniUyg.TUR            = ddlTur.Text;
                yeniUyg.BIRIM          = ddlBirim.SelectedValue;
                yeniUyg.TESPIT_TARIH   = Convert.ToDateTime(dtpTespitTarih.Text);
                yeniUyg.UYGUNSUZ_DURUM = txtUygnsuzDurum.Text;
                yeniUyg.ONERI_AKSIYON  = txtAksiyon.Text;
                yeniUyg.TESPIT_EDEN_AD = ddlTespitEden.SelectedValue;
                yeniUyg.SORUMLU_AD     = ddlSorumlu.SelectedValue;
                yeniUyg.AKTIFLIK       = "Aktif";
                yeniUyg.TERMIN_TARIH   = Convert.ToDateTime(dateTerminTarihi.Text);
                db.UYGUNSUZLUK.Add(yeniUyg);
                if (db.SaveChanges() > 0)
                {
                    MODUL_MAILAYAR mailOnay = new MODUL_MAILAYAR();
                    mailOnay = db.MODUL_MAILAYAR.FirstOrDefault(i => i.ID_MODUL == 2);
                    MailSend ms     = new MailSend();
                    PERSONEL per    = new PERSONEL();
                    string   fullad = ddlSorumlu.Text;
                    string[] parce  = fullad.Split(' ');
                    string   ad     = parce[0];

                    per = db.PERSONEL.FirstOrDefault(i => i.PERSONEL_AD.ToUpper() == ad.ToUpper());
                    string MudahilMail = per.EMAIL;

                    string mail = "<table width="100%" border="0" cellspacing="0"> <tbody> <tr> <td align="center" valign="top" style="background-color: #f0f0f0; padding: 20px"> <table width="100%" border="0" cellspacing="0" style="box-sizing: border-box;"> <tbody> <tr> <td style="background-color: #4791d2; border-bottom: 2px solid #367fbe; height: 6px;"></td> </tr> <tr> <td style="background-color: #fff; text-align: left; padding: 20px;"> <p style="font-family: Tahoma; font-size: 12px"> Sayın " + ddlSorumlu.SelectedValue + ",<br /> <br /> Adınıza uygunsuzluk kaydı oluşturulmuştur. Aşağıdaki tablodan detayları inceleyebilirsiniz. </p> <table style="width: 100%; border-width: 1px; border-style: solid; border-collapse: collapse; font-size: 10pt; font-family: Tahoma;" bordercolor="black"> <tbody> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Tespit Tarihi</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;"> " + dtpTespitTarih.Text + " </td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Termin Tarihi</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + dateTerminTarihi.Text + " </td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Birim</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;"> " + ddlBirim.SelectedValue + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Uygunsuz Durum</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;"> " + txtUygnsuzDurum.Text + " </td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Önerilen Aksiyon </td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;"> " + txtAksiyon.Text + " </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Tür</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlTur.SelectedValue + " </td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Tespit Eden</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlTespitEden.SelectedValue + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Sorumlu</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlSorumlu.Text + "</td> </tr> </tbody> </table> </td> </tr> <tr> <td style="background-color: #4791d2; border-top: 2px solid #367fbe; height: 6px;"></td> </tr> </tbody> </table> </td> </tr> </tbody> </table>";


                    ms.MailGonder(mailOnay.YENI_KAYIT, MudahilMail, "Uygunsuzluk Bildirim Maili", HttpUtility.HtmlDecode(mail).ToString());
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Uygunsuzluk Eklendi','succsess');", true);

                    bind();
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Uygunsuzluk Kaydı Oluşturulamadı','fail');", true);
                }
            }
            catch (Exception)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Hay Aksi!  Beklenmedik bir hata oluştu :(','fail');", true);
            }
        }
Exemplo n.º 3
0
        protected void btnEKLE_Click(object sender, EventArgs e)
        {
            try
            {
                BILDIRIMLVL1 yeniBildirim = new BILDIRIMLVL1();

                string tarih = txtTarih.Text;
                string saat  = txtSaat.Text;
                string Date  = tarih + " " + saat;
                yeniBildirim.TARIHSAAT        = Date;
                yeniBildirim.VARDIYA          = ddlVardiya.Text;
                yeniBildirim.PERSONEL_AD      = ddlBildirimYapan.Text;
                yeniBildirim.BIRIM            = ddlBirim.Text;
                yeniBildirim.KATEGORI         = ddlKategori.Text;
                yeniBildirim.LOKASYON         = ddlLokasyon.Text;
                yeniBildirim.ONLEMBOOL        = ddlOnlemBool.Text;
                yeniBildirim.ACIKLAMA         = txtBildirimMetin.Text;
                yeniBildirim.AKSIYON          = txtAksiyon.Text;
                yeniBildirim.GORSEL           = imgBildirim.FileName.ToString();
                yeniBildirim.MUDAHIL_PERSONEL = ddlMudahilPerson.Text;
                yeniBildirim.DURUM            = "Aktif";
                yeniBildirim.BILDIRIM_DURUM   = "Onay Bekliyor";

                uygunsuzlukEkle(kontrol);


                imgBildirim.PostedFile.SaveAs(Server.MapPath("~/upload/") + imgBildirim.FileName.ToString());

                db.BILDIRIMLVL1.Add(yeniBildirim);
                if (db.SaveChanges() > 0)
                {
                    MODUL_MAILAYAR mailOnay = new MODUL_MAILAYAR();
                    mailOnay = db.MODUL_MAILAYAR.FirstOrDefault(i => i.ID_MODUL == 1);
                    MailSend ms     = new MailSend();
                    PERSONEL per    = new PERSONEL();
                    string   fullad = ddlMudahilPerson.Text;
                    string[] parce  = fullad.Split(' ');
                    string   ad     = parce[0];

                    per = db.PERSONEL.FirstOrDefault(i => i.PERSONEL_AD == ad);
                    string MudahilMail = per.EMAIL;


                    string c = "<table width="100%" border="0" cellspacing="0"> <tbody> <tr> <td align="center" valign="top" style="background-color: #f0f0f0; padding: 20px"> <table width="100%" border="0" cellspacing="0" style="box-sizing: border-box;"> <tbody> <tr> <td style="background-color: #4791d2; border-bottom: 2px solid #367fbe; height: 6px;"></td> </tr> <tr> <td style="background-color: #fff; text-align: left; padding: 20px;"> <p style="font-family: Tahoma; font-size: 12px"> Sayın " + ddlMudahilPerson.Text + ",<br /> Seviye 1 İSG Bildiriminde Müdahil Personel Olarak Atandınız. </p> <table style="width: 100%; border-width: 1px; border-style: solid; border-collapse: collapse; font-size: 10pt; font-family: Tahoma;" bordercolor="black"> <tbody> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Tarih ve Saat</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + Date + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Lokasyon</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlLokasyon.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Birim</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlBirim.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #F7FBFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Kategori</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlKategori.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Vardiya</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlVardiya.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Bildiren Personel</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + ddlBildirimYapan.Text + "</td> </tr> <tr style="width: 100%; border: 1px solid black; border-collapse: collapse; background-color: #FFFFFF;"> <td style="width: 20%; border: 1px solid black; border-collapse: collapse; text-align: left; font-weight: bold;">Bildirim Metni</td> <td style="width: 80%; border: 1px solid black; border-collapse: collapse; text-align: left;">" + txtBildirimMetin.Text + "</td> </tr> </tbody> </table> </td> </tr> <tr> <td style="background-color: #4791d2; border-top: 2px solid #367fbe; height: 6px;"></td> </tr> </tbody> </table> </td> </tr> </tbody> </table>";



                    ms.MailGonder(mailOnay.YENI_KAYIT, MudahilMail, "Seviye-1 İSG Bildirimi", HttpUtility.HtmlDecode(c).ToString());



                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction('Bildirim Eklendi','succsess');", true);
                    bind();
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction(Hay Aksi :('Bildirim Kaydı Oluşturulamadı'fail');", true);
                }
            }
            catch (Exception)
            {
                ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "myFunction(Hay Aksi :(','fail');", true);
            }
        }