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); }