public dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
{
dsGeneral ds = new dsGeneral();
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objJournal, "xmlGetJournal", (DataSet)ds, "dtPosJournal");
dsGeneral.dtPosJournalDataTable retdt = ((dsGeneral)dsreturn).dtPosJournal;
return(retdt);
}
public static DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal, dhJournalDetail CRDetail, dhJournalDetail DRDetail)
{
try
{
DataSet var_ret;
if (objblJournal == null)
{
objblJournal = new blJournal();
}
var_ret = objblJournal.InsertUpdateJournal(objDBNames, objJournal, CRDetail, DRDetail);
return(var_ret);
}
catch (Exception ex) { throw ex; }
}
public DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal, dhJournalDetail CRDetail, dhJournalDetail DRDetail)
{
DataSet ds;
ds = objDALGeneral.InsertUpdateJournal(objDBNames, objJournal);
if ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0))
{
int?ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ijournalid"].ToString());;
//DateTime ddate = (DateTime)(ds.Tables[0].Rows[0]["ddate"]); ;
if (objJournal.CRList != null)
{
JournalDetailList ItemCollection = objJournal.CRList;
foreach (dhJournalDetail item in ItemCollection)
{
CRDetail.IJournalId = ID;
CRDetail.IAccountID = item.IAccountID;
CRDetail.FAmount = item.FAmount;
CRDetail.IUpdate = objJournal.IUpdate;
CRDetail.VTransactionType = "CR";
DataSet dsitem = InsertUpdateJournalDetail(objDBNames, CRDetail);
}
}
if (objJournal.DrList != null)
{
JournalDetailList ItemCollection = objJournal.DrList;
foreach (dhJournalDetail item in ItemCollection)
{
DRDetail.IJournalId = ID;
DRDetail.IAccountID = item.IAccountID;
DRDetail.FAmount = item.FAmount;
DRDetail.IUpdate = objJournal.IUpdate;
DRDetail.VTransactionType = "DR";
DataSet dsitem = InsertUpdateJournalDetail(objDBNames, DRDetail);
}
}
}
return(ds);
// return ds;
}
//private DataSet InsertUpdateJournalItem(dhDBnames objDBNames, dhJournalDetail item)
//{
// DataSet ds;
// ds = objDALGeneral.InsertUpdateJournalItem(objDBNames, item);
// return ds;
//}
public dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
{
dsGeneral.dtPosJournalDataTable dt = objDALGeneral.GetJournal(objDBNames, objJournal);
return(dt);
}
public static dsGeneral.dtPosJournalDataTable GetJournal(dhDBnames objDBNames, dhJournal objJournal)
{
try
{
dsGeneral.dtPosJournalDataTable var_ret;
if (objblJournal == null)
{
objblJournal = new blJournal();
}
var_ret = objblJournal.GetJournal(objDBNames, objJournal);
return(var_ret);
}
catch (Exception ex) { throw ex; }
}
public DataSet InsertUpdateJournal(dhDBnames objDBNames, dhJournal objJournal)
{
DataSet dsreturn = objDatabase.GetDataSet(objDBNames, objJournal, "xmlInsertUpdateJournal");
return(dsreturn);
}