/// <summary>
/// To Add New Location
/// </summary>
/// <param name="oNewLocationBO"></param>
/// <returns></returns>
public string AddNewLocation(NewLocationBO oNewLocationBO)
{
cnn = new OracleConnection(con);
string returnResult = string.Empty;
proc = "USP_TRN_INS_CMP_NEW_PLOT";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
cmd.Parameters.Add("hhid_", oNewLocationBO.HHID);
cmd.Parameters.Add("newplotno_", oNewLocationBO.NewPlotNo);
cmd.Parameters.Add("newplotstatusid_", oNewLocationBO.NewPlotStatusId);
cmd.Parameters.Add("plotdistrict_", oNewLocationBO.District);
cmd.Parameters.Add("plotcounty_", oNewLocationBO.County);
cmd.Parameters.Add("plotsubcounty_", oNewLocationBO.SubCounty);
cmd.Parameters.Add("plotvillage_", oNewLocationBO.Village);
cmd.Parameters.Add("distFromOldPlot_", oNewLocationBO.DistanceFromOldPlot);
if (oNewLocationBO.DateOfSettlement != DateTime.MinValue)
{
cmd.Parameters.Add("dateofsettlement_", oNewLocationBO.DateOfSettlement);
}
else
{
cmd.Parameters.Add("dateofsettlement_", DBNull.Value);
}
cmd.Parameters.Add("plotparish_", oNewLocationBO.Parish);
cmd.Parameters.Add("isdeleted_", oNewLocationBO.IsDeleted);
cmd.Parameters.Add("createdby_", oNewLocationBO.CreatedBy);
cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
if (cmd.Parameters["errorMessage_"].Value != null)
{
returnResult = cmd.Parameters["errorMessage_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
cmd.Connection.Close();
return(returnResult);
}
/// <summary>
/// To Get New Location
/// </summary>
/// <param name="HHID"></param>
/// <returns></returns>
public NewLocationBO GetNewLocation(int HHID)
{
proc = "USP_TRN_GET_CMP_NEW_PLOT";
cnn = new OracleConnection(con);
//NewLocationBO oNewLocationBO = null;
NewLocationList lstNewLocation = new NewLocationList();
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("hhid_", HHID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
NewLocationBO oNewLocationBO = null;
try
{
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
oNewLocationBO = new NewLocationBO();
//if (!dr.IsDBNull(dr.GetOrdinal("BankID"))) oNewLocationBO.BankID = dr.GetInt32(dr.GetOrdinal("BankID"));
//if (!dr.IsDBNull(dr.GetOrdinal("BankName"))) oNewLocationBO.BankName = dr.GetString(dr.GetOrdinal("BankName"));
//if (!dr.IsDBNull(dr.GetOrdinal("City"))) oNewLocationBO.City = dr.GetString(dr.GetOrdinal("City"));
//if (!dr.IsDBNull(dr.GetOrdinal("BranchName"))) oNewLocationBO.BranchName = dr.GetString(dr.GetOrdinal("BranchName"));
//if (!dr.IsDBNull(dr.GetOrdinal("SwiftCode"))) oNewLocationBO.SwiftCode = dr.GetString(dr.GetOrdinal("SwiftCode"));
//if (!dr.IsDBNull(dr.GetOrdinal("IsDeleted"))) oNewLocationBO.IsDeleted = dr.GetString(dr.GetOrdinal("IsDeleted"));
oNewLocationBO = MapData(dr);
//lstNewLocation.Add(oNewLocationBO);
}
dr.Close();
}
catch (Exception ex)
{
throw ex;
}
return(oNewLocationBO);
}
/// <summary>
/// To Map Data
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private NewLocationBO MapData(IDataReader reader)
{
NewLocationBO oNewLocationBO = new NewLocationBO();
try
{
if (ColumnExists(reader, "cmp_newplotid") && !reader.IsDBNull(reader.GetOrdinal("cmp_newplotid")))
{
oNewLocationBO.NewPlotID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("cmp_newplotid")));
}
if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID")))
{
oNewLocationBO.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID")));
}
if (ColumnExists(reader, "newplotstatusid") && !reader.IsDBNull(reader.GetOrdinal("newplotstatusid")))
{
oNewLocationBO.NewPlotStatusId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("newplotstatusid")));
}
if (ColumnExists(reader, "newplotno") && !reader.IsDBNull(reader.GetOrdinal("newplotno")))
{
oNewLocationBO.NewPlotNo = reader.GetString(reader.GetOrdinal("newplotno"));
}
if (ColumnExists(reader, "plotdistrict") && !reader.IsDBNull(reader.GetOrdinal("plotdistrict")))
{
oNewLocationBO.District = reader.GetString(reader.GetOrdinal("plotdistrict"));
}
if (ColumnExists(reader, "plotcounty") && !reader.IsDBNull(reader.GetOrdinal("plotcounty")))
{
oNewLocationBO.County = reader.GetString(reader.GetOrdinal("plotcounty"));
}
if (ColumnExists(reader, "plotsubcounty") && !reader.IsDBNull(reader.GetOrdinal("plotsubcounty")))
{
oNewLocationBO.SubCounty = reader.GetString(reader.GetOrdinal("plotsubcounty"));
}
if (ColumnExists(reader, "plotvillage") && !reader.IsDBNull(reader.GetOrdinal("plotvillage")))
{
oNewLocationBO.Village = reader.GetString(reader.GetOrdinal("plotvillage"));
}
if (ColumnExists(reader, "plotparish") && !reader.IsDBNull(reader.GetOrdinal("plotparish")))
{
oNewLocationBO.Parish = reader.GetString(reader.GetOrdinal("plotparish"));
}
if (ColumnExists(reader, "distancefromoldplot"))
{
if (!reader.IsDBNull(reader.GetOrdinal("distancefromoldplot")))
{
oNewLocationBO.DistanceFromOldPlot = Convert.ToUInt32(reader.GetValue(reader.GetOrdinal("distancefromoldplot"))).ToString();
}
}
if (ColumnExists(reader, "DateOfSettlement") && !reader.IsDBNull(reader.GetOrdinal("DateOfSettlement")))
{
oNewLocationBO.DateOfSettlement = Convert.ToDateTime(reader.GetDateTime(reader.GetOrdinal("DateOfSettlement")));
}
}
catch (Exception ex)
{ throw ex; }
return(oNewLocationBO);
}
//public BankList GetBanks(string bankName, string city, string branchName, string swiftCode)
//{
// return (new NewLocationDAL()).GetBanks(bankName, city, branchName, swiftCode);
//}
//public NewLocationBO GetBankByBankID(int bankID)
//{
// return (new NewLocationDAL()).GetBankByBankID(bankID);
//}
/// <summary>
/// To Add New Location
/// </summary>
/// <param name="oNewLocationBO"></param>
/// <returns></returns>
public string AddNewLocation(NewLocationBO oNewLocationBO)
{
return((new NewLocationDAL()).AddNewLocation(oNewLocationBO));
}
