public List<menuitem> GetTopmenu(string token)
{
string loggedintoken = token;
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(loggedintoken);
List<menuitem> topmenu = new List<menuitem>();
switch (loggedinuser.ObjectType.ToString())
{
case "private":
topmenu = BuildSuperAdminMenu();
break;
case "comadmin":
topmenu = BuildJobUserMenu();
break;
case "comrecruit":
topmenu = BuildSuperAdminMenu();
break;
case "tsadmin":
topmenu = BuildTimeSheetAdminMenu();
break;
case "consultant":
topmenu = BuildConsultantMenu();
break;
}
return topmenu;
}
public ActionResult admin(UI.Models.portaluser admindata)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.AddAdmin(admindata.usermail, admindata.userpassword, admindata.usertitle, Session["usertoken"].ToString());
return(RedirectToAction("index"));
}
//[HttpPost]
//public ActionResult Import()
//{
// return View();
//}
public bool Edit(string contactid,string unid,string designation,string title,string firstname,string lastname,string emailaddress,string mobilephone,string secondaryemail,string phone,string companyname,string type,string objecttype,string contactgroup)
{
bool status = new bool();
string comcompanyid = Session["companyid"].ToString();
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
UI.Models.PortalContact editedcontact = new Models.PortalContact();
editedcontact.Companyname = companyname;
editedcontact.firstname = firstname;
editedcontact.lastname = lastname;
editedcontact.emailaddress = emailaddress;
editedcontact.officephone = phone;
editedcontact.mobilephone = mobilephone;
status=appclient.UpdateContact(contactid,
comcompanyid,
comcompanyid,
unid,
designation,
title,
firstname,
lastname,
emailaddress,
mobilephone,
secondaryemail,
phone, Newtonsoft.Json.JsonConvert.SerializeObject(editedcontact), type, objecttype, contactgroup, comcompanyid);
return status;
}
public bool DeleteContact(string contactid, string companyid, string objectid)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
bool status = appclient.DeleteContact(contactid, Session["companyid"].ToString(), Session["companyid"].ToString());
return(status);
}
//[HttpPost]
//public ActionResult Import()
//{
// return View();
//}
public bool Edit(string contactid, string unid, string designation, string title, string firstname, string lastname, string emailaddress, string mobilephone, string secondaryemail, string phone, string companyname, string type, string objecttype, string contactgroup)
{
bool status = new bool();
string comcompanyid = Session["companyid"].ToString();
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
UI.Models.PortalContact editedcontact = new Models.PortalContact();
editedcontact.Companyname = companyname;
editedcontact.firstname = firstname;
editedcontact.lastname = lastname;
editedcontact.emailaddress = emailaddress;
editedcontact.officephone = phone;
editedcontact.mobilephone = mobilephone;
status = appclient.UpdateContact(contactid,
comcompanyid,
comcompanyid,
unid,
designation,
title,
firstname,
lastname,
emailaddress,
mobilephone,
secondaryemail,
phone, Newtonsoft.Json.JsonConvert.SerializeObject(editedcontact), type, objecttype, contactgroup, comcompanyid);
return(status);
}
public ActionResult Add(UI.Models.PortalContact contact)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string jsoncontact = Newtonsoft.Json.JsonConvert.SerializeObject(contact);
appclient.CreateContact(Session["companyid"].ToString(), Session["companyid"].ToString(), Guid.NewGuid().ToString().Replace("-",""), contact.designation, contact.title, contact.firstname, contact.lastname, contact.emailaddress, contact.officephone, contact.secondaryemail, contact.mobilephone, jsoncontact, contact.objecttype,"", Session["companyid"].ToString());
return RedirectToAction("index");
}
public ActionResult consultant(UI.Models.portaluser recruiterdata)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.Addconsultant(recruiterdata.usermail, recruiterdata.userpassword, recruiterdata.usertitle, Session["usertoken"].ToString());
return RedirectToAction("index");
}
public ActionResult Add(UI.Models.PortalContact contact)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string jsoncontact = Newtonsoft.Json.JsonConvert.SerializeObject(contact);
appclient.CreateContact(Session["companyid"].ToString(), Session["companyid"].ToString(), Guid.NewGuid().ToString().Replace("-", ""), contact.designation, contact.title, contact.firstname, contact.lastname, contact.emailaddress, contact.officephone, contact.secondaryemail, contact.mobilephone, jsoncontact, contact.objecttype, "", Session["companyid"].ToString());
return(RedirectToAction("index"));
}
public string GetMailingLists(string companyid, string usertoken)
{
string JsonMailLists = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.maillist[] maillists = appclient.jsonMailinglists(companyid, usertoken);
JsonMailLists = Newtonsoft.Json.JsonConvert.SerializeObject(maillists);
return(JsonMailLists);
}
public string GetAllAccounts(string usertoken)
{
string accounts = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.accounts[] appaccounts = appclient.Getaccounts(usertoken);
accounts = Newtonsoft.Json.JsonConvert.SerializeObject(appaccounts);
return(accounts);
}
public string relaymailmessage(string mailrecipients, string subject, string messagebody)
{
string mailresponseid = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = mailrecipients.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length > 0)
{
if (str.ToLower().Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
else
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List <Business.ApplicationService.mailattachment> attachments = new List <Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, messagebody.ToString(), messagebody.ToString(), subject, attachments.ToArray(), Session["usertoken"].ToString());
return(response.StatusCode);
}
public ActionResult forward(UI.Models.MessagingObjectModel.forward data)
{
string mailresponseid = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = data.recipientid.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length > 0)
{
if (str.ToLower().Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + ";" + str;
}
}
else
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + ";" + str;
}
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List <Business.ApplicationService.mailattachment> attachments = new List <Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, "", data.messagebody.ToString(), data.mailsubject, attachments.ToArray(), Session["usertoken"].ToString());
return(Redirect(Request.UrlReferrer.ToString()));
}
public string relaymailmessage(string mailrecipients,string subject,string messagebody)
{
string mailresponseid = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = mailrecipients.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length >0)
{
if (str.ToLower().Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
else
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List<Business.ApplicationService.mailattachment> attachments = new List<Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, messagebody.ToString(), messagebody.ToString(),subject, attachments.ToArray(), Session["usertoken"].ToString());
return response.StatusCode;
}
public AccountCollection GetUserAccounts(string usertoken)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.accounts[] appaccounts = appclient.Getaccounts(usertoken);
AccountCollection AccountCollection = new Models.AccountCollection();
List <AccountgroupCollection> accountgroupcollection = new List <AccountgroupCollection>();
foreach (Business.ApplicationService.accounts item in appaccounts.GroupBy(p => p.categoryid).Select(g => g.First()))
{
AccountgroupCollection temgroup = new AccountgroupCollection();
temgroup.categoryid = item.categoryid;
temgroup.categoryname = item.categoryname;
temgroup.userid = item.userid;
List <Business.ApplicationService.accounts> resultaccounts = appaccounts.Where(p => p.categoryid == item.categoryid).ToList();
foreach (Business.ApplicationService.accounts subitem in resultaccounts)
{
PTAccount tempaccount = new PTAccount();
tempaccount.accountId = subitem.accountid;
tempaccount.accountName = subitem.accountname;
tempaccount.accounttype = subitem.accounttype;
tempaccount.amount = (float)Convert.ToDouble(subitem.amount);
tempaccount.uniqueid = subitem.unid;
tempaccount.categoryid = subitem.categoryid;
tempaccount.categoryname = subitem.categoryname;
tempaccount.createddate = subitem.createddate;
tempaccount.deleted = false;
tempaccount.description = subitem.description;
tempaccount.duemonth = subitem.duemonth;
tempaccount.duedate = subitem.duedate;
tempaccount.modifieddate = subitem.modifieddate;
tempaccount.providerid = subitem.providerid;
tempaccount.providername = subitem.providername;
tempaccount.recurrence = subitem.recurrence;
tempaccount.subcatid = subitem.subcategoryid;
tempaccount.userid = subitem.userid;
tempaccount.global = subitem.global;
tempaccount.initial = subitem.initial;
tempaccount.codes = subitem.codes;
temgroup.accounts.Add(tempaccount);
}
accountgroupcollection.Add(temgroup);
}
AccountCollection.requestedtime = DateTime.Now.ToString();
AccountCollection.accountcollection = accountgroupcollection;
return(AccountCollection);
}
public List <JobApplication> GetJobApplicants(string jobid, string companyid)
{
List <JobApplication> applications = new List <JobApplication>();
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
List <Business.ApplicationService.applicant> serviceapplicants = appclient.GetApplicantsinjob(System.Web.HttpContext.Current.Session["userid"].ToString(), companyid, jobid, "", "applicant").ToList();
foreach (Business.ApplicationService.applicant serviceapplicant in serviceapplicants)
{
JobApplication tempjobapplication = new JobApplication();
tempjobapplication.applicationid = serviceapplicant.transactionid;
portalcandidate tempcandidate = new portalcandidate();
tempcandidate.id = serviceapplicant.candidateid;
tempcandidate.resumeid = serviceapplicant.resumeid;
if (tempcandidate.resumeid == "" || tempcandidate.resumeid == null)
{
tempcandidate.resumeurl = "";
}
else
{
try
{
AmazonFile af = new AmazonFile();
tempcandidate.resumeurl = af.GetFileUrl(serviceapplicant.resumeid, System.Web.HttpContext.Current.Session["usertoken"].ToString());
}
catch
{
}
}
tempcandidate.contactid = serviceapplicant.contactid;
tempcandidate.data = serviceapplicant.data;
tempjobapplication.candidate = tempcandidate;
try
{
tempjobapplication.applicationstatus = serviceapplicant.status.ToString();
}
catch
{
tempjobapplication.applicationstatus = "0";
}
applications.Add(tempjobapplication);
}
return(applications);
}
public ActionResult forward(UI.Models.MessagingObjectModel.forward data)
{
string mailresponseid = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = data.recipientid.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length > 0)
{
if (str.ToLower().Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + ";" + str;
}
}
else
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + ";" + str;
}
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List<Business.ApplicationService.mailattachment> attachments = new List<Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, "", data.messagebody.ToString(), data.mailsubject, attachments.ToArray(), Session["usertoken"].ToString());
return Redirect(Request.UrlReferrer.ToString());
}
public string Addcandidates(string jobid, string candidateid)
{
string applicantid = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", candidateid, "master");
foreach (Business.ApplicationService.applicant sinapplicant in applicants)
{
UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
applicantid = appclient.AttachCandidate(Session["userid"].ToString(), Session["companyid"].ToString(), jobid, candidateid,
sinapplicant.contactid, sinapplicant.resumeid, sinapplicant.resumeurl, 0, sinapplicant.data);
}
return(applicantid);
}
public string Addcandidates(string jobid,string candidateid)
{
string applicantid="";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", candidateid, "master");
foreach (Business.ApplicationService.applicant sinapplicant in applicants)
{
UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
applicantid = appclient.AttachCandidate(Session["userid"].ToString(), Session["companyid"].ToString(), jobid, candidateid,
sinapplicant.contactid, sinapplicant.resumeid, sinapplicant.resumeurl, 0, sinapplicant.data);
}
return applicantid;
}
public ActionResult SendMail(UI.Models.MessagingObjectModel.JObsBulkMail maildata)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = maildata.recipients.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List <Business.ApplicationService.mailattachment> attachments = new List <Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, "", maildata.messagebody.ToString(), maildata.mailsubject, attachments.ToArray(), Session["usertoken"].ToString());
string[] jobs = maildata.jobs.Split(';');
foreach (string singlejob in jobs)
{
if (singlejob.Length == 32)
{
appclient.Updateemailstatus(singlejob, 1);
}
}
return(Redirect(Request.UrlReferrer.ToString()));
}
public string InsertJobDetials(Job job)
{
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
int CompID = 1;
int CatId = 1;
int stateId = 1;
int Expcodeid = 1;
Expcodeid = Convert.ToInt32(CommonFunctions.MapExperiencetoID[job.Exp].ToString());
string[] postypearray = job.postype.Split(',');
string PositionTypeId = "";
if (postypearray.Length > 0)
{
foreach (string postype in postypearray)
{
if (PositionTypeId == "")
{
PositionTypeId = CommonFunctions.MapPositiontoID[postype].ToString();
}
else
{
PositionTypeId = PositionTypeId + "," + CommonFunctions.MapPositiontoID[postype].ToString();
}
}
}
job.StartDate = DateTime.Now;
job.ModifiedDate = DateTime.Now;
string[] expdatearray = job.ExpDate.Split('/');
string expdt = new DateTime(Convert.ToInt32(expdatearray[2]), Convert.ToInt32(expdatearray[0]), Convert.ToInt32(expdatearray[1])).ToString("yyyy-MM-dd HH:mm:ss");
job.Publish = 1; //inhouse
job.jobdata = Newtonsoft.Json.JsonConvert.SerializeObject(job);
appclient.CreateJob("", "", job.JobName, job.JobDesc, job.PayRate, job.PrefSkills, PositionTypeId, job.City, job.StartDate.Day.ToString(), job.StartDate.Month.ToString(), job.StartDate.Year.ToString(), Convert.ToInt32(expdatearray[1]).ToString(), Convert.ToInt32(expdatearray[0]).ToString(), Convert.ToInt32(expdatearray[2]).ToString(), Expcodeid, (int)job.Publish, System.Web.HttpContext.Current.Session["companyid"].ToString(), "jobpost", job.Email, job.Phone, "", job.jobdata, job.additionaldetails);
return(m_nJobId);
}
catch { throw; }
} //with mv
public ActionResult Sent()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.InvitationApp[] invitationslist = appclient.GetInvitationmaster("*****@*****.**", "msgtype");
List<UI.Models.mailmessage> mailmessages = new List<Models.mailmessage>();
foreach (Business.ApplicationService.InvitationApp invitation in invitationslist)
{
UI.Models.mailmessage message = new Models.mailmessage();
message.mailitemid = invitation.invitationmasterid;
message.mailtime = invitation.invitetime.ToString();
message.receipients = invitation.invitees;
message.sender = invitation.sendorid;
message.mailbrief = invitation.invitationtext;
// message.tags = invitation.Prop;
mailmessages.Add(message);
}
return View(mailmessages);
}
public ActionResult Manage(string listid)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.contact[] contacts = appclient.GetContacts("9a73072573754e13a02381c9d931e5c4", "9a73072573754e13a02381c9d931e5c4", "1", "100");
List <UI.Models.PortalContact> portalcontacts = new List <Models.PortalContact>();
foreach (Business.ApplicationService.contact contact in contacts)
{
UI.Models.PortalContact tempcontact = new Models.PortalContact();
tempcontact.id = contact.contactid;
tempcontact.emailaddress = contact.emailid;
portalcontacts.Add(tempcontact);
}
return(View(portalcontacts));
}
public string Getapplicants()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", "", "master");
return Newtonsoft.Json.JsonConvert.SerializeObject(applicants.ToList());
// List<UI.Models.Applicantdetails> portalapplicants = new List<Models.Applicantdetails>();
// string applicant = "";
// foreach (Business.ApplicationService.applicant sinapplicant in applicants)
// {
// UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
// if (sinapplicant.objecttype != "masterview")
// {
// singleapplicant.data = Newtonsoft.Json.JsonConvert.SerializeObject(applicants.ToList());
// portalapplicants.Add(singleapplicant);
// }
// }
// return portalapplicants.ToString();
//}
}
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.contact[] contacts = appclient.GetContacts(Session["companyid"].ToString(), Session["companyid"].ToString(),"1","100");
List<UI.Models.PortalContact> portalcontacts = new List<Models.PortalContact>();
foreach (Business.ApplicationService.contact contact in contacts)
{
UI.Models.PortalContact singlecontact = new Models.PortalContact();
try
{
UI.Models.PortalContact ObjContact = Newtonsoft.Json.JsonConvert.DeserializeObject<UI.Models.PortalContact>(contact.data);
if (ObjContact == null)
{
singlecontact.Companyname = "";
singlecontact.middlename = "";
}
else
{
singlecontact.Companyname = ObjContact.Companyname;
singlecontact.middlename = ObjContact.middlename;
}
}
catch
{
singlecontact.Companyname = "";
singlecontact.middlename = "";
}
singlecontact.id = contact.contactid;
singlecontact.firstname = contact.firstname;
singlecontact.lastname = contact.lastname;
singlecontact.emailaddress = contact.emailid;
singlecontact.mobilephone = contact.mobile;
singlecontact.officephone = contact.phone;
singlecontact.objecttype = contact.objecttype;
singlecontact.designation = contact.designation;
portalcontacts.Add(singlecontact);
}
return View(portalcontacts);
}
public string Getapplicants()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", "", "master");
return(Newtonsoft.Json.JsonConvert.SerializeObject(applicants.ToList()));
// List<UI.Models.Applicantdetails> portalapplicants = new List<Models.Applicantdetails>();
// string applicant = "";
// foreach (Business.ApplicationService.applicant sinapplicant in applicants)
// {
// UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
// if (sinapplicant.objecttype != "masterview")
// {
// singleapplicant.data = Newtonsoft.Json.JsonConvert.SerializeObject(applicants.ToList());
// portalapplicants.Add(singleapplicant);
// }
// }
// return portalapplicants.ToString();
//}
}
public ActionResult Sent()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.InvitationApp[] invitationslist = appclient.GetInvitationmaster("*****@*****.**", "msgtype");
List <UI.Models.mailmessage> mailmessages = new List <Models.mailmessage>();
foreach (Business.ApplicationService.InvitationApp invitation in invitationslist)
{
UI.Models.mailmessage message = new Models.mailmessage();
message.mailitemid = invitation.invitationmasterid;
message.mailtime = invitation.invitetime.ToString();
message.receipients = invitation.invitees;
message.sender = invitation.sendorid;
message.mailbrief = invitation.invitationtext;
// message.tags = invitation.Prop;
mailmessages.Add(message);
}
return(View(mailmessages));
}
public static Dictionary <string, string> AfterLoginRoute(string token)
{
Dictionary <string, string> afterloginroute = new Dictionary <string, string>();
string loggedintoken = token;
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(loggedintoken);
List <menuitem> topmenu = new List <menuitem>();
switch (loggedinuser.ObjectType.ToString())
{
case "private":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "comadmin":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "comrecruit":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "tsadmin":
afterloginroute.Add("action", "admindashboard");
afterloginroute.Add("controller", "timesheet");
break;
case "consultant":
afterloginroute.Add("action", "dashboard");
afterloginroute.Add("controller", "timesheet");
break;
}
return(afterloginroute);
}
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.contact[] contacts = appclient.GetContacts(Session["companyid"].ToString(), Session["companyid"].ToString(), "1", "100");
List <UI.Models.PortalContact> portalcontacts = new List <Models.PortalContact>();
foreach (Business.ApplicationService.contact contact in contacts)
{
UI.Models.PortalContact singlecontact = new Models.PortalContact();
try
{
UI.Models.PortalContact ObjContact = Newtonsoft.Json.JsonConvert.DeserializeObject <UI.Models.PortalContact>(contact.data);
if (ObjContact == null)
{
singlecontact.Companyname = "";
singlecontact.middlename = "";
}
else
{
singlecontact.Companyname = ObjContact.Companyname;
singlecontact.middlename = ObjContact.middlename;
}
}
catch
{
singlecontact.Companyname = "";
singlecontact.middlename = "";
}
singlecontact.id = contact.contactid;
singlecontact.firstname = contact.firstname;
singlecontact.lastname = contact.lastname;
singlecontact.emailaddress = contact.emailid;
singlecontact.mobilephone = contact.mobile;
singlecontact.officephone = contact.phone;
singlecontact.objecttype = contact.objecttype;
singlecontact.designation = contact.designation;
portalcontacts.Add(singlecontact);
}
return(View(portalcontacts));
}
public ActionResult Add(ExternalInvoice einv, HttpPostedFileBase file)
{
Business.ApplicationService.AppServiceClient bd = new Business.ApplicationService.AppServiceClient();
Business.CoreService.MyFile fileuploaded = new Business.CoreService.MyFile();
Business.CoreService.IobjectServicesWebappVer2Client coreclient = new Business.CoreService.IobjectServicesWebappVer2Client();
AmazonFile af = new AmazonFile();
fileuploaded = af.WriteFile(Request.Files[0].FileName, Request.Files[0].InputStream, Session["companyid"].ToString(), Session["usertoken"].ToString());
coreclient.AddRelation(einv.invoiceid, fileuploaded.Id, "extinv", Session["usertoken"].ToString());
IList document = af.GetResourceTokens(null, einv.invoiceid, "extinv", Session["usertoken"].ToString());
string fileurl = "";
foreach (Business.CoreService.ResourceToken li in document)
{
fileurl = af.GetFileUrl(li.ContentId, Session["usertoken"].ToString());
}
return(RedirectToAction("inbound"));
}
public ActionResult Add(ExternalInvoice einv, HttpPostedFileBase file)
{
Business.ApplicationService.AppServiceClient bd = new Business.ApplicationService.AppServiceClient();
Business.CoreService.MyFile fileuploaded = new Business.CoreService.MyFile();
Business.CoreService.IobjectServicesWebappVer2Client coreclient = new Business.CoreService.IobjectServicesWebappVer2Client();
AmazonFile af = new AmazonFile();
fileuploaded = af.WriteFile(Request.Files[0].FileName, Request.Files[0].InputStream, Session["companyid"].ToString(), Session["usertoken"].ToString());
coreclient.AddRelation(einv.invoiceid, fileuploaded.Id, "extinv", Session["usertoken"].ToString());
IList document = af.GetResourceTokens(null, einv.invoiceid, "extinv", Session["usertoken"].ToString());
string fileurl = "";
foreach (Business.CoreService.ResourceToken li in document)
{
fileurl = af.GetFileUrl(li.ContentId, Session["usertoken"].ToString());
}
return RedirectToAction("inbound");
}
//
// GET: /Communication/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.InvitationApp[] invitationslist = appclient.GetInvitationmaster("*****@*****.**", "msgtype");
List<UI.Models.mailmessage> mailmessages = new List<Models.mailmessage>();
foreach (Business.ApplicationService.InvitationApp invitation in invitationslist)
{
UI.Models.mailmessage message = new Models.mailmessage();
message.mailitemid = invitation.invitationmasterid;
message.mailtime = invitation.invitetime.ToString();
message.receipients = invitation.invitees;
message.sender = invitation.sendorid;
message.mailbrief = invitation.invitationtext;
tags listmembersdata = JsonConvert.DeserializeObject<tags>(invitation.Prop);
message.properties =listmembersdata;
mailmessages.Add(message);
}
return View(mailmessages);
}
//
// GET: /Communication/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.InvitationApp[] invitationslist = appclient.GetInvitationmaster("*****@*****.**", "msgtype");
List <UI.Models.mailmessage> mailmessages = new List <Models.mailmessage>();
foreach (Business.ApplicationService.InvitationApp invitation in invitationslist)
{
UI.Models.mailmessage message = new Models.mailmessage();
message.mailitemid = invitation.invitationmasterid;
message.mailtime = invitation.invitetime.ToString();
message.receipients = invitation.invitees;
message.sender = invitation.sendorid;
message.mailbrief = invitation.invitationtext;
tags listmembersdata = JsonConvert.DeserializeObject <tags>(invitation.Prop);
message.properties = listmembersdata;
mailmessages.Add(message);
}
return(View(mailmessages));
}
public static Dictionary<string, string> AfterLoginRoute(string token)
{
Dictionary<string, string> afterloginroute = new Dictionary<string, string>();
string loggedintoken = token;
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(loggedintoken);
List<menuitem> topmenu = new List<menuitem>();
switch (loggedinuser.ObjectType.ToString())
{
case "private":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "comadmin":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "comrecruit":
afterloginroute.Add("action", "index");
afterloginroute.Add("controller", "jobs");
break;
case "tsadmin":
afterloginroute.Add("action", "admindashboard");
afterloginroute.Add("controller", "timesheet");
break;
case "consultant":
afterloginroute.Add("action", "dashboard");
afterloginroute.Add("controller", "timesheet");
break;
}
return afterloginroute;
}
public List <menuitem> GetTopmenu(string token)
{
string loggedintoken = token;
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(loggedintoken);
List <menuitem> topmenu = new List <menuitem>();
switch (loggedinuser.ObjectType.ToString())
{
case "private":
topmenu = BuildSuperAdminMenu();
break;
case "comadmin":
topmenu = BuildJobUserMenu();
break;
case "comrecruit":
topmenu = BuildSuperAdminMenu();
break;
case "tsadmin":
topmenu = BuildTimeSheetAdminMenu();
break;
case "consultant":
topmenu = BuildConsultantMenu();
break;
}
return(topmenu);
}
public ActionResult ChangePassword(string oldpassword, string newpassword, string accesstoken)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.ChangePassword(oldpassword, newpassword, Session["usertoken"].ToString());
return View();
}
public Job getPublicJobById(string intJobId)
{
CommonFunctions cf = new CommonFunctions();
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.jobs sjob = new Business.ApplicationService.jobs();
sjob = appclient.GetJob(intJobId, "", "", "");
Job tempjob = new Job();
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.State = sjob.cityid;
tempjob.JobLength = sjob.additionaldetails;
tempjob.Email = sjob.email;
tempjob.Phone = sjob.phone;
tempjob.jobdata = sjob.data;
tempjob.CompanyId = sjob.objectid;
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = enddatexception.Message;
}
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = createddatexception.Message;
}
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
try
{
tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString();
}
catch { }
return tempjob;
}
catch { throw; }
}
public string InsertJobDetials(Job job)
{
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
int CompID = 1;
int CatId = 1;
int stateId = 1;
int Expcodeid = 1;
Expcodeid = Convert.ToInt32(CommonFunctions.MapExperiencetoID[job.Exp].ToString());
string[] postypearray = job.postype.Split(',');
string PositionTypeId = "";
if (postypearray.Length > 0)
{
foreach (string postype in postypearray)
{
if (PositionTypeId == "")
{ PositionTypeId = CommonFunctions.MapPositiontoID[postype].ToString(); }
else
{
PositionTypeId = PositionTypeId + "," + CommonFunctions.MapPositiontoID[postype].ToString();
}
}
}
job.StartDate = DateTime.Now;
job.ModifiedDate = DateTime.Now;
string[] expdatearray = job.ExpDate.Split('/');
string expdt = new DateTime(Convert.ToInt32(expdatearray[2]), Convert.ToInt32(expdatearray[0]), Convert.ToInt32(expdatearray[1])).ToString("yyyy-MM-dd HH:mm:ss");
job.Publish = 1; //inhouse
job.jobdata = Newtonsoft.Json.JsonConvert.SerializeObject(job);
appclient.CreateJob("", "", job.JobName, job.JobDesc, job.PayRate, job.PrefSkills, PositionTypeId, job.City, job.StartDate.Day.ToString(), job.StartDate.Month.ToString(), job.StartDate.Year.ToString(), Convert.ToInt32(expdatearray[1]).ToString(), Convert.ToInt32(expdatearray[0]).ToString(), Convert.ToInt32(expdatearray[2]).ToString(), Expcodeid, (int)job.Publish, System.Web.HttpContext.Current.Session["companyid"].ToString(), "jobpost", job.Email, job.Phone, "", job.jobdata, job.additionaldetails);
return m_nJobId;
}
catch { throw; }
}
public List<JobApplication> GetJobApplicants(string jobid, string companyid)
{
List<JobApplication> applications = new List<JobApplication>();
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
List<Business.ApplicationService.applicant> serviceapplicants = appclient.GetApplicantsinjob(System.Web.HttpContext.Current.Session["userid"].ToString(), companyid, jobid, "","applicant").ToList();
foreach (Business.ApplicationService.applicant serviceapplicant in serviceapplicants)
{
JobApplication tempjobapplication = new JobApplication();
tempjobapplication.applicationid = serviceapplicant.transactionid;
portalcandidate tempcandidate = new portalcandidate();
tempcandidate.id = serviceapplicant.candidateid;
tempcandidate.resumeid = serviceapplicant.resumeid;
if (tempcandidate.resumeid == "" || tempcandidate.resumeid == null)
{
tempcandidate.resumeurl = "";
}
else
{
try
{
AmazonFile af = new AmazonFile();
tempcandidate.resumeurl = af.GetFileUrl(serviceapplicant.resumeid, System.Web.HttpContext.Current.Session["usertoken"].ToString());
}
catch
{
}
}
tempcandidate.contactid = serviceapplicant.contactid;
tempcandidate.data = serviceapplicant.data;
tempjobapplication.candidate = tempcandidate;
try
{
tempjobapplication.applicationstatus = serviceapplicant.status.ToString();
}
catch
{
tempjobapplication.applicationstatus = "0";
}
applications.Add(tempjobapplication);
}
return applications;
}
public List<Job> getJobDetailsByJobId(string intJobId, string companyid)
{
CommonFunctions cf = new CommonFunctions();
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.jobs sjob = new Business.ApplicationService.jobs();
sjob = appclient.GetJob(intJobId, "", "", companyid);
Job tempjob = new Job();
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.State = sjob.cityid;
tempjob.JobLength = sjob.additionaldetails;
tempjob.Email = sjob.email;
tempjob.Phone = sjob.phone;
tempjob.jobdata = sjob.data;
UI.Models.Job Objob = Newtonsoft.Json.JsonConvert.DeserializeObject<UI.Models.Job>(sjob.data);
tempjob.payratemax = Objob.payratemax;
tempjob.payratemode = Objob.payratemode;
tempjob.Travel = Objob.Travel;
tempjob.payratenegotaible = Objob.payratenegotaible;
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = enddatexception.Message;
}
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = createddatexception.Message;
}
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
try
{
string[] jobpositioncodearray = sjob.positiontype.Split(',');
foreach (string positioncode in jobpositioncodearray)
{
if (tempjob.postype == "")
{
tempjob.postype = CommonFunctions.MapIDtoPosition[positioncode].ToString();
tempjob.PositionType.Add(CommonFunctions.MapIDtoPosition[positioncode].ToString());
}
else
{
tempjob.postype = tempjob.postype + "," +CommonFunctions.MapIDtoPosition[positioncode].ToString();
tempjob.PositionType.Add(CommonFunctions.MapIDtoPosition[positioncode].ToString());
}
}
}
catch { tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString(); }
List<Job> jobslist = new List<Job>();
jobslist.Add(tempjob);
//}
return jobslist;
}
catch { throw; }
}
public List <Job> getJobDetailsByJobId(string intJobId, string companyid)
{
CommonFunctions cf = new CommonFunctions();
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.jobs sjob = new Business.ApplicationService.jobs();
sjob = appclient.GetJob(intJobId, "", "", companyid);
Job tempjob = new Job();
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.State = sjob.cityid;
tempjob.JobLength = sjob.additionaldetails;
tempjob.Email = sjob.email;
tempjob.Phone = sjob.phone;
tempjob.jobdata = sjob.data;
UI.Models.Job Objob = Newtonsoft.Json.JsonConvert.DeserializeObject <UI.Models.Job>(sjob.data);
tempjob.payratemax = Objob.payratemax;
tempjob.payratemode = Objob.payratemode;
tempjob.Travel = Objob.Travel;
tempjob.payratenegotaible = Objob.payratenegotaible;
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = enddatexception.Message;
}
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = createddatexception.Message;
}
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
try
{
string[] jobpositioncodearray = sjob.positiontype.Split(',');
foreach (string positioncode in jobpositioncodearray)
{
if (tempjob.postype == "")
{
tempjob.postype = CommonFunctions.MapIDtoPosition[positioncode].ToString();
tempjob.PositionType.Add(CommonFunctions.MapIDtoPosition[positioncode].ToString());
}
else
{
tempjob.postype = tempjob.postype + "," + CommonFunctions.MapIDtoPosition[positioncode].ToString();
tempjob.PositionType.Add(CommonFunctions.MapIDtoPosition[positioncode].ToString());
}
}
}
catch { tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString(); }
List <Job> jobslist = new List <Job>();
jobslist.Add(tempjob);
//}
return(jobslist);
}
catch { throw; }
}
//for time being using static userid
public List<Job> getAllInhouseorPublishActiveorInactiveJobsList()
{
string executionprocess = "";
CommonFunctions cf = new CommonFunctions();
executionprocess += "created commonfunctions Object";
try
{
List<Business.ApplicationService.jobs> servicejobslist = new List<Business.ApplicationService.jobs>();
executionprocess += "service jobs list object";
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
executionprocess += "appclient object";
executionprocess += "; companyid =" + System.Web.HttpContext.Current.Session["companyid"].ToString();
Business.ApplicationService.jobs[] serviceJobs = appclient.GetJobs("", "", System.Web.HttpContext.Current.Session["companyid"].ToString());
executionprocess += "service jobs array";
servicejobslist = serviceJobs.ToList();
executionprocess += "service jobs array to list done";
}
catch
{
throw (new Exception(executionprocess + "exception at service jobs list"));
}
List<Job> jobslist = new List<Job>();
executionprocess += "service joblist object";
foreach (Business.ApplicationService.jobs sjob in servicejobslist)
{
Job tempjob = new Job();
executionprocess += "service tempjob object";
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.jobdata = sjob.data;
UI.Models.Job Objob = Newtonsoft.Json.JsonConvert.DeserializeObject<UI.Models.Job>(sjob.data);
tempjob.payratemax = Objob.payratemax;
tempjob.payratemode = Objob.payratemode;
tempjob.Travel = Objob.Travel;
tempjob.payratenegotaible = Objob.payratenegotaible;
tempjob.State = sjob.cityid;
executionprocess += "assigning values to temp job";
try
{
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = executionprocess + enddatexception.Message;
}
try
{
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = executionprocess + strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
try
{
tempjob.createddate = DateTime.ParseExact(sjob.createddate, "MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
}
catch
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = executionprocess + createddatexception.Message;
}
executionprocess += "time conversions done";
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
executionprocess += "desc and additional details added";
try
{
string[] positiontypecodearray = sjob.positiontype.Split(',');
if (positiontypecodearray.Length > 0)
{
foreach (string positioncode in positiontypecodearray)
{
if (tempjob.postype == null || tempjob.postype == "")
{
tempjob.postype = CommonFunctions.MapIDtoPosition[positioncode].ToString();
}
else
{
tempjob.postype = tempjob.postype + "," + CommonFunctions.MapIDtoPosition[positioncode].ToString();
}
}
}
}
catch { tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString(); }
try
{
executionprocess += "Before retrieving job applications object ; ";
List<JobApplication> applications = GetJobApplicants(sjob.jobid, System.Web.HttpContext.Current.Session["companyid"].ToString());
executionprocess += "job applications object";
tempjob.applications = applications;
executionprocess += "assigning applicationa to job done";
jobslist.Add(tempjob);
executionprocess += "assigning job to job list done";
}
catch
{
throw (new Exception(executionprocess + "exception at jobs applications list"));
}
}
return jobslist.OrderByDescending(x => x.createddate).ToList();
}
catch
{
throw (new Exception(executionprocess + "exception at top level"));
}
}
public Job getPublicJobById(string intJobId)
{
CommonFunctions cf = new CommonFunctions();
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.jobs sjob = new Business.ApplicationService.jobs();
sjob = appclient.GetJob(intJobId, "", "", "");
Job tempjob = new Job();
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.State = sjob.cityid;
tempjob.JobLength = sjob.additionaldetails;
tempjob.Email = sjob.email;
tempjob.Phone = sjob.phone;
tempjob.jobdata = sjob.data;
tempjob.CompanyId = sjob.objectid;
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = enddatexception.Message;
}
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = createddatexception.Message;
}
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
try
{
tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString();
}
catch { }
return(tempjob);
}
catch { throw; }
}
public bool DeleteContact( string contactid,string companyid, string objectid)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
bool status = appclient.DeleteContact(contactid,Session["companyid"].ToString(), Session["companyid"].ToString());
return status;
}
//
// GET: /Users/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
UI.Models.UserViewModel userviewdata = new Models.UserViewModel();
List<Business.ApplicationService.appuser> allusers = new List<Business.ApplicationService.appuser>();
List<Business.ApplicationService.appuser> admins = new List<Business.ApplicationService.appuser>();
List<Business.ApplicationService.appuser> recruiters = new List<Business.ApplicationService.appuser>();
List<Business.ApplicationService.appuser> consultants = new List<Business.ApplicationService.appuser>();
List<Business.ApplicationService.appuser> timesheetadmins = new List<Business.ApplicationService.appuser>();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(Session["usertoken"].ToString());
if (loggedinuser.ObjectType.ToLower() == "private")
{
admins = appclient.GetAdmins(Session["companyid"].ToString(), "comadmin", Session["usertoken"].ToString()).ToList();
recruiters = appclient.GetAdmins(Session["companyid"].ToString(), "comrecruit", Session["usertoken"].ToString()).ToList();
allusers.AddRange(admins);
allusers.AddRange(recruiters);
Business.menuitem addrecruiter = new Business.menuitem();
addrecruiter.linkname = "Add Recruiter";
addrecruiter.linkpath = "/users/recruiter";
addrecruiter.menuposition = 1;
userviewdata.actions.Add(addrecruiter);
Business.menuitem addadmin = new Business.menuitem();
addadmin.linkname = "Add Admin";
addadmin.linkpath = "/users/admin";
addadmin.menuposition = 2;
userviewdata.actions.Add(addadmin);
userviewdata.UsersCollection = allusers;
}
else if (loggedinuser.ObjectType.ToLower() == "tsadmin")
{
consultants = appclient.GetAdmins(Session["companyid"].ToString(), "consultant", Session["usertoken"].ToString()).ToList();
allusers.AddRange(consultants);
Business.menuitem addconsultant = new Business.menuitem();
addconsultant.linkname = "Add Consultant";
addconsultant.linkpath = "/users/consultant";
addconsultant.menuposition = 1;
userviewdata.actions.Add(addconsultant);
timesheetadmins = appclient.GetAdmins(Session["companyid"].ToString(), "tsadmin", Session["usertoken"].ToString()).ToList();
allusers.AddRange(timesheetadmins);
Business.menuitem addTimeSheetAdmins = new Business.menuitem();
addTimeSheetAdmins.linkname = "Add Timesheet Admin";
addTimeSheetAdmins.linkpath = "/users/sheetadmin";
addTimeSheetAdmins.menuposition = 2;
userviewdata.actions.Add(addTimeSheetAdmins);
userviewdata.UsersCollection = allusers;
}
return View(userviewdata);
}
public ActionResult Manage(string listid)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.contact[] contacts = appclient.GetContacts("9a73072573754e13a02381c9d931e5c4", "9a73072573754e13a02381c9d931e5c4","1","100");
List<UI.Models.PortalContact> portalcontacts = new List<Models.PortalContact>();
foreach (Business.ApplicationService.contact contact in contacts)
{
UI.Models.PortalContact tempcontact = new Models.PortalContact();
tempcontact.id = contact.contactid;
tempcontact.emailaddress = contact.emailid;
portalcontacts.Add(tempcontact);
}
return View(portalcontacts);
}
public ActionResult SendMail(UI.Models.MessagingObjectModel.JObsBulkMail maildata)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
string recipientstring = "";
string[] recipients = maildata.recipients.Split(',');
foreach (string str in recipients)
{
if (str.ToLower() != "undefined" && str.Length == 32)
{
if (recipientstring == "")
{
recipientstring = str;
}
else
{
recipientstring = recipientstring + "," + str;
}
}
}
Business.CoreService.IobjectServicesWebappVer2Client client = new Business.CoreService.IobjectServicesWebappVer2Client();
List<Business.ApplicationService.mailattachment> attachments = new List<Business.ApplicationService.mailattachment>();
string companyemail = "";
try
{
companyemail = Session["companyemail"].ToString();
}
catch
{
companyemail = "mailer@" + Session["companyname"].ToString() + ".com";
}
Business.ApplicationService.AppRestResponse response = appclient.SendComplexMessage(recipientstring, companyemail, "", maildata.messagebody.ToString(), maildata.mailsubject, attachments.ToArray(), Session["usertoken"].ToString());
string[] jobs = maildata.jobs.Split(';');
foreach (string singlejob in jobs)
{
if (singlejob.Length == 32)
{
appclient.Updateemailstatus(singlejob, 1);
}
}
return Redirect(Request.UrlReferrer.ToString());
}
public string GetMailingLists(string companyid,string usertoken)
{
string JsonMailLists = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.maillist[] maillists= appclient.jsonMailinglists(companyid,usertoken);
JsonMailLists = Newtonsoft.Json.JsonConvert.SerializeObject(maillists);
return JsonMailLists;
}
public string GetAllAccounts(string usertoken)
{
string accounts = "";
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.accounts[] appaccounts = appclient.Getaccounts(usertoken);
accounts = Newtonsoft.Json.JsonConvert.SerializeObject(appaccounts);
return accounts;
}
public AccountCollection GetUserAccounts(string usertoken)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.accounts[] appaccounts = appclient.Getaccounts(usertoken);
AccountCollection AccountCollection = new Models.AccountCollection();
List<AccountgroupCollection> accountgroupcollection = new List<AccountgroupCollection>();
foreach (Business.ApplicationService.accounts item in appaccounts.GroupBy(p => p.categoryid).Select(g => g.First()))
{
AccountgroupCollection temgroup = new AccountgroupCollection();
temgroup.categoryid = item.categoryid;
temgroup.categoryname = item.categoryname;
temgroup.userid = item.userid;
List<Business.ApplicationService.accounts> resultaccounts = appaccounts.Where(p => p.categoryid == item.categoryid).ToList();
foreach (Business.ApplicationService.accounts subitem in resultaccounts)
{
PTAccount tempaccount = new PTAccount();
tempaccount.accountId = subitem.accountid;
tempaccount.accountName = subitem.accountname;
tempaccount.accounttype = subitem.accounttype;
tempaccount.amount = (float)Convert.ToDouble(subitem.amount);
tempaccount.uniqueid = subitem.unid;
tempaccount.categoryid = subitem.categoryid;
tempaccount.categoryname = subitem.categoryname;
tempaccount.createddate = subitem.createddate;
tempaccount.deleted = false;
tempaccount.description = subitem.description;
tempaccount.duemonth = subitem.duemonth;
tempaccount.duedate = subitem.duedate;
tempaccount.modifieddate = subitem.modifieddate;
tempaccount.providerid = subitem.providerid;
tempaccount.providername = subitem.providername;
tempaccount.recurrence = subitem.recurrence;
tempaccount.subcatid = subitem.subcategoryid;
tempaccount.userid = subitem.userid;
tempaccount.global = subitem.global;
tempaccount.initial = subitem.initial;
tempaccount.codes = subitem.codes;
temgroup.accounts.Add(tempaccount);
}
accountgroupcollection.Add(temgroup);
}
AccountCollection.requestedtime = DateTime.Now.ToString();
AccountCollection.accountcollection = accountgroupcollection;
return AccountCollection;
}
//
// GET: /Candidate/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", "", "master");
List <UI.Models.Applicantdetails> portalcontacts = new List <Models.Applicantdetails>();
foreach (Business.ApplicationService.applicant sinapplicant in applicants)
{
UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
try
{
UI.Models.Applicantdetails Objapplicant = Newtonsoft.Json.JsonConvert.DeserializeObject <UI.Models.Applicantdetails>(sinapplicant.data);
if (Objapplicant == null)
{
singleapplicant.firstname = "";
singleapplicant.lastname = "";
singleapplicant.person.email = "";
}
else
{
singleapplicant.firstname = Objapplicant.firstname;
singleapplicant.lastname = Objapplicant.lastname;
singleapplicant.person.email = Objapplicant.person.email;
singleapplicant.person.contact = Objapplicant.person.contact;
singleapplicant.person.companyname = Objapplicant.person.companyname;
singleapplicant.address.line1 = Objapplicant.address.line1;
singleapplicant.address.line2 = Objapplicant.address.line2;
singleapplicant.address.city = Objapplicant.address.city;
singleapplicant.address.cityid = Objapplicant.address.cityid;
singleapplicant.address.state = Objapplicant.address.state;
singleapplicant.address.country = Objapplicant.address.country;
singleapplicant.detailedinfo.visa = Objapplicant.detailedinfo.visa;
singleapplicant.detailedinfo.payrate = Objapplicant.detailedinfo.payrate;
singleapplicant.detailedinfo.salary = Objapplicant.detailedinfo.salary;
singleapplicant.detailedinfo.availability = Objapplicant.detailedinfo.availability;
singleapplicant.detailedinfo.relocation = Objapplicant.detailedinfo.relocation;
singleapplicant.detailedinfo.location = Objapplicant.detailedinfo.location;
singleapplicant.detailedinfo.travel = Objapplicant.detailedinfo.travel;
singleapplicant.detailedinfo.addinfo = Objapplicant.detailedinfo.addinfo;
singleapplicant.job.experience = Objapplicant.job.experience;
singleapplicant.job.skills.primary = Objapplicant.job.skills.primary;
singleapplicant.job.category.id = Objapplicant.job.category.id;
singleapplicant.job.category.name = Objapplicant.job.category.name;
singleapplicant.job.subcategory.id = Objapplicant.job.subcategory.id;
singleapplicant.job.subcategory.name = Objapplicant.job.subcategory.name;
singleapplicant.supplier.companyname = Objapplicant.supplier.companyname;
singleapplicant.supplier.person.email = Objapplicant.supplier.person.email;
singleapplicant.supplier.person.contact = Objapplicant.supplier.person.contact;
singleapplicant.supplier.person.companyname = Objapplicant.supplier.person.companyname;
}
}
catch
{
singleapplicant.firstname = "";
}
singleapplicant.candidateid = sinapplicant.candidateid;
singleapplicant.contactid = sinapplicant.contactid;
singleapplicant.createddate = sinapplicant.createddate;
singleapplicant.creatorid = sinapplicant.creatorid;
singleapplicant.jobid = sinapplicant.jobid;
portalcontacts.Add(singleapplicant);
}
return(View(portalcontacts));
}
public ActionResult import(UI.Models.Mailinglist maillist, HttpPostedFileBase file)
{
string strPath = string.Empty;
string filename = string.Empty;
string redirecturl = "http://" + Request.Url.Authority + "/lists/list?listid=" + maillist.id;
//file upload path
string filenewname = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(Request.Files[0].FileName);
string UploadFileFolderPath = HttpContext.Server.MapPath("~/Content");//System.Configuration.ConfigurationManager.AppSettings["ExcelSheet"]; //folder shld exists in appln path
if (filenewname.ToString().Trim().Length > 0)
{
if (!Directory.Exists(Server.MapPath("~/Content")))
{
Directory.CreateDirectory(Server.MapPath("~/Content"));
}
string savepath = Server.MapPath("~/Content" + "/");
string pathToCheck = savepath + filenewname;
Request.Files[0].SaveAs(Server.MapPath("~/Content") + "/" + filenewname);
}
strPath = Server.MapPath("~/Content") + "/" + filenewname;
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strPath + ";Extended Properties='Excel 12.0;Persist Security Info=False;HDR=NO;'";
//Create Connection to Excel work book
System.Data.OleDb.OleDbConnection excelConnection = new System.Data.OleDb.OleDbConnection(excelConnectionString);
//
excelConnection.Open();
DataTable exceldatatable = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (exceldatatable == null)
{
return(null);
}
String[] excelSheets = new String[exceldatatable.Rows.Count];
int i = 0;
foreach (DataRow row in exceldatatable.Rows)
{
excelSheets[i] = row["TABLE_NAME"].ToString();
i++;
}
//
System.Data.OleDb.OleDbDataAdapter MyCommand = null;
System.Data.DataSet DtSet = null;
DataTable dt = new DataTable();
string message = string.Empty;
string commandtext = " select * from [" + excelSheets[0].ToString() + "]";
MyCommand = new System.Data.OleDb.OleDbDataAdapter(commandtext, excelConnection);
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet, "[" + excelSheets[0].ToString() + "]");
dt = DtSet.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string name = "";
string description = "";
string email = "";
try
{
name = dr[0].ToString();
description = dr[2].ToString();
}
catch { }
try
{
email = dr.ItemArray[1].ToString();
if (email.Trim() != "")
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.AddListMember(maillist.id, email.Trim(), name, description, Session["usertoken"].ToString());
}
else
{
return(Redirect(redirecturl));
}
}
catch
{
}
}
return(Redirect(redirecturl));
}
public ActionResult ChangePassword(string oldpassword, string newpassword, string accesstoken)
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.ChangePassword(oldpassword, newpassword, Session["usertoken"].ToString());
return(View());
}
//
// GET: /Candidate/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
Business.ApplicationService.applicant[] applicants = appclient.GetApplicants("", Session["companyid"].ToString(), "", "","master");
List<UI.Models.Applicantdetails> portalcontacts = new List<Models.Applicantdetails>();
foreach (Business.ApplicationService.applicant sinapplicant in applicants)
{
UI.Models.Applicantdetails singleapplicant = new Models.Applicantdetails();
try
{
UI.Models.Applicantdetails Objapplicant = Newtonsoft.Json.JsonConvert.DeserializeObject<UI.Models.Applicantdetails>(sinapplicant.data);
if (Objapplicant == null)
{
singleapplicant.firstname = "";
singleapplicant.lastname = "";
singleapplicant.person.email = "";
}
else
{
singleapplicant.firstname = Objapplicant.firstname;
singleapplicant.lastname = Objapplicant.lastname;
singleapplicant.person.email = Objapplicant.person.email;
singleapplicant.person.contact = Objapplicant.person.contact;
singleapplicant.person.companyname = Objapplicant.person.companyname;
singleapplicant.address.line1 = Objapplicant.address.line1;
singleapplicant.address.line2 = Objapplicant.address.line2;
singleapplicant.address.city = Objapplicant.address.city;
singleapplicant.address.cityid = Objapplicant.address.cityid;
singleapplicant.address.state = Objapplicant.address.state;
singleapplicant.address.country = Objapplicant.address.country;
singleapplicant.detailedinfo.visa = Objapplicant.detailedinfo.visa;
singleapplicant.detailedinfo.payrate = Objapplicant.detailedinfo.payrate;
singleapplicant.detailedinfo.salary = Objapplicant.detailedinfo.salary;
singleapplicant.detailedinfo.availability = Objapplicant.detailedinfo.availability;
singleapplicant.detailedinfo.relocation = Objapplicant.detailedinfo.relocation;
singleapplicant.detailedinfo.location = Objapplicant.detailedinfo.location;
singleapplicant.detailedinfo.travel = Objapplicant.detailedinfo.travel;
singleapplicant.detailedinfo.addinfo = Objapplicant.detailedinfo.addinfo;
singleapplicant.job.experience = Objapplicant.job.experience;
singleapplicant.job.skills.primary = Objapplicant.job.skills.primary;
singleapplicant.job.category.id = Objapplicant.job.category.id;
singleapplicant.job.category.name = Objapplicant.job.category.name;
singleapplicant.job.subcategory.id = Objapplicant.job.subcategory.id;
singleapplicant.job.subcategory.name = Objapplicant.job.subcategory.name;
singleapplicant.supplier.companyname = Objapplicant.supplier.companyname;
singleapplicant.supplier.person.email = Objapplicant.supplier.person.email;
singleapplicant.supplier.person.contact = Objapplicant.supplier.person.contact;
singleapplicant.supplier.person.companyname = Objapplicant.supplier.person.companyname;
}
}
catch
{
singleapplicant.firstname = "";
}
singleapplicant.candidateid = sinapplicant.candidateid;
singleapplicant.contactid = sinapplicant.contactid;
singleapplicant.createddate = sinapplicant.createddate;
singleapplicant.creatorid = sinapplicant.creatorid;
singleapplicant.jobid = sinapplicant.jobid;
portalcontacts.Add(singleapplicant);
}
return View(portalcontacts);
}
} //with mv
public List <Job> getAllInhouseorPublishActiveorInactiveJobsList() //for time being using static userid
{
string executionprocess = "";
CommonFunctions cf = new CommonFunctions();
executionprocess += "created commonfunctions Object";
try
{
List <Business.ApplicationService.jobs> servicejobslist = new List <Business.ApplicationService.jobs>();
executionprocess += "service jobs list object";
try
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
executionprocess += "appclient object";
executionprocess += "; companyid =" + System.Web.HttpContext.Current.Session["companyid"].ToString();
Business.ApplicationService.jobs[] serviceJobs = appclient.GetJobs("", "", System.Web.HttpContext.Current.Session["companyid"].ToString());
executionprocess += "service jobs array";
servicejobslist = serviceJobs.ToList();
executionprocess += "service jobs array to list done";
}
catch
{
throw (new Exception(executionprocess + "exception at service jobs list"));
}
List <Job> jobslist = new List <Job>();
executionprocess += "service joblist object";
foreach (Business.ApplicationService.jobs sjob in servicejobslist)
{
Job tempjob = new Job();
executionprocess += "service tempjob object";
tempjob.JobId = sjob.jobid;
tempjob.JobIDforPublisPartnersList = 0;
tempjob.JobName = sjob.jobname;
tempjob.Exp = CommonFunctions.MapIDtoExperience[sjob.expid.ToString()].ToString();
tempjob.PayRate = sjob.payrate;
tempjob.PrefSkills = sjob.preferenceskills;
tempjob.Status = sjob.status;
tempjob.jobdata = sjob.data;
UI.Models.Job Objob = Newtonsoft.Json.JsonConvert.DeserializeObject <UI.Models.Job>(sjob.data);
tempjob.payratemax = Objob.payratemax;
tempjob.payratemode = Objob.payratemode;
tempjob.Travel = Objob.Travel;
tempjob.payratenegotaible = Objob.payratenegotaible;
tempjob.State = sjob.cityid;
executionprocess += "assigning values to temp job";
try
{
try
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
catch
{
tempjob.ExpiryDate = new DateTime(Convert.ToInt32(sjob.endyear), Convert.ToInt32(sjob.endmonth), Convert.ToInt32(sjob.enddate));
}
}
catch (Exception enddatexception)
{
string strdatexceptioninfo = executionprocess + enddatexception.Message;
}
try
{
try
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
catch
{
tempjob.StartDate = new DateTime(Convert.ToInt32(sjob.startyear), Convert.ToInt32(sjob.startmonth), Convert.ToInt32(sjob.startdate));
}
}
catch (Exception strdatexception)
{
string strdatexceptioninfo = executionprocess + strdatexception.Message;
}
tempjob.jobmailstatus = sjob.emailstatus;
try
{
try
{
tempjob.createddate = DateTime.ParseExact(sjob.createddate, "MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture);
}
catch
{
tempjob.createddate = DateTime.Parse(sjob.createddate);
}
}
catch (Exception createddatexception)
{
string strdatexceptioninfo = executionprocess + createddatexception.Message;
}
executionprocess += "time conversions done";
tempjob.JobDesc = sjob.jobdescription;
tempjob.additionaldetails = sjob.additionaldetails;
executionprocess += "desc and additional details added";
try
{
string[] positiontypecodearray = sjob.positiontype.Split(',');
if (positiontypecodearray.Length > 0)
{
foreach (string positioncode in positiontypecodearray)
{
if (tempjob.postype == null || tempjob.postype == "")
{
tempjob.postype = CommonFunctions.MapIDtoPosition[positioncode].ToString();
}
else
{
tempjob.postype = tempjob.postype + "," + CommonFunctions.MapIDtoPosition[positioncode].ToString();
}
}
}
}
catch { tempjob.postype = CommonFunctions.MapIDtoPosition[sjob.positiontype].ToString(); }
try
{
executionprocess += "Before retrieving job applications object ; ";
List <JobApplication> applications = GetJobApplicants(sjob.jobid, System.Web.HttpContext.Current.Session["companyid"].ToString());
executionprocess += "job applications object";
tempjob.applications = applications;
executionprocess += "assigning applicationa to job done";
jobslist.Add(tempjob);
executionprocess += "assigning job to job list done";
}
catch
{
throw (new Exception(executionprocess + "exception at jobs applications list"));
}
}
return(jobslist.OrderByDescending(x => x.createddate).ToList());
}
catch
{
throw (new Exception(executionprocess + "exception at top level"));
}
}
public ActionResult import(UI.Models.Mailinglist maillist, HttpPostedFileBase file)
{
string strPath = string.Empty;
string filename = string.Empty;
string redirecturl = "http://" + Request.Url.Authority + "/lists/list?listid=" + maillist.id;
//file upload path
string filenewname = Guid.NewGuid().ToString().Replace("-", "") + Path.GetExtension(Request.Files[0].FileName);
string UploadFileFolderPath = HttpContext.Server.MapPath("~/Content");//System.Configuration.ConfigurationManager.AppSettings["ExcelSheet"]; //folder shld exists in appln path
if (filenewname.ToString().Trim().Length > 0)
{
if (!Directory.Exists(Server.MapPath("~/Content")))
{
Directory.CreateDirectory(Server.MapPath("~/Content"));
}
string savepath = Server.MapPath("~/Content" + "/");
string pathToCheck = savepath + filenewname;
Request.Files[0].SaveAs(Server.MapPath("~/Content") + "/" + filenewname);
}
strPath = Server.MapPath("~/Content") + "/" + filenewname;
//Create connection string to Excel work book
string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strPath + ";Extended Properties='Excel 12.0;Persist Security Info=False;HDR=NO;'";
//Create Connection to Excel work book
System.Data.OleDb.OleDbConnection excelConnection = new System.Data.OleDb.OleDbConnection(excelConnectionString);
//
excelConnection.Open();
DataTable exceldatatable = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (exceldatatable == null)
{
return null;
}
String[] excelSheets = new String[exceldatatable.Rows.Count];
int i = 0;
foreach (DataRow row in exceldatatable.Rows)
{
excelSheets[i] = row["TABLE_NAME"].ToString();
i++;
}
//
System.Data.OleDb.OleDbDataAdapter MyCommand = null;
System.Data.DataSet DtSet = null;
DataTable dt = new DataTable();
string message = string.Empty;
string commandtext = " select * from [" + excelSheets[0].ToString() + "]";
MyCommand = new System.Data.OleDb.OleDbDataAdapter(commandtext, excelConnection);
DtSet = new System.Data.DataSet();
MyCommand.Fill(DtSet, "[" + excelSheets[0].ToString() + "]");
dt = DtSet.Tables[0];
foreach (DataRow dr in dt.Rows)
{
string name = "";
string description = "";
string email = "";
try
{
name = dr[0].ToString();
description = dr[2].ToString();
}
catch { }
try
{
email = dr.ItemArray[1].ToString();
if (email.Trim() != "")
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
appclient.AddListMember(maillist.id, email.Trim(), name, description, Session["usertoken"].ToString());
}
else
return Redirect(redirecturl);
}
catch
{
}
}
return Redirect(redirecturl);
}
//
// GET: /Users/
public ActionResult Index()
{
Business.ApplicationService.AppServiceClient appclient = new Business.ApplicationService.AppServiceClient();
UI.Models.UserViewModel userviewdata = new Models.UserViewModel();
List <Business.ApplicationService.appuser> allusers = new List <Business.ApplicationService.appuser>();
List <Business.ApplicationService.appuser> admins = new List <Business.ApplicationService.appuser>();
List <Business.ApplicationService.appuser> recruiters = new List <Business.ApplicationService.appuser>();
List <Business.ApplicationService.appuser> consultants = new List <Business.ApplicationService.appuser>();
List <Business.ApplicationService.appuser> timesheetadmins = new List <Business.ApplicationService.appuser>();
Business.ApplicationService.appuser loggedinuser = appclient.GetUserObject(Session["usertoken"].ToString());
if (loggedinuser.ObjectType.ToLower() == "private")
{
admins = appclient.GetAdmins(Session["companyid"].ToString(), "comadmin", Session["usertoken"].ToString()).ToList();
recruiters = appclient.GetAdmins(Session["companyid"].ToString(), "comrecruit", Session["usertoken"].ToString()).ToList();
allusers.AddRange(admins);
allusers.AddRange(recruiters);
Business.menuitem addrecruiter = new Business.menuitem();
addrecruiter.linkname = "Add Recruiter";
addrecruiter.linkpath = "/users/recruiter";
addrecruiter.menuposition = 1;
userviewdata.actions.Add(addrecruiter);
Business.menuitem addadmin = new Business.menuitem();
addadmin.linkname = "Add Admin";
addadmin.linkpath = "/users/admin";
addadmin.menuposition = 2;
userviewdata.actions.Add(addadmin);
userviewdata.UsersCollection = allusers;
}
else if (loggedinuser.ObjectType.ToLower() == "tsadmin")
{
consultants = appclient.GetAdmins(Session["companyid"].ToString(), "consultant", Session["usertoken"].ToString()).ToList();
allusers.AddRange(consultants);
Business.menuitem addconsultant = new Business.menuitem();
addconsultant.linkname = "Add Consultant";
addconsultant.linkpath = "/users/consultant";
addconsultant.menuposition = 1;
userviewdata.actions.Add(addconsultant);
timesheetadmins = appclient.GetAdmins(Session["companyid"].ToString(), "tsadmin", Session["usertoken"].ToString()).ToList();
allusers.AddRange(timesheetadmins);
Business.menuitem addTimeSheetAdmins = new Business.menuitem();
addTimeSheetAdmins.linkname = "Add Timesheet Admin";
addTimeSheetAdmins.linkpath = "/users/sheetadmin";
addTimeSheetAdmins.menuposition = 2;
userviewdata.actions.Add(addTimeSheetAdmins);
userviewdata.UsersCollection = allusers;
}
return(View(userviewdata));
}
