// Type report between specific dates using store procedure// public virtual List<TypeReports> GetReportByTypeName(DateTime fromDate, DateTime toDate) { SqlConnection connection = new SqlConnection(Connection); string query = "sp_GetReportByType"; connection.Open(); SqlCommand command = new SqlCommand(query, connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@FromDate", fromDate); command.Parameters.AddWithValue("@ToDate", toDate); SqlDataReader reader = command.ExecuteReader(); List<TypeReports> TestReportList = new List<TypeReports>(); if (reader.HasRows) { while (reader.Read()) { string typeName = reader["typeName"].ToString(); int totalTest = (int)reader["totalTest"]; decimal totalAmount = (decimal)reader["totalAmount"]; TypeReports TestReport = new TypeReports(typeName, totalTest, totalAmount); TestReportList.Add(TestReport); } reader.Close(); } connection.Close(); return TestReportList; }
public async Task <IActionResult> Edit(int id, [Bind("IdType,Type")] TypeReports typeReports) { if (id != typeReports.IdType) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(typeReports); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TypeReportsExists(typeReports.IdType)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(typeReports)); }
public async Task <IActionResult> Create([Bind("IdType,Type")] TypeReports typeReports) { if (ModelState.IsValid) { _context.Add(typeReports); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(typeReports)); }
private static void SeedRepportType(DataContext dataContext) { if (dataContext.TypeReports.Where(r => r.Type == "PFE").FirstOrDefault() == null) { TypeReports typeReports = new TypeReports(); typeReports.Type = "PFE"; dataContext.TypeReports.Add(typeReports); dataContext.SaveChanges(); } if (dataContext.TypeReports.Where(r => r.Type == "STAGE").FirstOrDefault() == null) { TypeReports typeReports = new TypeReports(); typeReports.Type = "STAGE"; dataContext.TypeReports.Add(typeReports); dataContext.SaveChanges(); } if (dataContext.TypeReports.Where(r => r.Type == "PFA").FirstOrDefault() == null) { TypeReports typeReports = new TypeReports(); typeReports.Type = "PFA"; dataContext.TypeReports.Add(typeReports); dataContext.SaveChanges(); } }