public string GenerateSO(LP_GenerateTransNumber_Property objtransno)
{
string TransactionNumber = "";
_objPurchaseDAL = new LP_SalesOrder_DAL();
DataTable dt = _objPurchaseDAL.GenerateSONo(objtransno);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
TransactionNumber = dr["TransNumber"].ToString();
TransactionNumber = "SO-00" + (int.Parse(TransactionNumber) + 1) + "-" + objtransno.userid;
}
return(TransactionNumber);
}
else
{
TransactionNumber = "SO-001-" + objtransno.userid;
return(TransactionNumber);
}
}
public DataTable SelectSIByDate(LP_Voucher_ViewModel objvoucherinvoice)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.SelectSIBYDate(objvoucherinvoice));
}
public DataTable SelectOne(int productIdx)
{
_objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty);
return(_objPurchaseDAL.SelectOne());
}
public DataTable SelectAllSalesInvoiceDetails(int id)
{
_objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty);
return(_objPurchaseDAL.SelectAllInvoiceDetails(id));
}
public DataTable GetStockandPrice(int productid)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.GetStockandPrice(productid));
}
public DataTable SelectAll()
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.SelectAll());
}
public bool Insert()
{
_objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty);
return(_objPurchaseDAL.Insert());
}
public bool ProcessSalesInvoice()
{
_objPurchaseDAL = new LP_SalesOrder_DAL(_objSOMasterProperty);
return(_objPurchaseDAL.ProcessSalesInvoice());
}
public DataSet SelectSIWithDetailData(int id)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.SelectAllSIDetailsDataById(id));
}
public DataTable CheckProductInInventory(int salesIdx)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.getSalesForReturn(salesIdx));
}
public DataTable SelectSalesForSalesReturn(int salesIdx)
{
_objPurchaseDAL = new LP_SalesOrder_DAL();
return(_objPurchaseDAL.getSalesForReturn(salesIdx));
}
