In this app,we try to develop regular expense of our daliy life. We entry our money begining of the month.Then,we entry our regular expense and show the regular expense.It records the regular expense.
We give our login username and password and it checks from permanent data which stores in key value "UserName" and "UserPassword".
@IBAction func Logintest(_ sender: Any) {
let user = username.text
let pass = passsword.text
//retrieve from database
let storedName=UserDefaults.standard.string(forKey: "UserName")
let storedPassword=UserDefaults.standard.string(forKey: "UserPassword")
//check if match
if (user==storedName && pass == storedPassword){
// displayAlertMessage(userMessage: "successful")
print("Yes logged")
self.performSegue(withIdentifier: "logintospend", sender: self)
}
else{
displayAlertMessage(userMessage: "not sucessful your username and/or password is wrong!!")
print("no logged")
}
//sucessful
}
We take username, Password from the user and save our data permanently.We check validation if any field is empty we show display alert message.
@IBAction func Register(_ sender: Any) {
let password = Password.text
let user = username.text
let confirmPassword = ConfirmPassword.text
//validation
if((user ?? "").isEmpty || (password ?? "").isEmpty || (confirmPassword ?? "").isEmpty)
{
displayAlertMessage(userMessage: "All fields are required")
return
}
if(password != confirmPassword)
{
displayAlertMessage(userMessage: "Passwords didn't match")
return
}
//store
UserDefaults.standard.set(password, forKey: "UserPassword")
UserDefaults.standard.set(user, forKey: "UserName")
//success
let alert = UIAlertController(title: "Congrats!", message: "Registration Successful", preferredStyle: UIAlertControllerStyle.alert)
let okAction = UIAlertAction(title: "Thanks", style: UIAlertActionStyle.default, handler: {action in
self.performSegue(withIdentifier: "RegisterToHomePage", sender: self)
})
alert.addAction(okAction)
self.present(alert, animated: true, completion: nil)
}
override func viewDidLoad() {
super.viewDidLoad()
self.view.backgroundColor = UIColor(patternImage: UIImage(named: "name.jpg")!)
let fileURL = try! FileManager.default.url(for: .documentDirectory, in: .userDomainMask, appropriateFor: nil, create: false)
.appendingPathComponent("HeroesDatabase.sqlite")
if sqlite3_open(fileURL.path, &db) != SQLITE_OK {
print("error opening database")
}
if sqlite3_exec(db, "CREATE TABLE IF NOT EXISTS try2 (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, powerrank INTEGER)", nil, nil,nil) != SQLITE_OK {
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("error creating table: \(errmsg)")
print("/////////////////////////////////")
}
readValues()
}
First we save our total money.We Entry our total money begining of the month and save our data permanently using UserDefult.
@IBAction func saved_total(_ sender: Any) {
let money = total_money.text?.trimmingCharacters(in: .whitespacesAndNewlines)
var num : Int = 0
var num2 : Int = 0
for x in money! {
num2=num2+1
if (x=="0" || x=="1" || x=="2" || x=="3" || x=="4" || x=="5" || x=="6" || x=="7" || x=="8" || x=="9" )
{
num=num+1
}
}
if (num != num2)
{
displayAlertMessage(userMessage: "Integer number must be entered!!")
return
}
userdef.set(money, forKey: "cnt")
print("Total money saved sucessfully")
}
Then we take regular expense and cut down from the total money.Here ,we use SQLITE to store our data.We use displayAlertMessag to show User message. We check validatation of the data.First textbox take only string value and second textbox take only integer value.Then,we insert our data try2 table.
@IBAction func buttonSave(_ sender: UIButton) {
let name = textFieldName.text?.trimmingCharacters(in: .whitespacesAndNewlines)
let powerRanking = textFieldPowerRanking.text?.trimmingCharacters(in: .whitespacesAndNewlines)
if(name?.isEmpty)!{
displayAlertMessage(userMessage: "You must fill up the field!!")
return
}
if(powerRanking?.isEmpty)!{
displayAlertMessage(userMessage: "You must fill up the field!!")
return
}
////////////
var num : Int = 0
var num2 : Int = 0
for x in powerRanking! {
num2=num2+1
if (x=="0" || x=="1" || x=="2" || x=="3" || x=="4" || x=="5" || x=="6" || x=="7" || x=="8" || x=="9" )
{
num=num+1
}
}
if (num != num2)
{
displayAlertMessage(userMessage: "Integer number must be entered!!")
return
}
/////////////
var dat=userdef.string(forKey: "cnt")
let myInt = Int(dat!)
let myInt2 = Int(powerRanking!)
let val = myInt! - myInt2!
print("ans: ",name)
var myString2 = String(val)
output.text="Remaining: " + myString2
userdef.set(myString2, forKey: "cnt")
////////////////
/*if()
{
displayAlertMessage(userMessage: "Passwords didn't match")
return
}*/
//////////////
//print(name," ",powerRanking)
var stmt: OpaquePointer?
let queryString = "INSERT INTO try2 (name, powerrank) VALUES (?,?)"
if sqlite3_prepare(db, queryString, -1, &stmt, nil) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("error preparing insert: \(errmsg)")
return
}
if sqlite3_bind_text(stmt, 1, name, -1, nil) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("failure binding name: \(errmsg)")
return
}
if sqlite3_bind_int(stmt, 2, (powerRanking! as NSString).intValue) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("failure binding name: \(errmsg)")
return
}
if sqlite3_step(stmt) != SQLITE_DONE {
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("failure inserting hero: \(errmsg)")
return
}
textFieldName.text=""
textFieldPowerRanking.text=""
readValues()
print("Data saved successfully")
}
@IBAction func delete_data(_ sender: Any) {
let queryString = "delete FROM try2"
var stmt:OpaquePointer?
if sqlite3_prepare(db, queryString, -1, &stmt, nil) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("error preparing delete: \(errmsg)")
return
}
if sqlite3_step(stmt) != SQLITE_DONE {
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("failure deleting hero: \(errmsg)")
return
}
readValues()
}
func readValues(){
heroList.removeAll()
let queryString = "SELECT * FROM try2"
var stmt:OpaquePointer?
if sqlite3_prepare(db, queryString, -1, &stmt, nil) != SQLITE_OK{
let errmsg = String(cString: sqlite3_errmsg(db)!)
print("error preparing insert: \(errmsg)")
return
}
while(sqlite3_step(stmt) == SQLITE_ROW){
let id = sqlite3_column_int(stmt, 0)
let name = String(cString: sqlite3_column_text(stmt, 1))
let powerrank = sqlite3_column_int(stmt, 2)
//print("enwcheck: ",name," ",name2)
heroList.append(Hero(id: Int(id), name: String(describing: name), powerRanking: Int(powerrank)))
}
self.tableViewHeroes.reloadData()
}
func displayAlertMessage(userMessage: String) {
let alert = UIAlertController(title: "Alert", message: userMessage, preferredStyle: UIAlertControllerStyle.alert)
let okAction = UIAlertAction(title: "OK", style: UIAlertActionStyle.default, handler: nil)
alert.addAction(okAction)
self.present(alert, animated: true, completion: nil)
}
class Hero {
var id: Int
var name: String?
var powerRanking: Int
init(id: Int, name: String?, powerRanking: Int){
self.id = id
self.name = name
self.powerRanking = powerRanking
}
}
