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