/// <summary>
/// To fetch details
/// </summary>
/// <param name="districtID"></param>
/// <returns></returns>
public CountyList GetCounty(string districtID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_COUNTY";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DISTRICTID_", districtID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objcountBO = null;
CountyList objcountlist = new CountyList();
while (dr.Read())
{
objcountBO = new CountyBO();
objcountBO.CountyID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("COUNTYID"))));
objcountBO.CountyName = dr.GetValue(dr.GetOrdinal("COUNTYNAME")).ToString();
objcountlist.Add(objcountBO);
}
dr.Close();
return(objcountlist);
}
/// <summary>
/// To fetch details
/// </summary>
/// <param name="districtID"></param>
/// <returns></returns>
public CountyList GetAllCounties(int districtID)
{
CountyList objCountyList = null;
using (cnn = new OracleConnection(connStr))
{
using (cmd = new OracleCommand("USP_MST_GET_COUNTY_ALL", cnn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("DistrictIDIN", districtID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objCountyBO = null;
objCountyList = new CountyList();
while (dr.Read())
{
objCountyBO = new CountyBO();
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYID")))
{
objCountyBO.CountyID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("COUNTYID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYNAME")))
{
objCountyBO.CountyName = dr.GetValue(dr.GetOrdinal("COUNTYNAME")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objCountyBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
objCountyBO.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
// if (!dr.IsDBNull(dr.GetOrdinal("districtid"))) objCountyBO.DistrictID =Convert.ToInt32( dr.GetString(dr.GetOrdinal("districtid")));
objCountyList.Add(objCountyBO);
}
dr.Close();
}
}
return(objCountyList);
}
public void SquareBracketOperator()
{
Int32 countyIndex;
CountyList newCountyList, oldCountyList;
oldCountyList = GetCounties(true);
newCountyList = new CountyList();
for (countyIndex = 0; countyIndex < oldCountyList.Count; countyIndex++)
{
newCountyList.Add(oldCountyList[oldCountyList.Count - countyIndex - 1]);
}
for (countyIndex = 0; countyIndex < oldCountyList.Count; countyIndex++)
{
Assert.AreEqual(newCountyList[countyIndex], oldCountyList[oldCountyList.Count - countyIndex - 1]);
}
}
/// <summary>
/// To get details
/// </summary>
/// <param name="County"></param>
/// <returns></returns>
public CountyList GetCounties(string County)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_SER_COUNTY";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("COUNTYNAME_", County);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO objcountBO = null;
CountyList objcountlist = new CountyList();
while (dr.Read())
{
objcountBO = new CountyBO();
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYID")))
{
objcountBO.CountyID = dr.GetInt32(dr.GetOrdinal("COUNTYID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("DISTRICTID")))
{
objcountBO.DistrictID = dr.GetInt32(dr.GetOrdinal("DISTRICTID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("COUNTYNAME")))
{
objcountBO.CountyName = dr.GetString(dr.GetOrdinal("COUNTYNAME"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED")))
{
objcountBO.IsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED"));
}
if (!dr.IsDBNull(dr.GetOrdinal("districtname")))
{
objcountBO.DistrictName = dr.GetString(dr.GetOrdinal("districtname"));
}
objcountlist.Add(objcountBO);
}
dr.Close();
return(objcountlist);
}
public CountyList LoadCountyData(string pDstrictId)
{
cnn = new OracleConnection(AppConfiguration.ConnectionString);
string proc = "USP_MST_GET_COUNTY";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DistrictIDIN", pDstrictId);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
CountyBO obMaster = null;
CountyList Master = new CountyList();
while (dr.Read())
{
obMaster = new CountyBO();
obMaster.CountyID = dr.GetInt32(dr.GetOrdinal("COUNTYID"));
obMaster.CountyName = dr.GetString(dr.GetOrdinal("COUNTYNAME"));
Master.Add(obMaster);
}
dr.Close();
return(Master);
}
