Example #1
0
        private void BindGrid()
        {
            try
            {
                DAL.DataClasses1DataContext objdal=new DAL.DataClasses1DataContext();
                dataGridView1.DataSource = from c in objdal.Videos
                                           select c;  //hide navigation column
                dataGridView1.Columns[0].ReadOnly = true; //make the id column read only

                //add new button column to the DataGridView
                //This column displays a delete icon in each row
                DataGridViewLinkColumn delbut = new DataGridViewLinkColumn();
                delbut.Width = 20;
                delbut.Text = "Add/Update";
                delbut.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                delbut.UseColumnTextForLinkValue = true;
                dataGridView1.Columns.Add(delbut);

                DataGridViewLinkColumn Update = new DataGridViewLinkColumn();
                Update.Width = 20;
                Update.Text = "Delete";
                Update.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                Update.UseColumnTextForLinkValue = true;
                dataGridView1.Columns.Add(Update);
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }
        }
Example #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string encPassword = "";
                string username    = txtUsername.Text.Trim();
                string password    = txtPassword.Text.Trim();
                using (MD5 md5Hash = MD5.Create())
                {
                    encPassword = GetMd5Hash(md5Hash, password);
                }

                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                DAL.User objuser = objdal.Users.FirstOrDefault(x => x.Username.Trim() == username && x.Password.Trim() == encPassword);

                if (objuser != null)
                {
                    LoggedInUser.UserID   = objuser.ID;
                    LoggedInUser.Username = objuser.Username;

                    Main objmain = new Main();
                    objmain.Tag = this;
                    objmain.Show(this);
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("Invalid username or password.");
                }
            }
            catch
            {
            }
        }
Example #3
0
        private void BindGrid()
        {
            try
            {
                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                dataGridView1.DataSource = from c in objdal.Videos
                                           select c;      //hide navigation column
                dataGridView1.Columns[0].ReadOnly = true; //make the id column read only

                //add new button column to the DataGridView
                //This column displays a delete icon in each row
                DataGridViewLinkColumn delbut = new DataGridViewLinkColumn();
                delbut.Width        = 20;
                delbut.Text         = "Add/Update";
                delbut.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                delbut.UseColumnTextForLinkValue = true;
                dataGridView1.Columns.Add(delbut);


                DataGridViewLinkColumn Update = new DataGridViewLinkColumn();
                Update.Width        = 20;
                Update.Text         = "Delete";
                Update.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
                Update.UseColumnTextForLinkValue = true;
                dataGridView1.Columns.Add(Update);
            }
            catch (Exception exp)
            {
                MessageBox.Show(exp.Message);
            }
        }
Example #4
0
        private void Main_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'dbDataSet.VideoCategory' table. You can move, or remove it, as needed.
            this.videoCategoryTableAdapter.Fill(this.dbDataSet.VideoCategory);
            // TODO: This line of code loads data into the 'dbDataSet.Video' table. You can move, or remove it, as needed.
            this.videoTableAdapter.Fill(this.dbDataSet.Video);
            // TODO: This line of code loads data into the 'dbDataSet.VideoCategory' table. You can move, or remove it, as needed.

            // TODO: This line of code loads data into the 'dbDataSet.Video' table. You can move, or remove it, as needed.
            this.videoTableAdapter.Fill(this.dbDataSet.Video);
            try
            {
                //label1.Text=LoggedInUser.Username;
                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                // var table = (from c in objdal.VideoCategories select c);
                comboBox1.DataSource    = (from c in objdal.VideoCategories select c).ToList();
                comboBox1.DisplayMember = "CategoryName";
                comboBox1.ValueMember   = "CategoryName";

                BindGrid();
                UpdateID();
            }
            catch
            {
            }
        }
Example #5
0
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            int id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());

            if (e.ColumnIndex == 5 && e.RowIndex >= 0 && operationCheck == 0 && id != 0) //delete icon button is clicked
            {
                DialogResult result = MessageBox.Show("Do you want to delete this record?", "Confirmation", MessageBoxButtons.OKCancel);
                if (result == DialogResult.OK)
                {
                    DeleteVideo(id); //delete the record from the Book table
                }
            }
            else if (e.ColumnIndex == 4 && e.RowIndex >= 0 && id != 0)
            {
                DialogResult result = MessageBox.Show("Do you want to update this record?", "Confirmation", MessageBoxButtons.OKCancel);
                if (result == DialogResult.OK)
                {
                    DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                    DAL.Video objvideo = objdal.Videos.FirstOrDefault(x => x.ID == id);
                    if (objvideo != null)
                    {
                        objvideo.VideoTitle    = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                        objvideo.VideoUrl      = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                        objvideo.CategoryTitle = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();

                        objdal.SubmitChanges();
                        //bind grid
                        dataGridView1.DataSource = from c in objdal.Videos
                                                   select c;
                    }
                }
            }
            else if (e.ColumnIndex == 4 && e.RowIndex >= 0 && id == 0)
            {
                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                DAL.Video objvideo = new DAL.Video();
                objvideo.UserID        = LoggedInUser.UserID;
                objvideo.VideoTitle    = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                objvideo.VideoUrl      = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                objvideo.CategoryTitle = objvideo.VideoTitle = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();

                objdal.Videos.InsertOnSubmit(objvideo);
                objdal.SubmitChanges();
                //bind grid
                dataGridView1.DataSource = from c in objdal.Videos
                                           select c;
            }
            UpdateID();
        }
Example #6
0
 private void DeleteVideo(int id)
 {
     try
     {
         DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
         DAL.Video objvideo = objdal.Videos.FirstOrDefault(x => x.ID == id);
         if (objvideo != null)
         {
             objdal.Videos.DeleteOnSubmit(objvideo);
             objdal.SubmitChanges();
             //bind grid
             dataGridView1.DataSource = from c in objdal.Videos
                                        select c;
         }
     }
     catch
     { }
 }
Example #7
0
 private void UpdateID()
 {
     try
     {
         DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
         int ID = 0;
         try
         {
             ID = (from c in objdal.Videos
                   select c).Max(x => x.ID);
         }
         catch
         {
             ID = 1;
         }
         ID++;
         textBox1.Text = ID.ToString();
     }
     catch { }
 }
Example #8
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtTitle.Text.Trim() != "" && txtURL.Text.Trim() != "")
                {
                    DAL.DataClasses1DataContext  objdal=new DAL.DataClasses1DataContext();

                    DAL.Video objvideo= new DAL.Video();

                    objvideo.VideoTitle = txtTitle.Text.Trim();
                    objvideo.VideoUrl = txtURL.Text.Trim();
                    objvideo.CategoryTitle = comboBox1.SelectedValue.ToString();
                    objvideo.UserID = LoggedInUser.UserID;

                    objdal.Videos.InsertOnSubmit(objvideo);
                    objdal.SubmitChanges();
                    if (objvideo.ID > 0)
                    {
                        MessageBox.Show("Record added successfully");
                        dataGridView1.DataSource = from c in objdal.Videos
                                                   select c;
                        UpdateID();
                        txtTitle.Text = txtURL.Text = "";
                    }
                    else
                    {
                        MessageBox.Show("Record not added");
                    }

                }
            }
            catch
            {

            }
        }
Example #9
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                string encPassword = "";
                string username = txtUsername.Text.Trim();
                string password = txtPassword.Text.Trim();
                using (MD5 md5Hash = MD5.Create())
                {
                    encPassword = GetMd5Hash(md5Hash, password);
                }

                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                DAL.User objuser = objdal.Users.FirstOrDefault(x => x.Username.Trim() == username && x.Password.Trim() == encPassword);

                if (objuser!=null)
                {

                    LoggedInUser.UserID = objuser.ID;
                    LoggedInUser.Username = objuser.Username;

                    Main objmain = new Main();
                    objmain.Tag = this;
                    objmain.Show(this);
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("Invalid username or password.");
                }

            }
            catch
            {

            }
        }
Example #10
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtTitle.Text.Trim() != "" && txtURL.Text.Trim() != "")
                {
                    DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();


                    DAL.Video objvideo = new DAL.Video();

                    objvideo.VideoTitle    = txtTitle.Text.Trim();
                    objvideo.VideoUrl      = txtURL.Text.Trim();
                    objvideo.CategoryTitle = comboBox1.SelectedValue.ToString();
                    objvideo.UserID        = LoggedInUser.UserID;

                    objdal.Videos.InsertOnSubmit(objvideo);
                    objdal.SubmitChanges();
                    if (objvideo.ID > 0)
                    {
                        MessageBox.Show("Record added successfully");
                        dataGridView1.DataSource = from c in objdal.Videos
                                                   select c;
                        UpdateID();
                        txtTitle.Text = txtURL.Text = "";
                    }
                    else
                    {
                        MessageBox.Show("Record not added");
                    }
                }
            }
            catch
            {
            }
        }
Example #11
0
        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            int id = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
            if (e.ColumnIndex == 5 && e.RowIndex >= 0 && operationCheck == 0 && id!=0) //delete icon button is clicked
            {

                DialogResult result = MessageBox.Show("Do you want to delete this record?", "Confirmation", MessageBoxButtons.OKCancel);
                if (result == DialogResult.OK)
                {
                    DeleteVideo(id); //delete the record from the Book table

                }

            }
            else if (e.ColumnIndex == 4 && e.RowIndex >= 0 && id!=0)
            {
                DialogResult result = MessageBox.Show("Do you want to update this record?", "Confirmation", MessageBoxButtons.OKCancel);
                if (result == DialogResult.OK)
                {
                    DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                    DAL.Video objvideo = objdal.Videos.FirstOrDefault(x => x.ID == id);
                    if (objvideo != null)
                    {
                        objvideo.VideoTitle = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                        objvideo.VideoUrl = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                        objvideo.CategoryTitle = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();

                        objdal.SubmitChanges();
                        //bind grid
                        dataGridView1.DataSource = from c in objdal.Videos
                                                   select c;
                    }
                }
            }
            else if (e.ColumnIndex == 4 && e.RowIndex >= 0  && id==0)
            {

                DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
                DAL.Video objvideo = new DAL.Video();
                objvideo.UserID = LoggedInUser.UserID;
                objvideo.VideoTitle = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                objvideo.VideoUrl = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                objvideo.CategoryTitle = objvideo.VideoTitle = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();

                objdal.Videos.InsertOnSubmit(objvideo);
                objdal.SubmitChanges();
                //bind grid
                dataGridView1.DataSource = from c in objdal.Videos
                                           select c;

            }
            UpdateID();
        }
Example #12
0
 private void UpdateID()
 {
     try
     {
         DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
         int ID=0;
         try
         {
             ID = (from c in objdal.Videos
                   select c).Max(x => x.ID);
         }
         catch
         {
             ID = 1;
         }
         ID++;
         textBox1.Text = ID.ToString();
     }
     catch { }
 }
Example #13
0
        private void Main_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'dbDataSet.VideoCategory' table. You can move, or remove it, as needed.
            this.videoCategoryTableAdapter.Fill(this.dbDataSet.VideoCategory);
            // TODO: This line of code loads data into the 'dbDataSet.Video' table. You can move, or remove it, as needed.
            this.videoTableAdapter.Fill(this.dbDataSet.Video);
            // TODO: This line of code loads data into the 'dbDataSet.VideoCategory' table. You can move, or remove it, as needed.

            // TODO: This line of code loads data into the 'dbDataSet.Video' table. You can move, or remove it, as needed.
            this.videoTableAdapter.Fill(this.dbDataSet.Video);
            try
            {

                //label1.Text=LoggedInUser.Username;
                DAL.DataClasses1DataContext objdal=new DAL.DataClasses1DataContext();
               // var table = (from c in objdal.VideoCategories select c);
                comboBox1.DataSource = (from c in objdal.VideoCategories select c).ToList();
                comboBox1.DisplayMember = "CategoryName";
                comboBox1.ValueMember = "CategoryName";

                BindGrid();
                UpdateID();

            }
            catch
            {

            }
        }
Example #14
0
 private void DeleteVideo(int id)
 {
     try
     {
         DAL.DataClasses1DataContext objdal = new DAL.DataClasses1DataContext();
         DAL.Video objvideo = objdal.Videos.FirstOrDefault(x => x.ID == id);
         if (objvideo != null)
         {
             objdal.Videos.DeleteOnSubmit(objvideo);
             objdal.SubmitChanges();
             //bind grid
             dataGridView1.DataSource = from c in objdal.Videos
                                        select c;
         }
     }
     catch
     { }
 }