Exemple #1
0
        //Buraya Kadar Firmaları seçtikten sonra Şubeleri Daha Sonra Bölümleri Seçmemizi Sağladık
        protected void rpWorkingList_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            if (e.CommandName == "Update")
            {
                using (db = new novartz_stajyer1Entities())
                {
                    Guid id = Guid.Parse(e.CommandArgument.ToString());
                    VW_FIRMDEPARTMENTMEMBER departmentMember = db.VW_FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == id);
                    RECID = departmentMember.ID;
                    hdnDepartmentID.Value = e.CommandArgument.ToString();
                    lblFirmUpdate.Text    = departmentMember.FIRMNAME;
                    lblPersonel.Text      = departmentMember.FULLNAME;
                    lblBranchUpdate.Text  = departmentMember.FIRMBRANCHNAME;
                    FillDrp(DrpDepartmentUpdate, db.VW_FIRMDEPARTMENT.Where(t => t.FIRMBRANCHID == departmentMember.FIRMBRANCHID).ToList(), "ID", "NAME", "Seçiniz");
                    DrpDepartmentUpdate.SelectedValue = departmentMember.FIRMDEPARTMENTID.ToString();//Drop  seçileceği zaman; seçilmeden önceki hangi bölüme ait ise o bölüm seçili olarak gelmesini sağlıyor.
                    departmentMember.ISACTIVE         = dropmdlcd.SelectedValue == "0";
                }
                ScriptManager.RegisterStartupScript(this, GetType(), "", "OpenModal()", true);

                upModalUpdate.Update();
            }
            else if (e.CommandName == "Delete")//Eğer buton Delete butonu ise bunu yapacak.
            {
                using (db = new novartz_stajyer1Entities())
                {
                    Guid id = Guid.Parse(e.CommandArgument.ToString());
                    FIRMDEPARTMENTMEMBER department = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.MEMBERID == id); //SinglorDefault tek veri çekmek için kulladığımız deyim
                                                                                                                      //FIRMBRANCH test = (from t in db.FIRMBRANCH where t.ID == id select t).SingleOrDefault();
                    db.FIRMDEPARTMENTMEMBER.Remove(department);                                                       //silmek için kullandın removeyi
                    db.SaveChanges();
                    FillDepartment();
                    UpdatePanel.Update();
                }
            }
        }
Exemple #2
0
        protected void btnSaveFirmDepartmentMember_Click(object sender, EventArgs e)//Yeni çalışan ekle kısmını yaptım kayıt yapıyor seçilen kısıma..
        {
            if (ValidateRecord())
            {
                Guid   id     = Guid.NewGuid();
                MEMBER member = null;
                using (db = new novartz_stajyer1Entities())
                {
                    member = new MEMBER
                    {
                        NAME         = txtmdlName.Text,
                        SURNAME      = txtmdlSurname.Text,
                        LOGINNAME    = txtmdlMail.Text,
                        BIRDDATE     = Convert.ToDateTime(txtmdlBirtday.Text),
                        PHONE        = txtmdlPhone.Text,
                        PASWORD      = txtmdlPassword.Text,
                        GENDER       = Convert.ToBoolean(drpmdlGender.SelectedValue == "1"),//Bayan ise true olarak çalışıyor
                        TYPEMEMBERID = Convert.ToByte(drpmdltypmember.SelectedValue),
                        CANLOGIN     = true,
                        ID           = id
                    };
                    db.MEMBER.Add(member);
                    db.SaveChanges();
                };
                if (drpmdltypmember.SelectedValue == "3")
                {
                    FIRMRESPONSIBLE rsp = null;
                    using (db = new novartz_stajyer1Entities())
                    {
                        Guid id3 = Guid.NewGuid();
                        rsp = new FIRMRESPONSIBLE
                        {
                            ID       = id3,
                            FIRMID   = Guid.Parse(DrpFirm.SelectedValue),
                            MEMBERID = id
                        };
                        db.FIRMRESPONSIBLE.Add(rsp);
                        db.SaveChanges();
                    }
                }


                FIRMDEPARTMENTMEMBER rec = null;
                using (db = new novartz_stajyer1Entities())
                {
                    Guid id2 = Guid.NewGuid();
                    rec = new FIRMDEPARTMENTMEMBER
                    {
                        ID = id2,
                        FIRMDEPARTMENTID = Guid.Parse(DrpDepartment.SelectedValue),
                        ISACTIVE         = dropmdlcd.SelectedValue == "1",
                        MEMBERID         = id
                    };
                    db.FIRMDEPARTMENTMEMBER.Add(rec);
                    db.SaveChanges();
                };
                MessageBox("İşleminiz Başarılı");
            }
        }
Exemple #3
0
 protected void btnUpdateSaveServer_Click(object sender, EventArgs e)//Güncelleme Bölümünde kaydetme işlemini yaptık...
 {
     using (db = new novartz_stajyer1Entities())
     {
         FIRMDEPARTMENTMEMBER rec = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == RECID);
         rec.FIRMDEPARTMENTID = Guid.Parse(DrpDepartmentUpdate.SelectedValue);
         rec.ISACTIVE         = Convert.ToBoolean(DrpcdUpdate.SelectedValue == "1");
         db.SaveChanges();
         FillDepartment();
         UpdatePanel.Update();
     }
 }
Exemple #4
0
        protected void btnAddDepartmentMember_Click(object sender, EventArgs e)
        {
            if (ValidateDepartmentMember())
            {
                Guid   id     = Guid.NewGuid();
                MEMBER member = null;
                using (db = new novartz_stajyer1Entities())
                {
                    member = new MEMBER
                    {
                        NAME         = txtDepMemberName.Text,
                        SURNAME      = txtDepMemberSurname.Text,
                        LOGINNAME    = txtDepMemberEmail.Text,
                        BIRDDATE     = Convert.ToDateTime(txtDepMemberBirthday.Text),
                        PHONE        = txtDepMemberTelephone.Text,
                        PASWORD      = txtDepMemberPassword.Text,
                        CANLOGIN     = true,
                        GENDER       = drpDepMemberGender.SelectedValue == "1",
                        TYPEMEMBERID = 2,
                        ID           = id,
                    };
                    db.MEMBER.Add(member);
                    db.SaveChanges();
                };

                FIRMDEPARTMENTMEMBER rec = null;
                using (db = new novartz_stajyer1Entities())
                {
                    Guid id2 = Guid.NewGuid();
                    rec = new FIRMDEPARTMENTMEMBER
                    {
                        ID = id2,
                        FIRMDEPARTMENTID = Guid.Parse(drpDepMemberDepartment.SelectedValue),
                        ISACTIVE         = drpDepMemberStatus.SelectedValue == "1",
                        MEMBERID         = id
                    };
                    db.FIRMDEPARTMENTMEMBER.Add(rec);
                    db.SaveChanges();
                    InitPage(false);
                    upDepartmentMember.Update();
                };
                MessageBox("İşleminiz Başarılı");
            }
        }
Exemple #5
0
        protected void rpFirmDepMemberList_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            switch (e.CommandName)
            {
            case "Update":
                if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
                {
                    using (db = new novartz_stajyer1Entities())
                    {
                        Guid selectedMemberID = Guid.Parse(e.CommandArgument.ToString());
                        lblDepartmentMemberIsUpdate.Text = "Güncelleyiniz";
                        VW_FIRMDEPARTMENTMEMBER rec = db.VW_FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == selectedMemberID);
                        if (rec != null)
                        {
                            FillDrp(drpDepMemberBranch, db.FIRMBRANCH.Where(d => d.FIRMID == RECID).ToList(), "ID", "NAME", "Şubesizler");
                            if (rec.FIRMBRANCHID.HasValue)
                            {
                                drpDepMemberBranch.SelectedValue = rec.FIRMBRANCHID.Value.ToString();
                            }
                            drpDepMemberBranch_SelectedIndexChanged(null, null);
                            drpDepMemberDepartment.SelectedValue = rec.FIRMDEPARTMENTID.ToString();
                            txtDepMemberTelephone.Text           = rec.PHONE;
                            txtDepMemberName.Text     = rec.NAME;
                            txtDepMemberSurname.Text  = rec.SURNAME;
                            txtDepMemberBirthday.Text = rec.BIRDDATE.ToString();
                            if (rec.GENDER.HasValue)
                            {
                                drpDepMemberGender.SelectedValue = rec.GENDER.Value ? "1" : "0";
                            }
                            drpDepMemberStatus.SelectedValue = rec.ISACTIVE ? "1" : "0";
                            drpDepMemEmail.Text = rec.LOGINNAME;
                            DEPARTMENTMEMBERID  = selectedMemberID;
                            ScriptManager.RegisterStartupScript(this, this.GetType(), "OpenDepartmentMemberModal", "$('#mdlNewDepartmentMember').modal('show');", true);
                            upMdlNewDepartmentMember.Update();
                        }
                    }
                }
                break;

            case "Delete":     // OLMADI BU KISIMM!!!

                using (db = new novartz_stajyer1Entities())
                {
                    Guid selectedMemberID = Guid.Parse(e.CommandArgument.ToString());

                    FIRMDEPARTMENTMEMBER rec = db.FIRMDEPARTMENTMEMBER.SingleOrDefault(t => t.ID == selectedMemberID);
                    if (rec != null)
                    {
                        //hata kontrolü yap 547
                        db.FIRMDEPARTMENTMEMBER.Remove(rec);
                        db.SaveChanges();
                        //  InitPage(false);
                        //  upMdlNewDepartmentMember.Update();
                    }



                    MEMBER mem = db.MEMBER.SingleOrDefault(t => t.ID == rec.MEMBERID);
                    if (mem != null)
                    {
                        db.MEMBER.Remove(mem);
                        db.SaveChanges();
                        InitPage(false);
                        upDepartmentMember.Update();
                    }
                }

                break;
            }
        }