public _SearchFilterViewModel SearchFilter(int LoginID)
{
_SearchFilterViewModel objSearchFilterViewModel = new _SearchFilterViewModel();
return(this.uow.Inventory.Searchfilter(LoginID));
}
public _SearchFilterViewModel Searchfilter(int LoginID)
{
_SearchFilterViewModel objSF = new _SearchFilterViewModel();
var cmd = context.Database.Connection.CreateCommand();
//cmd.CommandText = "exec Proc_Searchfilter 'GetSearchfilter'";
cmd.CommandText = "Proc_Searchfilter ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@IN_PARAMETER_NAME", "GetSearchfilter"));
cmd.Parameters.Add(new SqlParameter("@LoginID", LoginID));
try
{
context.Database.Connection.Open();
// Run the sproc
var reader = cmd.ExecuteReader();
// Read Color from the first result set
objSF.VMcolor = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstColorViewModel>(reader, "Color", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMlab = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstLabViewModel>(reader, "Lab", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
// Read Color from the first result set
objSF.VMfancyColor = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstfancyColorViewModel>(reader, "FancyColor", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMclarity = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstClarityViewModel>(reader, "Clarity", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
// Read Color from the first result set
objSF.VMfluorescence = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstFluorescenceViewModel>(reader, "Fluorescence", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMkeyToSymbol = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstKeyToSymbolViewModel>(reader, "KeyToSymbol", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
// Read Color from the first result set
objSF.VMgirdleNames = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstGirdleNamesViewModel>(reader, "GirdleNames", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMshade = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstShadeViewModel>(reader, "Shade", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
// Read Color from the first result set
objSF.VMtableBlackInclusion = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstTableBlackInclusionViewModel>(reader, "TableBlack", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMsideBlackInclusion = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstSideBlackInclusionViewModel>(reader, "SideBlack", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMmilkyInclusion = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstMilkyInclusionViewModel>(reader, "Milky", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMeyeClean = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstEyeCleanViewModel>(reader, "EyeClean", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMha = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <mstH_AViewModel>(reader, "HA", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMCaratsSize = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <MstCaratsSizeViewModel>(reader, "CaratsSize", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMStoneOrigin = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <MstStoneOriginViewModel>(reader, "Origin", MergeOption.AppendOnly).ToList();
// Move to second result set and read Posts
reader.NextResult();
objSF.VMSalesLocation = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <SalesLocationViewModel>(reader).ToList();
// Move to second result set and read Posts
reader.NextResult();
}
finally
{
context.Database.Connection.Close();
}
return(objSF);
}
