private static Int32 SaveJobInfo(Job JobDetails)
{
String connstring = Connection.GetConnectionString();
Int32 JobNumber = 0;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_JOB_INSERTJOBDETAILS, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue(JobTitl, JobDetails.JobTitle);
dbCom.Parameters.AddWithValue("@i_intJOBNO", JobDetails.JobNo);
dbCom.Parameters.AddWithValue(JobDescrption, JobDetails.JobDesc);
dbCom.Parameters.AddWithValue("@Comments", JobDetails.Comments);
dbCom.Parameters.AddWithValue(JobPostedDate, JobDetails.PostedDate);
dbCom.Parameters.AddWithValue(JobQualification, JobDetails.Qualification);
dbCom.Parameters.AddWithValue(JobApplyLink, JobDetails.ApplyLink);
dbCom.Parameters.AddWithValue("@STR_Location", JobDetails.Location);
SqlParameter returnParameter = dbCom.Parameters.Add("@JOBNUMBER", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.Output;
dbCom.ExecuteNonQuery();
JobNumber = Convert.ToInt32(dbCom.Parameters["@JOBNUMBER"].Value);
}
}
return(JobNumber);
}
public static bool Save(EmailServer EmailData)
{
string sp = "sp_EmailServer_Save";
string connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sp, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@HOST", SqlDbType.VarChar).Value = EmailData.Host;
dbCom.Parameters.Add("@PORT", SqlDbType.VarChar).Value = EmailData.Port;
dbCom.Parameters.Add("@SSL", SqlDbType.Bit).Value = EmailData.SSL;
dbCom.Parameters.Add("@Email", SqlDbType.VarChar).Value = EmailData.Email;
dbCom.Parameters.Add("@Password", SqlDbType.VarChar).Value = EmailData.Password;
dbCom.ExecuteNonQuery();
}
}
return(true);
}
public static CandidateProfile SaveCandidate(CandidateProfile CPOBJ)
{
CandidateProfile OBJ = null;
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_PERSON_CANDIDATEINSERTUPDATE, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue(CandidateName, CPOBJ.Name);
dbCom.Parameters.AddWithValue(CandidateGender, CPOBJ.Gender);
dbCom.Parameters.AddWithValue(CandidateDOB, CPOBJ.DOB);
dbCom.Parameters.AddWithValue(CandidateAddress, CPOBJ.Address);
dbCom.Parameters.AddWithValue(CandidateEmail, CPOBJ.Email);
dbCom.Parameters.AddWithValue(CandidateMobile, CPOBJ.Mobile);
dbCom.Parameters.AddWithValue(CandidateQual, CPOBJ.Qualification);
dbCom.Parameters.AddWithValue(CandidateExp, CPOBJ.Experiance);
dbCom.Parameters.AddWithValue(CandidateIntrst, CPOBJ.Interests);
dbCom.Parameters.AddWithValue(CandidateImage, CPOBJ.ImgValue);
dbCom.ExecuteNonQuery();
}
}
return(OBJ);
}
public static String GetCurrentUserName(String UserName)
{
String connstring = Connection.GetConnectionString();
String Query = String.Format("SELECT P.NAME FROM Person P INNER JOIN Users U ON P.PERSONID = U.PERSONID WHERE U.USERNAME='******'", UserName);
String CurrentUserName = String.Empty;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(Query, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
CurrentUserName = Convert.ToString(wizReader["NAME"]);
}
}
}
}
return(CurrentUserName);
}
public static String FetchJobApplyURL(Int32 JobNo)
{
String sql_select = String.Format("SELECT APPLYLINK FROM JOB WHERE JOBNO = {0}", JobNo);
String connstring = Connection.GetConnectionString();
String ApplyLinkURL = string.Empty;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
ApplyLinkURL = Convert.ToString(wizReader[0]);
}
}
}
}
return(ApplyLinkURL);
}
public static List <DAL.Job.keywordSearch> GetDegreeList(String Keyword)
{
List <DAL.Job.keywordSearch> list = new List <DAL.Job.keywordSearch>();
String connstring = Connection.GetConnectionString();
String sql_select = String.Format("Select DegreeName from Degree where DegreeName like '%{0}%' ", Keyword);
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var OBJ = new keywordSearch()
{
Keyword = Convert.ToString(wizReader["DegreeName"]),
};
list.Add(OBJ);
}
}
}
}
return(list);
}
public static void LogError(string source, Exception ex)
{
string connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.sp_LogError, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@Server", SqlDbType.VarChar).Value = System.Net.Dns.GetHostName();
dbCom.Parameters.Add("@Source", SqlDbType.VarChar).Value = source;
dbCom.Parameters.Add("@Message", SqlDbType.VarChar).Value = ex.Message;
dbCom.Parameters.Add("@StackTrace", SqlDbType.VarChar).Value = ex.StackTrace;
try
{
dbCom.ExecuteNonQuery();
}
catch (Exception exp)//Error handler itself failing,most cause database not reachable
{
System.IO.File.AppendAllText(System.Web.HttpContext.Current.Server.MapPath("~\\ErrorLog.txt"), DateTime.UtcNow.ToString() + exp.ToString());
}
}
}
}
public static void LogActivity(String message, string PageName)
{
try
{
if (HttpContext.Current.Session["sessionid"] == null)
{
HttpContext.Current.Session["sessionid"] = HttpContext.Current.Session.SessionID + DateTime.Now.Ticks.ToString();
}
String connstring = Connection.GetConnectionString();
string session = string.Empty;
using (SqlConnection conn = new SqlConnection(connstring))
{
conn.Open();
String query = "INSERT INTO dbo.ActivityLog (Timestamp, Session, IP, Browser, Device, Message,PageName) VALUES (@Timestamp, @Session, @IP, @Browser, @Device, @Message,@PageName)";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Timestamp", DateTime.UtcNow);
cmd.Parameters.AddWithValue("@Session", HttpContext.Current.Session["sessionid"]);
cmd.Parameters.AddWithValue("@IP", HttpContext.Current.Request.UserHostAddress);
cmd.Parameters.AddWithValue("@Browser", HttpContext.Current.Request.Browser.Browser);
cmd.Parameters.AddWithValue("@Device", HttpContext.Current.Request.Browser.Platform);
cmd.Parameters.AddWithValue("@Message", message);
cmd.Parameters.AddWithValue("@PageName", PageName);
cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
DALError.LogError("Utility.LogActivity", ex);
}
}
public static string TrySignIn(string username, string password)
{
string sp = "sp_TrySignIn";
string Role = "Invalid";
if (!(string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)))
{
String EncryptedPassword = PortalEncryption.Encrypt(password);
string connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sp, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@username", SqlDbType.VarChar).Value = username;
dbCom.Parameters.Add("@password", SqlDbType.VarChar).Value = EncryptedPassword;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
Role = (string)wizReader["Roles"];
}
}
}
}
}
return(Role);
}
public static Users CandidateSignUp(Users USROBJ)
{
Users Usr = new Users();
String EncryptedPassword = PortalEncryption.Encrypt(USROBJ.Password);
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_SIGNUP, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue(UserName, USROBJ.Username);
dbCom.Parameters.AddWithValue(UserMobile, USROBJ.Mobile);
dbCom.Parameters.AddWithValue(UserEmail, USROBJ.Email);
dbCom.Parameters.AddWithValue(UserPassword, EncryptedPassword);
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
Usr.Success = Convert.ToInt32(wizReader["Success"]);
Usr.Message = Convert.ToString(wizReader["Message"]);
}
}
}
return(Usr);
}
}
public static Users GetUserDetail(string username)
{
string sp = "sp_GetUserDetail";
string connstring = Connection.GetConnectionString();
var p = new Users();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sp, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@username", SqlDbType.VarChar).Value = username;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
{
p.Username = (string)wizReader["Username"];
p.Displayname = (string)wizReader["Displayname"];
p.Roles = (string)wizReader["Roles"];
};
}
}
}
}
return(p);
}
public static List <DAL.Job.keywordSearch> FetchKeywordAutocompleteData(String Keyword)
{
List <DAL.Job.keywordSearch> list = new List <DAL.Job.keywordSearch>();
String connstring = Connection.GetConnectionString();
String sql_select = String.Format("Select keyword from (SELECT Keyword from KEYWORD union select [Subject] from [Subject] union select [DegreeName] from [Degree] ) as result where KEYWORD like '%{0}%' ", Keyword);
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var OBJ = new keywordSearch()
{
Keyword = Convert.ToString(wizReader["keyword"]),
};
list.Add(OBJ);
}
}
}
}
return(list);
}
public static List <String> GetJobAutocompleteValue(String Keyword)
{
List <String> list = new List <String>();
String connstring = Connection.GetConnectionString();
String sql_select = String.Format("select CONVERT(varchar(100),jobno)+' - '+JOBTITLE as JOBNUMANDTITLE from job where IsDeleted=0 and (JOBNO like '%{0}%' or JOBTITLE like '%{0}%')", Keyword);
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sql_select, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
String JobTitle = Convert.ToString(wizReader["JOBNUMANDTITLE"]);
list.Add(JobTitle);
}
}
}
}
return(list);
}
public static List <Discussion> FetchDiscussion(string Jobno, int OffSetMinutes)
{
String connstring = Connection.GetConnectionString();
List <Discussion> D = new List <Discussion>();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_FETCHDISSCUSSIONTEXT, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue("@JOBNO", Jobno);
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
Discussion Chat = new Discussion();
Chat.ID = (Int32)wizReader["ID"];
Chat.ChatID = (Int32)wizReader["CHATID"];
Chat.UserName = (String)wizReader["USERNAME"];
Chat.JobNo = (Int32)wizReader["JOBNO"];
Chat.Messages = (String)wizReader["MESSAGES"];
Chat.DisplayName = Convert.ToString(wizReader["DisplayName"]);
Chat.ImgPath = Convert.ToString(wizReader["IMGPATH"]);
Chat.MessageDateTime = Convert.ToDateTime(wizReader["MSGDATETIME"]).AddMinutes(-OffSetMinutes);//- beacuse offset return utc-localtime
Chat.MyMsg = false;
if (HttpContext.Current.User.Identity != null)
{
if (Chat.UserName == System.Web.HttpContext.Current.User.Identity.Name.ToString())
{
Chat.MyMsg = true;
}
}
if (string.IsNullOrEmpty(Chat.ImgPath))
{
Chat.ImgPath = "/images/CandidateImages/NoImage.png";
}
else
{
Chat.ImgPath = "/images/CandidateImages/" + Chat.ImgPath;
}
D.Add(Chat);
}
}
}
}
return(D);
}
public static List <Job> GetJobList(SearchParam param = null)
{
List <Job> records = new List <Job>();
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.usp_Job_GetJobDetails, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
if (param.Keyword != null)
{
dbCom.Parameters.Add(Keyword, SqlDbType.VarChar).Value = param.Keyword;
dbCom.Parameters.Add(LocationSearch, SqlDbType.VarChar).Value = param.Location;
dbCom.Parameters.Add(Posted, SqlDbType.Int).Value = param.Posted;
}
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var p = new Job()
{
JobNo = (Int32)wizReader["JOBNO"],
JobTitle = (String)wizReader["JOBTITLE"],
JobDesc = (String)wizReader["JOBDESC"],
PostedDate = (DateTime)wizReader["POSTEDDATE"],
Qualification = (String)wizReader["QUALIFICATION"],
Point = Convert.ToInt32(wizReader["POINT"]),
};
records.Add(p);
}
}
}
}
return(records);
}
private static bool ExecuteSP(string SPName, List <SqlParameter> SPParameters)
{
string connstring = Connection.GetConnectionString();
using (SqlConnection con = new SqlConnection(connstring))
{
SqlCommand cmd = new SqlCommand(SPName, con);
cmd.CommandType = CommandType.StoredProcedure;
foreach (SqlParameter parameter in SPParameters)
{
cmd.Parameters.Add(parameter);
}
con.Open();
return(Convert.ToBoolean(cmd.ExecuteScalar()));
}
}
public static void RemoveJob(Int32 JobNumber)
{
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_REMOVEJOB, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue("@JOBNUMBER", JobNumber);
dbCom.ExecuteNonQuery();
}
}
}
public static List <Discussion> DiscussionAdmin()
{
String connstring = Connection.GetConnectionString();
List <Discussion> DA = new List <Discussion>();
//String Sql_GetDiscussionAdmin = String.Format("SELECT ID,CHATID,USERNAME,JOBNO,MESSAGES,MSGDATETIME FROM DISCUSSION ORDER BY MSGDATETIME DESC");
String Sql_GetDiscussionAdmin = String.Format("SELECT DISCUSSION.ID, CHATID,DISCUSSION.USERNAME,JOBNO,MESSAGES,MSGDATETIME,users.PERSONID,ISNULL(NAME,'anonymous') DisplayName,IMGPATH FROM DISCUSSION left join Users on Discussion.USERNAME=Users.USERNAME left join person on Person.PERSONID=Users.PERSONID ORDER BY MSGDATETIME DESC");
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(Sql_GetDiscussionAdmin, dbCon))
{
dbCom.CommandType = CommandType.Text;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
Discussion Chat = new Discussion();
Chat.ID = Convert.ToInt32(wizReader["ID"]);
Chat.ChatID = Convert.ToInt32(wizReader["CHATID"]);
Chat.UserName = Convert.ToString(wizReader["USERNAME"]);
Chat.DisplayName = Convert.ToString(wizReader["DISPLAYNAME"]);
Chat.JobNo = Convert.ToInt32(wizReader["JOBNO"]);
Chat.Messages = Convert.ToString(wizReader["MESSAGES"]);
Chat.MessageDateTime = Convert.ToDateTime(wizReader["MSGDATETIME"]);
Chat.ImgPath = Convert.ToString(wizReader["IMGPATH"]);
DA.Add(Chat);
if (String.IsNullOrEmpty(Chat.ImgPath))
{
Chat.ImgPath = "NoImage.png";
}
}
}
}
}
return(DA);
}
public static DataSet CandidateData()
{
DataSet ds = new DataSet();
try
{
String sql_select = String.Format("Select ISNULL(QUALIFICATION,'') +' '+ISNULL(EXPERIANCE,'') +' '+ISNULL(INTEREST,'') as PerKeyword, EMAIL,NAME from PERSON");
String connstring = Connection.GetConnectionString();
SqlDataAdapter adpt = new SqlDataAdapter(sql_select, connstring);
adpt.Fill(ds);
}
catch (Exception ex)
{
DALError.LogError("Utility.CandidateData", ex);
}
return(ds);
}
public static CandidateProfile FetchCandidateDetails(string phoneno)
{
CandidateProfile OBJ = new CandidateProfile();
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_PERSON_GETPERSONDETAILS, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue(Phoneno, phoneno);
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
OBJ.Name = Convert.ToString(wizReader["NAME"]);
OBJ.Gender = Convert.ToString(wizReader["GENDER"]);
OBJ.DOB = Convert.ToDateTime(wizReader["DOB"]);
OBJ.Address = Convert.ToString(wizReader["ADDRESS"]);
OBJ.Email = Convert.ToString(wizReader["EMAIL"]);
OBJ.Qualification = Convert.ToString(wizReader["QUALIFICATION"]);
OBJ.Experiance = Convert.ToString(wizReader["EXPERIANCE"]);
OBJ.Interests = Convert.ToString(wizReader["INTEREST"]);
OBJ.ImgValue = Convert.ToString(wizReader["IMGPATH"]);
}
}
if (String.IsNullOrEmpty(OBJ.ImgValue))
{
OBJ.ImgValue = "NoImage.png";
}
}
}
return(OBJ);
}
public static EmailServer GetEmailConfiguration()
{
EmailServer emailconfig = new EmailServer();
string sp = "sp_GetEmailConfig";
string connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(sp, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
{
emailconfig.Host = (string)wizReader["Host"];
emailconfig.Port = (string)wizReader["Port"];
emailconfig.SSL = (bool)wizReader["SSL"];
emailconfig.Email = (string)wizReader["Email"];
emailconfig.Password = (string)wizReader["Password"];
};
}
}
}
}
return(emailconfig);
}
public static Job GetJobDescription(Int32 JobNumber)
{
String connstring = Connection.GetConnectionString();
Job J = null;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.usp_Job_GetJobDetails, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@Jobno ", SqlDbType.VarChar).Value = JobNumber;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
J = new Job()
{
JobNo = (Int32)wizReader["JOBNO"],
JobTitle = (String)wizReader["JOBTITLE"],
JobDesc = (String)wizReader["JOBDESC"],
PostedDate = (DateTime)wizReader["POSTEDDATE"],
Qualification = (String)wizReader["QUALIFICATION"],
ApplyLink = (String)wizReader["APPLYLINK"],
Location = Convert.ToString(wizReader["Location"]),
Comments = Convert.ToString(wizReader["Comments"])
};
J.JobImpDates = Job.GetEventDateList(JobNumber);
J.JobNotes = Job.GetJobNotesList(JobNumber);
}
}
}
}
return(J);
}
public static Boolean InsertDiscussionMsg(DAL.Job.Discussion OBJ)
{
String connstring = Connection.GetConnectionString();
var status = false;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_INSERTDISSCUSSIONTEXT, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue("@JobNumber", OBJ.JobNo);
dbCom.Parameters.AddWithValue("@USERNAME", OBJ.UserName);
dbCom.Parameters.AddWithValue("@MESSAGES", OBJ.Messages);
status = Convert.ToBoolean(dbCom.ExecuteNonQuery());
}
}
return(status);
}
public static List <JOBIMNOTES> GetJobNotesList(Int32 JobNumber)
{
List <JOBIMNOTES> records = new List <JOBIMNOTES>();
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.usp_JOBIMNOTES_GetJobNotes, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add(JobNum, SqlDbType.VarChar).Value = JobNumber;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var K = new JOBIMNOTES()
{
Id = Convert.ToInt32(wizReader["Id"]),
Title = Convert.ToString(wizReader["TITLE"]),
DownloadLink = "/Notes/" + Convert.ToString(wizReader["DOWNLOADLINK"]),
Uplodedby = Convert.ToString(wizReader["UPLODEDBY"]),
Uplodeddate = Convert.ToDateTime(wizReader["UPLODEDDATE"])
};
records.Add(K);
}
}
}
}
return(records);
}
public static ResetPassword GetResetPassword(String ResetPasswordvalue)
{
string connstring = Connection.GetConnectionString();
String Msg = String.Empty;
ResetPassword Resetuser = new ResetPassword();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_RESETPASSWPRD, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add("@MOBILENUMBER", SqlDbType.VarChar).Value = ResetPasswordvalue;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
if (Convert.ToBoolean(wizReader["ReturnCode"]))
{
Resetuser.Message = "Sucessfull. To be Sent";
Resetuser.Username = wizReader["USERNAME"].ToString();
Resetuser.Email = wizReader["Email"].ToString();
Resetuser.UniqueId = wizReader["UniqueId"].ToString();
}
else
{
Resetuser.Message = "Mobile Number is not found!";
}
}
}
}
}
return(Resetuser);
}
public static List <JOBIMPDATES> GetEventDateList(Int32 JobNumber)
{
List <JOBIMPDATES> records = new List <JOBIMPDATES>();
String connstring = Connection.GetConnectionString();
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.usp_JOBIMPDATES_GetEventDateTime, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.Add(JobNum, SqlDbType.VarChar).Value = JobNumber;
using (SqlDataReader wizReader = dbCom.ExecuteReader())
{
while (wizReader.Read())
{
var K = new JOBIMPDATES()
{
Id = Convert.ToInt32(wizReader["Id"]),
JobNo = JobNumber,
Events = Convert.ToString(wizReader["EVENTS"]),
EventDateTime = Convert.ToDateTime(wizReader["EVENTSDATETIME"])
};
records.Add(K);
}
}
}
}
return(records);
}
public static List <int> SaveJobDetails(Job JobDetails)
{
String connstring = Connection.GetConnectionString();
List <int> ret = new List <int>();
int status = 0;
Int32 JobNumber = JobDetails.JobNo;
using (SqlConnection dbCon = new SqlConnection(connstring))
{
dbCon.Open();
JobNumber = SaveJobInfo(JobDetails);
status = 1;
if (JobDetails.JobNotes != null)
{
if (JobDetails.JobNotes.Count > 0)
{
foreach (var item in JobDetails.JobNotes)
{
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_JOBIMNOTES_INSERTIMNOTES, dbCon))
{
dbCom.CommandType = CommandType.StoredProcedure;
try
{
dbCom.Parameters.AddWithValue("@JobNumber", JobNumber);
dbCom.Parameters.AddWithValue("@STR_TITLE", item.Title);
dbCom.Parameters.AddWithValue("@DT_UPLODEDDATE", DateTime.UtcNow);
dbCom.Parameters.AddWithValue("@STR_DOWNLOADLINK", item.DownloadLink);
dbCom.Parameters.AddWithValue("@STR_UPLODEDBY", System.Web.HttpContext.Current.User.Identity.Name.ToString());
dbCom.Parameters.AddWithValue("@INT_INSERT", item.DBOP);
dbCom.Parameters.AddWithValue("Id", item.Id);
dbCom.ExecuteNonQuery();
status = 2;
}
catch (Exception ex)
{
DALError.LogError("Job.SaveJobDetails-SaveImpNotes", ex);
}
}
}
}
}
else
{
status = 2;
}
if (JobDetails.JobImpDates != null)
{
if (JobDetails.JobImpDates.Count > 0)
{
foreach (var item in JobDetails.JobImpDates)
{
using (SqlCommand dbCom = new SqlCommand(StoredProcedure.USP_JOBEVENTDATETIME_INSERTJOBDETAILS, dbCon))
{
try
{
dbCom.CommandType = CommandType.StoredProcedure;
dbCom.Parameters.AddWithValue(JobEvents, item.Events);
dbCom.Parameters.AddWithValue(JobEventsDT, item.EventDateTime);
dbCom.Parameters.AddWithValue(InsertCondition, item.DBOP);
dbCom.Parameters.AddWithValue(JobNum, JobNumber);
dbCom.Parameters.AddWithValue("Id", item.Id);
dbCom.ExecuteNonQuery();
status = status + 1;
if (status < 3)
{
status = 4;
}
}
catch (Exception ex)
{
DALError.LogError("Job.SaveJobDetails-SaveImpDates", ex);
}
}
}
var JobImpDatesCount = JobDetails.JobImpDates.Count + 2;
if (status == JobImpDatesCount)
{
status = 3;
}
}
}
else
{
status = status + 1;
if (status < 3)
{
status = 4;
}
}
}
ret.Add(status);
ret.Add(JobNumber);
return(ret);
}
