/// <summary>
/// Method to Delete FeeCharges
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Delete(FeeChargesEn argEn)
{
bool lbRes = false;
string sqlCmd = "DELETE FROM SAS_FeeCharges WHERE SAFT_Code = @SAFT_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.FTCode);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Delete Failed! No Row has been updated...");
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
/// <summary>
/// Method to Get List of KokoCharges
/// </summary>
/// <param name="argEn">KokoCharges Entity is an Input.FTCode is an Input Property</param>
/// <returns>Returns List of KokoCharges</returns>
public List <FeeChargesEn> GetKokoCharges(FeeChargesEn argEn)
{
List <FeeChargesEn> loEnList = new List <FeeChargesEn>();
string sqlCmd = "SELECT SAKOD_CategoryCode, SAKOD_FeeAmount, SAKO_Code,SAKOD_CategoryName FROM SAS_KokorikulumDetails WHERE " +
"SAKO_Code =@SAKO_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKO_Code", DbType.String, argEn.FTCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
while (loReader.Read())
{
FeeChargesEn loItem = LoadObjectKoko(loReader);
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get FeeCharges Entity
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input</param>
/// <returns>Returns FeeCharges Entity</returns>
public FeeChargesEn GetItem(FeeChargesEn argEn)
{
FeeChargesEn loItem = new FeeChargesEn();
string sqlCmd = "Select * FROM SAS_FeeCharges WHERE SAFT_Code = @SAFT_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.FTCode);
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
if (loReader != null)
{
loReader.Read();
loItem = LoadObject(loReader);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loItem);
}
/// <summary>
/// Method to Load FeeCharges Entity
/// </summary>
/// <param name="argReader">IDataReader Object is an Input.</param>
/// <returns>Returns FeeCharges Entity</returns>
private FeeChargesEn LoadObjectKoko(IDataReader argReader)
{
FeeChargesEn loItem = new FeeChargesEn();
loItem.SCCode = GetValue <string>(argReader, "SAKOD_CategoryCode");
loItem.FSAmount = GetValue <double>(argReader, "SAKOD_FeeAmount");
loItem.SCDesc = GetValue <string>(argReader, "SAKOD_CategoryName");
return(loItem);
}
/// <summary>
/// Method to Load FeeCharges Entity
/// </summary>
/// <param name="argReader">IDataReader Object is an Input.</param>
/// <returns>Returns FeeCharges Entity</returns>
private FeeChargesEn LoadObject(IDataReader argReader)
{
FeeChargesEn loItem = new FeeChargesEn();
loItem.FTCode = GetValue <string>(argReader, "SAFT_Code");
loItem.SCCode = GetValue <string>(argReader, "SASC_Code");
loItem.FSAmount = GetValue <double>(argReader, "SAFS_Amount");
return(loItem);
}
/// <summary>
/// Method to Get FeeCharges Entity
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input</param>
/// <returns>Returns FeeCharges Entity</returns>
public FeeChargesEn GetItem(FeeChargesEn argEn)
{
try
{
FeeChargesDAL loDs = new FeeChargesDAL();
return(loDs.GetItem(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Get List of FeeCharges
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input.FTCode is an Input Property</param>
/// <returns>Returns List of FeeCharges</returns>
public List <KokoEn> Getkokobaru(FeeChargesEn argEn)
{
try
{
FeeChargesDAL loDs = new FeeChargesDAL();
return(loDs.Getkokobaru(argEn));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Check Validation
/// </summary>
/// <param name="argEn">FeeCharges Entity is as Input.</param>
/// <returns>Returns a Boolean</returns>
public bool IsValid(FeeChargesEn argEn)
{
try
{
if (argEn.FTCode == null || argEn.FTCode.ToString().Length <= 0)
{
throw new Exception("FTCode Is Required!");
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Method to Insert FeeCharges
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Insert(FeeChargesEn argEn)
{
bool flag;
using (TransactionScope ts = new TransactionScope())
{
try
{
FeeChargesDAL loDs = new FeeChargesDAL();
flag = loDs.Insert(argEn);
ts.Complete();
}
catch (Exception ex)
{
throw ex;
}
}
return(flag);
}
/// <summary>
/// Method to Update FeeCharges
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input.</param>
/// <returns>Returns Boolean</returns>
public bool Update(FeeChargesEn argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd;
try
{
if (iOut == 0)
{
sqlCmd = "UPDATE SAS_FeeCharges SET SAFS_Amount = @SAFS_Amount,SAFS_gstamout=@SAFS_gstamout WHERE SAFT_Code = @SAFT_Code and SASC_Code = @SASC_Code";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.FTCode);
_DatabaseFactory.AddInParameter(ref cmd, "@SASC_Code", DbType.String, argEn.SCCode);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFS_Amount", DbType.Double, argEn.FSAmount);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFS_gstamout", DbType.Double, argEn.GSTAmount);
_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 Insert KokoCharges
///// </summary>
///// <param name="argEn">KokoCharges Entity is an Input.</param>
///// <returns>Returns Boolean</returns>
public bool InsertKokoCharges(FeeChargesEn argEn)
{
bool lbRes = false;
int iOut = 0;
string sqlCmd;
try
{
if (iOut == 0)
{
sqlCmd = "INSERT INTO SAS_KokorikulumDetails(SAKO_Code,SAKOD_CategoryCode,SAKOD_FeeAmount,SAKOD_CategoryName) VALUES (@SAKO_Code,@SAKOD_CategoryCode,@SAKOD_FeeAmount,@SAKOD_CategoryName) ";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKO_Code", DbType.String, argEn.FTCode);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKOD_CategoryCode", DbType.String, argEn.SCCode);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKOD_FeeAmount", DbType.Double, argEn.FSAmount);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKOD_CategoryName", DbType.String, argEn.SCDesc);
_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 List of FeeCharges
/// </summary>
/// <param name="argEn">FeeCharges Entity is an Input.FTCode is an Input Property</param>
/// <returns>Returns List of FeeCharges</returns>
public List <FeeChargesEn> GetFeeCharges(FeeChargesEn argEn)
{
List <FeeChargesEn> loEnList = new List <FeeChargesEn>();
string sqlCmd = "SELECT SAS_FeeCharges.SAFT_Code, SAS_FeeCharges.SASC_Code, SAS_FeeCharges.SAFS_Amount,SAS_FeeCharges.safs_gstamout, SAS_StudentCategory.SASC_Desc " +
" FROM SAS_StudentCategory INNER JOIN SAS_FeeCharges ON SAS_StudentCategory.SASC_Code = SAS_FeeCharges.SASC_Code " +
" WHERE SAS_FeeCharges.SAFT_Code =@SAFT_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAFT_Code", DbType.String, argEn.FTCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
while (loReader.Read())
{
FeeChargesEn loItem = LoadObject(loReader);
loItem.FTCode = GetValue <string>(loReader, "SAFT_Code");
loItem.SCDesc = GetValue <string>(loReader, "SASC_Desc");
loItem.GSTAmount = GetValue <double>(loReader, "safs_gstamout");
loItem.FSAmount = GetValue <double>(loReader, "SAFS_Amount");
loEnList.Add(loItem);
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}
/// <summary>
/// Method to Get List of KokoCharges
/// </summary>
/// <param name="argEn">KokoCharges Entity is an Input.FTCode is an Input Property</param>
/// <returns>Returns List of KokoCharges</returns>
public List <KokoEn> Getkokobaru(FeeChargesEn argEn)
{
List <KokoEn> loEnList = new List <KokoEn>();
string sqlCmd = "select distinct kk.sako_code , kk.sako_description, kk.sako_status," +
" local.sakod_feeamount as sakodfeeamountlocalin,local.sakod_gstin as sakodgstamountlocalin, local.sakod_feeamountout as sakodfeeamountlocalout," +
" local.sakod_gstout as sakodfeegstamountlocalout, nonlocal.sakod_feeamount as sakodfeeamountinterin, nonlocal.sakod_gstin as sakodgstamountinterin, " +
" nonlocal.sakod_feeamountout as sakodfeeamountinterout,nonlocal.sakod_gstout as sakodgstamountinterout, local.sakod_categorycode as LocalCategory," +
" nonlocal.sakod_categorycode as NonLocalCategory,local.saft_code as saft_code,local.saft_taxmode as saft_taxmode from sas_kokorikulum kk inner join sas_feetypes ft on ft.saft_code = saft_code left join (select saft_code,sako_code,sakod_feeamount, sakod_feeamountout, sakod_gstin, sakod_gstout, " +
" safd_type,sakod_categorycode,saft_taxmode from sas_kokorikulumdetails where sas_kokorikulumdetails.sakod_categorycode in ('W') )as local on local.sako_code = kk.sako_code and local.saft_code = ft.saft_code" +
" left join (select saft_code,sako_code,sakod_feeamount, sakod_feeamountout, sakod_gstin, sakod_gstout,safd_type, sakod_categorycode,saft_taxmode from sas_kokorikulumdetails " +
" where sas_kokorikulumdetails.sakod_categorycode in ('BW') )as nonlocal on nonlocal.sako_code = kk.sako_code and nonlocal.saft_code = ft.saft_code WHERE kk.sako_code = @SAKO_Code";
try
{
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@SAKO_Code", DbType.String, argEn.FTCode);
_DbParameterCollection = cmd.Parameters;
using (IDataReader loReader = _DatabaseFactory.GetIDataReader(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection).CreateDataReader())
{
while (loReader.Read())
{
KokoEn loItem = new KokoEn();
FeeTypesDAL loDs = new FeeTypesDAL();
FeeTypesEn loEn = new FeeTypesEn();
loItem.sakod_idkoko = GetValue <int>(loReader, "saft_taxmode");
loItem.Code = GetValue <string>(loReader, "sako_code");
loItem.Saftcode = GetValue <string>(loReader, "saft_code");
loItem.LocalCategory = GetValue <string>(loReader, "LocalCategory");
loItem.NonLocalCategory = GetValue <string>(loReader, "NonLocalCategory");
int Tax = loItem.sakod_idkoko;
loItem.taxmode = (GetGstMode(Tax));
if (loItem.taxmode == 2)
{
loItem.sakodfeeamountlocalin = GetValue <double>(loReader, "sakodfeeamountlocalin");
loItem.sakodfeeamountlocalout = GetValue <double>(loReader, "sakodfeeamountlocalout");
loItem.sakodgstamountlocalin = GetValue <double>(loReader, "sakodgstamountlocalin");
loItem.sakodfeegstamountlocalout = GetValue <double>(loReader, "sakodfeegstamountlocalout");
loItem.sakodfeeamountinterin = GetValue <double>(loReader, "sakodfeeamountinterin");
loItem.sakodfeeamountinterout = GetValue <double>(loReader, "sakodfeeamountinterout");
loItem.sakodgstamountinterin = GetValue <double>(loReader, "sakodgstamountinterin");
loItem.sakodgstamountinterout = GetValue <double>(loReader, "sakodgstamountinterout");
loItem.Local_TempAmount = loItem.sakodfeeamountlocalin - loItem.sakodgstamountlocalin;
loItem.LocalTempAmount = loItem.sakodfeeamountlocalout - loItem.sakodfeegstamountlocalout;
loItem.Inter_TempAmount = loItem.sakodfeeamountinterin - loItem.sakodgstamountinterin;
loItem.NonLocalTempAmount = loItem.sakodfeeamountinterout - loItem.sakodgstamountinterout;
loItem.totalfeelocalin = loItem.sakodfeeamountlocalin;
loItem.totalfeelocalout = loItem.sakodfeeamountlocalout;
loItem.totalfeeinterin = loItem.sakodfeeamountinterin;
loItem.totalfeeinterout = loItem.sakodfeeamountinterout;
}
else if (loItem.taxmode == 1)
{
loItem.sakodgstamountlocalin = GetValue <double>(loReader, "sakodgstamountlocalin");
loItem.sakodfeegstamountlocalout = GetValue <double>(loReader, "sakodfeegstamountlocalout");
loItem.sakodgstamountinterin = GetValue <double>(loReader, "sakodgstamountinterin");
loItem.sakodgstamountinterout = GetValue <double>(loReader, "sakodgstamountinterout");
loItem.totalfeelocalin = GetValue <double>(loReader, "sakodfeeamountlocalin");
loItem.totalfeelocalout = GetValue <double>(loReader, "sakodfeeamountlocalout");
loItem.totalfeeinterin = GetValue <double>(loReader, "sakodfeeamountinterin");
loItem.totalfeeinterout = GetValue <double>(loReader, "sakodfeeamountinterout");
loItem.sakodfeeamountlocalin = loItem.totalfeelocalin - loItem.sakodgstamountlocalin;
loItem.sakodfeeamountlocalout = loItem.totalfeelocalout - loItem.sakodfeegstamountlocalout;
loItem.sakodfeeamountinterin = loItem.totalfeeinterin - loItem.sakodgstamountinterin;
loItem.sakodfeeamountinterout = loItem.totalfeeinterout - loItem.sakodgstamountinterout;
loItem.Local_TempAmount = loItem.totalfeelocalin - loItem.sakodgstamountlocalin;
loItem.LocalTempAmount = loItem.totalfeelocalout - loItem.sakodfeegstamountlocalout;
loItem.Inter_TempAmount = loItem.totalfeeinterin - loItem.sakodgstamountinterin;
loItem.NonLocalTempAmount = loItem.totalfeeinterout - loItem.sakodgstamountinterout;
}
if (loItem.Saftcode != null)
{
loEnList.Add(loItem);
}
}
loReader.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(loEnList);
}