//User Get By UserName/EmailId and Paswword public List<UserProfileModel> GetUserInfoByUserNamePassword(credentialModel mymodel) { List<UserProfileModel> model = new List<UserProfileModel>(); int intValue = 0; try { cmd = new SqlCommand("GetUserInfoByUserNamePassword_Sp", con); cmd.Parameters.Add("@UserName", SqlDbType.VarChar, 200).Value = mymodel.UserName; cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 150).Value = PasswordSecurity.Encrypt(mymodel.Password);//Password Encryption cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) con.Open(); dr = cmd.ExecuteReader(); while (dr.Read()) { model.Add(new UserProfileModel { UserId = Convert.ToInt32(dr["User_UserId"]), OrgId = Convert.ToInt32(dr["User_OrgId"]), UserFirstName = dr["User_FirstName"].ToString(), UserLastName = dr["User_LastName"].ToString(), UserStreet = dr["User_Street"].ToString(), UserStateId = Convert.ToInt32(dr["User_StateId"]), UserState = dr["User_StateName"].ToString(), UserCityId = Convert.ToInt32(dr["User_CityId"]), UserCity = dr["User_CityName"].ToString(), ProfilePhoto = dr["User_ProfilePhoto"].ToString(), RoleId = Convert.ToInt32(dr["User_RoleId"]), RoleName = dr["User_RoleName"].ToString(), UserName = dr["User_UserName"].ToString(), UserEmailId = dr["User_EmailId"].ToString(), UserMobileNo = dr["User_MobileNo"].ToString(), Password = PasswordSecurity.Decrypt(dr["User_Password"].ToString()),//Password Decryption CreatedBy = Convert.ToInt32(dr["User_CreatedBy"]), CreatedOn = Convert.ToDateTime(dr["User_CreatedOn"]), ModifiedBy = Convert.ToInt32(dr["User_ModifiedBy"]), ModifiedOn = Convert.ToDateTime(dr["User_ModifiedOn"]), IsActive = Convert.ToBoolean(dr["User_IsActive"]), IsDelete = Convert.ToBoolean(dr["User_IsDelete"]), OrgName = dr["Org_Name"].ToString(), OrgStreet = dr["Org_Street"].ToString(), OrgCityId = Convert.ToInt32(dr["Org_CityId"]), OrgCity = dr["Org_CityName"].ToString(), OrgStateId = Convert.ToInt32(dr["Org_StateId"]), OrgState = dr["Org_StateName"].ToString(), RegisteredAs = dr["Org_RegisteredAs"].ToString(), Logo = dr["Org_Logo"].ToString(), OrgCreatedBy = Convert.ToInt32(dr["Org_CreatedBy"]), OrgCreatedOn = Convert.ToDateTime(dr["Org_CreatedOn"]), OrgModifiedBy = Convert.ToInt32(dr["Org_ModifiedBy"]), OrgModifiedOn = Convert.ToDateTime(dr["Org_ModifiedOn"]), Org_IsActive = Convert.ToBoolean(dr["Org_IsActive"]), Org_IsDelete = Convert.ToBoolean(dr["Org_IsDelete"]), }); intValue = Convert.ToInt32(dr["User_UserId"]); } Organization_Sp_Class objOrg = new Organization_Sp_Class(); LoginDetailModel loginmodel = new LoginDetailModel(); loginmodel.UserId = intValue; objOrg.InsertLoginDetail(loginmodel); if (con.State == ConnectionState.Open) con.Close(); } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } return model; }
public ResponseModel InsertLoginDetail(LoginDetailModel model) { try { string strHostName = ""; string VisitorsIPAddr = ""; if (System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null) { VisitorsIPAddr = System.Web.HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString(); strHostName = System.Web.HttpContext.Current.Request.UserHostName; } else if (System.Web.HttpContext.Current.Request.UserHostAddress.Length != 0) { VisitorsIPAddr = System.Web.HttpContext.Current.Request.UserHostAddress; strHostName = System.Web.HttpContext.Current.Request.UserHostName; } cmd = new SqlCommand("InsertLoginDetail_Sp", con); if (model.LoginDetailId > 0) cmd.Parameters.Add("@LoginDetailId", SqlDbType.BigInt).Value = model.LoginDetailId; cmd.Parameters.Add("@UserId", SqlDbType.BigInt).Value = model.UserId; cmd.Parameters.Add("@LoginIp", SqlDbType.NVarChar, 150).Value = VisitorsIPAddr; cmd.Parameters.Add("@LogoutIp", SqlDbType.NVarChar, 150).Value = model.LogoutIp; cmd.Parameters.Add("@CreatedBy", SqlDbType.BigInt).Value = model.CreatedBy; cmd.CommandType = CommandType.StoredProcedure; if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); message = "Success"; if (con.State == ConnectionState.Open) { con.Close(); } } catch (Exception ex) { obj.Message = ex.Message; ret = 0; } obj.Response = ret; return obj; }
public ResponseModel InsertLoginDetail(LoginDetailModel model) { return obj.InsertLoginDetail(model); }