using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using CertAuth.Data; using CertAuth.Domain; using Microsoft.Data.SqlClient; using Microsoft.AspNetCore.Mvc.Rendering; namespace CertAuthAdmin.Models { public class RFIDTagMstrDA { private readonly CertAuth.Data.CertAuthContext _context; public RFIDTagMstrDA(CertAuth.Data.CertAuthContext context) { _context = context; } public bool InsertTagMstr(RFIDTagMstr TagMstr) { string connStr = Globals.connStr; bool rslt = false; int rsltCnt = 0; using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("RFIDTagMstr_Insert", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TagUID", TagMstr.TagUID); cmd.Parameters.AddWithValue("@TagSignature", TagMstr.TagSignature); cmd.Parameters.AddWithValue("@TagEncryption", ""); cmd.Parameters.AddWithValue("@SoldToVendorKey", TagMstr.SoldToVendorKey); cmd.Parameters.AddWithValue("@Status", TagMstr.Status); cmd.Parameters.AddWithValue("@TimeStamp", TagMstr.TimeStamp); con.Open(); try { rsltCnt = cmd.ExecuteNonQuery(); } catch (Exception ex) { rslt = false; } con.Close(); if (rsltCnt == 1) { rslt = true; } return rslt; } } public IEnumerable GetAll_WD() { string connStr = Globals.connStr; List lst; lst = new List(); IEnumerable theList; using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("RFIDTagMstr_SelectAll_WD", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RFIDTagMstr_WD rec = new RFIDTagMstr_WD(); rec.Id = (int)rdr["Id"]; rec.TagUID = rdr["TagUID"].ToString(); rec.TagSignature = rdr["TagSignature"].ToString(); string STVK = rdr["SoldToVendorKey"].ToString(); if (STVK == "") { rec.SoldToVendorKey = 0; } else { rec.SoldToVendorKey = Convert.ToInt32(STVK); } rec.VendorName = rdr["VendorName"].ToString(); rec.Status = rdr["Status"].ToString(); rec.StatusDesc = rdr["StatusDesc"].ToString(); rec.TimeStamp = (DateTime)rdr["TimeStamp"]; lst.Add(rec); } con.Close(); } theList = lst; return theList; } public IEnumerable GetUnAssigneds() { string connStr = Globals.connStr; List lst; lst = new List(); IEnumerable theList; using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("RFIDTagMstr_Select_Unassigned", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { RFIDTagMstr_UnAssigned rec = new RFIDTagMstr_UnAssigned(); rec.Id = (int)rdr["Id"]; rec.TagUID = rdr["TagUID"].ToString(); string RFK = rdr["RFIDKey"].ToString(); if (RFK != "") { rec.RFIDKey = (int)rdr["RFIDKey"]; } else { rec.RFIDKey = 0; } rec.ItemName = rdr["ItemName"].ToString(); if (rec.RFIDKey == 0) { lst.Add(rec); } } con.Close(); } theList = lst; return theList; } public List GetSlctItms() { IEnumerable tblTUA; List Sli; bool slct = false; tblTUA = GetUnAssigneds(); Sli = new List(); foreach (var itm in tblTUA) { Sli.Add(new SelectListItem() { Value = itm.Id.ToString(), Text = itm.TagUID, Selected = slct }); slct = false; }; return Sli; } public List GetOneItem(int? RFKEy) { CertAuth.Domain.RFIDTagMstr tblTUA; List Sli; tblTUA = _context.RFIDTagMstr.FirstOrDefault(m => m.Id == RFKEy); Sli = new List(); Sli.Add(new SelectListItem() { Value = tblTUA.Id.ToString(), Text = tblTUA.TagUID, Selected = true }) ; return Sli; } } }