public List <GenerateidMasterDTO> GetModeofTransaction(string Formname, string ConnectionString)
{
string strquery = string.Empty;
lstmodeoftransactions = new List <GenerateidMasterDTO>();
try
{
strquery = "select recordid,filedname from tabgenerateidmaster WHERE formname ='" + Formname.ToUpper() + "' and filedname<> '' and status='Y'";
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, strquery))
{
while (dr.Read())
{
GenerateidMasterDTO objGenerateId = new GenerateidMasterDTO();
objGenerateId.pFieldname = dr["filedname"].ToString();
objGenerateId.pTransactionModeId = Convert.ToInt32(dr["recordid"]);
lstmodeoftransactions.Add(objGenerateId);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstmodeoftransactions);
}
public List <GenerateidMasterDTO> GetGenerateidmasterList(string ConnectionString)
{
string strquery = string.Empty;
lstmodeoftransactions = new List <GenerateidMasterDTO>();
try
{
strquery = "select Recordid,formname,filedname,code,Serice,finanicalyear,normalyear," +
"(case when finanicalyear='Y' then 'Financial Year' when normalyear='Y' then 'Calendar Year' when finanicalyear='N' and normalyear='N' then 'NO' end )as sericereset from tabgenerateidmaster WHERE formname <>'APPLICATION' and status='Y'";
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, strquery))
{
while (dr.Read())
{
GenerateidMasterDTO objGenerateId = new GenerateidMasterDTO();
objGenerateId.pRecordid = Convert.ToInt32(dr["Recordid"]);
objGenerateId.pFormName = Convert.ToString(dr["formname"]);
objGenerateId.pFieldname = Convert.ToString(dr["filedname"]);
objGenerateId.pTransactionCode = Convert.ToString(dr["code"]);
objGenerateId.pTransactionSerice = Convert.ToString(dr["Serice"]);
objGenerateId.pFinanicalyear = Convert.ToString(dr["finanicalyear"]);
objGenerateId.pNormalyear = Convert.ToString(dr["normalyear"]);
objGenerateId.pSericeReset = Convert.ToString(dr["sericereset"]);
lstmodeoftransactions.Add(objGenerateId);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstmodeoftransactions);
}
public List <GenerateidMasterDTO> GetFormNames(string ConnectionString)
{
string strquery = string.Empty;
lstFormnames = new List <GenerateidMasterDTO>();
try
{
strquery = "select distinct Formname from tabgenerateidmaster WHERE formname <>'APPLICATION' and status='Y'";
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, strquery))
{
while (dr.Read())
{
GenerateidMasterDTO objGenerateId = new GenerateidMasterDTO();
objGenerateId.pFormName = dr["Formname"].ToString();
lstFormnames.Add(objGenerateId);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lstFormnames);
}
