/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.ClientAddress> GetAllClientAddressessByClientId(Int32 clientId)
{
var clientAddresses = new List <Entities.ClientAddress>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClientAddressByClientId))
{
database.AddInParameter(dbCommand, "@client_id", DbType.Int32, clientId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
//var customerAndTransporterMapping = new CustomerAndTransporterMapping();
var clientAddress = new Entities.ClientAddress
{
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
//CustomerAndTransporterMapping = customerAndTransporterMapping.GetTransportersListByCustomerAddressId(DRE.GetInt32(reader, "client_address_id"))
};
clientAddresses.Add(clientAddress);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientAddresses);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.Brand> GetAllBrands()
{
var brands = new List <Entities.Brand>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllBrands))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var brand = new Entities.Brand
{
BrandId = DRE.GetNullableInt32(reader, "brand_id", 0),
BrandName = DRE.GetNullableString(reader, "brand_name", null),
guid = DRE.GetNullableGuid(reader, "row_guid", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
brands.Add(brand);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(brands);
}
/// <summary>
///
/// </summary>
/// <param name="patientId"></param>
/// <returns></returns>
public List <Entities.PatientExerciseHistory> GetPatientExerciseHistoriesByPatientId(Int32 patientId)
{
List <Entities.PatientExerciseHistory> patientExercisesHistory = new List <Entities.PatientExerciseHistory>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetPatientExerciseDetailsByPatientId))
{
database.AddInParameter(dbCommand, "@patient_id", DbType.Int32, patientId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
Entities.PatientExerciseHistory patientExerciseHistory = new Entities.PatientExerciseHistory()
{
PatientExerciseHistoryId = DRE.GetNullableInt32(reader, "patient_exercise_history_id", 0),
PatientId = DRE.GetNullableInt32(reader, "patient_id", 0),
ExerciseName = DRE.GetNullableString(reader, "exercise_name", null),
Frequency = DRE.GetNullableString(reader, "frequency", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
patientExercisesHistory.Add(patientExerciseHistory);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(patientExercisesHistory);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.ClientAddress> GetAllClientAddressess()
{
var clientAddresses = new List <Entities.ClientAddress>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClientAddressess))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var clientAddress = new Entities.ClientAddress
{
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
clientAddresses.Add(clientAddress);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientAddresses);
}
/// <summary>
///
/// </summary>
/// <param name="clientAddressId"></param>
/// <returns></returns>
public Entities.ClientAddress GetClientAddressById(Int32 clientAddressId)
{
var clientAddress = new Entities.ClientAddress();
DbCommand dbCommand = null;
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetClientAddressById))
{
database.AddInParameter(dbCommand, "@client_address_id", DbType.Int32, clientAddressId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var _clientAddress = new Entities.ClientAddress
{
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", null),
ClientType = DRE.GetNullableString(reader, "client_type", null),
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientName = DRE.GetNullableString(reader, "client_name", null),
ClientAddressCode = DRE.GetNullableString(reader, "client_address_code", null),
AddressTypeId = DRE.GetNullableInt32(reader, "address_type_id", 0),
AddressType = DRE.GetNullableString(reader, "address_type", null),
ClientAddressId = DRE.GetNullableInt32(reader, "client_address_id", 0),
ClientAddressName = DRE.GetNullableString(reader, "client_address_name", null),
Address = DRE.GetNullableString(reader, "address", null),
CountryId = DRE.GetNullableInt32(reader, "country_id", null),
CountryName = DRE.GetNullableString(reader, "country_name", null),
StateId = DRE.GetNullableInt32(reader, "state_id", 0),
StateName = DRE.GetNullableString(reader, "state_name", null),
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
Area = DRE.GetNullableString(reader, "area", null),
EmailId = DRE.GetNullableString(reader, "email_id", null),
ContactNos = DRE.GetNullableString(reader, "contact_nos", null),
GSTNo = DRE.GetNullableString(reader, "gst_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
clientAddress = _clientAddress;
}
}
}
return(clientAddress);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.Client> GetAllClients()
{
var clients = new List <Entities.Client>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClients))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
ClientAddress clientAddress = new ClientAddress();
var client = new Entities.Client
{
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", 0),
ClientTypeName = DRE.GetNullableString(reader, "client_type", null),
ClientId = DRE.GetNullableInt32(reader, "client_id", 0),
ClientCode = DRE.GetNullableString(reader, "client_code", null),
ClientName = DRE.GetNullableString(reader, "client_name", null),
PANNo = DRE.GetNullableString(reader, "pan_no", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null),
ClientAddressess = clientAddress.GetAllClientAddressessByClientId(DRE.GetInt32(reader, "client_id"))
};
clients.Add(client);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clients);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.MedicalTestParameters> GetMedicalTestParameterDetailsByTestId(Int32 medicalTestId)
{
var medicalTestParameters = new List <Entities.MedicalTestParameters>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetMedicalTestParametersByTestId))
{
database.AddInParameter(dbCommand, "@medical_test_id", DbType.Int32, medicalTestId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var medicalTestParameter = new Entities.MedicalTestParameters()
{
MedicalTestParameterId = DRE.GetNullableInt32(reader, "medical_test_parameter_id", null),
MedicalTestId = DRE.GetNullableInt32(reader, "medical_test_id", 0),
TestParameterName = DRE.GetNullableString(reader, "test_parameter_name", null),
TestParameterDesc = DRE.GetNullableString(reader, "test_parameter_desc", null),
TestParameterSequence = DRE.GetNullableDecimal(reader, "test_parameter_sequence", null),
MinimumValue = DRE.GetNullableDecimal(reader, "minimum_value", null),
MaximumValue = DRE.GetNullableDecimal(reader, "maximum_value", null),
NormalValue = DRE.GetNullableDecimal(reader, "normal_value", null),
UnitOfMeasurementId = DRE.GetNullableInt32(reader, "unit_of_measurement_id", null),
UnitCode = DRE.GetNullableString(reader, "unit_code", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
medicalTestParameters.Add(medicalTestParameter);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(medicalTestParameters);
}
public List <Entities.City> GetCitiesByState(Int32 stateId)
{
var cities = new List <Entities.City>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListofCitiesByState))
{
database.AddInParameter(dbCommand, "@state_id", DbType.Int32, stateId);
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var city = new Entities.City
{
CityId = DRE.GetNullableInt32(reader, "city_id", 0),
CityName = DRE.GetNullableString(reader, "city_name", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
cities.Add(city);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(cities);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.WorkingPeriod> GetAllWorkingPeriods()
{
var workingPeriods = new List <Entities.WorkingPeriod>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllWorkingPeriods))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var workingPeriod = new Entities.WorkingPeriod
{
WorkingPeriodId = DRE.GetNullableInt32(reader, "working_period_id", 0),
StartDate = DRE.GetNullableString(reader, "start_date", null),
EndDate = DRE.GetNullableString(reader, "end_date", null),
FinancialYear = DRE.GetNullableString(reader, "financial_year", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
workingPeriods.Add(workingPeriod);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(workingPeriods);
}
/// <summary>
/// /
/// </summary>
/// <returns></returns>
public List <Entities.Pettycash> GetAllPettyCashDocno()
{
var Pettys = new List <Entities.Pettycash>();
try
{
using (DbCommand dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllPettycase))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var Petty = new Entities.Pettycash
{
PettycaseId = DRE.GetNullableInt32(reader, "pettycase_id", 0),
DocNo = DRE.GetNullableString(reader, "docno", null),
EntryDate = DRE.GetNullableString(reader, "Date", null),
DateRange = DRE.GetNullableString(reader, "daterange", null),
AccountHead = DRE.GetNullableString(reader, "account_head_name", null),
Supplier = DRE.GetNullableString(reader, "nameofsupplier", null),
VoucherNo = DRE.GetNullableString(reader, "voucherno", null),
Amount = DRE.GetNullableDecimal(reader, "Amount", 0),
guid = DRE.GetNullableGuid(reader, "row_guid", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
Pettys.Add(Petty);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Pettys);
}
/// <summary>
/// Gets a list of all roles
/// </summary>
/// <returns>A collection of all roles.</returns>
public List <Entities.Role> GetAllRoles()
{
var roles = new List <Entities.Role>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetListOfAllRoles))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var role = new Entities.Role
{
RoleId = DRE.GetNullableInt32(reader, "role_id", 0),
RoleName = DRE.GetNullableString(reader, "role_name", null),
RoleDesc = DRE.GetNullableString(reader, "role_desc", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
roles.Add(role);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(roles);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <Entities.ClientType> GetAllClientTypes()
{
var clientTypes = new List <Entities.ClientType>();
DbCommand dbCommand = null;
try
{
using (dbCommand = database.GetStoredProcCommand(DBStoredProcedure.GetAllClientTypes))
{
using (IDataReader reader = database.ExecuteReader(dbCommand))
{
while (reader.Read())
{
var clientType = new Entities.ClientType
{
ClientTypeId = DRE.GetNullableInt32(reader, "client_type_id", 0),
ClientTypeName = DRE.GetNullableString(reader, "client_type", null),
SrNo = DRE.GetNullableInt64(reader, "sr_no", null)
};
clientTypes.Add(clientType);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbCommand = null;
}
return(clientTypes);
}
