public bool BALUpdateVoucher(LINKPayment objPayment)
{
bool status = false;
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
//update tblGRN set status=9
status = objDALPayment.DALVoucherIDStatus(objPayment);
}
catch (Exception ex)
{
}
return(status);
}
public List<LINKPayment> BALGetInvoice(LINKPayment objPayment)
{
List<LINKPayment> listobj = new List<LINKPayment>();
DataTable dt = new DataTable();
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
dt = objDALPayment.DALGetInvoice(objPayment);
for (int i = 0; i < dt.Rows.Count; i++)
{
listobj.Add(ConvertToObjectInvoice(dt.Rows[i]));
}
}
catch (Exception ex)
{
}
return listobj;
}
public List <LINKPayment> BALGetLastPayment(LINKPayment objPayment)
{
List <LINKPayment> listobj = new List <LINKPayment>();
DataTable dt = new DataTable();
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
dt = objDALPayment.DALGetLastPayment(objPayment);
for (int i = 0; i < dt.Rows.Count; i++)
{
listobj.Add(ConvertToObjectLastPayment(dt.Rows[i]));
}
}
catch (Exception ex)
{
}
return(listobj);
}
public int BALGetMAXVoucherID()
{
int getID = 0;
DataTable dt = new DataTable();
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
dt = objDALPayment.DALGetMaxVoucherID();
if (dt.Rows.Count > 0)
{
getID = Convert.ToInt32(dt.Rows[0][0].ToString());
}
}
catch (Exception ex)
{
}
return(getID);
}
public bool BALInsertInvoice(LINKPayment objPayment, List <LINKPayment> objLists)
{
bool status = false;
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
LINKPayment objLink = new LINKPayment();
if (objLists.Count > 0)
{
status = objDALPayment.DALInsertInvoice(objPayment);
if (status)
{
foreach (LINKPayment objList in objLists)
{
objLink.GRNNo = objList.GRNNo;
objLink.InvoiceID = objList.InvoiceID;
status = objDALPayment.DALInsertInvoiceFromGRN(objLink);
//update tblGRN set status=9 MRP DB
if (status)
{
status = objDALPayment.DALGRNStatus(objLink);
}
}
}
if (status)
{
}
}
}
catch (Exception ex)
{
}
return(status);
}
public bool BALUpdateVoucher(LINKPayment objPayment)
{
bool status = false;
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
//update tblGRN set status=9
status = objDALPayment.DALVoucherIDStatus(objPayment);
}
catch (Exception ex)
{
}
return status;
}
public bool BALInsertVoucher(LINKPayment objPayment, List<LINKPayment> objLists)
{
bool status = false;
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
LINKPayment objLink = new LINKPayment();
if (objLists.Count > 0)
{
status = objDALPayment.DALInsertVoucher(objPayment);
if (status)
{
foreach (LINKPayment objList in objLists)
{
objLink.VoucherID = objList.VoucherID;
objLink.InvoiceID = objList.InvoiceID;
status = objDALPayment.DALInsertVoucherFromInvoive(objLink);
if (status)
{
//update tblGRN set status=9
status = objDALPayment.DALInvoiceStatus(objLink);
}
}
}
}
}
catch (Exception ex)
{
}
return status;
}
public int BALGetMAXVoucherID()
{
int getID = 0;
DataTable dt = new DataTable();
try
{
DataAccessHandler.Voucher objDALPayment = new DataAccessHandler.Voucher();
dt = objDALPayment.DALGetMaxVoucherID();
if (dt.Rows.Count > 0)
{
getID = Convert.ToInt32(dt.Rows[0][0].ToString());
}
}
catch (Exception ex)
{
}
return getID;
}