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()