// constructor public EmployeeViewModel() { dhEmployee objEmployee = new dhEmployee(); // ListEmptloye = iFacede.GetEmployee(Globalized.ObjDbName, objEmployee).AsEnumerable().ToObservableCollection<dhEmployee>(); dsGeneral.dtEmployeeDataTable dtEmployee = iFacede.GetEmployee(Globalized.ObjDbName, objEmployee); ListEmptloye = DataHolders.ReflectionUtility.DataTableToObservableCollection <dhEmployee>(dtEmployee); }
/// <summary> /// Gets the employee. /// </summary> /// <param name="objDBName">Name of the obj DB.</param> /// <param name="objEmployee">The obj employee.</param> /// <returns></returns> public dsGeneral.dtEmployeeDataTable GetEmployee(dhDBnames objDBName, dhEmployee objEmployee) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objEmployee, "xmlGetEmployee", (DataSet)ds, "dtEmployee"); dsGeneral.dtEmployeeDataTable retdt = ((dsGeneral)dsreturn).dtEmployee; return(retdt); }
private void loadData(dhEmployee objEmployee, Boolean ShowResultCount = false) { dsGeneral.dtEmployeeDataTable dtEmployee = iFacede.GetEmployee(Globalized.ObjDbName, objEmployee); sequence = ReflectionUtility.DataTableToObservableCollection <dhEmployee>(dtEmployee); EmployeeList.ItemsSource = sequence; // pageControl.PageContract = null; //pageControl.PageContract = this; Globalized.ShowMsg(lblErrorMsg); // show msg for local search if ((ShowResultCount) && (sequence != null)) { String msg = String.Format(" {0} Search Results Found", sequence.Count); //pageControl.ReLoad(); Globalized.setException(msg, lblErrorMsg, DataHolders.MsgType.Info); } }
//private static void HideProgressBarfrm() //{ // if (objModernWindow != null) // { // ProgressBar ProgressBarfrm = FindChildByType<ProgressBar>(objModernWindow); // ProgressBarfrm.Visibility = Visibility.Hidden; // } //} //private static void ShowProgressBarfrm() //{ // if (objModernWindow != null) // { // ProgressBar ProgressBarfrm = FindChildByType<ProgressBar>(objModernWindow); // ProgressBarfrm.Visibility = Visibility.Visible; // } //} public static dsGeneral.dtEmployeeDataTable GetEmployee(dhDBnames objDBNames, dhEmployee objEmployee) { try { // // ShowProgressBarfrm(); dsGeneral.dtEmployeeDataTable var_ret = new dsGeneral.dtEmployeeDataTable(); if (objBLEmployee == null) { objBLEmployee = new blEmployee(); } var_ret = objBLEmployee.GetEmployee(objDBNames, objEmployee); //// HideProgressBarfrm(); return(var_ret); } catch (Exception ex) { throw ex; } }
private void Stock_MouseDoubleClick(object sender, MouseButtonEventArgs e) { if (sender != null) { DataGridRow dgr = sender as DataGridRow; // get the obect and then Invoice ID opne the Id in readonly mode dhEmployee objTodisplay = new dhEmployee(); objTodisplay.IEmpid = ((dhEmployee)dgr.Item).IEmpid; dsGeneral.dtEmployeeDataTable dtEmployee = iFacede.GetEmployee(Globalized.ObjDbName, objTodisplay); ObservableCollection <dhEmployee> listItem = ReflectionUtility.DataTableToObservableCollection <dhEmployee>(dtEmployee); if (listItem.Count > 0) { objTodisplay = listItem.Cast <dhEmployee>().Where(i => i.IEmpid.Equals(objTodisplay.IEmpid)).SingleOrDefault(); objTodisplay.IUpdate = 1; AddTabItem(objTodisplay); } } }
private void ConstructResultSet() { dhEmployee objEmployee = new dhEmployee(); dsGeneral.dtEmployeeDataTable dt = iFacede.GetEmployee(Globalized.ObjDbName, objEmployee); _results = new List <dhEmployee>(); foreach (DataRow row in dt.Rows) { _results.Add(new dhEmployee { IEmpid = Convert.ToInt32(row["iEmpid"]), VEmpfName = Convert.ToString(row["vEmpfName"]), IMobile = Convert.ToString(row["iMobile"]), VEmployeeInfo = Convert.ToString(row["vEmpfName"]) + " , " + Convert.ToString(row["VAddress"]) + " , " + Convert.ToString(row["iMobile"]), //VItemName = Convert.ToString(row["VItemName"]), //FMaxDiscountPresent = Convert.ToDouble(row["fMaxDiscountPresent"]), //VEmployeeMobile = Convert.ToString(row["VEmployeeMobile"]), //VEmployeeName = Convert.ToString(row["ReadingInches"]), }); } }
private void Button_Click(object sender, RoutedEventArgs e) { try { dhEmployee objEmployee = new dhEmployee(); objEmployee = (dhEmployee)EmpInfo.DataContext; objEmployee.VMartialStatus = VMartialStatus.SelectedValue.ToString(); int IIEmpid; if (cmbIEmpTypeId.SelectedValue != null) { int.TryParse(cmbIEmpTypeId.SelectedValue.ToString(), out IIEmpid); objEmployee.IEmpTypeId = IIEmpid; } else { objEmployee.IEmpTypeId = 1; objEmployee.IEmpTypeId = 1; } // check for existing Name dhEmployeeValidator validator = new dhEmployeeValidator(); FluentValidation.Results.ValidationResult results = validator.Validate(objEmployee); bool validationSucceeded = results.IsValid; IList <ValidationFailure> failures = results.Errors; if (validationSucceeded) { dsGeneral.dtEmployeeDataTable dtEmployee = iFacede.GetEmployee(Globalized.ObjDbName, new dhEmployee()); ObservableCollection <dhEmployee> listItem = ReflectionUtility.DataTableToObservableCollection <dhEmployee>(dtEmployee); string bFound = null; //if ((this.vEmployeeNameTextBox.Text!= "") && (item.VEmployeeName != "")) { } //foreach (dhEmployee item in ListAccounts) //{ // string[] words = item.VEmployeeName.Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); // string[] filter = objEmployee.VEmployeeName.ToLower().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); // if ((objEmployee.IEmployeeID != null) && (item.IEmployeeID == objEmployee.IEmployeeID)) // { // continue; // } // bFound = words.Where(x => filter.Contains(x.ToLower())).FirstOrDefault(); // if (bFound != null) // { // break; // } //} //if (bFound != null) //{ // if (!blUtil.OverrideInformation(objEmployee.VEmployeeName, bFound)) // { // this.vEmployeeNameTextBox.SelectAll(); // this.vEmployeeNameTextBox.Focus(); // return; // } //} //if (iSaleManIDComboBox.SelectedValue != null) //{ // objEmployee.ISaleManID = Convert.ToInt32(iSaleManIDComboBox.SelectedValue.ToString()); //} // objEmployee.VCity = VMartialStatus.SelectedValue.ToString(); // objEmployee.VEmployeeadress = objEmployee.VMarket + " , " + objEmployee.VArea + " , " + objEmployee.VDistrict + " , " + objEmployee.VCity; //lblErrorMsg.Visibility = Visibility.Hidden; DataSet dsr = iFacede.InsertUpdateEmployee(Globalized.ObjDbName, objEmployee); if (dsr.Tables[0].Rows.Count > 0) { objEmployee.IEmpid = Convert.ToInt32(dsr.Tables[0].Rows[0][0].ToString()); } if (objEmployee.IUpdate == 1) { //lblErrorMsg.Visibility = Visibility.Visible; //lblErrorMsg.Foreground = Brushes.Green; //lblErrorMsg.Content = "Employee ' " + objEmployee.VEmployeeName + " ' Information is Updated Successfully"; Globalized.SetMsg("Employee ' " + objEmployee.VEmpfName + " ' Information is Updated Successfully", DataHolders.MsgType.Info); // Globalized.ShowMsg(lblErrorMsg); GlobalObjEmployee = objEmployee; // We need to get data from database to bind it back LoadData(); // LoadData(); } else { Globalized.SetMsg("Employee ' " + objEmployee.VEmpfName + " ' Information is Saved Successfully", DataHolders.MsgType.Info); objEmployee.IUpdate = 1; GlobalObjEmployee = objEmployee; // We need to get data from database to bind it back LoadData(); // ModernWindow Obj = (ModernWindow)Application.Current.MainWindow; // GlobalObjEmployee = null; // Obj.ContentSource = new Uri("/Pages/emp/listEmp.xaml", UriKind.Relative); } } else { System.Media.SystemSounds.Beep.Play(); lblErrorMsg.Visibility = Visibility.Visible; lblErrorMsg.Foreground = Brushes.Red; lblErrorMsg.Content = failures.First().ErrorMessage; } //Globalized.ShowMsg(lblErrorMsg); } catch (Exception ex) { Globalized.setException(ex, lblErrorMsg, MsgType.Error); } }
public dsGeneral.dtEmployeeDataTable GetEmployee(dhDBnames objDBNames, dhEmployee objEmployee) { dsGeneral.dtEmployeeDataTable dt = objDALGeneral.GetEmployee(objDBNames, objEmployee); return(dt); }