using System; using System.Collections.Generic; using System.Linq; using System.Runtime.ConstrainedExecution; using System.Threading.Tasks; using CertAuth.Domain; using Microsoft.AspNetCore.Mvc.Rendering; using Microsoft.Data.SqlClient; namespace CertAuthAdmin.Models { public class TableDtlDA { public List tblDtl { get; set; } private List Sli { get; set; } public List GetByTableCode(string TblCd, string Stat) { string connStr = Globals.connStr; List DtlCodelst; DtlCodelst = new List(); using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("TableDtl_GetByTableCode", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = "Select DetailCode from TableDtl Where TableCode = @TableCode and Status = @Status"; cmd.Parameters.AddWithValue("@TableCode", TblCd); cmd.Parameters.AddWithValue("@Status", Stat); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { string DtlCode = rdr["DetailCode"].ToString(); DtlCodelst.Add(DtlCode); } con.Close(); } return DtlCodelst; } public List GetRecrdByTableCode(string TblCd, string Stat) { string connStr = Globals.connStr; List DtlTbl = new List(); using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("TableDtl_GetByTableCode", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = "Select DetailCode from TableDtl Where TableCode = @TableCode and Status = @Status"; cmd.Parameters.AddWithValue("@TableCode", TblCd); cmd.Parameters.AddWithValue("@Status", Stat); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CertAuth.Domain.TableDtl DtlRow = new CertAuth.Domain.TableDtl(); DtlRow.Id = (int)rdr["Id"]; DtlRow.TableCode = rdr["TableCode"].ToString(); DtlRow.DetailCode = rdr["DetailCode"].ToString(); DtlRow.CodeDescShort = rdr["CodeDescShort"].ToString(); DtlRow.CodeDescLong = rdr["CodeDescLong"].ToString(); DtlRow.Status = rdr["Status"].ToString(); DtlRow.TimeStamp = (DateTime)rdr["TimeStamp"]; DtlTbl.Add(DtlRow); DtlRow = null; } con.Close(); } return DtlTbl; } public List GetRecrdByTableCodeWD(string TblCd, string Stat) { string connStr = Globals.connStr; List DtlTbl = new List(); using (SqlConnection con = new SqlConnection(connStr)) { SqlCommand cmd = new SqlCommand("TableDtl_GetByTableCode_WD", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; //cmd.CommandType = System.Data.CommandType.Text; //cmd.CommandText = "Select DetailCode from TableDtl Where TableCode = @TableCode and Status = @Status"; cmd.Parameters.AddWithValue("@TableCode", TblCd); cmd.Parameters.AddWithValue("@Status", Stat); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { CertAuth.Domain.TableDtl_WD DtlRow = new CertAuth.Domain.TableDtl_WD(); DtlRow.Id = (int)rdr["Id"]; DtlRow.TableCode = rdr["TableCode"].ToString(); DtlRow.DetailCode = rdr["DetailCode"].ToString(); DtlRow.CodeDescShort = rdr["CodeDescShort"].ToString(); DtlRow.CodeDescLong = rdr["CodeDescLong"].ToString(); DtlRow.Status = rdr["Status"].ToString(); DtlRow.StatusDesc = rdr["StatusDesc"].ToString(); DtlRow.TimeStamp = (DateTime)rdr["TimeStamp"]; DtlTbl.Add(DtlRow); DtlRow = null; } con.Close(); } return DtlTbl; } public List GetSlctItms(string TblType, string Stat, bool setSelect, string SelectVal) { bool slct = false; tblDtl = GetRecrdByTableCode(TblType, Stat); Sli = new List(); foreach (var itm in tblDtl) { if (setSelect && SelectVal == itm.DetailCode) { slct = true; } Sli.Add(new SelectListItem() { Value = itm.DetailCode, Text = itm.CodeDescShort, Selected = slct }); slct = false; }; return Sli; } //public List GetSlctLstUsers(bool setSelect, string SelectVal) //{ // List UsersSli; // bool slct = false; // UsersDA _UserDA = new UsersDA(); // IEnumerable tblUsers = _UserDA.GetAll(); // foreach (var itm in tblUsers) // { // if // } //} } }