/// <summary> /// /// </summary> /// <param name="drugGroup"></param> /// <returns></returns> private bool DeleteDrugRoute(Entities.DrugRoutes drugRoute) { var isDeleted = false; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteDrugRoute)) { database.AddInParameter(dbCommand, "@drug_route_id", DbType.Int32, drugRoute.DrugRouteId); database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, drugRoute.DeletedBy); database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, drugRoute.DeletedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); var result = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { isDeleted = Convert.ToBoolean(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(isDeleted); }
/// <summary> /// /// </summary> /// <param name="drugRoute"></param> /// <returns></returns> public Int32 SaveDrugRoute(Entities.DrugRoutes drugRoute) { var drugRouteId = 0; if (drugRoute.DrugRouteId == null || drugRoute.DrugRouteId == 0) { drugRouteId = AddDrugRoute(drugRoute); return(drugRouteId); } else { if (drugRoute.IsDeleted == true) { var result = DeleteDrugRoute(drugRoute); if (result == true) { drugRouteId = 1; } } else { drugRouteId = UpdateDrugRoute(drugRoute); } } return(drugRouteId); }
/// <summary> /// Add DrugGroup names /// </summary> /// <param name="drugRoutes"></param> /// <returns></returns> private Int32 AddDrugRoute(Entities.DrugRoutes drugRoute) { var drugRouteId = 0; try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.InsertDrugRoute)) { database.AddInParameter(dbCommand, "@drug_route_id", DbType.Int32, drugRoute.DrugRouteId); database.AddInParameter(dbCommand, "@route_name", DbType.String, drugRoute.RouteName); database.AddInParameter(dbCommand, "@created_by", DbType.Int32, drugRoute.CreatedBy); database.AddInParameter(dbCommand, "@created_by_ip", DbType.String, drugRoute.CreatedByIP); database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0); drugRouteId = database.ExecuteNonQuery(dbCommand); if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value) { drugRouteId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value")); } } } catch (Exception e) { throw e; } return(drugRouteId); }
public List <Entities.DrugRoutes> SearchDrugRoutesByRouteName(string routeName) { var drugRoutes = new List <Entities.DrugRoutes>(); try { using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllDrugRouteIdAndRouteName)) { database.AddInParameter(dbCommand, "@route_name", DbType.String, routeName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugRoute = new Entities.DrugRoutes { DrugRouteId = DRE.GetNullableInt32(reader, "drug_route_id", 0), RouteName = DRE.GetNullableString(reader, "route_name", null) }; drugRoutes.Add(drugRoute); } } } } catch (Exception ex) { throw ex; } return(drugRoutes); }
/// <summary> /// /// </summary> /// <param name="drugRouteName"></param> /// <returns></returns> public Entities.DrugRoutes GetDrugRouteDetailsByName(string drugRouteName) { var drugRouteDetails = new Entities.DrugRoutes(); using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetDetailsOfDrugRouteByName)) { database.AddInParameter(dbCommand, "@drug_route_name", DbType.String, drugRouteName); using (IDataReader reader = database.ExecuteReader(dbCommand)) { while (reader.Read()) { var drugRoute = new Entities.DrugRoutes { DrugRouteId = DRE.GetNullableInt32(reader, "drug_route_id", 0), RouteName = DRE.GetNullableString(reader, "route_name", null) }; drugRouteDetails = drugRoute; } } } return(drugRouteDetails); }
public Int32 SaveDrugRoute(Entities.DrugRoutes drugRoute) { return(_drugRoutes.SaveDrugRoute(drugRoute)); }