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