public static IEnumerable <SelectListItem> GetRAPSDroneList()
{
List <SelectListItem> SelectList = new List <SelectListItem>();
SelectList.Add(new SelectListItem {
Text = "Please Select...", Value = ""
});
String SQL = "SELECT 0 as Value, 'Not Available' as Name";
using (var ctx = new ExponentPortalEntities()) {
using (var cmd = ctx.Database.Connection.CreateCommand()) {
ctx.Database.Connection.Open();
SQL = "SELECT [DroneId] as Value, [RPASSerialNo] as Name FROM [MSTR_Drone] where IsActive=1";
SQL += "\n" +
" AND\n " +
" MSTR_Drone.CreatedBy =" + Util.getLoginUserID();
SQL += "\n ORDER BY [DroneName]";
cmd.CommandText = SQL;
using (var reader = cmd.ExecuteReader()) {
while (reader.Read())
{
SelectList.Add(new SelectListItem {
Text = reader["Name"].ToString(),
Value = reader["Value"].ToString()
});
} //while
} //using
ctx.Database.Connection.Close();
} //using Database.Connection
} //using ExponentPortalEntities;
return(SelectList); //return the list objects
} //function GetDropDowntList
}//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()
