public DataSet InsertUpdateEmployee(dhDBnames objDBNames, dhEmployee objEmployee)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateEmployee(objDBNames, objEmployee);
return(ds);
}
private void AddTabItem(dhEmployee objTodisplay)
{
// create new tab item
TabItem tab = new TabItem();
tab.Header = string.Format(objTodisplay.VEmpfName);
tab.Name = string.Format("Employee{0}", objTodisplay.IEmpid);
tab.HeaderTemplate = tabDynamic.FindResource("TabHeader") as DataTemplate;
// tab.MouseDoubleClick += new MouseButtonEventHandler(tab_MouseDoubleClick);
AddEmployeeView wintoOpen = new AddEmployeeView(objTodisplay);
tab.Content = wintoOpen;
tab.IsSelected = true;
var item = tabDynamic.Items.Cast <TabItem>().Where(i => i.Name.Equals(tab.Name)).SingleOrDefault();
if (item == null)
{
tabDynamic.Items.Add(tab);// tabDynamic.Items.Remove(item);
}
else
{
item.IsSelected = true;
}
// tabDynamic.DataContext = _tabItems;
}
/// <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);
}
// 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);
}
public AddEmployeeView(dhEmployee objTodisplay)
{
InitializeComponent();
MyViewModel = new AddEmployeeViewModel(objTodisplay);
// InitializeComponent();
this.GlobalObjEmployee = new dhEmployee();
this.GlobalObjEmployee = objTodisplay;
this.EmpInfo.DataContext = this.GlobalObjEmployee;
this.AccountInfo.DataContext = MyViewModel.EmployeeAccount;
}
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);
}
}
public static DataSet InsertUpdateEmployee(dhDBnames objDBNames, dhEmployee objEmployee)
{
try
{
DataSet var_ret;
if (objBLEmployee == null)
{
objBLEmployee = new blEmployee();
}
var_ret = objBLEmployee.InsertUpdateEmployee(objDBNames, objEmployee);
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 LoadData()
{
VMartialStatus.DataContext = GetTable();
cmbIEmpTypeId.DataContext = GetEmType();
VMartialStatus.DisplayMemberPath = "MartialStatus";
VMartialStatus.SelectedValuePath = "MartialStatus";
cmbIEmpTypeId.DisplayMemberPath = "vEmpType";
cmbIEmpTypeId.SelectedValuePath = "iEmpTypeId";
if ((GlobalObjEmployee != null) && (GlobalObjEmployee.IEmpid > 0))
{
EmpInfo.DataContext = GlobalObjEmployee;
VMartialStatus.SelectedValue = GlobalObjEmployee.VMartialStatus;
cmbIEmpTypeId.SelectedValue = GlobalObjEmployee.IEmpTypeId;
if (GlobalObjEmployee.Active != true)
{
SalleryBox.IsEnabled = false;
}
else
{
SalleryBox.IsEnabled = true;
}
//else
//{
// SalleryBox.DataContext = new dhSalary();
//}
BindSalary();
}
else
{
GlobalObjEmployee = new dhEmployee();
EmpInfo.DataContext = GlobalObjEmployee;
SalleryBox.IsEnabled = false;
}
MyViewModel.ObjAddEdit = GlobalObjEmployee;
MyViewModel.EmployeeAccount = Globalized.GetAccountByMdule(MyViewModel.db, MyViewModel.ObjAddEdit.IEmpid, MyViewModel.MyModuel.IModuleID);
this.AccountInfo.DataContext = MyViewModel.EmployeeAccount;
Globalized.ShowMsg(lblErrorMsg);
}
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 AddEmployeeViewModel(dhEmployee objEmp)
{
this.ObjAddEdit = new dhEmployee();
this.MyModuel = Globalized.ActiveModule(this.db, MyName, 0);
this.EmployeeAccount = Globalized.GetAccountByMdule(this.db, objEmp.IEmpid, MyModuel.IModuleID);
}
//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; }
}
public dsGeneral.dtEmployeeDataTable GetEmployee(dhDBnames objDBNames, dhEmployee objEmployee)
{
dsGeneral.dtEmployeeDataTable dt = objDALGeneral.GetEmployee(objDBNames, objEmployee);
return(dt);
}
public DataSet InsertUpdateEmployee(dhDBnames objDBName, dhEmployee objEmployee)
{
DataSet dsreturn = objDatabase.GetDataSet(objDBName, objEmployee, "xmlInsertUpdateEmployee");
return(dsreturn);
}
public EmployeeViewModel(dhEmployee ObjToDisplay)
{
}
// constructor
public AddEmployeeViewModel()
{
this.ObjAddEdit = new dhEmployee();
this.MyModuel = Globalized.ActiveModule(this.db, MyName, 0);
}
