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