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