public SummaryCalsViewModel summaryCals(params string[] parameters) { SummaryCalsViewModel summaryvals = new SummaryCalsViewModel(); try { context.Database.Connection.Open(); var cmd = context.Database.Connection.CreateCommand(); cmd.CommandText = "proc_CustomSiteSearch "; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@loginID", parameters[0])); cmd.Parameters.Add(new SqlParameter("@searchText", parameters[1])); cmd.Parameters.Add(new SqlParameter("@pageIndex", parameters[2])); cmd.Parameters.Add(new SqlParameter("@pageSize", parameters[3])); cmd.Parameters.Add(new SqlParameter("@OrderBy", parameters[4])); cmd.Parameters.Add(new SqlParameter("@OrderDir", parameters[5])); cmd.Parameters.Add(new SqlParameter("@raisedEvent", parameters[6])); var reader = cmd.ExecuteReader(); summaryvals = ((IObjectContextAdapter)context) .ObjectContext .Translate <SummaryCalsViewModel>(reader).FirstOrDefault(); return(summaryvals); } finally { context.Database.Connection.Close(); } }
public SummaryCalsViewModel SummaryCalculation(params string[] parameters) { SummaryCalsViewModel objSearchFilterViewModel = new SummaryCalsViewModel(); return(this.uow.Inventory.summaryCals(parameters)); }