Пример #1
0
        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);
            }
        }
Пример #2
0
        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);
        }
Пример #3
0
        public static string Decrypt(string cipherString)
        {
            string ret_str = cipherString.TrimEnd();

            try
            {
                byte[] keyArray;


                byte[] toEncryptArray = Convert.FromBase64String(cipherString.TrimEnd());


                string key = "drashtajinfotech@Job2019";

                keyArray = UTF8Encoding.UTF8.GetBytes(key);


                TripleDESCryptoServiceProvider tdes = new TripleDESCryptoServiceProvider();

                tdes.Key = keyArray;


                tdes.Mode = CipherMode.ECB;

                tdes.Padding = PaddingMode.PKCS7;

                ICryptoTransform cTransform  = tdes.CreateDecryptor();
                byte[]           resultArray = cTransform.TransformFinalBlock(
                    toEncryptArray, 0, toEncryptArray.Length);

                tdes.Clear();

                ret_str = UTF8Encoding.UTF8.GetString(resultArray);
            }
            catch (Exception ex)
            {
                DALError.LogError("PortalEncryption.Decrypt", ex);
            }
            return(ret_str);
        }
Пример #4
0
        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);
        }