/// <summary>
///
/// </summary>
/// <param name="drugGroup"></param>
/// <returns></returns>
private Int32 UpdateDrugGroup(Entities.DrugGroup drugGroup)
{
var drugGroupId = 0;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.UpdateDrugGroup))
{
database.AddInParameter(dbCommand, "@drug_group_id", DbType.Int32, drugGroup.DrugGroupId);
database.AddInParameter(dbCommand, "@group_name", DbType.String, drugGroup.GroupName);
database.AddInParameter(dbCommand, "@modified_by", DbType.Int32, drugGroup.ModifiedBy);
database.AddInParameter(dbCommand, "@modified_by_ip", DbType.String, drugGroup.ModifiedByIP);
database.AddOutParameter(dbCommand, "@return_value", DbType.Int32, 0);
drugGroupId = database.ExecuteNonQuery(dbCommand);
if (database.GetParameterValue(dbCommand, "@return_value") != DBNull.Value)
{
drugGroupId = Convert.ToInt32(database.GetParameterValue(dbCommand, "@return_value"));
}
}
}
catch (Exception e)
{
throw e;
}
return(drugGroupId);
}
/// <summary>
///
/// </summary>
/// <param name="drugGroup"></param>
/// <returns></returns>
private bool DeleteDrugGroup(Entities.DrugGroup drugGroup)
{
var isDeleted = false;
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.DeleteDrugGroup))
{
database.AddInParameter(dbCommand, "@drug_group_id", DbType.Int32, drugGroup.DrugGroupId);
database.AddInParameter(dbCommand, "@deleted_by", DbType.Int32, drugGroup.DeletedBy);
database.AddInParameter(dbCommand, "@deleted_by_ip", DbType.String, drugGroup.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="drugGroup"></param>
/// <returns></returns>
public Int32 SaveDrugGroup(Entities.DrugGroup drugGroup)
{
var drugGroupId = 0;
if (drugGroup.DrugGroupId == null || drugGroup.DrugGroupId == 0)
{
drugGroupId = AddDrugGroup(drugGroup);
return(drugGroupId);
}
else
{
if (drugGroup.IsDeleted == true)
{
var result = DeleteDrugGroup(drugGroup);
if (result == true)
{
drugGroupId = 1;
}
}
else
{
drugGroupId = UpdateDrugGroup(drugGroup);
}
}
return(drugGroupId);
}
public List <Entities.DrugGroup> SearchDrugGroupsByGroupName(string groupName)
{
var drugGroups = new List <Entities.DrugGroup>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.SearchDrugGroupByName))
{
database.AddInParameter(dbCommand, "@group_name", DbType.String, groupName);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugGroup = new Entities.DrugGroup
{
DrugGroupId = DRE.GetNullableInt32(reader, "drug_group_id", 0),
GroupName = DRE.GetNullableString(reader, "group_name", null)
};
drugGroups.Add(drugGroup);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(drugGroups);
}
/// <summary>
///
/// </summary>
/// <param name="drugGroupName"></param>
/// <returns></returns>
public Entities.DrugGroup GetDrugGroupDetailsByName(string drugGroupName)
{
var drugGroupDetails = new Entities.DrugGroup();
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetDetailsOfDrugGroupByName))
{
database.AddInParameter(dbCommand, "@DrugGroup_name", DbType.String, drugGroupName);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var drugGruop = new Entities.DrugGroup
{
DrugGroupId = DRE.GetNullableInt32(reader, "drug_group_id", 0),
GroupName = DRE.GetNullableString(reader, "group_name", null)
};
drugGroupDetails = drugGruop;
}
}
}
return(drugGroupDetails);
}
public Int32 SaveDrugGroup(Entities.DrugGroup drugGroup)
{
return(_drugGroup.SaveDrugGroup(drugGroup));
}