//[Route("api/JSearch/GetJobs")]
public HttpResponseMessage GetJobbySearch([FromUri] String PLocation, [FromUri] String PKeySkill, [FromUri] String PQualification,
[FromUri] String PJobCategory, [FromUri] String PMinExp, [FromUri] String PMaxExp, [FromUri] String PJobCode, [FromUri] String PSourceType)
{
#region R&D Work
//{Location:"CTYGSP0510000001",KeySkill:"accounts",Qualification:"%",JobCategory:"%",MinExp:"0",MaxExp:"31",JobCode:"%",SourceType:"PERM"}
//dynamic item1 = Newtonsoft.Json.JsonConvert.DeserializeObject(Params);
//var lst = Newtonsoft.Json.JsonConvert.DeserializeObject(Params);
//List<dynamic> lstitem = new List<dynamic>();
//lstitem.Add(item1);
////var bb = from item in lst select item;
////foreach(var aa in lst)
////{
////}
#endregion R&D Work
JSParams JParam = new JSParams()
{
Location = PLocation,
KeySkill = PKeySkill,
Qualification = PQualification,
JobCategory = PJobCategory,
MinExp = PMinExp,
MaxExp = PMaxExp,
JobCode = PJobCode,
SourceType = PSourceType
};
List <dynamic> lstJob = GetParamDetails(JParam);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstJob.Count > 0 ? 001 : -101,
ResponseData = lstJob,
ResponseStatus = lstJob.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstJob.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
return(response);
}
public HttpResponseMessage Get()
{
String Version = System.Configuration.ConfigurationManager.AppSettings["APKVersion"].ToString();
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = 001,
ResponseData = Version,
ResponseStatus = "Success"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = HttpStatusCode.OK;
return(response);
}
//[Route("api/Param/GetCountryBySearch")]
public HttpResponseMessage GetCountryBySearch([FromUri] string SearchName, [FromUri] String SearchVal)
{
List <dynamic> lstCountrySearch = GetParamDetailsBySearch(ParamType.Country, string.Empty, SearchName, SearchVal);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstCountrySearch.Count > 0 ? 001 : -101,
ResponseData = lstCountrySearch,
ResponseStatus = lstCountrySearch.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstCountrySearch.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
return(response);
}
//[Route("api/Param/GetExperience")]
public HttpResponseMessage GetAllExperience()
{
List <dynamic> lstJobExp = GetParamDetails(ParamType.Experience, String.Empty);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstJobExp.Count > 0 ? 001 : -101,
ResponseData = lstJobExp,
ResponseStatus = lstJobExp.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstJobExp.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
return(response);
}
public HttpResponseMessage GetAllIndustry()
{
List <dynamic> lstindustry = GetParamDetails(ParamType.IndustryCat, string.Empty);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstindustry.Count > 0 ? 001 : -101,
ResponseData = lstindustry,
ResponseStatus = lstindustry.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstindustry.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
//response.RequestMessage = strLoc.Length > 0 ? "Success" : "Failed";
return(response);
}
public HttpResponseMessage CandidateProfile([FromUri] string ResumeID)
{
int?ReturnStatus = 0;
System.Data.DataTable dtd = new System.Data.DataTable();
DatabaseTransaction objDB = new DatabaseTransaction();
objDB.AddConnectionName = "RMSRemote";
List <KeyValuePair <object, object> > lst = new List <KeyValuePair <object, object> >();
lst.Add(new KeyValuePair <object, object>("@RMSResumeID", ResumeID));
dtd = objDB.SqlGetData("RMSProfileDetaileMobile", ref lst, ExecType.Dynamic, ReturnDBOperation.DataTable, ref ReturnStatus);
var dtlist = new List <dynamic>();
if (dtd != null && dtd.Rows.Count > 0)
{
dtlist = new CommonMethods().DatatableToList(dtd);
}
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = dtlist.Count > 0 ? 001 : -101,
ResponseData = dtlist,
ResponseStatus = dtlist.Count > 0 ? "Success" : "Failed"
};
JavaScriptSerializer objserz = new JavaScriptSerializer();
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
String strz = objserz.Serialize(objresponse);
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
//response.Content = new ObjectContent(strz.GetType(), strz, jsonformat);
response.StatusCode = dtlist.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
return(response);
}
//[Route("api/Param/GetLocation")]
public HttpResponseMessage GetAllLocation()
{
//[FromUri] String strParam
//strParam = strParam.Length > 0 ? strParam : "CONGSP0510000001";
List <dynamic> lstLocation = GetParamDetails(ParamType.Location, "CONGSP0510000001");
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstLocation.Count > 0 ? 001 : -101,
ResponseData = lstLocation,
ResponseStatus = lstLocation.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstLocation.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
//response.RequestMessage = strLoc.Length > 0 ? "Success" : "Failed";
return(response);
}
//[Route("api/Param/GetLocationBySearch")]
public HttpResponseMessage GetLocationBySearch([FromUri] string SearchName, [FromUri] String SearchVal)
{
List <dynamic> lstLocSearch = GetParamDetailsBySearch(ParamType.Location, "CONGSP0510000001", SearchName, SearchVal);
#region CodeReasearch on Dynamic Keyword based List
////+ [0] Count = 4 object { System.Collections.Generic.Dictionary<string, object>}
//List<Dictionary<string, dynamic>> result = lstLocSearch.ConvertAll(new Converter<dynamic, Dictionary<string, dynamic>>(DynamicToDictionaryConverter));
//List<Dictionary<string, dynamic>> result1 = new List<Dictionary<string, dynamic>>();
//Dictionary<string, dynamic> dd1 = new Dictionary<string, dynamic>();
//var LocSearch = lstLocSearch.FindAll(p =>
//{
// var lst11 = p as Dictionary<string, dynamic>;
// return lst11.Keys.Any(x => x[x.IndexOf(searchName)].ToString().Contains(SearchVal));
//}
//);
//PropertyInfo[] props = result.GetType().GetProperties();
//foreach (Dictionary<string, dynamic> dd in lstLocSearch)
//{
// if(dd.Keys.ToString().ToUpper().Contains(searchName.ToUpper()) && dd.Values.ToString().ToUpper().Contains(SearchVal.ToUpper()))
// {
// result1.Add(dd);
// }
//}
//foreach (var item in lstLocSearch.AsEnumerable())
//{
// IDictionary<string, object> dn = new ExpandoObject();
// item
//}
//((System.Collections.Generic.IDictionary<string, object>)new System.Collections.Generic.ICollection<object>(lstLocSearch);
//dynamic[] arr;
//IDictionary<object, object> objaa = new ExpandoObject();
//objaa = (IDictionary<string, object>)lstLocSearch;
//Enumerable.ToList<dynamic>((lstLocSearch)).IndexOf(new ExpandoObject().;
//Dictionary<string, object> dd = (new System.Collections.Generic.Dictionary<string, object>())(lstLocSearch);
//for (int i = 0; i < lstLocSearch.Count; i++)
//{
// objaa.Add(lstLocSearch[i].Keys, lstLocSearch[i].Values);
//}
//foreach(ExpandoObject eo in lstLocSearch)
//{
// objaa.Add(eo. lstLocSearch[i].Values);
//}
//Dictionary<dynamic, dynamic> result = new Dictionary<dynamic, dynamic>();
//if (objaa.Keys.Contains(searchName) && objaa.Values.Contains(SearchVal))
//{
// result.Add(objaa.Keys,objaa.Values);
//}
//foreach (IDictionary<string, object> eo in lstLocSearch.AsEnumerable())
//{
// //dn[column.ColumnName] = item[column];
// //objaa.Add(eo);
// //eo.
//}
//lstLocSearch.CopyTo(arr);
//dynamic[] lstarr = lstLocSearch.ToArray();
//foreach (dynamic value in lstLocSearch)
//{
// if (lstLocSearch.Contains())
// {
// exampleDictionary.Add(value, 1);
// }
//}
//result = result.FindAll(p => p.Keys.Any(x => x[x.IndexOf(searchName)].ToString().Contains(SearchVal))).ToList();
//result = result.Find(p=>p.Keys.Equals(searchName)).Values.Equals(SearchVal)
//var aaa = from p in result where p.Keys.Contains(searchName) && p.Values.Contains(SearchVal) select p;
//var aaa = from p in lstLocSearch where p.
//List < dynamic > lst1 = (List<dynamic>)aaa;
//var result = (from c in lstLocSearch where c.LastName.StartsWith("Mc") select c).ToList();
//List<dynamic> lstLocSearc1 = dn.Keys.Select(x => x[x.IndexOf(searchName)].ToString().Contains(SearchVal)).ToList();
//var LocSearch = lstLocSearch.FindAll(p =>
//{
// var lst11 = p as IDictionary<string, object>;
// return lst11.Keys.Any(x => x[x.IndexOf(searchName)].ToString().Contains(SearchVal));
//}
//);
#endregion CodeReasearch on Dynamic Keyword based List
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = lstLocSearch.Count > 0 ? 001 : -101,
ResponseData = lstLocSearch,//Enumerable.ToList<dynamic>(result.AsEnumerable),
ResponseStatus = lstLocSearch.Count > 0 ? "Success" : "Failed"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = lstLocSearch.Count > 0 ? HttpStatusCode.OK : HttpStatusCode.NotFound;
return(response);
}
public HttpResponseMessage CandidatePassword([FromUri] string SearchVal)
{
int?ReturnStatus = 0;
System.Data.DataTable dtd = new System.Data.DataTable();
DatabaseTransaction objDB = new DatabaseTransaction();
objDB.AddConnectionName = "RMSRemote";
List <KeyValuePair <object, object> > lst = new List <KeyValuePair <object, object> >();
lst.Add(new KeyValuePair <object, object>("@RMSEmail", SearchVal));
dtd = objDB.SqlGetData("RMSJSResumeRetrievePwdMobile", ref lst, ExecType.Dynamic, ReturnDBOperation.DataTable, ref ReturnStatus);
ResponseClass objresponse = new ResponseClass();
switch (ReturnStatus)
{
case 1:
if (dtd != null && dtd.Rows.Count > 0)
{
String strEmail = Convert.ToString(dtd.Rows[0]["Email"]);
FileStream fm = new FileStream(HttpContext.Current.Server.MapPath("~/MailTemplate/ForgotPassword.html"), FileMode.Open, FileAccess.Read);
StreamReader sr = new StreamReader(fm);
string str = sr.ReadToEnd();
sr.Close();
fm.Close();
str = str.Replace("[RMSLoginID]", strEmail);
str = str.Replace("[RMSPassword]", Convert.ToString(dtd.Rows[0]["CanPassword"]));
try
{
MailSend objSendMail = new MailSend()
{
mailTo = strEmail,
mailFromName = "Genius Consultants Ltd.",
mailSubject = "Genius Consultants Ltd : Forgot Password",
mailBody = str
};
objSendMail.SendMail();
objresponse = new ResponseClass()
{
ResponseCode = 001,
ResponseData = "An Email has been sent to the registered Email with Login Credentials",
ResponseStatus = "Success"
};
}
catch (Exception ex)
{
Logger.Log("Actionname:Forgot Password-MailSend " + "Exception Source : " + ex.TargetSite + " Message : " + ex.Message);
}
}
break;
case -11:
objresponse = new ResponseClass()
{
ResponseCode = 001,
ResponseData = "No Email ID Found, so unable to retrieve any credential",
ResponseStatus = "Success"
};
break;
}
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
response.StatusCode = HttpStatusCode.OK;
return(response);
}
//public async Task<JSLogin> Candidate()
public async Task <HttpResponseMessage> JobApplication()
//public async Task<ResponseClass> PostJobApplication()
{
///Request: RMASD49685-Perm, RMASD49520-Perm, RMASD49276-Perm, RMASD49188-Perm
//Logger.Log("Checking : " + "ResumeId: " + "111");
String ResumeID = string.Empty;
String JobType = string.Empty;
String JobID = string.Empty;
List <dynamic> lstJs = new List <dynamic>();
List <JobApply> lstJob = new List <JobApply>();
try
{
//if (!Request.Content.IsMimeMultipartContent())
//{
// throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
//}
//Logger.Log("Checking : " + "ResumeId: " + "222");
//RMSResumeCheckforMobile
//if(Request.Content.Headers.ContentType.MediaType.ToString() != "multipart/form-data")
//{
// throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
//}
var provider = await Request.Content.ReadAsMultipartAsync <InMemoryMultipartFormDataStreamProvider>(new InMemoryMultipartFormDataStreamProvider());
NameValueCollection formData = provider.FormData;
//Logger.Log("Checking : " + "ResumeId: " + "333");
foreach (var key in provider.FormData.AllKeys)
{
//string k = key;
object k = key;
foreach (var val in provider.FormData.GetValues(key))
{
// Trace.WriteLine(string.Format("{0}: {1}", key, val));
switch (key)
{
case "ResumeId":
//Logger.Log("Checking : " + "ResumeId: " + val);
ResumeID = val.Replace('"', ' ').Trim();
break;
case "JobDetails":
//Logger.Log("Checking : " + "JobDetails: " + val);
String str = val.Replace('"', ' ').Trim();//"RMASD49685-Perm, RMASD49520-Perm, RMASD49276-Perm, RMASD49188-Perm";
String[] strsplic = str.Trim().Split(',');
foreach (var staa in strsplic.AsEnumerable())
{
JobApply jbapl = new JobApply()
{
JobType = staa.Split('-').GetValue(1).ToString(),
JobID = staa.Split('-').GetValue(0).ToString(),
};
lstJob.Add(jbapl);
}
break;
}
}
}
//Logger.Log("Checking : " + "ResumeId: " + ResumeID + ",JobCode:" + lstJob[0].JobID);
foreach (JobApply objjob in lstJob)
{
if (objjob.JobType.ToUpper() == "TEMP")
{
int?tempReturnStatus = 0;
System.Data.DataTable dtd = new System.Data.DataTable();
DatabaseTransaction objDB = new DatabaseTransaction();
objDB.AddConnectionName = "RMSRemote";
List <KeyValuePair <object, object> > lst = new List <KeyValuePair <object, object> >();
lst.Add(new KeyValuePair <object, object>("@RMSJobCode", objjob.JobID));
lst.Add(new KeyValuePair <object, object>("@RMSResumeID", ResumeID));
lst.Add(new KeyValuePair <object, object>("@CreatedBy", ResumeID));
lst.Add(new KeyValuePair <object, object>("@Type", "TEMP"));
dynamic retValue1 = objDB.SqlGetData("RMSJobApplicationDetailsAdd", ref lst, ExecType.Dynamic, ReturnDBOperation.InUpDel, ref tempReturnStatus);
}
else if (objjob.JobType.ToUpper() == "PERM")
{
int?canReturnStatus = 0;
System.Data.DataTable dtd = new System.Data.DataTable();
DatabaseTransaction objDB = new DatabaseTransaction();
objDB.AddConnectionName = "RMSRemote";
List <KeyValuePair <object, object> > lstcan = new List <KeyValuePair <object, object> >();
lstcan.Add(new KeyValuePair <object, object>("@RMSResumeID", ResumeID));
dtd = objDB.SqlGetData("RMSFetchDetailsForLocal", ref lstcan, ExecType.Dynamic, ReturnDBOperation.DataTable, ref canReturnStatus);
if (dtd != null && dtd.Rows.Count > 0)
{
int?chkReturnStatus = 0;
System.Data.DataTable dtd1 = new System.Data.DataTable();
DatabaseTransaction objDB1 = new DatabaseTransaction();
objDB.AddConnectionName = "RMSLocal";
List <KeyValuePair <object, object> > lstcan1 = new List <KeyValuePair <object, object> >();
lstcan1.Add(new KeyValuePair <object, object>("@RemoteRMSResumeID", ResumeID));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateName", Convert.ToString(dtd.Rows[0]["RMSCandidateName"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateSex", Convert.ToString(dtd.Rows[0]["RMSCandidateSex"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateDOB", Convert.ToString(dtd.Rows[0]["RMSCandidateDOB"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateAddress", Convert.ToString(dtd.Rows[0]["RMSCandidateAddress"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateMobileNo", Convert.ToString(dtd.Rows[0]["RMSCandidateMobileNo"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateEmailID", Convert.ToString(dtd.Rows[0]["RMSCandidateEmailID"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSAnnualSalary", Convert.ToString(dtd.Rows[0]["RMSAnnualSalary"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSResumeHeadline", Convert.ToString(dtd.Rows[0]["RMSResumeHeadline"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSResumeSource", Convert.ToString(dtd.Rows[0]["RMSResumeSource"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSResumeType", Convert.ToString(dtd.Rows[0]["RMSResumeType"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSUserID", Convert.ToString(dtd.Rows[0]["RMSUserID"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSPassword", Convert.ToString(dtd.Rows[0]["RMSPassword"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCity", Convert.ToString(dtd.Rows[0]["RMSCandidateCityID"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSQualification", Convert.ToString(dtd.Rows[0]["RMSQualificationID"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCategory", Convert.ToString(dtd.Rows[0]["RMSCategoryID"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateKeySkill", Convert.ToString(dtd.Rows[0]["RMSCandidateKeySkill"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCandidateExp", Convert.ToInt32(dtd.Rows[0]["RMSCandidateExp"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCurrentCompany", Convert.ToString(dtd.Rows[0]["RMSCurrentCompany"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSCurrentDesignation", Convert.ToString(dtd.Rows[0]["RMSCurrentDesignation"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSPreviousCompany", Convert.ToString(dtd.Rows[0]["RMSPreviousCompany"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSDetailsText", Convert.ToString(dtd.Rows[0]["RMSDetailsText"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSDetailsFull", (byte[])dtd.Rows[0]["RMSDetailsFull"]));
lstcan1.Add(new KeyValuePair <object, object>("@RMSFileExt", Convert.ToString(dtd.Rows[0]["RMSFileEXT"])));
lstcan1.Add(new KeyValuePair <object, object>("@RMSFileName", Convert.ToString(dtd.Rows[0]["RMSFileName"])));
lstcan1.Add(new KeyValuePair <object, object>("@CreatedBy", ResumeID));
lstcan1.Add(new KeyValuePair <object, object>("@TYPE", objjob.JobType.ToUpper()));
lstcan1.Add(new KeyValuePair <object, object>("@JOBCODE", objjob.JobID));
dynamic retValue2 = objDB.SqlGetData("RMSResumeDetailsAddForLocalDB", ref lstcan1, ExecType.Dynamic, ReturnDBOperation.InUpDel, ref chkReturnStatus);
}
}
}
lstJs.Add(lstJob);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = 1,
ResponseData = lstJs,
ResponseStatus = "Success"
};
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
return(response);
//return objresponse;
}
catch (Exception ex)
{
lstJs.Add(ex.Message);
ResponseClass objresponse = new ResponseClass()
{
ResponseCode = -102,
ResponseData = lstJs,
ResponseStatus = "Error"
};
Logger.Log("Exception Source : " + ex.TargetSite + " Message : " + ex.Message);
var jsonformat = new System.Net.Http.Formatting.JsonMediaTypeFormatter();
HttpResponseMessage response = new HttpResponseMessage();
response.Content = new ObjectContent(objresponse.GetType(), objresponse, jsonformat);
return(response);
//return objresponse;
}
finally
{
lstJs = null;
}
}
