예제 #1
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            DataGridViewRow  row  = dataGridView1.CurrentRow;
            DataGridViewCell cell = dataGridView1.CurrentCell;

            if (cell.Value.Equals("Modify"))
            {
                DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
                using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
                {
                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                    }

                    var lst = con.Query <Admission>(@"Select * from dbo.Admission Where Id = @Id", new { @Id = dtId.Value }).FirstOrDefault();
                    con.Close();

                    lblHiddenId.Text              = lst.Id.ToString();
                    AdmisionDate_dtp.Value        = lst.AdmissionDate;
                    Class_Cb.Text                 = lst.Class;
                    Section_cb.Text               = lst.Section;
                    FirstName_Txt.Text            = lst.FirstName;
                    MiddleName_tb.Text            = lst.MiddleName;
                    LastName_tb.Text              = lst.LastName;
                    FatherName_tb.Text            = lst.FatherName;
                    TemporaryAddress_tb.Text      = lst.TemporaryAddress;
                    PermanentAddress_textBox.Text = lst.PermanentAddress;
                    EmailAddress_tb.Text          = lst.Email;
                    PhoneNumber_tb.Text           = lst.PhoneNo;
                    DateOfBirth_dtp.Value         = lst.DateOfBirth;
                    Image_Path.Text               = lst.Image_Path;
                    if (lst.Gender.Equals("Male"))
                    {
                        Male_radioButton.Checked = true;
                    }
                    else if (lst.Gender.Equals("Female"))
                    {
                        Female_radioButton.Checked = true;
                    }
                    else
                    {
                        Other_radioButton.Checked = true;
                    }

                    if (!string.IsNullOrEmpty(lst.Image_Path))
                    {
                        pictureBox1.Image = new Bitmap(lst.Image_Path);
                        Image_Path.Text   = lst.Image_Path;
                    }
                    else
                    {
                        pictureBox1.Image = null;
                        Image_Path.Text   = "";
                    }
                }
            }
            else if (cell.Value.Equals("Delete"))
            {
                DataGridViewTextBoxCell dtId = (DataGridViewTextBoxCell)row.Cells["Id"];
                if (DialogResult.Yes == MessageBox.Show("Are you sure to Delete ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
                {
                    using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
                    {
                        con.Open();

                        con.Execute("Delete from dbo.Admission Where Id = @Id", new { @Id = dtId.Value });
                        con.Close();

                        MessageBox.Show("Data Deleted Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);

                        BindData();
                    };
                }
            }
        }
예제 #2
0
        private void Save_Btn_Click(object sender, EventArgs e)
        {
            if (FirstName_Txt.Text.Equals(string.Empty))
            {
                MessageBox.Show("First Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                FirstName_Txt.Focus();
            }
            else if (LastName_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Last Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                LastName_tb.Focus();
            }
            else if (FatherName_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Father Name is required.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                FatherName_tb.Focus();
            }
            else
            {
                using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
                {
                    con.Open();

                    string gender = "";
                    if (Male_radioButton.Checked)
                    {
                        gender = "Male";
                    }
                    else if (Female_radioButton.Checked)
                    {
                        gender = "Female";
                    }
                    else
                    {
                        gender = "Other";
                    }


                    if (!Directory.Exists(Application.StartupPath + "\\Student"))
                    {
                        Directory.CreateDirectory(Application.StartupPath + "\\Student");
                    }

                    if (!string.IsNullOrEmpty(Image_Path.Text))
                    {
                        pictureBox1.Image.Save(Application.StartupPath + "\\Student\\" + FirstName_Txt.Text + MiddleName_tb.Text + LastName_tb.Text, System.Drawing.Imaging.ImageFormat.Jpeg);
                    }

                    if (!lblHiddenId.Text.Equals("0"))
                    {
                        con.Execute("Update dbo.Admission Set AdmissionDate = @AdmissionDate, Class = @Class, Section = @Section, FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, FatherName = @FatherName, TemporaryAddress = @TemporaryAddress, PermanentAddress = @PermanentAddress, Email = @Email, PhoneNo = @PhoneNo, DateOfBirth = @DateOfBirth, Gender = @Gender, Image_Path = @Image_Path Where Id = @Id", new
                        {
                            @Id               = lblHiddenId.Text,
                            @AdmissionDate    = AdmisionDate_dtp.Text,
                            @Class            = Class_Cb.Text,
                            @Section          = Section_cb.Text,
                            @FirstName        = FirstName_Txt.Text,
                            @MiddleName       = MiddleName_tb.Text,
                            @LastName         = LastName_tb.Text,
                            @FatherName       = FatherName_tb.Text,
                            @TemporaryAddress = TemporaryAddress_tb.Text,
                            @PermanentAddress = PermanentAddress_textBox.Text,
                            @Email            = EmailAddress_tb.Text,
                            @PhoneNo          = PhoneNumber_tb.Text,
                            @DateOfBirth      = DateOfBirth_dtp.Text,
                            @Gender           = gender,
                            @Image_Path       = Image_Path.Text,
                            @Ent_User         = Session.Email,
                            @Ent_DateTime     = DateTime.Now
                        });
                    }
                    else
                    {
                        con.Execute("Insert into dbo.Admission (AdmissionDate, Class, Section, FirstName, MiddleName, LastName, FatherName, TemporaryAddress, PermanentAddress, Email, PhoneNo, DateOfBirth, Gender, Image_Path, Ent_User, Ent_DateTime) Values (@AdmissionDate, @Class, @Section, @FirstName, @MiddleName, @LastName, @FatherName, @TemporaryAddress, @PermanentAddress, @Email, @PhoneNo, @DateOfBirth, @Gender, @Image_Path, @Ent_User, @Ent_DateTime)", new
                        {
                            @AdmissionDate    = AdmisionDate_dtp.Text,
                            @Class            = Class_Cb.Text,
                            @Section          = Section_cb.Text,
                            @FirstName        = FirstName_Txt.Text,
                            @MiddleName       = MiddleName_tb.Text,
                            @LastName         = LastName_tb.Text,
                            @FatherName       = FatherName_tb.Text,
                            @TemporaryAddress = TemporaryAddress_tb.Text,
                            @PermanentAddress = PermanentAddress_textBox.Text,
                            @Email            = EmailAddress_tb.Text,
                            @PhoneNo          = PhoneNumber_tb.Text,
                            @DateOfBirth      = DateOfBirth_dtp.Text,
                            @Gender           = gender,
                            @Image_Path       = Image_Path.Text,
                            @Ent_User         = Session.Email,
                            @Ent_DateTime     = DateTime.Now
                        });
                    }
                    MessageBox.Show("Data Saved Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);

                    BindData();

                    lblHiddenId.Text              = "0";
                    FirstName_Txt.Text            = string.Empty;
                    MiddleName_tb.Text            = string.Empty;
                    LastName_tb.Text              = string.Empty;
                    Section_cb.Text               = string.Empty;
                    FatherName_tb.Text            = string.Empty;
                    Class_Cb.Text                 = string.Empty;
                    TemporaryAddress_tb.Text      = string.Empty;
                    PermanentAddress_textBox.Text = string.Empty;
                    EmailAddress_tb.Text          = string.Empty;
                    PhoneNumber_tb.Text           = string.Empty;
                    DateOfBirth_dtp.Text          = string.Empty;
                };
            }
        }
예제 #3
0
        private void Save_b_Click(object sender, EventArgs e)
        {
            if (FirstName_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("First Name Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
                FirstName_tb.Focus();
            }
            else if (LastName_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Last Name Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if (EmailAddress_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Email Address Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if (JoinDate_dtp.Text.Equals(string.Empty))
            {
                MessageBox.Show("Join Date Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if (Password_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Password Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if (PhoneNumber_tb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Phone Number Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else if (Faculty_cb.Text.Equals(string.Empty))
            {
                MessageBox.Show("Faculty Is Required", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                using (IDbConnection con = new SqlConnection(SQLConnection.getConnection()))
                {
                    con.Open();

                    if (con.Query <int>("Select 1 from dbo.StaffRegistration Where Email = @Email", new { @Email = EmailAddress_tb.Text }).FirstOrDefault() == 1 && lblHiddenId.Text == "0")
                    {
                        MessageBox.Show("Email Already Exists.", "warnning", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                    else
                    {
                        string gender = "";
                        if (Male_rb.Checked)
                        {
                            gender = "Male";
                        }
                        else if (Female_rb.Checked)
                        {
                            gender = "Female";
                        }
                        else
                        {
                            gender = "Other";
                        }


                        if (!Directory.Exists(Application.StartupPath + "\\Staff"))
                        {
                            Directory.CreateDirectory(Application.StartupPath + "\\Staff");
                        }

                        if (!string.IsNullOrEmpty(Image_Path.Text))
                        {
                            pictureBox1.Image.Save(Application.StartupPath + "\\Staff\\" + FirstName_tb.Text + MiddleName_tb.Text + LastName_tb.Text, System.Drawing.Imaging.ImageFormat.Jpeg);
                        }

                        if (!lblHiddenId.Text.Equals("0"))
                        {
                            con.Execute("Update dbo.StaffRegistration Set FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, Address = @Address, Email = @Email, PhoneNo = @PhoneNo, JoinDate = @JoinDate, Faculty = @Faculty, Gender = @Gender, Password = @Password, Image_Path = @Image_Path Where Id = @Id", new
                            {
                                @Id           = lblHiddenId.Text,
                                @FirstName    = FirstName_tb.Text,
                                MiddleName    = MiddleName_tb.Text,
                                LastName      = LastName_tb.Text,
                                Address       = Address_tb.Text,
                                Email         = EmailAddress_tb.Text,
                                PhoneNo       = PhoneNumber_tb.Text,
                                JoinDate      = JoinDate_dtp.Value,
                                Faculty       = Faculty_cb.Text,
                                Password      = Password_tb.Text,
                                @Gender       = gender,
                                @Image_Path   = Image_Path.Text,
                                @Ent_User     = Session.Email,
                                @Ent_DateTime = DateTime.Now
                            });
                        }
                        else
                        {
                            con.Execute("Insert into dbo.StaffRegistration (FirstName, MiddleName, LastName, Address, Email, PhoneNo, JoinDate, Faculty, Gender, Password, Image_Path, Ent_User, Ent_DateTime) Values (  @FirstName, @MiddleName, @LastName , @Address , @Email, @PhoneNo, @JoinDate,@Faculty, @Gender,@Password, @Image_Path, @Ent_User, @Ent_DateTime)", new
                            {
                                @FirstName    = FirstName_tb.Text,
                                @MiddleName   = MiddleName_tb.Text,
                                @LastName     = LastName_tb.Text,
                                @Address      = Address_tb.Text,
                                @Email        = EmailAddress_tb.Text,
                                @PhoneNo      = PhoneNumber_tb.Text,
                                @JoinDate     = JoinDate_dtp.Text,
                                @Faculty      = Faculty_cb.Text,
                                @Gender       = gender,
                                @Password     = Password_tb.Text,
                                @Image_Path   = "",
                                @Ent_User     = Session.Email,
                                @Ent_DateTime = DateTime.Now
                            });
                        }
                        MessageBox.Show("Data Saved Successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        BindData();
                        lblHiddenId.Text     = "0";
                        FirstName_tb.Text    = string.Empty;
                        MiddleName_tb.Text   = string.Empty;
                        LastName_tb.Text     = string.Empty;
                        Address_tb.Text      = string.Empty;
                        EmailAddress_tb.Text = string.Empty;
                        PhoneNumber_tb.Text  = string.Empty;
                        JoinDate_dtp.Text    = string.Empty;
                        Password_tb.Text     = string.Empty;
                    }
                }
            }
        }