public static int UserValidation(String UserName, String Password) {
string PasswordCrypto = Util.GetEncryptedPassword(Password);
int result = 0;
using (var ctx = new ExponentPortalEntities()) {
var query = from data in ctx.MSTR_User
where ((data.UserName.Equals(UserName)
&& (data.Password.Equals(PasswordCrypto)))
|| (data.GeneratedPassword.Equals(PasswordCrypto)))
select data;
var _objuserdetail = query.ToList();
if (_objuserdetail.Count > 0)
{
if (_objuserdetail[0].GeneratedPassword == PasswordCrypto)
{
string updatesql = "update MSTR_User set Password='******',GeneratedPassword='' where UserId=" + _objuserdetail[0].UserId;
Util.doSQL(updatesql);
}
else { }
}
result = _objuserdetail.Count;
}
return result;
}
public bool saveValidationItem() {
Decimal dMinFieldValue = 0;
Decimal dMaxFieldValue = 0;
String MinFieldValue = Util.getQ("Field_Min_" + ID);
String MaxFieldValue = Util.getQ("Field_Max_" + ID);
if (FieldType.ToLower() == "checkbox") {
String FieldValue = Util.getQ("Field_" + ID);
if (FieldValue == "1") {
MinFieldValue = "1";
MaxFieldValue = "1";
} else {
MinFieldValue = "0";
MaxFieldValue = "0";
}
}
Decimal.TryParse(MinFieldValue, out dMinFieldValue);
Decimal.TryParse(MaxFieldValue, out dMaxFieldValue);
//Delete from table if already saved
String SQL = "DELETE FROM [DroneCheckListValidation] WHERE \n" +
" [DroneID]= " + DroneID + " AND\n" +
" [DroneCheckListID] = " + CheckListID + " AND\n" +
" [DroneCheckListItemID] = " + ID;
Util.doSQL(SQL);
//Save Mi
SQL = "INSERT INTO [DroneCheckListValidation](\n" +
" [DroneID],\n" +
" [DroneCheckListID],\n" +
" [DroneCheckListItemID],\n" +
" [MinValue],\n" +
" [MaxValue],\n" +
" [CanBeIgnored],\n" +
" [MustBeChecked]\n" +
") VALUES (\n" +
" " + DroneID + ",\n" +
" " + CheckListID + ",\n" +
" " + ID + ",\n" +
" " + dMinFieldValue.ToString() + ",\n" +
" " + dMaxFieldValue.ToString() + ",\n" +
" 1,\n" +
" 1\n" +
")";
Util.doSQL(SQL);
return true;
}
public String getLiveUAS() {
String SQL;
SQL = @"IF OBJECT_ID('tempdb..#TempLiveDrons') IS NOT NULL
DROP TABLE #TempLiveDrons;";
Util.doSQL(SQL);
SQL = @"select
DroneID,
max(FlightMapDataID) as FlightMapDataID
INTO
#TempLiveDrons
from
FlightMapData
WHERE
CreatedTime > DATEADD(month, -1, GETDATE())
Group BY
DroneID";
Util.doSQL(SQL);
SQL = @"SELECT
MSTR_Drone.DroneID,
FlightMapData.FlightID,
MSTR_Drone.AccountID,
MSTR_Drone.DroneName,
UAVType.Name as UAVType,
FlightMapData.Latitude,
FlightMapData.Longitude,
FlightMapData.ReadTime,
FlightMapData.Speed,
FlightMapData.Altitude,
FlightMapData.TotalFlightTime
FROM
FlightMapData,
#TempLiveDrons,
MSTR_Drone
LEFT JOIN LUP_Drone AS UAVType ON
UAVType.Type='UAVType' AND
MSTR_Drone.UavTypeId = UAVType.TypeID
WHERE
FlightMapData.FlightMapDataID = #TempLiveDrons.FlightMapDataID AND
MSTR_Drone.DroneID = FlightMapData.DroneID
";
return Util.getDBRowsJson(SQL);
}
}//DisplayField()
public int saveCheckListItem(int DroneCheckListID) {
String SQL = "";
SQL = "INSERT INTO [DroneCheckListItem](\n" +
" [DroneCheckListID],\n" +
" [DroneCheckListItemID],\n" +
" [FieldValue],\n" +
" [FieldNote]\n" +
") VALUES(\n" +
" " + DroneCheckListID.ToString() + ",\n" +
" " + ID.ToString() + ",\n" +
" '" + Util.toSQL(FieldValue) + "',\n" +
" '" + Util.toSQL(FieldNote) + "'\n" +
")";
Util.doSQL(SQL);
return 0;
}
}//getFlights()
public void saveTechnicalLog(HttpRequestBase Request) {
String SQL;
String[] Index = Request["theFlight.Index"].Split(',');
foreach (String RowID in Index) {
if (RowID == "SLNO") continue;
String FlightID = Request["theFlight[" + RowID + "].ID"];
String LogTakeOffTime = Request["theFlight[" + RowID + "].FlightDate"] + " " +
Request["theFlight[" + RowID + "].LogTakeOffTime"];
String LogLandingTime = Request["theFlight[" + RowID + "].FlightDate"] + " " +
Request["theFlight[" + RowID + "].LogLandingTime"];
if (FlightID == "0") {
//create new flight for drone
SQL =
"INSERT INTO DroneFlight (\n" +
" DroneID,\n" +
" PilotID,\n" +
" FlightDate,\n" +
" CreatedOn,\n" +
" CreatedBy,\n" +
" [LogFrom],\n" +
" [LogTo],\n" +
" [LogTakeOffTime],\n" +
" [LogLandingTime],\n" +
" [LogBattery1ID],\n" +
" [LogBattery1StartV],\n" +
" [LogBattery1EndV],\n" +
" [LogBattery2ID],\n" +
" [LogBattery2StartV],\n" +
" [LogBattery2EndV],\n" +
" [isLogged],\n" +
" [LogDateTime],\n" +
" [LogCreatedBy],\n" +
" [Descrepency],\n" +
" [ActionTaken]\n" +
") VALUES (" +
" " + Util.toInt(Request["DroneID"]) + ",\n" +
" " + Util.getLoginUserID() + ",\n" +
" '" + Util.toSQLDate(LogTakeOffTime) + "',\n" +
" GETDATE(),\n" +
" " + Util.getLoginUserID() + ",\n" +
" '" + Request["theFlight[" + RowID + "].LogFrom"] + "',\n" +
" '" + Request["theFlight[" + RowID + "].LogTo"] + "',\n" +
" '" + Util.toSQLDate(LogTakeOffTime) + "',\n" +
" '" + Util.toSQLDate(LogLandingTime) + "',\n" +
" '" + Request["theFlight[" + RowID + "].LogBattery1ID"] + "',\n" +
" " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery1StartV"]) + ",\n" +
" " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery1EndV"]) + ",\n" +
" '" + Request["theFlight[" + RowID + "].LogBattery2ID"] + "',\n" +
" " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery2StartV"]) + ",\n" +
" " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery2EndV"]) + ",\n" +
" 1,\n" +
" GETDATE(),\n" +
" " + Util.getLoginUserID() + ",\n" +
" '" + Request["theFlight[" + RowID + "].Descrepency"] + "',\n" +
" '" + Request["theFlight[" + RowID + "].ActionTaken"] + "'\n" +
")";
Util.doSQL(SQL);
} else { //if(FlightID == "0")
//Update flight information for technical Log
SQL =
"UPDATE\n" +
" DroneFlight\n" +
"SET\n" +
" [LogFrom] = '" + Request["theFlight[" + RowID + "].LogFrom"] + "',\n" +
" [LogTo] = '" + Request["theFlight[" + RowID + "].LogTo"] + "',\n" +
" [LogTakeOffTime] = '" + Util.toSQLDate(LogTakeOffTime) + "',\n" +
" [LogLandingTime] = '" + Util.toSQLDate(LogLandingTime) + "',\n" +
" [LogBattery1ID] = '" + Request["theFlight[" + RowID + "].LogBattery1ID"] + "',\n" +
" [LogBattery1StartV] = " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery1StartV"]) + ",\n" +
" [LogBattery1EndV] = " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery1EndV"]) + ",\n" +
" [LogBattery2ID] = '" + Request["theFlight[" + RowID + "].LogBattery2ID"] + "',\n" +
" [LogBattery2StartV] = " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery2StartV"]) + ",\n" +
" [LogBattery2EndV] = " + Util.toDecimal(Request["theFlight[" + RowID + "].LogBattery2EndV"]) + ",\n" +
" [isLogged] = 1,\n" +
" [LogDateTime] = GETDATE(),\n" +
" LogCreatedBy=" + Util.getLoginUserID() + ",\n" +
" Descrepency = '" + Request["theFlight[" + RowID + "].Descrepency"] + "',\n" +
" ActionTaken = '" + Request["theFlight[" + RowID + "].ActionTaken"] + "'\n" +
"WHERE\n" +
" ID=" + FlightID;
Util.doSQL(SQL);
}//if(FlightID == "0")
}//foreach(Index)
}//saveTechnicalLog()
