/// <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)); }