public bool Varified()
{
ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO();
try
{
db.setQuery(@"select * from AVLUserVarify
WHERE userID=@userID AND phoneVarified = @phoneVarified ");
db.AddParams("@userID", this.userID);
db.AddParams("@phoneVarified", true);
if (db.Query_DataTable().Rows.Count > 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
ClassLibrary.JSystem.Except.AddException(ex);
return(false);
}
finally
{
db.Dispose();
}
}
public static bool SendToOldDatabase(byte[] pData)
{
System.Data.SqlClient.SqlConnectionStringBuilder constr = new System.Data.SqlClient.SqlConnectionStringBuilder();
constr.DataSource = ".";
constr.InitialCatalog = "BusAvlSendLogs";
constr.UserID = "sa";
constr.Password = "******";
ClassLibrary.JDataBase db = new ClassLibrary.JDataBase(constr);
try
{
db.setQuery("Insert into SendLogs(SendLog) VALUES(@SendLog)");
db.AddParams("SendLog", pData);
if (db.Query_Execute() >= 0)
{
return(true);
}
return(false);
}
catch (Exception ex)
{
return(false);
}
finally
{
db.Dispose();
}
}
public static bool AddAVL(DataTable pDT, string pErrorCommand)
{
if (pDT == null || pDT.Rows.Count == 0)
{
return(true);
}
string fileName = Guid.NewGuid().ToString();
BusManagment.Transaction.JTicketTransactions.WriteDataTableToFile(pDT, fileName, false);
ClassLibrary.JDataBase db = new ClassLibrary.JDataBase();
int BusSerial = 0;
try
{
if (pDT.Rows.Count >= 1)
{
int.TryParse(pDT.Rows[0]["BusSerial"].ToString(), out BusSerial);
}
if (BusSerial > 0 && BusSerial < 10000)
{
if (semaphore[BusSerial] == null)
{
semaphore[BusSerial] = new Semaphore(1, 1);
}
semaphore[BusSerial].WaitOne();
}
db.DataTypesName = "dbo.AVLPointList";
db.setQuery(@"EXEC SP_InsertAUTAvlTransactionWithDataTable @List");
db.AddParams("@List", pDT);
db.CommandTimeout = 60 * pDT.Rows.Count;
db.Query_Execute();
if (!db.Error)
{
BusManagment.Transaction.JTicketTransactions.Deleted(fileName, false);
}
return(true);
}
catch (Exception ex)
{
return(false);
}
finally
{
if (BusSerial > 0 && BusSerial < 10000)
{
semaphore[BusSerial].Release();
}
db.Dispose();
}
}
public bool Update()
{
//JPersonAddressTable addressTable = new JPersonAddressTable();
//addressTable.SetValueProperty(this);
//return addressTable.Update();
ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO();
try
{
db.setQuery(@"UPDATE AVLUserVarify SET
email=@email , phonenumber = @phonenumber, phoneVarified = @phoneVarified, emailVarified = @emailVarified
WHERE userID=@userID");
db.AddParams("@email", this.email);
db.AddParams("@phonenumber", this.phonenumber);
db.AddParams("@phoneVarified", this.phoneVarified);
db.AddParams("@emailVarified", this.emailVarified);
db.AddParams("@userID", this.userID);
db.beginTransaction("UpdateAVLUserVarify");
if (db.Query_Execute() > -1)
{
if (db.Commit())
{
return(true);
}
}
db.Rollback("UpdateAVLUserVarify");
return(false);
}
catch (Exception ex)
{
ClassLibrary.JSystem.Except.AddException(ex);
db.Rollback("UpdateAVLUserVarify");
return(false);
}
finally
{
db.Dispose();
}
}
public static bool AddAVL(TransactionPublic.JTransactionAVLHeader AH, TransactionPublic.JTransactionAVL AVL, Int64 recordNumber, string Header_IMEI, float Header_BusSerial, byte[] Header_Version, ClassLibrary.JDataBase db)
{
if (db == null || AH == null || AVL == null)
{
return(false);
}
db.Params.Clear();
if (db.Params.Count > 0)
{
try
{
db.Params.Remove("Longitude");
db.Params.Remove("Latitude");
db.Params.Remove("Altitude");
db.Params.Remove("Speed");
db.Params.Remove("Course");
db.Params.Remove("EventDate");
db.Params.Remove("SimCardCharge");
db.Params.Remove("BusSerial");
db.Params.Remove("IMEI");
db.Params.Remove("Version");
db.Params.Remove("BatteryCharge");
db.Params.Remove("GpsAnt");
db.Params.Remove("GsmAnt");
db.Params.Remove("recordNumber");
db.Params.Remove("TransactionID");
db.Params.Remove("Dir");
}
catch
{
}
}
DateTime dtemp;
string date = (new DateTime(AH.DATE.Year, AH.DATE.Month, AH.DATE.Day, AVL.Time[0], AVL.Time[1], AVL.Time[2])).ToString("yyyy-MM-dd HH:mm:ss");
if (DateTime.TryParse(date, out dtemp) & AH.DATE.Year >= 2015)
{
}
else
{
date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
db.setQuery(@"EXEC SP_InsertAUTAvlTransaction_Zarrin_Save_Just_Point
@Longitude,
@Latitude,
@Altitude,
@Speed,
@Course,
@EventDate,
@SimCardCharge,
@BusSerial,
@IMEI,
@Version,
@BatteryCharge,
@GpsAnt,
@GsmAnt,
@recordNumber,
@TransactionID,
@Dir");
db.AddParams("Longitude", AVL.Lon);
db.AddParams("Latitude", AVL.Lat);
db.AddParams("Altitude", AVL.Alt.ToString());
db.AddParams("Speed", AVL.Speed.ToString());
db.AddParams("Course", AVL.Cource.ToString());
db.AddParams("EventDate", date);
db.AddParams("SimCardCharge", AH.SimCharge.ToString());
db.AddParams("BusSerial", AH.busSerial.ToString());
db.AddParams("IMEI", Header_IMEI.ToString());
db.AddParams("Version", Header_Version);
db.AddParams("BatteryCharge", AH.Battryvoltvalue.ToString());
db.AddParams("GpsAnt", AH.GpsAnttena.ToString());
db.AddParams("GsmAnt", AH.GsmAnttena.ToString());
db.AddParams("recordNumber", recordNumber.ToString());
db.AddParams("TransactionID", AVL.transactionid.ToString());
db.AddParams("Dir", AVL.Dir.ToString());
db.CommandTimeout = 60;
if (db.Query_Execute() >= 0)
{
db.Params.Clear();
return(true);
}
return(true);
}
public static bool AddAVL(Transaction.JTransactionAVLHeader AH, Transaction.JTransactionAVL AVL, Int64 recordNumber, string Header_IMEI, float Header_BusSerial, byte[] Header_Version, ClassLibrary.JDataBase pdb, string pErrorCommand)
{
if (AH == null || AVL == null)
{
return(false);
}
ClassLibrary.JDataBase db = new ClassLibrary.JDataBase();
db.Params.Clear();
//if(AH.busSerial == 2122)
// db.Params.Clear();
if (db.Params.Count > 0)
{
try
{
db.Params.Remove("Longitude");
db.Params.Remove("Latitude");
db.Params.Remove("Altitude");
db.Params.Remove("Speed");
db.Params.Remove("Course");
db.Params.Remove("EventDate");
db.Params.Remove("SimCardCharge");
db.Params.Remove("BusSerial");
db.Params.Remove("IMEI");
db.Params.Remove("Version");
db.Params.Remove("BatteryCharge");
db.Params.Remove("GpsAnt");
db.Params.Remove("GsmAnt");
db.Params.Remove("recordNumber");
db.Params.Remove("TransactionID");
db.Params.Remove("Dir");
db.Params.Remove("BusLine");
}
catch
{
}
}
string date = (new DateTime(AH.DATE.Year, AH.DATE.Month, AH.DATE.Day, AVL.Time[0], AVL.Time[1], AVL.Time[2])).ToString("yyyy-MM-dd HH:mm:ss");
db.setQuery(@"EXEC SP_InsertAUTAvlTransaction_Zarrin_Save_Just_Point
@Longitude,
@Latitude,
@Altitude,
@Speed,
@Course,
@EventDate,
@SimCardCharge,
@BusSerial,
@IMEI,
@Version,
@BatteryCharge,
@GpsAnt,
@GsmAnt,
@recordNumber,
@TransactionID,
@Dir,
@BusLine");
db.AddParams("Longitude", AVL.Lon);
db.AddParams("Latitude", AVL.Lat);
db.AddParams("Altitude", AVL.Alt.ToString());
db.AddParams("Speed", AVL.Speed.ToString());
db.AddParams("Course", AVL.Cource.ToString());
db.AddParams("EventDate", date);
db.AddParams("SimCardCharge", AH.SimCharge.ToString());
db.AddParams("BusSerial", AH.busSerial.ToString());
db.AddParams("IMEI", Header_IMEI.ToString());
db.AddParams("Version", Header_Version);
db.AddParams("BatteryCharge", AH.Battryvoltvalue.ToString());
db.AddParams("GpsAnt", AH.GpsAnttena.ToString());
db.AddParams("GsmAnt", AH.GsmAnttena.ToString());
db.AddParams("recordNumber", recordNumber.ToString());
db.AddParams("TransactionID", AVL.transactionid.ToString());
db.AddParams("Dir", AVL.Dir.ToString());
db.AddParams("BusLine", AH.busLine.ToString());
DataTable dt;
try
{
db.CommandTimeout = 60;
db.Query_Execute(true, pErrorCommand, false);
//db.Dispose();
return(true);
//dt = db.Query_DataTable();
//if (dt != null && dt.Rows.Count > 0 && Convert.ToInt32(dt.Rows[0][0]) > 0)
//{
// db.Params.Clear();
// return true;
//}
//else
// return false;
}
catch (Exception ex)
{
return(false);
}
}