def handle(self, *args, **kwargs):
sheet = pd.read_excel('home/sheets/CSE C.xlsx')
i = 0
while True:
try:
if sheet['roll no'][i] != sheet['roll no'][i]:
break
except KeyError:
break
user = User()
user.username = sheet['roll no'][i]
user.first_name = sheet['name'][i]
user.email = sheet['mail id'][i] + '@skct.edu.in'
user.set_password('123testpass')
user.save()
student = Student()
student.user = user
student.reg_no = sheet['roll no'][i]
student.dep = sheet['department'][i]
student.room = sheet['room no'][i]
student.batch = sheet['batch no'][i]
student.parent_no = str(int(sheet['parents no'][i]))
student.student_no = str(int(sheet['student no'][i]))
student.image = f"/profile_img/{sheet['roll no'][i]}.jpg"
student.save()
print(sheet['roll no'][i])
i += 1
def register(request):
form = SignUpForm()
if request.method == "POST":
form = SignUpForm(request.POST)
if form.is_valid():
user = form.save()
student = Student()
student.user = user
student.save()
return render(
request, 'register.html', {
'form': form,
'register_button': True,
'sign_in_button': True,
'exit_button': False
})
def stduent_create(request):
if request.method == 'GET':
form = StduentForm()
return render(request, 'home/studentform.html', {'form': form})
if request.method == 'POST':
user = User()
user.username = request.POST.get('registerNo')
user.first_name = request.POST.get('name')
user.email = request.POST.get('registerNo') + '@skct.edu.in'
user.set_password('123testpass')
user.save()
student = Student()
student.user = user
student.reg_no = request.POST.get('registerNo')
student.dep = request.POST.get('department')
student.room = request.POST.get('room')
student.batch = request.POST.get('batch')
student.parent_no = str(request.POST.get('parentNo'))
student.student_no = str(request.POST.get('studentNo'))
student.image = request.FILES['image']
student.save()
return redirect('home')