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))