public Guid UpdateRFIDlog(SMSRFIDLog RFIDlog)
{
Guid rfID = Guid.Empty;
LogDAL member = new LogDAL();
rfID = member.UpdateRFIDlog(RFIDlog);
return(rfID);
}
public List <SMSRFIDLog> GetAllRFIDLog()
{
List <SMSRFIDLog> listOfRFID = new List <SMSRFIDLog>();
using (DbConnection conn = Reedley.CreateConnection())
{
conn.Open();
try
{
using (DbCommand sprocCmd = conn.CreateCommand())
{
sprocCmd.CommandType = CommandType.StoredProcedure;
sprocCmd.CommandText = spGetAllRFIDByGateTerminal;
using (IDataReader sprocReader = Reedley.ExecuteReader(sprocCmd))
{
while (sprocReader.Read())
{
SMSRFIDLog svc = new SMSRFIDLog();
svc.RFIDLogID = sprocReader["RFIDLogID"].ToGuid();
svc.RFID = sprocReader["RFID"].ToStringDefault();
svc.DateTimeStamp = sprocReader["DateTimeStamp"].ToStringDefault();
svc.LogType = sprocReader["LogType"].ToStringDefault();
svc.FirstName = sprocReader["FirstName"].ToStringDefault();
svc.LastName = sprocReader["LastName"].ToStringDefault();
svc.MiddleName = sprocReader["MiddleName"].ToStringDefault();
svc.MobileNumber = sprocReader["MobileNumber"].ToStringDefault();
svc.Status = sprocReader["Status"].ToStringDefault();
listOfRFID.Add(svc);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(listOfRFID);
}
public Guid UpdateRFIDlog(SMSRFIDLog RFIDlog)
{
Guid RFIDLogID = RFIDlog.RFIDLogID;
using (DbConnection conn = Reedley.CreateConnection())
{
conn.Open();
try
{
using (DbCommand sprocCmd = conn.CreateCommand())
{
sprocCmd.CommandType = CommandType.StoredProcedure;
sprocCmd.CommandText = spUpdateRFIDLog;
sprocCmd.Parameters.Add(new SqlParameter("@RFIDLogID", RFIDlog.RFIDLogID.ToDatabaseObj())
{
SqlDbType = SqlDbType.UniqueIdentifier
});
sprocCmd.Parameters.Add(new SqlParameter("@Status", RFIDlog.Status.ToDatabaseObj())
{
SqlDbType = SqlDbType.NVarChar
});
using (IDataReader sprocReader = Reedley.ExecuteReader(sprocCmd))
{
while (sprocReader.Read())
{
RFIDLogID = sprocReader["RFIDLogID"].ToGuid();
}
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
return(RFIDLogID);
}
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);
}
