public static List <ClientsRecord> AllUserList() { List <ClientsRecord> UserList = new List <ClientsRecord>(); using (DBClass context = new DBClass()) { DataTable dt = context.getData("getAllUserList", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { UserList.Add(new ClientsRecord { UserName = Convert.ToString(dr["UserName"]), Name = dr["Name"].ToString(), //Company = Convert.ToString(dr["Company"]), Phone = Convert.ToString(dr["Phone"]), EmailID = Convert.ToString(dr["Email_ID"]), CreatedDate = Convert.ToDateTime(dr["CreationDate"]), UserRole = Convert.ToString(dr["UserRole"]), }); } return(UserList); } }
public List <Enquiry> getAllEnquiryData() { List <Enquiry> enquiryList = new List <Enquiry>(); // creating list of model. DataTable dt = new DataTable(); using (DBClass context = new DBClass()) { dt = context.getData("getAllEnquiry", CommandType.StoredProcedure); foreach (DataRow dr in dt.Rows) { enquiryList.Add(new Enquiry { EnquiryID = Convert.ToString(dr["ID"]), UserName = Convert.ToString(dr["UserName"]), Enq_Category = Convert.ToString(dr["EnquiryCategory"]), Enq_Subject = Convert.ToString(dr["EnquirySubject"]), EnquiryDetail1 = Convert.ToString(dr["EnquiryDetail"]), Enq_CreateDate = Convert.ToString(dr["CreateDate"]), Buyer_Count = Convert.ToInt32(dr["Buyer_Count"]) }); } return(enquiryList); } }