public ProductMaster_TissueBank GetProductMaster_DomainFamily_ByTissueBankProductMasterId(int TissueBankProductMasterId, out TransactionalInformation transaction)
{
transaction = new TransactionalInformation();
ProductMaster_TissueBank productMaster_TissueBank = new ProductMaster_TissueBank();
try
{
_productMasterDataService.CreateSession();
productMaster_TissueBank = _productMasterDataService.GetProductMaster_DomainFamily_ByTissueBankProductMasterId(TissueBankProductMasterId, out transaction);
}
catch (Exception ex)
{
transaction.ReturnMessage = new List <string>();
string errorMessage = ex.Message;
transaction.ReturnStatus = false;
transaction.ReturnMessage.Add(errorMessage);
}
finally
{
_productMasterDataService.CloseSession();
}
return(productMaster_TissueBank);
}
public ProductMaster_TissueBank GetProductMaster_DomainFamily_ByTissueBankProductMasterId(int TissueBankProductMasterId, out TransactionalInformation transaction)
{
transaction = new TransactionalInformation();
ProductMaster_TissueBank productMaster_TissueBank = (from pm in dbConnection.ProductMaster
join ds in dbConnection.DomainScope on pm.DomainScopeId equals ds.DomainScopeId into dsSet
from ds in dsSet.DefaultIfEmpty()
join pmFamily in dbConnection.ProductMaster on pm.FamilyId equals pmFamily.ProductMasterId into t1
from rt1 in t1.DefaultIfEmpty()
join tbpm in dbConnection.TissueBankProductMaster on pm.ProductMasterId equals tbpm.ProductMasterId
where tbpm.TissueBankProductMasterId == TissueBankProductMasterId
select new ProductMaster_TissueBank
{
ProductMasterId = pm.ProductMasterId,
ProductMasterName = pm.ProductMasterName,
ProductMasterDescription = pm.ProductMasterDescription,
ProductMasterFeatures = pm.ProductMasterFeatures,
ProductMasterImageName = pm.ProductMasterImageName,
ProductMasterThumbnailImageName = pm.ProductMasterThumbnailImageName,
DomainScopeId = pm.DomainScopeId,
FamilyId = pm.FamilyId,
IsActive = pm.IsActive,
CreatedDate = pm.CreatedDate,
CreatedBy = pm.CreatedBy,
LastModifiedDate = pm.LastModifiedDate,
LastModifiedBy = pm.LastModifiedBy,
DomainName = ds.DomainName,
FamilyProductMasterName = rt1.ProductMasterName
}).First();
transaction.ReturnStatus = true;
transaction.ReturnMessage.Add("1 Product Master found.");
return(productMaster_TissueBank);
}
public ProductMasterApiModel()
{
ProductMaster_TissueBank = new ProductMaster_TissueBank();
}
