public IDataSourceAccesser GetAccesserForSource(AccesserType source) { if (Accessers.Count == 0) { Type interfaceType = typeof(IDataSourceAccesser); Type attributeType = typeof(DataSourceAccesserAttribute); var types = AppDomain.CurrentDomain.GetAssemblies().SelectMany(assembly => assembly.GetTypes()) .Where(t => interfaceType.IsAssignableFrom(t) && !t.IsInterface).ToArray(); var attributes = types.SelectMany(type => type.GetCustomAttributes(attributeType, false)).ToArray(); for (int i = 0; i < types.Count(); i++) { var attribute = (DataSourceAccesserAttribute)attributes[i]; var accesser = (IDataSourceAccesser)Activator.CreateInstance(types[i]); Accessers.Add(attribute.AccesserType, accesser); } } return(Accessers[source]); }
public ActionResult BGirisi() { Accessers accessers = new Accessers(); SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=cms;User ID=cmsadmin;Password=Honeybc01"); conn.Open(); #region first SqlCommand firstcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'B_T3_K4' ORDER BY [TRANSIT_DATE] DESC", conn); int firstsbi = 0; SqlDataReader firstCardReader = firstcmd.ExecuteReader(); while (firstCardReader.Read()) { var data = firstCardReader.GetValue(0).ToString(); firstsbi = int.Parse(data); accessers.firstCardNu = firstCardReader.GetValue(1).ToString(); accessers.firstDirection = firstCardReader.GetValue(2).ToString() == "Entry" ? "Giriş" : "Çıkış"; } firstCardReader.Close(); SqlCommand firstGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); firstGetInfo.Parameters.AddWithValue("@SBI", firstsbi); SqlDataReader firstdr = firstGetInfo.ExecuteReader(); while (firstdr.Read()) { accessers.firtsName = firstdr.GetValue(1).ToString(); accessers.firstSurname = firstdr.GetValue(2).ToString(); //accessers.firstImage = firstdr.GetValue(3).ToString(); accessers.firstImage = "file://10.34.60.2/HolderImages/" + firstdr.GetValue(3).ToString(); } firstdr.Close(); firstcmd.Dispose(); firstGetInfo.Dispose(); #endregion #region second SqlCommand secondcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'B_T3_K5' ORDER BY [TRANSIT_DATE] DESC", conn); int secondsbi = 0; SqlDataReader secondCardReader = secondcmd.ExecuteReader(); while (secondCardReader.Read()) { var data = secondCardReader.GetValue(0).ToString(); secondsbi = int.Parse(data); accessers.secondCardNu = secondCardReader.GetValue(1).ToString(); accessers.secondDirection = secondCardReader.GetValue(2).ToString() == "Entry" ? "Giriş" : "Çıkış"; } secondCardReader.Close(); SqlCommand secondGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); secondGetInfo.Parameters.AddWithValue("@SBI", secondsbi); SqlDataReader seconddr = secondGetInfo.ExecuteReader(); while (seconddr.Read()) { accessers.secondName = seconddr.GetValue(1).ToString(); accessers.secondSurname = seconddr.GetValue(2).ToString(); //accessers.secondImage = seconddr.GetValue(3).ToString(); accessers.secondImage = "file://10.34.60.2/HolderImages/" + seconddr.GetValue(3).ToString(); } seconddr.Close(); secondcmd.Dispose(); secondGetInfo.Dispose(); #endregion conn.Close(); //ViewBag.Message = accessers; return(View(accessers)); }
// GET: Home public ActionResult Index() { Accessers accessers = new Accessers(); SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=cms;User ID=cmsadmin;Password=Honeybc01"); conn.Open(); #region first SqlCommand firstcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'TKK1' ORDER BY [TRANSIT_DATE] DESC", conn); int firstsbi = 0; SqlDataReader firstCardReader = firstcmd.ExecuteReader(); while (firstCardReader.Read()) { var data = firstCardReader.GetValue(0).ToString(); firstsbi = int.Parse(data); accessers.firstCardNu = firstCardReader.GetValue(1).ToString(); accessers.firstDirection = firstCardReader.GetValue(2).ToString(); } firstCardReader.Close(); SqlCommand firstGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); firstGetInfo.Parameters.AddWithValue("@SBI", firstsbi); SqlDataReader firstdr = firstGetInfo.ExecuteReader(); while (firstdr.Read()) { accessers.firtsName = firstdr.GetValue(1).ToString(); accessers.firstSurname = firstdr.GetValue(2).ToString(); //accessers.firstImage = firstdr.GetValue(3).ToString(); accessers.firstImage = "http://ebi500dra/AccessCapturer/cmsimage/" + firstdr.GetValue(3).ToString(); } firstdr.Close(); firstcmd.Dispose(); firstGetInfo.Dispose(); #endregion #region second SqlCommand secondcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'TESTTKEY' ORDER BY [TRANSIT_DATE] DESC", conn); int secondsbi = 0; SqlDataReader secondCardReader = secondcmd.ExecuteReader(); while (secondCardReader.Read()) { var data = secondCardReader.GetValue(0).ToString(); secondsbi = int.Parse(data); accessers.secondCardNu = secondCardReader.GetValue(1).ToString(); accessers.secondDirection = secondCardReader.GetValue(2).ToString(); } secondCardReader.Close(); SqlCommand secondGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); secondGetInfo.Parameters.AddWithValue("@SBI", secondsbi); SqlDataReader seconddr = secondGetInfo.ExecuteReader(); while (seconddr.Read()) { accessers.secondName = seconddr.GetValue(1).ToString(); accessers.secondSurname = seconddr.GetValue(2).ToString(); //accessers.secondImage = seconddr.GetValue(3).ToString(); accessers.secondImage = "http://ebi500dra/AccessCapturer/cmsimage/" + seconddr.GetValue(3).ToString(); } seconddr.Close(); secondcmd.Dispose(); secondGetInfo.Dispose(); #endregion #region third SqlCommand thirdcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'DOORVO' ORDER BY [TRANSIT_DATE] DESC", conn); int thirdsbi = 0; SqlDataReader thirdCardReader = thirdcmd.ExecuteReader(); while (thirdCardReader.Read()) { var data = thirdCardReader.GetValue(0).ToString(); thirdsbi = int.Parse(data); accessers.thirdCardNu = thirdCardReader.GetValue(1).ToString(); accessers.thirdDirection = thirdCardReader.GetValue(2).ToString(); } thirdCardReader.Close(); SqlCommand thirdGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); thirdGetInfo.Parameters.AddWithValue("@SBI", thirdsbi); SqlDataReader thirddr = thirdGetInfo.ExecuteReader(); while (thirddr.Read()) { accessers.thirdName = thirddr.GetValue(1).ToString(); accessers.thirdSurname = thirddr.GetValue(2).ToString(); //accessers.thirdImage = thirddr.GetValue(3).ToString(); accessers.thirdImage = "http://ebi500dra/AccessCapturer/cmsimage/" + thirddr.GetValue(3).ToString(); } thirddr.Close(); thirdcmd.Dispose(); thirdGetInfo.Dispose(); #endregion #region forth SqlCommand forthcmd = new SqlCommand("SELECT TOP 1 SBI_ID, CARD_NUMBER, STR_DIRECTION FROM [cms].[dbo].[HA_TRANSIT] Where [TERMINAL]= 'TKEYMEMO' ORDER BY [TRANSIT_DATE] DESC", conn); int forthsbi = 0; SqlDataReader forthCardReader = forthcmd.ExecuteReader(); while (forthCardReader.Read()) { var data = forthCardReader.GetValue(0).ToString(); forthsbi = int.Parse(data); accessers.forthCardNu = forthCardReader.GetValue(1).ToString(); accessers.forthDirection = forthCardReader.GetValue(2).ToString(); } forthCardReader.Close(); SqlCommand forthGetInfo = new SqlCommand("SELECT [SbiID],[Name],[Surname],[CHImage] FROM[cms].[dbo].[Employee] where SbiID =@SBI", conn); forthGetInfo.Parameters.AddWithValue("@SBI", forthsbi); SqlDataReader forthdr = forthGetInfo.ExecuteReader(); while (forthdr.Read()) { accessers.forthName = forthdr.GetValue(1).ToString(); accessers.forthSurname = forthdr.GetValue(2).ToString(); //accessers.forthImage = forthdr.GetValue(3).ToString(); accessers.forthImage = "http://ebi500dra/AccessCapturer/cmsimage/" + forthdr.GetValue(3).ToString(); } forthdr.Close(); forthcmd.Dispose(); forthGetInfo.Dispose(); #endregion conn.Close(); //ViewBag.Message = accessers; return(View(accessers)); }