internal DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.CheckItemInvoiced(objDBNames, objInvoice);
return(ds);
}
private void UserControl_Loaded_1(object sender, RoutedEventArgs e)
{
dhInvoice objInvoice = new dhInvoice();
// loadData(objInvoice);
}
internal DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.RemoveSaleInovice(dhDBnames, objInvoice);
return(ds);
}
public DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateSaleInovice(objDBNames, objInvoice);
return(ds);
}
public DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet ds;
ds = objDALGeneral.GetSaleInovice(objDBNames, objInvoice);
return(ds);
}
//= new ObservableCollection<dhParty>();
public InvoicesViewModel()
{
DisplayName = "Invoices";
dhInvoice objLoad = new dhInvoice();
this.loadData(objLoad);
}
public static DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet var_ret;
if (objblInvoice == null)
{
objblInvoice = new blInvoice();
}
{
var_ret = objblInvoice.CheckItemInvoiced(objDBNames, objInvoice);
}
return(var_ret);
}
//public static DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice, Boolean InsertItems = false)
//{
// try
// {
// DataSet var_ret;
// if (objblInvoice == null) { objblInvoice = new blInvoice(); }
// var_ret = objblInvoice.InsertUpdateSaleInovice(objDBNames, objInvoice);
// if (InsertItems)
// {
// // get the SaleID
// long ID = Convert.ToInt64(var_ret.Tables[0].Rows[0]["iSaleid"].ToString()); ;
// // get the observerable collection
// ItemsList ItemCollection = objInvoice.ItemsOfInvoice;
// int ItemID = 1;
// // check is it draft
// if (objInvoice.BIsDraft == true)
// {
// // check if the item are there already
// if ((var_ret.Tables.Count == 1) && (var_ret.Tables["dtPosSaleItem"].Rows.Count > 0))
// {
// ObservableCollection<dhSaleItem> objlist = ReflectionUtility.DataTableToObservableCollection<dhSaleItem>(var_ret.Tables["dtPosSaleItem"]);
// //ItemsList ToDelete = objlist.ToObservableCollectio();
// //List<dhSaleItem> abc = (List<dhSaleItem>)ItemCollection;
// foreach (dhSaleItem item in ItemCollection)
// {
// item.ISaleid = ID;
// //int.TryParse(
// item.IUpdate = !string.IsNullOrEmpty(objInvoice.IUpdate.ToString()) ? objInvoice.IUpdate : 0;
// // item.ISerialNumber = ItemID;
// ItemID = ItemID + 1;
// item.IUserId = Convert.ToInt32(objInvoice.IUserid);
// if (objblInvoice == null) { objblInvoice = new blInvoice(); }
// {
// var_ret = objblInvoice.InsertUpdateSaleInoviceItem(objDBNames, item);
// }
// }
// //foreach (dhSaleItem item in objlist)
// //{
// //}
// }
// }
// }
// return var_ret;
// }
// catch (Exception ex) { throw ex; }
//}
public static DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet var_ret;
if (objblInvoice == null)
{
objblInvoice = new blInvoice();
}
{
var_ret = objblInvoice.GetSaleInovice(objDBNames, objInvoice);
}
return(var_ret);
}
public DataSet GetSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objInvoice, "xmlGetSaleInovice");
if ((dsreturn.Tables.Count > 0) && (dsreturn.Tables.Count == 1))
{
dsreturn.Tables[0].TableName = "dtPosSaleInovice";
}
else if ((dsreturn.Tables.Count > 0) && (dsreturn.Tables.Count == 2))
{
dsreturn.Tables[0].TableName = "dtPosSaleInovice";
dsreturn.Tables[1].TableName = "dtPosSaleItem";
}
return(dsreturn);
}
public static DataSet InsertUpdateSaleInovice(dhDBnames objDBNames, dhInvoice objInvoice, Boolean InsertItems = false)
{
try
{
DataSet var_ret, ItemDs;
if (objblInvoice == null)
{
objblInvoice = new blInvoice();
}
var_ret = objblInvoice.InsertUpdateSaleInovice(objDBNames, objInvoice);
if (InsertItems)
{
// get the SaleID
long ID = Convert.ToInt64(var_ret.Tables[0].Rows[0]["iSaleid"].ToString());;
// get the observerable collection
ItemsList ItemCollection = objInvoice.ItemsOfInvoice;
int ItemID = 1;
foreach (dhSaleItem item in ItemCollection)
{
item.ISaleid = ID;
if (item.ISaleItemid != 0)
{
item.IUpdate = !string.IsNullOrEmpty(objInvoice.IUpdate.ToString()) ? objInvoice.IUpdate : 0;
}
else
{
item.IUpdate = 0;
}
ItemID = ItemID + 1;
item.IUserId = Convert.ToInt32(objInvoice.IUserid);
if (objblInvoice == null)
{
objblInvoice = new blInvoice();
}
{
ItemDs = objblInvoice.InsertUpdateSaleInoviceItem(objDBNames, item);
}
}
}
return(var_ret);
}
catch (Exception ex) { throw ex; }
}
private TabItem AddTabItem()
{
int count = _tabItems.Count;
TabItem tab = new TabItem();
// tab.Header = "Add Invoice";//string.Format("Tab {0}", count);
//tab.Name = "AddInvoice";//string.Format("tab{0}", count);
tab.Header = string.Format("Lift {0}", TabCounter + 1);//string.Format("Tab {0}", count);
tab.Name = string.Format("Lift{0}", TabCounter);
tab.HeaderTemplate = tabDynamic.FindResource("TabHeader") as DataTemplate;
dhInvoice NewItem = new dhInvoice();
// NewItem
tab.Content = new EmptyInvoiceView();
_tabItems.Insert(count - 1, tab);
TabCounter++;
return(tab);
}
public static DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice)
{
try
{
DataSet var_ret;
if (objblInvoice == null)
{
objblInvoice = new blInvoice();
}
var_ret = objblInvoice.RemoveSaleInovice(dhDBnames, objInvoice);
return(var_ret);
}
catch (Exception)
{
throw;
}
}
private void Invoices_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
dhInvoice objTodisplay = new dhInvoice();
objTodisplay.ISaleid = ((dhInvoice)dgr.Item).ISaleid;
DataSet dsr = iFacede.GetSaleInovice(Globalized.ObjDbName, objTodisplay);
objTodisplay = (dhInvoice)dgr.Item;
if ((dsr.Tables.Count > 0) && (dsr.Tables[0].Rows.Count > 0))
{
ObservableCollection <dhInvoice> objlist = ReflectionUtility.DataTableToObservableCollection <dhInvoice>(dsr.Tables[0]);
objTodisplay = (dhInvoice)objlist.SingleOrDefault();
}
if ((dsr.Tables.Count > 0) && (dsr.Tables[1].Rows.Count > 0))
{
ObservableCollection <dhSaleItem> listItem = ReflectionUtility.DataTableToObservableCollection <dhSaleItem>(dsr.Tables[1]);
ItemsList itemlist = new ItemsList().AddRange(listItem);
objTodisplay.ItemsOfInvoice = itemlist;
}
//DataSet dsr = iFacede.GetSaleInovice(Globalized.ObjDbName, objTodisplay);
//ObservableCollection<dhSaleItem> ListAccounts = ReflectionUtility.DataTableToObservableCollection<dhSaleItem>(dsr.Tables[1]);
//ItemsList itemlist = new ItemsList().AddRange(ListAccounts);
//objTodisplay = (dhInvoice)dgr.Item;
if (objTodisplay.BIsDraft != true)
{
objTodisplay.IsReadOnly = true;
}
else
{
objTodisplay.IsReadOnly = false;
}
// AddTabItem(objTodisplay);
}
}
public DataSet RemoveSaleInovice(dhDBnames dhDBnames, dhInvoice objInvoice)
{
DataSet dsreturn = objDatabase.GetDataSet(dhDBnames, objInvoice, "xmlRemoveSaleInovice");
return(dsreturn);
}
public DataSet CheckItemInvoiced(dhDBnames objDBNames, dhInvoice objInvoice)
{
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objInvoice, "xmlCheckItemInvoiced");
return(dsreturn);
}
private void loadData(dhInvoice objInovice /* , Boolean ShowResultCount = false*/)
{
DataSet dtInovice = iFacede.GetSaleInovice(Globalized.ObjDbName, objInovice);
Invoices = ReflectionUtility.DataTableToObservableCollection <dhInvoice>(dtInovice.Tables[0]);
}
