/// <summary>
/// Creating master entries for GL Updating
/// </summary>
/// <param name="type"> 0- Cash, 1- Cheque, 2- Transfer</param>
public object CreateMasterEntry(int type, object nextNoObj)
{
object retObj;
retObj = new object();
switch (type)
{
case 0:
cashnn = new CashNN();
cashnn = (CashNN)nextNoObj;
cashnn = InsertCashMaster(cashnn);
retObj = cashnn;
break;
case 1:
chqnn = new ChequeNN();
chqnn = (ChequeNN)nextNoObj;
chqnn = InsertChequeMaster(chqnn);
retObj = chqnn;
break;
case 2:
trnn = new TransferNN();
trnn = (TransferNN)nextNoObj;
trnn = InsertTransferMaster(trnn);
retObj = trnn;
break;
}
//strsql = " ";
return(retObj);
}
public TransferNN GetTransferLastNo()
{
TransferNN trLast = new TransferNN();
strsql = "Select top 1 * from indCA Order by Ind Desc";
table = db.GetDataTable(strsql, DBAccess.GL);
if (table.Rows.Count == 1)
{
trLast.ind = int.Parse(table.Rows[0]["ind"].ToString());
trLast.ws = table.Rows[0]["ws"].ToString();
trLast.st = DateTime.Parse(table.Rows[0]["st"].ToString());
}
return(trLast);
}
/// <summary>
/// Transfer master entry
/// </summary>
/// <param name="trnn"></param>
/// <returns>Transfer object</returns>
private TransferNN InsertTransferMaster(TransferNN trnn)
{
// throw new NotImplementedException();
trnn.ws = Environment.MachineName + DateTime.Now.ToShortTimeString().Trim();
strsql = "Insert into indTR Values ('" + trnn.ws + "',GETDATE())";
db = new DBAccess();
db.ExecuteQuery(strsql, DBAccess.GL);
//strsql = "Select top 1 * from indCA Order by Ind Desc";
//table = db.GetDataTable(strsql, DBAccess.GL);
//if (table.Rows.Count == 1)
//{
// trnn.ind = int.Parse(table.Rows[0]["ind"].ToString());
// trnn.ws = table.Rows[0]["ws"].ToString();
// trnn.st = DateTime.Parse(table.Rows[0]["st"].ToString());
//}
trnn = GetTransferLastNo();
return(trnn);
}
