public RFIDLogEntityDC GetLogsByRFID(string RFID)
{
RFIDLogEntityDC listOfRFID = new RFIDLogEntityDC();
LogDAL member = new LogDAL();
listOfRFID = member.GetLogByRFID(RFID);
return(listOfRFID);
}
public RFIDLogEntityDC InsertRFIDlog(RFIDLogEntityDC member)
{
LogDAL userDAL = new LogDAL();
RFIDLogEntityDC memberResponse = new RFIDLogEntityDC();
memberResponse = userDAL.InsertRFIDlog(member);
return(memberResponse);
}
public RFIDLogEntityDC GetLogsByRFID(string RFID)
{
RFIDLogEntityDC listOfRFID = new RFIDLogEntityDC();
LogServiceManager member = new LogServiceManager();
listOfRFID = member.GetLogsByRFID(RFID);
return(listOfRFID);
}
public RFIDLogEntityDC GetLogByRFID(string RFID)
{
RFIDLogEntityDC rfidLog = new RFIDLogEntityDC();
using (DbConnection conn = Reedley.CreateConnection())
{
conn.Open();
try
{
using (DbCommand sprocCmd = conn.CreateCommand())
{
sprocCmd.CommandType = CommandType.StoredProcedure;
sprocCmd.CommandText = spGetLogByRFID;
sprocCmd.Parameters.Add(new SqlParameter("@RFID", RFID)
{
SqlDbType = SqlDbType.NVarChar
});
using (IDataReader sprocReader = Reedley.ExecuteReader(sprocCmd))
{
while (sprocReader.Read())
{
rfidLog.RFIDLogID = sprocReader["RFIDLogID"].ToGuid();
rfidLog.RFID = sprocReader["RFID"].ToStringDefault();
rfidLog.DateTimeStamp = sprocReader["DateTimeStamp"].ToStringDefault();
rfidLog.LogType = sprocReader["LogType"].ToStringDefault();
rfidLog.Status = sprocReader["Status"].ToStringDefault();
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(rfidLog);
}
public RFIDLogEntityDC InsertRFIDlog(RFIDLogEntityDC RFIDlog)
{
RFIDLogEntityDC logResult = new RFIDLogEntityDC();
using (DbConnection conn = Reedley.CreateConnection())
{
conn.Open();
try
{
using (DbCommand sprocCmd = conn.CreateCommand())
{
sprocCmd.CommandType = CommandType.StoredProcedure;
sprocCmd.CommandText = spInsertRFIDlog;
sprocCmd.Parameters.Add(new SqlParameter("@RFIDLogID", RFIDlog.RFIDLogID.ToDatabaseObj())
{
SqlDbType = SqlDbType.UniqueIdentifier
});
sprocCmd.Parameters.Add(new SqlParameter("@RFID", RFIDlog.RFID.ToDatabaseObj())
{
SqlDbType = SqlDbType.NVarChar
});
sprocCmd.Parameters.Add(new SqlParameter("@DateTimeStamp", RFIDlog.DateTimeStamp.ToDatabaseObj())
{
SqlDbType = SqlDbType.DateTime
});
sprocCmd.Parameters.Add(new SqlParameter("@GateTerminalID", RFIDlog.GateTerminalID.ToDatabaseObj())
{
SqlDbType = SqlDbType.UniqueIdentifier
});
sprocCmd.Parameters.Add(new SqlParameter("@Status", RFIDlog.Status.ToDatabaseObj())
{
SqlDbType = SqlDbType.NVarChar
});
sprocCmd.Parameters.Add(new SqlParameter("@LogType", RFIDlog.LogType.ToDatabaseObj())
{
SqlDbType = SqlDbType.NVarChar
});
using (IDataReader sprocReader = Reedley.ExecuteReader(sprocCmd))
{
while (sprocReader.Read())
{
logResult.RFIDLogID = sprocReader["RFIDLogID"].ToGuid();
logResult.DateTimeStamp = sprocReader["DateTimeStamp"].ToStringDefault();
logResult.LogType = sprocReader["LogType"].ToString();
logResult.GateTerminalID = sprocReader["GateTerminalID"].ToGuid();
logResult.Status = sprocReader["Status"].ToString();
}
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(RFIDlog);
}
public RFIDLogEntityDC InsertRFIDLogs(RFIDLogEntityDC RFIDlog)
{
LogServiceManager memberManager = new LogServiceManager();
memberManager.InsertRFIDlog(RFIDlog);
SMSRFIDLog list = new SMSRFIDLog();
List <SMSRFIDLog> listOfRFID = new List <SMSRFIDLog>();
listOfRFID = memberManager.GetAllRFIDLog();
int count = listOfRFID.Count();
string smsurl = ConfigurationManager.AppSettings["SMSUrl"];
int i = 0;
if (count != 0)
{
//do
//{
foreach (SMSRFIDLog logs in listOfRFID)
{
if (logs.LogType.ToInt() == 2)
{
try
{
if (logs.MobileNumber.Length == 12)
{
Console.WriteLine("Successfully Send:{0} ", listOfRFID[i].RFID);
string uri = smsurl + listOfRFID[i].MobileNumber + " &message-type=sms.automatic&message="
+ "Reedley International School Log Out of " + listOfRFID[i].LastName + ", " + listOfRFID[i].FirstName + ", " + listOfRFID[i].MiddleName + ". " + listOfRFID[i].DateTimeStamp +
" .System Generated SMS do not reply";
// Send the HTTP request to Diafaan SMS Server
WebRequest request = WebRequest.Create(uri);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
{
// Get the HTTP response from Diafaan SMS Server
Stream dataStream = response.GetResponseStream();
using (StreamReader reader = new StreamReader(dataStream))
{
reader.ReadToEnd();
}
}
}
SMSRFIDLog rfidLog = new SMSRFIDLog();
rfidLog.Status = logs.Status;
rfidLog.RFIDLogID = logs.RFIDLogID;
var updateMemb = memberManager.UpdateRFIDlog(rfidLog);
//var insertLogs = member.InsertRFIDlog(RFIDlog);
}
catch
{
throw;
}
}
else
{
try
{
if (logs.MobileNumber.Length == 12)
{
Console.WriteLine("Successfully Send:{0} ", listOfRFID[i].RFID);
string uri = smsurl + listOfRFID[i].MobileNumber + " &message-type=sms.automatic&message="
+ "Reedley International School Log In of " + listOfRFID[i].LastName + ", " + listOfRFID[i].FirstName + ", " + listOfRFID[i].MiddleName + ". " + listOfRFID[i].DateTimeStamp +
" .System Generated SMS do not reply";
// Send the HTTP request to Diafaan SMS Server
WebRequest request = WebRequest.Create(uri);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
{
// Get the HTTP response from Diafaan SMS Server
Stream dataStream = response.GetResponseStream();
using (StreamReader reader = new StreamReader(dataStream))
{
reader.ReadToEnd();
}
}
}
SMSRFIDLog rfidLog = new SMSRFIDLog();
rfidLog.Status = logs.Status;
rfidLog.RFIDLogID = logs.RFIDLogID;
var updateMemb = memberManager.UpdateRFIDlog(rfidLog);
}
catch
{
throw;
}
}
// i++;
//} while (i < count);
}
}
return(RFIDlog);
}
