/// <summary>
/// Method to Get ChequeDetails Item
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input.</param>
/// <returns>Returns a ChequeDetails Item</returns>
public ChequeDetailsEn GetItem(ChequeDetailsEn argEn)
{
ChequeDetailsEn loItem = new ChequeDetailsEn();
string sqlCmd = "Select * FROM SAS_ChequeDetails ";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
if (loReader != null)
{
loReader.Read();
loItem = LoadObject(loReader);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loItem);
}
/// <summary>
/// Method to Insert ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is the Input.</param>
/// <returns>Returns a Boolean</returns>
public bool Insert(ChequeDetailsEn argEn)
{
bool lbRes = false;
try
{
string sqlCmd = "INSERT INTO SAS_ChequeDetails(ProcessId,ChequeStartNo,ChequeEndNo) VALUES (@ProcessId,@ChequeStartNo,@ChequeEndNo) ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@ProcessId", DbType.String, argEn.ProcessId);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeStartNo", DbType.String, argEn.ChequeStartNo);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeEndNo", DbType.String, argEn.ChequeEndNo);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Insertion Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Get ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input.ProcessID is Input Property.</param>
/// <returns>Returns List of ChequeDetails</returns>
public List <ChequeDetailsEn> GetList(ChequeDetailsEn argEn)
{
List <ChequeDetailsEn> loEnList = new List <ChequeDetailsEn>();
string sqlCmd = "select * from SAS_ChequeDetails where processid = '" + argEn.ProcessId + "'";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
ChequeDetailsEn loItem = LoadObject(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Delete ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input.ProceddID is Property.</param>
/// <returns>Returns a Boolean</returns>
public bool Delete(ChequeDetailsEn argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM SAS_ChequeDetails WHERE processID = @ProcessID ";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@ProcessID", DbType.String, argEn.ProcessId);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Deletion Failed! No Row has been deleted...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Load ChequeDetails Entity
/// </summary>
/// <param name="argReader">Reader Object is an Input.</param>
/// <returns>Returns Cheques Entity Object.</returns>
private ChequeDetailsEn LoadObject(IDataReader argReader)
{
ChequeDetailsEn loItem = new ChequeDetailsEn();
loItem.ProcessId = GetValue <string>(argReader, "ProcessId");
loItem.ChequeStartNo = GetValue <string>(argReader, "ChequeStartNo");
loItem.ChequeEndNo = GetValue <string>(argReader, "ChequeEndNo");
return(loItem);
}
/// <summary>
/// Method to Update ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is the Input.</param>
/// <returns>Returns a Boolean</returns>
public bool Update(ChequeDetailsEn argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd = "Select count(*) as cnt From SAS_ChequeDetails WHERE ";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader dr = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
if (dr.Read())
{
iOut = clsGeneric.NullToInteger(dr["cnt"]);
}
if (iOut < 0)
{
throw new Exception("Update Failed! No Record Exist!");
}
}
if (iOut != 0)
{
sqlCmd = "UPDATE SAS_ChequeDetails SET ProcessId = @ProcessId, ChequeStartNo = @ChequeStartNo, ChequeEndNo = @ChequeEndNo WHERE ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@ProcessId", DbType.String, argEn.ProcessId);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeStartNo", DbType.String, argEn.ChequeStartNo);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeEndNo", DbType.String, argEn.ChequeEndNo);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Update Failed! No Row has been updated...");
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Get ChequeDetails Item
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input.</param>
/// <returns>Returns a ChequeDetails Item</returns>
public ChequeDetailsEn GetItem(ChequeDetailsEn argEn)
{
try
{
ChequeDetailsDAL loDs = new ChequeDetailsDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input.ProcessID is Input Property.</param>
/// <returns>Returns List of ChequeDetails</returns>
public List <ChequeDetailsEn> GetList(ChequeDetailsEn argEn)
{
try
{
ChequeDetailsDAL loDs = new ChequeDetailsDAL();
return(loDs.GetList(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Validate ChequeDetails Fields
/// </summary>
/// <param name="argEn">ChequeDetails Entity is an Input</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(ChequeDetailsEn argEn)
{
try
{
if (argEn.ProcessId == null || argEn.ProcessId.ToString().Length <= 0)
{
throw new Exception("ProcessId Is Required!");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Delete Cheques Batch
/// </summary>
/// <param name="argEn">Cheques Entity is the Input.ProcessID is the Input Property.</param>
/// <returns>Returns a Boolean</returns>
public bool BatchDelete(ChequeEn argEn)
{
bool lbRes = false;
List <ChequeDetailsEn> loChDetails = new List <ChequeDetailsEn>();
string sqlCmd = "Select * from SAS_Cheque WHERE ProcessID = @ProcessID";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmdSel = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmdSel, "@ProcessID", DbType.String, argEn.ProcessID);
_DbParameterCollection = cmdSel.Parameters;
if (!FormHelp.IsBlank(sqlCmd))
{
ChequeDetailsDAL loObjChequeDAL = new ChequeDetailsDAL();
ChequeDetailsEn loItem = null;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmdSel,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
loItem = new ChequeDetailsEn();
loItem.ProcessId = GetValue <string>(loReader, "ProcessID");
loChDetails.Add(loItem);
loItem = null;
loReader.Close();
}
int i = 0;
//deleting each item in batch
for (i = 0; i < loChDetails.Count; i++)
{
loObjChequeDAL.Delete(loChDetails[i]);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
Delete(argEn);
return(lbRes);
}
/// <summary>
/// Method to Update ChequeDetails
/// </summary>
/// <param name="argEn">ChequeDetails Entity is the Input.</param>
/// <returns>Returns a Boolean</returns>
public bool Update(ChequeDetailsEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
ChequeDetailsDAL loDs = new ChequeDetailsDAL();
flag = loDs.Update(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
/// <summary>
/// Method to Get refund Cheques
/// </summary>
/// <param name="argEn">Cheques Entity is an Input.ProcessID is Input Property.</param>
/// <returns>Returns List of Cheques</returns>
public List <ChequeEn> GetRefundList(ChequeEn argEn)
{
List <ChequeEn> loEnList = new List <ChequeEn>();
argEn.ProcessID = argEn.ProcessID.Replace("*", "%");
string sqlCmd = "SELECT SAS_Cheque.*, SAS_Accounts.TransCode, SAS_Cheque.PaymentNo, SAS_Accounts.BankCode,SAS_Accounts.transid,SAS_Accounts.BatchCode FROM SAS_Cheque INNER JOIN SAS_Accounts ON SAS_Cheque.PaymentNo = SAS_Accounts.BatchCode where SAS_Cheque.PaymentType = '" + argEn.PaymentType + "' and SAS_Cheque.PrintStatus = '" + argEn.PrintStatus + "'";
if (argEn.ProcessID.Length != 0)
{
sqlCmd = sqlCmd + " AND ProcessID LIKE '" + argEn.ProcessID + "'";
}
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType,
DataBaseConnectionString, sqlCmd).CreateDataReader())
{
while (loReader.Read())
{
ChequeDetailsDAL dscheDetials = new ChequeDetailsDAL();
ChequeDetailsEn locheDetials = new ChequeDetailsEn();
ChequeEn loItem = LoadObject(loReader);
locheDetials.ProcessId = loItem.ProcessID;
loItem.ChequeDetailslist = dscheDetials.GetList(locheDetials);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
