EMS_New

-------------------------------------------------BLL.py-------------------------------------------------------

 ##class Employee:

##    def __init__(self,empNo = 200,empName= 'Sara',Designation = 'IT Expert',join_date = '2009-09-09',Salary= 7000,DeptNo = 1,empAddress= 'Idgah'):

##        self.empNo = empNo

##        self.empName = empName

##        self.Designation = Designation

##        self.join_date = join_date

##        self.Salary = Salary

##        self.DeptNo = DeptNo

##        self.empAddress = empAddress



##--------------SMS1-------------------


class SMS:

    def __init__(self,student_id=101,student_name='sas',age=20,DOB='2020-09-09',student_address='xhj'):

        self.student_id=student_id

        self.student_name=student_name

        self.age=age

        self.DOB=DOB

        self.student_address=student_address



##objSMS=SMS1()

##print(objSMS)

-----------------------------------------DBAL.py---------------------------------------------------------
##import pyodbc as p
##from BLL import Employee
##
##def getConnection():
##    connection=p.connect(r'Driver=SQL Server; Server=IBRAT786\SQLEXPRESS;Database=EMS-crud application;')
##    cursor=connection.cursor()
##    return cursor
##print(getConnection())

##
##def getEmployees():
##    cursor = getConnection()
##    cursor.execute("select * from EMPLOYEE")
##    rows = cursor.fetchall()
##    emp_list = []
##    for row in rows:
##        objEmp = Employee(empNo= row[0], empName = row[1], Designation = row[2],join_date = row[3],Salary= row[4],DeptNo = row[5],empAddress = row[6])
##        objDict = objEmp.__dict__
##        emp_list.append(objDict)
##    return emp_list
##        
##print(getEmployees())
##
##def addEmployee(obj):
##    cursor = getConnection()
##    cursor.execute(f"insert into Employee values({obj.empNo},'{obj.empName}','{obj.Designation}',{obj.join_date},{obj.Salary},{obj.DeptNo},'{obj.empAddress}')")
##    cursor.commit()
##    print("row added successfully!")
##
##def getEmployeeById(n):
##    cursor = getConnection()
##    cursor.execute(f"select * from EMPLOYEE where empNo = {n}")
##    row = cursor.fetchone()
####    print(row)
##    objEmp = Employee(empNo= row[0], empName = row[1], Designation = row[2],join_date = row[3],Salary= row[4],DeptNo = row[5],empAddress = row[6])

##    objDict = objEmp.__dict__
##    return objDict
##
##def updateEmployee(obj):
##    cursor = getConnection()
##    cursor.execute(f"update EMPLOYEE set empName = '{obj.empName}', Designation = '{obj.Designation}', join_date = {obj.join_date}, Salary = {obj.Salary}, DeptNo = {obj.DeptNo}, empAddress = '{obj.empAddress}' where empNo = {obj.empNo}")
##    cursor.commit()
##    print("row updated sucessfully!")
##
##def deleteEmployee(pk):
##    cursor = getConnection()
##    cursor.execute(f"delete from EMPLOYEE where empNo = {pk}")
##    cursor.commit()
##    print("row deleted successfully")
##    
##----------------SMS1------------------
##
##import pyodbc as p
##from BLL import SMS
##
##
##def getConnection():
##    connection=p.connect(r'Driver=SQL Server; Server=IBRAT786\SQLEXPRESS;Database=SMS;')
##    cursor=connection.cursor()
##    return cursor
##print(getConnection())
##
##def getSMS():
##    cursor=getConnection()
##    cursor.execute("select * from SMS1")
##    rows=cursor.fetchall()
##    sms_list=[]
##    for row in rows:
##        objsms=SMS(student_id=row[0],student_name=row[1],age=row[2],DOB=row[3],student_address=row[4])
##        objDict=objsms.__dict__
##        sms_list.append(objDict)    
##    return sms_list
####print(getSMS())
##
##def addSMS(a):
##    cursor=getConnection()
##    cursor.execute(f"insert from SMS1 VALUES('{a.student_name}',{a.age},'{a.DOB}','{a.student_address}'),student_name")
##    cursor.commit()
##    print("row add .....")
##
##    objSMS=SMS()
##
##    objSMS.student_id=student_id
##    objSMS.student_name=input('student_name:')
##    objSMS.age=input('age:')
##    objSMS.DOB=input('DOB:')
##    objSMS.student_address=input(f'student_address:')
##
##    
##def getSMSById(n):
##    cursor=getConnection()
##    cursor.execute(f"select * from SMS1 where student_name={n}")
##    rows=cursor.fetchone()
####    print(row)
####    objEmp = Employee(empNo= row[0], empName = row[1], Designation = row[2],join_date = row[3],Salary= row[4],DeptNo = row[5],empAddress = row[6])
####    objDict = objEmp.__dict__
####    return objDict
##    
##
##def updateSMS(a):
##    cursor = getConnection()
##    cursor.execute(f"update SMS1 set student_id = '{a.student_name}',age={a.age},DOB='{a.DOB}',student_address='{a.student_address}' where empNo = {a.student_id}")
##    cursor.commit()
##    print("row updated sucessfully!")
##
##def deleteSMS(b):
##    cursor=getConnection()
##    cursor.execute(f"delete from SMS1 where student_id={b}")
##    cursor.commit()
##    print("Row Deleted")

##---------------------------------------------------------

import pyodbc as p
from BLL import SMS

def getConnection():
    connection=p.connect(r'Driver=SQL Server; Server=IBRAT786\SQLEXPRESS;Database=SMS;')
    cursor=connection.cursor()
    return cursor
print(getConnection())


def getSMS():
    cursor=getConnection()
    cursor.execute("select * from SMS1")
    rows=cursor.fetchall()
    sms_list=[]
    for row in rows:
        objsms=SMS(student_id=row[0],student_name=row[1],age=row[2],DOB=row[3],student_address=row[4])

        objDict=objsms.__dict__
        sms_list.append(objDict)
    return sms_list

##print(getSMS())


def addSMS(obj):
    cursor=getConnection()
    cursor.execute(f"insert into SMS1 values ({obj.student_id},'{obj.student_name}',{obj.age},'{obj.DOB}','{obj.student_address}')")
    cursor.commit()
    print("row added...")


def getSMSById(n):
    cursor=getConnection()
    cursor.execute(f"select * from SMS1 where student_id={n}")
    row=cursor.fetchone()
    print(row)
    objsms=SMS(student_id=row[0],student_name=row[1],age=row[2],DOB=row[3],student_address=row[4])
    objDict=objsms.__dict__
    return objDict

print(getSMSById(n))


----------------------------------------------SMS.py--------------------------------------------------------------

##---------------------DBAL-------------------------


##def getConnection():
##    connection=p.connect(r'Driver=SQL Server; Server=IBRAT786\SQLEXPRESS;Database=SMS;')
##    cursor=connection.cursor()
##    return cursor

##def SMS1():
##    cursor=getConnection()
##    cursor.execute('select * from SMS1')
##    rows=cursor.fetchall()
##    return rows
##rows=SMS1()
##print(rows)

##from BLL import SMS1
##
##def getSMS1():
##    cursor=getConnection()
##    cursor.execute('select * from SMS1')
##    rows=cursor.fetchall()
##    for row in rows:
##        objSMS=SMS1(student_id=row[0],student_name=row[1],age=row[2],DOB=row[3],student_address=row[4])
##        print(objSMS)
##getSMS1()
##             
##def addStudent(a):
##    cursor=getConnection()
##    cursor.execute("insert into values ({a.student_id},'{a.student_name}',{a.age},'{a.DOB}','{a.student_address}')")
##    cursor.commit()
##    ("Data Added...")
    
####getConnection()#check connection
####
####print(getConnection())# 
##
###function ke help se sare rows ko fech karna h

'''
def getALLEmployee():
    cursor=getConnection()
    cursor.execute('select * from EMPLOYEE')
    rows=cursor.fetchall()
    return rows

rows=getALLEmployee()
print(rows)


from BLL import Employee

def getEmployee():
    cursor=getConnection()
    cursor.execute('select * from EMPLOYEE')
    rows=cursor.fetchall()
    for row in rows:
        objEmp = Employee(empNo=row[0],empName=row[1],Designation=row[2],join_date=row[3],Salary=row[4],DeptNo=row[5],empAddress=row[6])
        print(objEmp)

getEmployee()'''


##
####import BLL
##
####def getEmployee():
####    cursor=getConnection()
####    cursor.execute('select * from EMPLOYEE')
####    rows=cursor.fetchall()
####    for row in rows:
####        objEmp = BLL.Employee(empNo=row[0],empName=row[1],Designation=row[2],join_date=row[3],Salary=row[4],DeptNo=row[5],empAddress=row[6])
####        print(objEmp)
####
####getEmployee()
##
##
##
###EXCESSING ONE COLUMN OBJ.WHICH FIELD YOU SEE
##
####def getEmployee():
####    cursor=getConnection()
####    cursor.execute('select * from EMPLOYEE')
####    rows=cursor.fetchall()
####    for row in rows:
####        objEmp = Employee(empNo=row[0],empName=row[1],Designation=row[2],join_date=row[3],Salary=row[4],DeptNo=row[5],empAddress=row[6])
####        print(objEmp.empName)
####
######getEmployee()
##
###CONVERT INTO DICTONARY
##def getEmployee():
##    cursor=getConnection()
##    cursor.execute('select * from EMPLOYEE')
##    rows=cursor.fetchall()
##    emp_list=[]
##    for row in rows:
##        objEmp = Employee(empNo=row[0],empName=row[1],Designation=row[2],join_date=row[3],Salary=row[4],DeptNo=row[5],empAddress=row[6])
##        objDict=objEmp.__dict__
##        emp_list.append(objDict)
##    return emp_list    
####print(getEmployee())
##
###CON
##def AddEmployee(obj):
##    cursor=getConnection()
##    cursor.execute(f"insert into Employee values({obj.empNo},'{obj.empName}','{obj.Desingnation}','{obj.join_date}',{obj.Salary},{obj.DeptNo},'{obj.empAddress}')")
##    cursor.commit()
##    print('DATA ADDED...')
##    
##    
##
##
##def DeleteData(n):
##    cursor=getConnection()
##    cursor.execute(f"delete from employee where empNo={n}")
##    cursor.commit()
##    print("ROW DELETE SUCCESSFULLY...")
##
##
##
##def getEmpByID(a):
##    cursor=getConnection()
##    cursor.execute(f'select * from employee where empNo={a}')
##    row=cursor.fetchone()
##    print(row)
##
##    objEmp = Employee(empNo=row[0],empName=row[1],Designation=row[2],join_date=row[3],Salary=row[4],DeptNo=row[5],empAddress=row[6])
##    objDict=objEmp.__dict__
##    return objDict
##
##        
##def UpdateEmployee(a):
##    cursor=getConnection()
##    cursor.execute(f"UPDATE  Employee set empName='{a.empName}',Designation='{a.Desingnation}',join_date='{a.join_date}',Salary={a.Salary},DeptNo={a.DeptNo},empAddress='{a.empAddress}'where empNo={a.empNo}")
##    cursor.commit()
##    
##    print("UPDATE SUCCESSFULLY...")


##---------------------------UI------------------------------

##import pyodbc as p
##from BLL import Employee
##
##connection=p.connect(r'Driver=SQL Server; Server=IBRAT786\SQLEXPRESS;Database=EMS-crud application;')
####print(connection)
##
##cursor=connection.cursor()
##
####    
##empNo=input("enter:")
##
##x='select * from EMPlOYEE where empNo=?'
##cursor.execute(x,(empNo))
##
##rows=cursor.fetchall()
##for row in rows:
##    print(row)

'''import DBAL

user_input=input("enter 'GET' to fetch all rows,enter 'ADD' to insert a new ,enter 'DELETE' to delete a row,enter 'UPDATE' to update a row:'' ")
if user_input=='GET':
    rows=DBAL.getEmployee()
    print( rows)

elif user_input=='ADD':
    objEmp=Employee()

    
    objEmp.empNo=input(f"enter empNo:")
    objEmp.empName=input("enter empName:")
    objEmp.Desingnation=input("enter Desingnation:")
    objEmp.join_date=input("enter join_date:")
    objEmp.Salary=input("enter Salary:")
    objEmp.DeptNo=input("enter DeptNo:")
    objEmp.empAddress=input("enter empAddress:")
    
    DBAL.AddEmployee(objEmp)'''
##    
##
##elif user_input=='DELETE':
##    ID=input("enter the id of the row you want to delete:")
##    DBAL.DeleteData(ID)
##
##
##   
##
##elif user_input=='UPDATE':
##    ID=input("enter the id you want update: ")
##    row=DBAL.getEmpByID(ID)
##    print(row)
##
##    objEmp=Employee()
##    
##    objEmp.empNo=ID
##    objEmp.empName=input("enter empName:")
##    objEmp.Desingnation=input("enter Desingnation:")
##    objEmp.join_date=input("enter join_date:")
##    objEmp.Salary=input("enter Salary:")
##    objEmp.DeptNo=input("enter DeptNo:")
##    objEmp.empAddress=input("enter empAddress:")
##    
##    DBAL.UpdateEmployee(objEmp)
##


##import DBAL
##
##user=input(" enter 'GET' to fetch all rows in a table,'ADD' a new row in table :")
##if  user =='GET':
##    rows=DBAL.addStudent()
##    print(rows)
##
##elif user =='ADD' :
##    objSMS=SMS1()
##
##    objSMS.student_id=input(f'student_id:')
##    objSMS.student_name=input('student_name:')
##    objSMS.age=input('age:')
##    objSMS.DOB=input('DOB:')
##    objSMS.student_address=input(f'student_address:')
##
##    DBAL.addStudent(objSMS)
##    


##------------------------BLL----------------------


##create table EMPLOYEE (
## C int primary key,
## empName varchar(100),
## Designation varchar(100),
## join_date varchar(100),
## Salary int,
## DeptNo int foreign key references DEPARTMENT(deptNo),
## empAddress varchar (100)
##)

##class Employee:
##    def __init__(self,empNo=1,empName='xyz',Designation='ITI',join_date='2002-07-02',Salary=23000,DeptNo=3,empAddress='abc'):
##        self.empNo=empNo
##        self.empName=empName
##        self.Designation=Designation
##        self.join_date=join_date
##        self.Salary=Salary
##        self.DeptNo=DeptNo
##        self.empAddress=empAddress
##objEmp=Employee()
##print(objEmp)

##class SMS1:
##    def __init__(self,student_id=101,student_name='sxas',age=20,DOB='2020-09-09',student_address='xhj'):
##        self.student_id=student_id
##        self.student_name=student_name
##        self.age=age
##        self.DOB=DOB
##        self.student_address=student_address
##objSMS=SMS1()
##print(objSMS)
-------------------------------------------------------UI.py-------------------------------------------------------------

##import DBAL
##from BLL import Employee
##
##user_input = input("enter 'GET' to fetch all rows, enter 'ADD' to insert a new row, enter  'UPDATE' to update an existing row and 'DELETE' to delete a row:  ")
##
##if user_input == 'GET':
##    rows = DBAL.getEmployees()
##    print(rows)
##
##elif user_input == 'ADD':
##    objEmp = Employee()
##    
##    objEmp.empNo = input("enter a employee number: ")
##    objEmp.empName = input("enter employee name: ")
##    objEmp.Designation = input("enter Designation: ")
##    objEmp.join_date = input("enter join date: ")
##    objEmp.Salary = input("enter Salary:")
##    objEmp.DeptNo = input("enter DeptNo: ")
##    objEmp.empAddress = input("enter address empAddress: ")
##
##    DBAL.addEmployee(objEmp)


##elif user_input == 'UPDATE':
##    ID = input("enter the id of the row you want to update: ")
##    row = DBAL.getEmployeeById(ID)
##    print(row)
##
##    print("ENTER UPDATION DETAILS: ")
##
##    objEmp = Employee()
##    
##    objEmp.empNo = ID
##    objEmp.empName = input("enter employee name: ")
##    objEmp.Designation = input("enter Designation: ")
##    objEmp.join_date = input("enter join date: ")
##    objEmp.Salary = input("enter Salary:")
##    objEmp.DeptNo = input("enter DeptNo: ")
##    objEmp.empAddress = input("enter address empAddress: ")
##
##    DBAL.updateEmployee(objEmp)
##
##elif user_input == 'DELETE':
##    ID = input("enter the id of the row you want to delete: ")
##    DBAL.deleteEmployee(ID)
##
##else:
##    print("please enter valid command.")
##


##------------------------SMS1-------------------------

##def updateEmployee(obj):
##    cursor = getConnection()
##    cursor.execute(f"update EMPLOYEE set empName = '{obj.empName}', Designation = '{obj.Designation}', join_date = {obj.join_date}, Salary = {obj.Salary}, DeptNo = {obj.DeptNo}, empAddress = '{obj.empAddress}' where empNo = {obj.empNo}")
##    cursor.commit()
##    print("row updated sucessfully!")
##
##def deleteEmployee(pk):
##    cursor = getConnection()
##    cursor.execute(f"delete from EMPLOYE where empNo = {pk}")
##    cursor.commit()
##    print("row deleted successfully")
##    



##----------------------------------------------------------

import DBAL
from BLL import SMS

user=input("enter 'get' to fetch all rows, enter 'ADD' to insert a new row, enter  'UPDATE' to update an existing row and 'DELETE' to delete a row:  ")

if user =='get':
    row=DBAL.getSMS()
    print(row)

elif user=='add':
    objsms=SMS()

    objsms.student_id=input("enter a student_id:")
    objsms.student_name=input("enter a student_id:")
    objsms.age=input("enter a age:")
    objsms.DOB=input("enter a DOB:")
    objsms.student_address=input("enter a student_address:")

    DBAL.addSMS(objsms)


  

Comments

Post a Comment

Popular posts from this blog

Java

What is Java? Java is a simple, object oriented, secure programming language it is developed by James Gosling launched by mid 1992 with the name of Oak. Key Features of Java 1. Simple- Java is design to be easy to learn because it remove C++ pointers and operator overloading 2. Platform Independent- (WORA) Write One Run Anywhere 3. Object Oriented- Everything in Java is an Object (except for basic data types) 4. Robust- Robust means Strong: - Java is design to be handles errors reliably. 1 Garbage Collection 2.Exception Handling 5. Multithreaded- Java is multithread because it has built in capability to perform multiple task simultaneously within a single program. Thread is a smallest unit of execution. In Java every program has at least one thread(the main thread) Multi-thread allows you to spawn “child” threads to handle background work while the main thread stay active. 6.High-Performance- While technically is interpreted, Java uses a JIT (Just-In-Time) Compiler...
Read more

COMPUTER GRAPHICS IN BCA 3 YEAR

Image
  Computer Graphics     What is Computer Graphics? Computer graphics is an art in which images, lines, and charts are created by programming them in a computer. Simply put, "Drawing pictures on a computer screen is called computer graphics." Creating pictures with the help of a computer is called computer graphics. In this, two or three dimensional pictures are created. It uses a lot of software techniques to create, modify, and store pictures. With the help of Computer Graphics, we can display images of any size in the computer screen. Graphics are presented in computers using a lot of algorithms and techniques. Nowadays, computer graphics are used everywhere such as – in user interfaces, in TVs, in motion pictures, and in mobile games, etc. Computer graphics are made up of many pixels. A pixel is the smallest unit of graphics that appear on a computer screen. The term computer graphics was first used by Verne Hudson and William Fetter in 1960. When we draw a pictur...
Read more