def __init__(self): self.FirstName = input("Enter First Name :") self.LastName = input("Enter Last Name :") #Validation To Check Enrollment Number Is Valid Or Not... while (True): self.EnrollmentNumber = input("Enter Enrollment Number :") if (not Validation.DataValidationEnroll(self.EnrollmentNumber)): print( "<<<< Please Enter Valid Enrollment Number!... >>>>" ) continue break #Validation To Check Email Is Valid Or Not... while (True): self.Email = input("Enter Email :") if (not Validation.DataValidationEmail(self.Email)): print("<<<< Please Enter Valid Email!... >>>>") continue break self.City = input("Enter City Name:") Database.Curcer.execute( "Insert into StudentDetail (FirstName,LastName,EnrollmentNumber,Email,City) Values(?,?,?,?,?)", (self.FirstName, self.LastName, self.EnrollmentNumber, self.Email, self.City)) Database.Connection.commit() print("Your Data Inserted Successfully")
def UpdateStudentDetails(Enrollment): print("Enter Details where you have to Update it.") FirstName = input("Enter First Name :") LastName = input("Enter Last Name :") #Validation To Check Email Is Valid Or Not... while (True): Email = input("Enter Email :") if (not Validation.DataValidationEmail(Email)): print("<<<< Please Enter Valid Email!... >>>>") continue break City = input("Enter City Name:") Database.Curcer.execute( "update StudentDetail set FirstName=?,LastName=?,Email=?,City=? where EnrollmentNumber=?", (FirstName, LastName, Email, City, Enrollment)) Database.Connection.commit() print("Your Data Updated Successfully")