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