Пример #1
0
        public DataSet dal_LoginHistoryDetail(bel_LoginHistory obj_bel_Login)
        {
            DataSet ds = new DataSet();
               try
               {
               SqlCommand sqlcmd = new SqlCommand("spu_LoginHistory");
               sqlcmd.CommandTimeout = 0;
               sqlcmd.CommandType = CommandType.StoredProcedure;
               sqlcmd.Parameters.Clear();
               sqlcmd.Parameters.AddWithValue("@LoginistoryID", obj_bel_Login._LoginistoryID);
               sqlcmd.Parameters.AddWithValue("@LoginHistoryDate", obj_bel_Login._LoginHistoryDate);
               sqlcmd.Parameters.AddWithValue("@UserGroupID", Convert.ToInt32(HttpContext.Current.Session["UserGroupID"]));
               sqlcmd.Parameters.AddWithValue("@UserID", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
               sqlcmd.Parameters.AddWithValue("@Status", obj_bel_Login._Status);
               sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_Login._iMode);
               sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"]));
               sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
               ds = DataFunctions.GetDataSet(sqlcmd);
               }
               catch (Exception ex)
               {

               }
               return ds;
        }
Пример #2
0
        public void LoginHistory(string Status)
        {
            bel_LoginHistory obj_bel_Login = new bel_LoginHistory();
            dal_LoginHistory obj_dal_Login = new dal_LoginHistory();
            try
            {
                obj_bel_Login._LoginHistoryDate = System.DateTime.Now;
                obj_bel_Login._Status = Status;
                obj_bel_Login._iMode = "Insert";
                using (DataSet ds = obj_dal_Login.dal_LoginHistoryDetail(obj_bel_Login))
                {

                }
            }
            catch (Exception exe)
            {
                LogFile(exe.Message, "Common:LoginHistory", Convert.ToInt32(exe.StackTrace.Substring(exe.StackTrace.LastIndexOf(":line") + 5)), "Common/CommonFunction");
            }
        }