public async Task <IActionResult> PutDashMod([FromRoute] int id, [FromBody] DashMod dashMod) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != dashMod.AutoId) { return(BadRequest()); } _context.Entry(dashMod).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!DashModExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostDashMod([FromBody] DashMod dashMod) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.DashMod.Add(dashMod); await _context.SaveChangesAsync(); return(CreatedAtAction("GetDashMod", new { id = dashMod.AutoId }, dashMod)); }
public IActionResult Index() { DashMod dashMod = new DashMod(); double toDate = (int)DateTime.Now.ToOADate(); using (HttpClient client = new HttpClient()) { client.BaseAddress = new Uri(iBaseURI); MediaTypeWithQualityHeaderValue contentType = new MediaTypeWithQualityHeaderValue("application/json"); client.DefaultRequestHeaders.Accept.Add(contentType); HttpResponseMessage response = client.GetAsync("/api/DashMods/?actDate=" + toDate + "&dSess=" + dSess + "&mdBID=" + mdBId).Result; // var stringData = response.Content.ReadAsStringAsync().Result; dashMod = JsonConvert.DeserializeObject <DashMod>(stringData); } return(View(dashMod)); }
public DashMod GetDashMod(double actDate, string dSess, int mDbId) { DashMod dashMod = new DashMod(); List <DashActivity> dashActList = new List <DashActivity>(); List <DashAttendance> dashAttList = new List <DashAttendance>(); List <DashFees> dashFeeList = new List <DashFees>(); List <DashAttClss> dashAttClssList = new List <DashAttClss>(); dashMod.DBid = mDbId; var conn = _context.Database.GetDbConnection(); if (conn.State == ConnectionState.Closed) { conn.Open(); } using (var command = conn.CreateCommand()) { MySql = "SELECT top(20) TransActName, ActivityID, TransActivity.RegNumber, Students.FirstName, Students.PresentRollNo, Students.PresentClass, "; MySql = MySql + " TransActObserver, TeachID, TransActRemarks"; MySql = MySql + " FROM TransActivity WITH(NOLOCK) INNER JOIN Students ON Students.RegNumber = TransActivity.RegNumber"; MySql = MySql + " WHERE TransActivity.TransActDate = " + actDate; MySql = MySql + " AND Students.StdSession='" + repSplChr(dSess) + "'"; MySql = MySql + " AND TransActivity.Dormant = 0 "; MySql = MySql + " AND TransActivity.DBID = " + mDbId; MySql = MySql + " ORDER BY TransActivity.AutoID Desc"; command.CommandType = System.Data.CommandType.Text; command.CommandText = MySql; DbDataReader kMyReader = command.ExecuteReader(); if (kMyReader.HasRows) { while (kMyReader.Read()) { DashActivity acts = new DashActivity(); acts.ActivityGroup = ""; if (!kMyReader.IsDBNull(0)) { acts.Activity = kMyReader.GetString(0); } if (!kMyReader.IsDBNull(1)) { acts.ActivityID = kMyReader.GetInt32(1); } if (!kMyReader.IsDBNull(2)) { acts.RegNum = kMyReader.GetInt32(2).ToString(); } if (!kMyReader.IsDBNull(3)) { acts.Name = kMyReader.GetString(3); } if (!kMyReader.IsDBNull(4)) { acts.Roll = kMyReader.GetInt32(4).ToString(); } if (!kMyReader.IsDBNull(5)) { acts.Clss = kMyReader.GetString(5); } //if (!kMyReader.IsDBNull(6)) { acts.LoggedBY = kMyReader.GetInt32(6); } if (!kMyReader.IsDBNull(8)) { acts.Remark = kMyReader.GetString(8); } dashActList.Add(acts); } } kMyReader.Close(); dashMod.DashActivities = dashActList; MySql = "SELECT top(20) RegNum, Clss, Students.FirstName, Students.PresentRollNo, "; MySql = MySql + " AtType, Cause, Remark"; MySql = MySql + " FROM Attendance WITH(NOLOCK) INNER JOIN Students ON Students.RegNumber = Attendance.RegNum "; MySql = MySql + " WHERE Attendance.AttDate = " + actDate; MySql = MySql + " AND Attendance.AcaSession = '" + repSplChr(dSess) + "'"; MySql = MySql + " AND Attendance.isAbsent = 0 "; MySql = MySql + " AND Attendance.DBID = " + mDbId; //MySql = MySql + " AND Students.DBID = " + mDbId; MySql = MySql + " ORDER BY Attendance.AutoID Desc"; command.CommandType = System.Data.CommandType.Text; command.CommandText = MySql; kMyReader = command.ExecuteReader(); if (kMyReader.HasRows) { while (kMyReader.Read()) { DashAttendance atts = new DashAttendance(); if (!kMyReader.IsDBNull(0)) { atts.RegNum = kMyReader.GetInt32(0).ToString(); } if (!kMyReader.IsDBNull(1)) { atts.Clss = kMyReader.GetString(1); } if (!kMyReader.IsDBNull(2)) { atts.Name = kMyReader.GetString(2); } if (!kMyReader.IsDBNull(3)) { atts.Roll = kMyReader.GetInt32(3).ToString(); } if (!kMyReader.IsDBNull(4)) { atts.AtType = kMyReader.GetString(4); } if (!kMyReader.IsDBNull(5)) { atts.Cause = kMyReader.GetString(5); } if (!kMyReader.IsDBNull(6)) { atts.Remarks = kMyReader.GetString(6); } //if (!kMyReader.IsDBNull(7)) { atts.Roll = kMyReader.GetString(7); } dashAttList.Add(atts); } } kMyReader.Close(); dashMod.DashAttendances = dashAttList; MySql = "SELECT SUM(AmountPaid) "; MySql = MySql + " FROM Receipt"; MySql = MySql + " WHERE ReceiptDate = " + actDate; MySql = MySql + " AND Dormant = 0"; MySql = MySql + " AND DBID = " + mDbId; command.CommandType = System.Data.CommandType.Text; command.CommandText = MySql; kMyReader = command.ExecuteReader(); if (kMyReader.HasRows) { kMyReader.Read(); if (!kMyReader.IsDBNull(0)) { dashMod.TodaysFeeCollection = kMyReader.GetDouble(0).ToString(); } else { dashMod.TodaysFeeCollection = "0.00"; } } kMyReader.Close(); MySql = "SELECT top(20) Receipt.RegNo, Receipt.ForPeriod, Receipt.AmountPaid, Receipt.FeeHeading, Students.FirstName, Students.PresentClass "; MySql = MySql + " FROM Receipt WITH (NOLOCK) INNER JOIN Students ON Students.RegNumber = Receipt.RegNo "; MySql = MySql + " WHERE Receipt.ReceiptDate = " + actDate; MySql = MySql + " AND Receipt.AcaSession = '" + repSplChr(dSess) + "'"; MySql = MySql + " AND Receipt.DBID = " + mDbId; //MySql = MySql + " AND Students.DBID = " + mDbId; MySql = MySql + " AND Receipt.Dormant = 0 "; //MySql = MySql + " AND Students.Dormant = 0 " ; MySql = MySql + " ORDER BY Receipt.AutoID Desc"; command.CommandType = System.Data.CommandType.Text; command.CommandText = MySql; kMyReader = command.ExecuteReader(); if (kMyReader.HasRows) { while (kMyReader.Read()) { DashFees atts = new DashFees(); if (!kMyReader.IsDBNull(0)) { atts.RegNum = kMyReader.GetInt32(0).ToString(); } if (!kMyReader.IsDBNull(1)) { atts.FeeDate = DateTime.FromOADate(kMyReader.GetDouble(1)); } if (!kMyReader.IsDBNull(2)) { atts.Amount = (int)kMyReader.GetDouble(2); } if (!kMyReader.IsDBNull(3)) { atts.FeeName = kMyReader.GetString(3); } if (!kMyReader.IsDBNull(4)) { atts.Name = kMyReader.GetString(4); } if (!kMyReader.IsDBNull(5)) { atts.Clss = kMyReader.GetString(5); } dashFeeList.Add(atts); } } kMyReader.Close(); dashMod.DashFeess = dashFeeList; DashAttClss attCs; MySql = "SELECT Count(RegNum), Clss "; MySql = MySql + " FROM Attendance"; MySql = MySql + " WHERE isAbsent = 0"; MySql = MySql + " AND DBID = " + mDbId; MySql = MySql + " AND Dormant = 0 "; MySql = MySql + " GROUP BY Clss"; command.CommandType = System.Data.CommandType.Text; command.CommandText = MySql; kMyReader = command.ExecuteReader(); if (kMyReader.HasRows) { while (kMyReader.Read()) { attCs = new DashAttClss(); if (!kMyReader.IsDBNull(0)) { attCs.Ccount = kMyReader.GetInt32(0); } if (!kMyReader.IsDBNull(1)) { attCs.Cclss = kMyReader.GetString(1); } dashAttClssList.Add(attCs); } } kMyReader.Close(); dashMod.DashAttClss = dashAttClssList; return(dashMod); } }