def Add(self,Branch,Job,JobType,Comments1,Comments2,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
try:
if by == -1:
by=User.objects.get(UserEmail='*****@*****.**').id
details = {
'Branch':Branch,
'Job':Job,
'JobType':JobType,
'Comments1':Comments1,
'Comments2':Comments2,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBInsertBranchJob(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No BranchJob Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Add(self,Userid,JobBranch,Status,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
try:
details = {
'User':Userid,
'Status':Status,
'JobBranch':JobBranch,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBInsertStudentJob(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No StudentJob Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Update(self, _Id, Name, by, ip, req_op=SYSTEM_PERMISSION_UPDATE):
try:
_Id = int(_Id)
obj = JobType.objects.get(id=_Id)
prev = pickle.dumps(obj)
prev = prev.replace("'", ">")
prev = prev.replace("\n", "<")
prev = prev.replace("\\", "+")
details = {"Id": _Id, "Name": Name, "prev": prev, "by": by, "op": req_op, "ip": ip}
result = DBUpdateJobType(details)
if result["result"] == 1:
return (1, result["rescode"])
else:
return (-1, decode(result))
except ObjectDoesNotExist:
return (-1, "No JobType Object exists in database with this name")
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ""
for i in args:
msg += "[%s : %s]" % (i, values[i])
self.JobLogger.exception("%s : %s" % (inspect.getframeinfo(frame)[2], msg))
return (-2, str(ex))
def Add(self,CompanyName,CompanyAdress,CompanyWebsite,CompanyAbout,CompanyOtherDetails1,CompanyOtherDetails2,Userid,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
try:
if by==-1:
by=User.objects.get(UserEmail='*****@*****.**').id
if Userid==-1:
Userid=User.objects.get(UserEmail='*****@*****.**').id
details = {
'CompanyName':CompanyName,
'CompanyAdress':CompanyAdress,
'CompanyWebsite':CompanyWebsite,
'CompanyAbout':CompanyAbout,
'CompanyOtherDetails1':CompanyOtherDetails1,
'CompanyOtherDetails2':CompanyOtherDetails2,
'User':Userid,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBInsertCompanyInfo(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No User Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Update(self,_Id,CompanyId,Profile,Designation,Package,DateOfVisit,JobDetails1,JobDetails2,RecruitmentRounds,ContactPersonName,ContactPersonMobile,ContactPersonEmail,ContactPersonDetails,RegistrationsUpto,by,ip,req_op=SYSTEM_PERMISSION_UPDATE):
try:
_Id=int(_Id)
obj=Job.objects.get(id=_Id);
prev=pickle.dumps(obj)
prev=prev.replace("'", ">");
prev=prev.replace("\n", "<");
prev=prev.replace("\\", "+");
details = {
'Id':_Id,
'Company':CompanyId,
'Profile':Profile,
'Designation':Designation,
'Package':Package,
'DateOfVisit':DateOfVisit,
'JobDetails1':JobDetails1,
'JobDetails2':JobDetails2,
'RecruitmentRounds':RecruitmentRounds,
'ContactPersonName':ContactPersonName,
'ContactPersonMobile':ContactPersonMobile,
'ContactPersonEmail':ContactPersonEmail,
'ContactPersonDetails':ContactPersonDetails,
'RegistrationsUpto':RegistrationsUpto,
'prev':prev,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBUpdateJob(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No User Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Add(self, Name, by, ip, req_op=SYSTEM_PERMISSION_INSERT):
try:
details = {"Name": Name, "by": by, "op": req_op, "ip": ip}
result = DBInsertJobType(details)
if result["result"] == 1:
return (1, result["rescode"])
else:
return (-1, decode(result))
except ObjectDoesNotExist:
return (-1, "No JobType Object exists in database with this name")
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ""
for i in args:
msg += "[%s : %s]" % (i, values[i])
self.JobLogger.exception("%s : %s" % (inspect.getframeinfo(frame)[2], msg))
return (-2, str(ex))
def Update(self,_Id,CompanyName,CompanyAdress,CompanyWebsite,CompanyAbout,CompanyOtherDetails1,CompanyOtherDetails2,Userid,by,ip,req_op=SYSTEM_PERMISSION_UPDATE):
try:
_Id=int(_Id)
obj=CompanyInfo.objects.get(id=_Id);
prev=pickle.dumps(obj)
prev=prev.replace("'", ">");
prev=prev.replace("\n", "<");
prev=prev.replace("\\", "+");
if by==-1:
by=User.objects.get(UserEmail='*****@*****.**').id
if Userid==-1:
Userid=User.objects.get(UserEmail='*****@*****.**').id
details = {
'Id':_Id,
'CompanyName':CompanyName,
'CompanyAdress':CompanyAdress,
'CompanyWebsite':CompanyWebsite,
'CompanyAbout':CompanyAbout,
'CompanyOtherDetails1':CompanyOtherDetails1,
'CompanyOtherDetails2':CompanyOtherDetails2,
'User':Userid,
'prev':prev,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBUpdateCompanyInfo(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No CompanyInfo Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Add(self,CompanyId,Profile,Designation,Package,DateOfVisit,JobDetails1,JobDetails2,RecruitmentRounds,ContactPersonName,ContactPersonMobile,ContactPersonEmail,ContactPersonDetails,RegistrationsUpto,by,ip,req_op=SYSTEM_PERMISSION_INSERT):
try:
if by==-1:
by=User.objects.get(UserEmail='*****@*****.**').id
details = {
'Company':CompanyId,
'Profile':Profile,
'Designation':Designation,
'Package':Package,
'DateOfVisit':DateOfVisit,
'JobDetails1':JobDetails1,
'JobDetails2':JobDetails2,
'RecruitmentRounds':RecruitmentRounds,
'ContactPersonName':ContactPersonName,
'ContactPersonMobile':ContactPersonMobile,
'ContactPersonEmail':ContactPersonEmail,
'ContactPersonDetails':ContactPersonDetails,
'RegistrationsUpto':RegistrationsUpto,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBInsertJob(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No User Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
def Update(self,_Id,Branch,Job,JobType,Comments1,Comments2,by,ip,req_op=SYSTEM_PERMISSION_UPDATE):
try:
_Id=int(_Id)
obj=BranchJob.objects.get(id=_Id);
prev=pickle.dumps(obj)
prev=prev.replace("'", ">");
prev=prev.replace("\n", "<");
prev=prev.replace("\\", "+");
details = {
'Id':_Id,
'Branch':Branch,
'Job':Job,
'JobType':JobType,
'Comments1':Comments1,
'Comments2':Comments2,
'prev':prev,
'by':by,
'op':req_op,
'ip':ip,
}
result = DBUpdateBranchJob(details)
if (result['result'] == 1):
return (1,result['rescode'] )
else:
return (-1,decode(result))
except ObjectDoesNotExist:
return (-1,'No BranchJob Object exists in database with this name')
except Exception, ex:
frame = inspect.currentframe()
args, _, _, values = inspect.getargvalues(frame)
msg = ''
for i in args:
msg += "[%s : %s]" % (i,values[i])
self.JobLogger.exception('%s : %s' % (inspect.getframeinfo(frame)[2],msg))
return (-2,str(ex))
