// 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);
}
