コード例 #1
0
ファイル: LoginPage.xaml.cs プロジェクト: krathi123/Visitors
        private void submitBtn_Click(object sender, RoutedEventArgs e)
        {
            UserMaster usrmasterRef = new UserMaster();

            usrmasterRef.mobileNo = mobileNotxt.Text.Trim();

            if (passwordBoxsample.Password.Trim() == "")
            {
                MessageBox.Show("Please enter password !");
            }
            else
            {
                usrmasterRef.pwd = passwordBoxsample.Password.Trim();
                UserMasterDAO usrmasterDAORef = new UserMasterDAOImpl();
                int           i = usrmasterDAORef.login(usrmasterRef);
                if (i == 1)
                {
                    radCarouse1 r = new radCarouse1();
                    r.Show();
                    Hide();
                }
                else if (i == 0)
                {
                    mobileNotxt.Text           = "";
                    passwordBoxsample.Password = "";
                    MessageBox.Show("invalid credential!");
                }
            }
        }
コード例 #2
0
        private void RadButton_Click(object sender, RoutedEventArgs e)
        {
            UserNameTxt.Text = "";
            UserMasterDAO userMasterDaoRef = new UserMasterDAOImpl();
            List <string> listNm           = new List <string>();

            listNm.Add("user Id");
            listNm.Add("User Name");
            listNm.Add("Mobile No");
            listNm.Add("Address");
            listNm.Add("gender");
            listNm.Add("Email Id");
            listNm.Add("DOB");
            listNm.Add("password");
            listNm.Add("designation");
            // List<List<string>> itemList = new List<List<string>>();
            List <ArrayList> usrList = new List <ArrayList>();

            usrList = userMasterDaoRef.getUsrList(null);

            DataTable dt = CreateDataTable(listNm, usrList);

            dataGridUser.ItemsSource = dt.DefaultView;

            dataGridUser.Columns[0].IsReadOnly = true;
            dataGridUser.Columns[1].IsReadOnly = false;
            dataGridUser.Columns[2].IsReadOnly = false;
            dataGridUser.Columns[3].IsReadOnly = false;
            dataGridUser.Columns[4].IsReadOnly = false;
            dataGridUser.Columns[5].IsReadOnly = false;
            dataGridUser.Columns[6].IsReadOnly = false;
            dataGridUser.Columns[7].IsReadOnly = false;
            dataGridUser.Columns[8].IsReadOnly = true;
        }
コード例 #3
0
        private void findAllbtn_Click(object sender, EventArgs e)
        {
            UserMasterDao userMasterDaoRef = new UserMasterDAOImpl();
            List <string> listNm           = new List <string>();

            listNm.Add("user Id");
            listNm.Add("User Name");
            listNm.Add("Mobile No");
            listNm.Add("Address");
            listNm.Add("gender");
            listNm.Add("Email Id");
            listNm.Add("DOB");
            listNm.Add("password");
            listNm.Add("designation");
            // List<List<string>> itemList = new List<List<string>>();
            List <ArrayList> usrList = new List <ArrayList>();

            usrList = userMasterDaoRef.getUsrList(null);

            dataGridVieweditUsr.DataSource                      = CreateDataTable(listNm, usrList);
            dataGridVieweditUsr.Columns[0].ReadOnly             = true;
            dataGridVieweditUsr.Columns[1].ReadOnly             = false;
            dataGridVieweditUsr.Columns[2].ReadOnly             = false;
            dataGridVieweditUsr.Columns[3].ReadOnly             = false;
            dataGridVieweditUsr.Columns[4].ReadOnly             = false;
            dataGridVieweditUsr.Columns[5].ReadOnly             = false;
            dataGridVieweditUsr.Columns[6].ReadOnly             = false;
            dataGridVieweditUsr.Columns[7].ReadOnly             = false;
            dataGridVieweditUsr.Columns[8].ReadOnly             = true;
            dataGridVieweditUsr.FirstDisplayedScrollingRowIndex = dataGridVieweditUsr.RowCount - 1;
            //dataGridVieweditUsr.FirstDisplayedScrollingRowIndex = dataGridVieweditUsr.ColumnCount - 1;
        }
コード例 #4
0
        private void deleteBtn_Click(object sender, RoutedEventArgs e)
        {
            UserMaster    usrMasterRef    = new UserMaster();
            UserMasterDAO usrMasterDAORef = new UserMasterDAOImpl();
            DataRowView   row             = (DataRowView)dataGridUser.SelectedItems[0];

            usrMasterRef.userid = Convert.ToInt32(row["user Id"]);
            usrMasterDAORef.deleteUser(usrMasterRef);
        }
コード例 #5
0
        private void submitBtn_Click(object sender, RoutedEventArgs e)
        {
            UserMasterDAO usrMasterDAOREf = new UserMasterDAOImpl();
            UserMaster    usrMasterref    = new UserMaster();

            //if (pwdtxt.Text == cpwd.Text)
            //    usrMasterref.pwd = pwdtxt.Text;
            if (pwdtxt.Password != cpwd.Password)
            {
                MessageBox.Show("confirm password doesnt match with password!!");
            }
            else if (pwdtxt.Password == "")
            {
                MessageBox.Show("pls enter password!!");
            }
            else if (cpwd.Password == "")
            {
                MessageBox.Show("pls enter confirm password!!");
            }
            else
            {
                usrMasterref.pwd      = pwdtxt.Password;
                usrMasterref.username = userNameTxt.Text;
                usrMasterref.mobileNo = mobileNoTxt.Text;
                usrMasterref.address  = adressTxt.Text;
                if (maleRbtn.IsChecked == true)
                {
                    usrMasterref.gender = "M";
                }
                else if (femaleRbtn.IsChecked == true)
                {
                    usrMasterref.gender = "F";
                }
                usrMasterref.emailId = emailidTxt.Text;
                if (dobCalender.SelectedDate.HasValue)
                {
                    usrMasterref.dob = dobCalender.SelectedDate.Value;
                    Console.WriteLine("DOB:{0}\n", usrMasterref.dob);
                }
                RoleMaster r = new RoleMaster();
                r.roleName = DesgcomboBox.Text;
                usrMasterref.designationRef = r;

                byte[]       images = null;
                FileStream   stream = new FileStream(imglocation, FileMode.Open, FileAccess.Read);
                BinaryReader brs    = new BinaryReader(stream);
                images = brs.ReadBytes((int)stream.Length);
                if (images == null)
                {
                    MessageBox.Show("Upload image!");
                }
                usrMasterref.picture = images;
                usrMasterDAOREf.insertUser(usrMasterref);
                clearFields();
            }
        }
コード例 #6
0
ファイル: AddUser.cs プロジェクト: krathi123/Trial
        private void AddUserControl_Load(object sender, EventArgs e)
        {
            UserMasterDao usrMasterDAOREf = new UserMasterDAOImpl();
            List <string> rolenamelist    = usrMasterDAOREf.getRoleName();

            foreach (var item in rolenamelist)
            {
                designationCmb.Items.Add(item);
            }
        }
コード例 #7
0
ファイル: AddusrCtrl.xaml.cs プロジェクト: krathi123/Visitors
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            //  DataContext = new AddusrCtrlVM();
            UserMasterDAO usrMasterDAOREf = new UserMasterDAOImpl();
            List <string> rolenamelist    = usrMasterDAOREf.getRoleName();

            foreach (var item in rolenamelist)
            {
                DesgcomboBox.Items.Add(item);
            }
        }
コード例 #8
0
ファイル: AddUser.cs プロジェクト: krathi123/Trial
        private void submitBtn_Click(object sender, EventArgs e)
        {
            if (userNameTxt.Text == "" || mobileNoTxt.Text == "" || emailIDTxt.Text == "" || pwdTxt.Text == "" || confirmPwdTxt.Text == "" || dobDatePicker.Value == DateTime.UtcNow.Date)
            {
                MessageBox.Show("enter all the values", "error message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            else
            {
                //if (ValidateChildren(ValidationConstraints.Enabled))
                //{
                //    MessageBox.Show(userNameTxt.Text, "Demo App - Message!");
                //}
                UserMasterDao usrMasterDAOREf = new UserMasterDAOImpl();
                UserMaster    usrMasterRef    = new UserMaster();


                usrMasterRef.username = userNameTxt.Text;
                usrMasterRef.mobileNo = mobileNoTxt.Text;
                usrMasterRef.address  = addressTxt.Text;
                usrMasterRef.emailId  = emailIDTxt.Text;
                usrMasterRef.pwd      = pwdTxt.Text;
                string     cpwd = confirmPwdTxt.Text;
                RoleMaster r    = new RoleMaster();
                r.roleName = designationCmb.Text;
                usrMasterRef.designationRef = r;
                usrMasterRef.dob            = dobDatePicker.Value;
                Console.WriteLine("\n date = {0}\n", usrMasterRef.dob);

                bool isChecked = malerbtn.Checked;
                if (isChecked)
                {
                    usrMasterRef.gender = "M";
                }
                else
                {
                    usrMasterRef.gender = "F";
                }
                if (usrMasterRef.pwd == cpwd)
                {
                    usrMasterDAOREf.insertUser(usrMasterRef);
                    clearFields();
                }
                else
                {
                    MessageBox.Show("password doesn't match !!");
                }
            }
        }
コード例 #9
0
 private void QRCodeBtn_Click(object sender, RoutedEventArgs e)
 {
     //    if (dataGridUser.ItemsSource == "")
     //    {
     //        MessageBox.Show("No Data!");
     //    }
     //    else
     {
         UserMaster    usrMasterRef    = new UserMaster();
         UserMasterDAO usrMasterDAORef = new UserMasterDAOImpl();
         DataRowView   row             = (DataRowView)dataGridUser.SelectedItems[0];
         int           id = Convert.ToInt32(row["user Id"]);
         usrMasterRef = usrMasterDAORef.findbyprimaryKey(id);
         QrCodegenerator(usrMasterRef);
         image1.Visibility = Visibility.Visible;
     }
 }
コード例 #10
0
        private void searchRoleNameBtn_Click_1(object sender, RoutedEventArgs e)
        {
            if (roleNameTxt.Text.Trim() == "")
            {
                MessageBox.Show("Please enter Role name !");
            }
            UserNameTxt.Text = "";
            UserMaster usrmasterRef = new UserMaster();

            usrmasterRef.username = null;
            RoleMaster rolemasterRef = new RoleMaster();

            rolemasterRef.roleName      = roleNameTxt.Text.Trim();
            usrmasterRef.designationRef = rolemasterRef;
            UserMasterDAO userMasterDaoRef = new UserMasterDAOImpl();
            List <string> listNm           = new List <string>();

            listNm.Add("user Id");
            listNm.Add("User Name");
            listNm.Add("Mobile No");
            listNm.Add("Address");
            listNm.Add("gender");
            listNm.Add("Email Id");
            listNm.Add("DOB");
            listNm.Add("password");
            listNm.Add("designation");
            List <List <string> > itemList = new List <List <string> >();
            List <ArrayList>      usrList  = new List <ArrayList>();

            usrList = userMasterDaoRef.getUsrList(usrmasterRef);

            DataTable dt = CreateDataTable(listNm, usrList);

            dataGridUser.ItemsSource = dt.DefaultView;

            dataGridUser.Columns[0].IsReadOnly = true;
            dataGridUser.Columns[1].IsReadOnly = false;
            dataGridUser.Columns[2].IsReadOnly = false;
            dataGridUser.Columns[3].IsReadOnly = false;
            dataGridUser.Columns[4].IsReadOnly = false;
            dataGridUser.Columns[5].IsReadOnly = false;
            dataGridUser.Columns[6].IsReadOnly = false;
            dataGridUser.Columns[7].IsReadOnly = false;
            dataGridUser.Columns[8].IsReadOnly = true;
            UserNameTxt.Text = "";
        }
コード例 #11
0
        private void deleteBtn_Click(object sender, EventArgs e)
        {
            UserMaster usermasterRef = new UserMaster();
            int        rowIndex      = dataGridVieweditUsr.CurrentCell.RowIndex;
            var        row           = dataGridVieweditUsr.Rows[rowIndex];
            var        changedValue  = (string)row.Cells[rowIndex].Value;

            Console.WriteLine("$$$$$$$$$$$$$$$$$ values:{0}", (string)row.Cells[rowIndex].Value);


            usermasterRef.userid = Convert.ToInt32(row.Cells["user Id"].Value);

            UserMasterDao userMasterDaoRef = new UserMasterDAOImpl();

            userMasterDaoRef.deleteUser(usermasterRef);
            dataGridVieweditUsr.Update();
            dataGridVieweditUsr.Refresh();
        }
コード例 #12
0
        private void searchUserNameBtn_Click_1(object sender, RoutedEventArgs e)
        {
            if (UserNameTxt.Text.Trim() == "")
            {
                MessageBox.Show("Please enter user name!");
            }
            else
            {
                UserMaster usrmasterRef = new UserMaster();
                usrmasterRef.username = UserNameTxt.Text.Trim();

                RoleMaster rolemasterRef = new RoleMaster();
                rolemasterRef.roleName      = null;
                usrmasterRef.designationRef = rolemasterRef;
                UserMasterDAO userMasterDaoRef = new UserMasterDAOImpl();
                List <string> listNm           = new List <string>();
                listNm.Add("user Id");
                listNm.Add("User Name");
                listNm.Add("Mobile No");
                listNm.Add("Address");
                listNm.Add("gender");
                listNm.Add("Email Id");
                listNm.Add("DOB");
                listNm.Add("password");
                listNm.Add("designation");
                List <List <string> > itemList = new List <List <string> >();
                List <ArrayList>      usrList  = new List <ArrayList>();
                usrList = userMasterDaoRef.getUsrList(usrmasterRef);
                if (usrList.Count == 0)
                {
                    Console.WriteLine("inside if null");
                    QRCodeBtn.Visibility     = Visibility.Hidden;
                    dataGridUser.ItemsSource = null;
                    image1.Visibility        = Visibility.Hidden;
                }

                else
                {
                    Console.WriteLine("inside else null");
                    DataTable dt = CreateDataTable(listNm, usrList);
                    dataGridUser.ItemsSource = dt.DefaultView;
                }
            }
        }
コード例 #13
0
        private void submitbtn_Click(object sender, EventArgs e)
        {
            UserMaster usrmasterRef = new UserMaster();

            usrmasterRef.mobileNo = mobileNoTxt.Text.Trim();
            usrmasterRef.pwd      = pwdTxt.Text.Trim();
            RoleMaster role = new RoleMaster();


            usrmasterRef.designationRef = role;
            UserMasterDao usrmasterDAORef = new UserMasterDAOImpl();
            UserMaster    usrmasterRef1   = usrmasterDAORef.login(usrmasterRef);

            username = usrmasterRef1.username;
            mobileNo = usrmasterRef1.mobileNo;
            EmailId  = usrmasterRef1.emailId;
            if (usrmasterRef1 != null)
            {
                Console.WriteLine("Role Name ={0}", usrmasterRef1.designationRef.roleName);
                if (usrmasterRef1.designationRef.roleName == "Manager")
                {
                    manager Check = new manager();
                    Check.Show();
                    Hide();
                }
                else if (usrmasterRef1.designationRef.roleName == "Waiter")
                {
                    Waiter Check = new Waiter();
                    Check.Show();
                    Hide();
                }
                else if (usrmasterRef1.designationRef.roleName == "Admin")
                {
                    adminpage Check = new adminpage();
                    Check.Show();
                    Hide();
                }
            }

            else
            {
                MessageBox.Show("couln't login");
            }
        }
コード例 #14
0
        private void qrBtn_Click(object sender, RoutedEventArgs e)
        {
            BarcodeSettings.ApplyKey("your key");//you need a key from e-iceblue, otherwise the watermark 'E-iceblue' will be shown in barcode
            BarcodeSettings settings = new BarcodeSettings();

            settings.Type           = BarCodeType.QRCode;
            settings.Unit           = GraphicsUnit.Pixel;
            settings.ShowText       = false;
            settings.ResolutionType = ResolutionType.UseDpi;
            //input data
            UserMaster    u      = new UserMaster();
            UserMasterDAO usrDAO = new UserMasterDAOImpl();

            u = usrDAO.findbyprimaryKey(6);

            string data = "UserName :"******"\n Password : "******"\nMobileNo : " + u.mobileNo + "\ngender : " + u.gender;

            Console.WriteLine("Usren mae:{0} password:{1} Mobile No={2} gender={3}", u.username, u.pwd, u.mobileNo, u.gender);
            settings.Data = data;
            string foreColor = "Black";
            string backColor = "White";

            settings.ForeColor = System.Drawing.Color.FromName(foreColor);
            settings.BackColor = System.Drawing.Color.FromName(backColor);
            settings.X         = Convert.ToInt16(30);
            short leftMargin = 1;

            settings.LeftMargin = leftMargin;
            short rightMargin = 1;

            settings.RightMargin = rightMargin;
            short topMargin = 1;

            settings.TopMargin = topMargin;
            short bottomMargin = 1;

            settings.BottomMargin = bottomMargin;
            settings.QRCodeECL    = QRCodeECL.L;

            BarCodeGenerator generator = new BarCodeGenerator(settings);
            Image            QRbarcode = generator.GenerateImage();

            image1.Source = BitmapToImageSource(QRbarcode);
        }
コード例 #15
0
        private void searchdesgBtn_Click(object sender, EventArgs e)
        {
            UserMaster usrmasterRef = new UserMaster();

            usrmasterRef.username = "";
            RoleMaster rolemasterRef = new RoleMaster();

            rolemasterRef.roleName = searchdesgTxt.Text;
            Console.WriteLine("inside else if \nRole Name:{0}", rolemasterRef.roleName);
            usrmasterRef.designationRef = rolemasterRef;
            Console.WriteLine("in user edit \nRole Name:{0}", usrmasterRef.designationRef.roleName);
            UserMasterDao userMasterDaoRef = new UserMasterDAOImpl();
            List <string> listNm           = new List <string>();

            listNm.Add("user Id");
            listNm.Add("User Name");
            listNm.Add("Mobile No");
            listNm.Add("Address");
            listNm.Add("gender");
            listNm.Add("Email Id");
            listNm.Add("DOB");
            listNm.Add("password");
            listNm.Add("designation");
            // List<List<string>> itemList = new List<List<string>>();
            List <ArrayList> usrList = new List <ArrayList>();

            usrList = userMasterDaoRef.getUsrList(usrmasterRef);

            dataGridVieweditUsr.DataSource                      = CreateDataTable(listNm, usrList);
            dataGridVieweditUsr.Columns[0].ReadOnly             = true;
            dataGridVieweditUsr.Columns[1].ReadOnly             = false;
            dataGridVieweditUsr.Columns[2].ReadOnly             = false;
            dataGridVieweditUsr.Columns[3].ReadOnly             = false;
            dataGridVieweditUsr.Columns[4].ReadOnly             = false;
            dataGridVieweditUsr.Columns[5].ReadOnly             = false;
            dataGridVieweditUsr.Columns[6].ReadOnly             = false;
            dataGridVieweditUsr.Columns[7].ReadOnly             = false;
            dataGridVieweditUsr.Columns[8].ReadOnly             = true;
            dataGridVieweditUsr.FirstDisplayedScrollingRowIndex = dataGridVieweditUsr.RowCount - 1;
            //    dataGridVieweditUsr.FirstDisplayedScrollingRowIndex = dataGridVieweditUsr.ColumnCount - 1;
        }
コード例 #16
0
        private void dataGridVieweditUsr_CellValueChanged(object sender, DataGridViewCellEventArgs e)
        {
            Console.WriteLine("\n++++++++++ cell changed+++++++++++++++++\n");
            var row          = dataGridVieweditUsr.Rows[e.RowIndex];
            var col          = dataGridVieweditUsr.Columns[e.ColumnIndex];
            var changedValue = (string)row.Cells[e.ColumnIndex].Value;

            Console.WriteLine("************row index:{0}\t col: {1}", e.RowIndex, e.ColumnIndex);
            Console.WriteLine(" *******************************Row value :{0} \n", row.Cells["User Name"].Value);
            Console.WriteLine("Changed value:{0}\n", changedValue);
            UserMaster usermasterRef = new UserMaster();

            usermasterRef.userid = Convert.ToInt32(row.Cells["user Id"].Value);
            Console.WriteLine(" *******************************Row value :{0} \n", row.Cells["user Id"].Value);
            RoleMaster role = new RoleMaster();

            role.roleName = Convert.ToString(row.Cells["designation"].Value);
            usermasterRef.designationRef          = role;
            usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            if (e.ColumnIndex == 1)
            {
                MessageBox.Show("User name updated");
                usermasterRef.username = changedValue;
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
            }
            else if (e.ColumnIndex == 2)
            {
                MessageBox.Show("mobile No. updated!!");
                usermasterRef.mobileNo = changedValue;
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
                //
            }
            else if (e.ColumnIndex == 3)
            {
                MessageBox.Show("address updated!!");
                usermasterRef.address  = changedValue;
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
                //  usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            }
            else if (e.ColumnIndex == 4)
            {
                MessageBox.Show("gender updated!!");
                usermasterRef.gender   = changedValue;
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
                //  usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            }
            else if (e.ColumnIndex == 5)
            {
                MessageBox.Show("emailId updated!!");
                usermasterRef.emailId  = changedValue;
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
                //  usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            }
            else if (e.ColumnIndex == 6)
            {
                MessageBox.Show("dob updated!!");
                usermasterRef.dob      = Convert.ToDateTime(changedValue);
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.pwd      = Convert.ToString(row.Cells["password"].Value);
                //  usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            }
            else if (e.ColumnIndex == 7)
            {
                MessageBox.Show("pwd updated!!");
                usermasterRef.pwd      = (changedValue);
                usermasterRef.username = Convert.ToString(row.Cells["User Name"].Value);
                usermasterRef.mobileNo = Convert.ToString(row.Cells["Mobile No"].Value);
                usermasterRef.address  = Convert.ToString(row.Cells["Address"].Value);
                usermasterRef.gender   = Convert.ToString(row.Cells["gender"].Value);
                usermasterRef.emailId  = Convert.ToString(row.Cells["Email Id"].Value);
                usermasterRef.dob      = Convert.ToDateTime(row.Cells["DOB"].Value);
                //   usermasterRef.designationRef.roleName = Convert.ToString(row.Cells["designation"].Value);
            }

            UserMasterDao userMasterDaoRef = new UserMasterDAOImpl();

            userMasterDaoRef.updateUser(usermasterRef);
        }
コード例 #17
0
        private void dataGridUser_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
        {
            int           rowIndex        = e.Row.GetIndex();
            UserMaster    usrMasterRef    = new UserMaster();
            UserMasterDAO usrMasterDAORef = new UserMasterDAOImpl();

            var col = dataGridUser.CurrentColumn.DisplayIndex;

            var changedValue = dataGridUser.Columns[col].GetCellContent(e.Row);

            Console.WriteLine("\n\n\nvalue changed:{0}", changedValue);
            FrameworkElement element_1 = (dataGridUser.Columns[0].GetCellContent(e.Row));
            var userId = ((TextBlock)element_1).Text;

            usrMasterRef.userid = Convert.ToInt32(userId);


            Console.WriteLine("\n+\nUser Id={0}", usrMasterRef.userid);
            //usrMasterRef.userid = Convert.ToInt32(dataGridUser.Columns[0].GetCellContent(e.Row));
            RoleMaster roleMasteRef = new RoleMaster();


            FrameworkElement element_username = (dataGridUser.Columns[1].GetCellContent(e.Row));

            Console.WriteLine("****************************************************");
            var username = "";

            if (col == 1)
            {
                username = ((TextBox)element_username).Text;
            }
            else
            {
                username = ((TextBlock)element_username).Text;
            }

            usrMasterRef.username = Convert.ToString(username);
            Console.WriteLine("\n\n\nuserName:{0}", usrMasterRef.username);


            FrameworkElement element_mobile = dataGridUser.Columns[2].GetCellContent(e.Row);
            var mobile_no = "";

            if (col == 2)
            {
                mobile_no = ((TextBox)element_mobile).Text;
            }
            else
            {
                mobile_no = ((TextBlock)element_mobile).Text;
            }
            usrMasterRef.mobileNo = mobile_no;
            Console.WriteLine("mobile  No:{0}", usrMasterRef.mobileNo);


            FrameworkElement element_adress = dataGridUser.Columns[3].GetCellContent(e.Row);
            var address = "";

            if (col == 3)
            {
                address = ((TextBox)element_adress).Text;
            }
            else
            {
                address = ((TextBlock)element_adress).Text;
            }
            usrMasterRef.address = Convert.ToString(address);
            Console.WriteLine("address  :{0}", usrMasterRef.address);



            FrameworkElement element_gender = dataGridUser.Columns[4].GetCellContent(e.Row);
            var gender = "";

            if (col == 4)
            {
                gender = ((TextBox)element_gender).Text;
            }
            else
            {
                gender = ((TextBlock)element_gender).Text;
            }
            usrMasterRef.gender = Convert.ToString(gender);
            Console.WriteLine("gender  :{0}", usrMasterRef.gender);



            FrameworkElement element_emailId = dataGridUser.Columns[5].GetCellContent(e.Row);
            var emailId = "";

            if (col == 5)
            {
                emailId = ((TextBox)element_emailId).Text;
            }
            else
            {
                emailId = ((TextBlock)element_emailId).Text;
            }
            usrMasterRef.emailId = Convert.ToString(emailId);
            Console.WriteLine("email ID  :{0}", usrMasterRef.emailId);


            FrameworkElement element2 = dataGridUser.Columns[6].GetCellContent(e.Row);
            var dob = "";

            if (col == 6)
            {
                dob = ((TextBox)element2).Text;
            }
            else
            {
                dob = ((TextBlock)element2).Text;
            }

            usrMasterRef.dob = Convert.ToDateTime(dob);
            Console.WriteLine("dob  :{0}", usrMasterRef.dob);



            FrameworkElement element_pwd = dataGridUser.Columns[7].GetCellContent(e.Row);
            var pwd = "";

            if (col == 7)
            {
                pwd = ((TextBox)element_pwd).Text;
            }
            else
            {
                pwd = ((TextBlock)element_pwd).Text;
            }
            usrMasterRef.pwd = Convert.ToString(pwd);
            Console.WriteLine("pwd  :{0}", usrMasterRef.pwd);



            FrameworkElement element_role = dataGridUser.Columns[8].GetCellContent(e.Row);
            var role = "";

            if (col == 8)
            {
                role = ((TextBox)element_role).Text;
            }
            else
            {
                role = ((TextBlock)element_role).Text;
            }
            roleMasteRef.roleName       = Convert.ToString(role);
            usrMasterRef.designationRef = roleMasteRef;
            Console.WriteLine("role name  :{0}", usrMasterRef.designationRef.roleName);

            usrMasterDAORef.updateUser(usrMasterRef);
        }